or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  5. Catch up on Cruising: Latest news in bite size

Sign up to our newsletter and become the first to know about our latest deals and promotions

Princess Cruises
Crown Princess
Crown Princess

Valid: 13 Feb 2018 - 28 Feb 2018


- Flight from Auckland to Barcelona via Doha flying Qatar

- 3 nights Pre-Cruise
- Shared transfers from Airport to Hotel
- 3 nights accommodation in Barcelona in a Four Star Hotel; Gallery Hotel or similar
- Shared transfers from Hotel to Port

- 21 night cruise on board Crown Princess
- Main meals & entertainment onboard
- Port charges & government fees

BONUS:
- Receive US$50 onboard credit per stateroom^
- Free Wine & Dine~
- Free Stateroom Location Upgrade#

- 3 nights Post-Cruise
- Shared transfers from Port to Hotel
- 3 nights accommodation in Barcelona in a Four Star Hotel; Gallery Hotel or similar
- Hop on Hop off tour
- Skip the Line – Guided Visit to La Sagrada Familia
- Shared transfer from Hotel to Airport

- Flights from Barcelona to Auckland via Doha

Special Conditions

Package price is based on the lead-in cabin pricing, flights are based on availability on 13/02/2018, flights will be reconfirmed when booking is confirmed. Flights will need to be paid in full when booked and are non-refundable
Offer subject to availability at time of booking and for new bookings only. Prices can be withdrawn at any time without prior notice. Prices are per person share twin based on best available cruise fare, inclusive of all discounts unless otherwise stated. Prices maybe subject to currency fluctuations and are based on cash or bank transfer. Cruise deposit, amendment and cancellation conditions apply. Travel agent service fees may apply. Special conditions apply - please ask for full details at time of enquiry.

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 131

Total elapsed time: 0.31802487373352

# Query Time
(1) connect 0.00057721138000488
(2) DESCRIBE `specials` 0.0030710697174072
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'cruise-factor-fly-cruise-stay-package-to-europe') AND (orchid_available = 1) LIMIT 1 0.0017850399017334
(4) DESCRIBE `cruises` 0.0025160312652588
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74766))) 0.00061202049255371
(6) DESCRIBE `avid_specials` 0.00095891952514648
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1401465 and class = 'Special') OR (item_id = 74766 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015130043029785
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1401465') 0.00029420852661133
(9) DESCRIBE `ships` 0.0020461082458496
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.0004889965057373
(11) DESCRIBE `ships` 0.0020208358764648
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00034809112548828
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019311904907227
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(15) DESCRIBE `itineraries` 0.0010008811950684
(16) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74766') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014579296112061
(17) DESCRIBE `ports` 0.001392126083374
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033402442932129
(19) DESCRIBE `ports` 0.00096297264099121
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002748966217041
(21) DESCRIBE `ports` 0.00093507766723633
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00024890899658203
(23) DESCRIBE `specialsailingdates` 0.00099706649780273
(24) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1401465') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00074100494384766
(25) DESCRIBE `sailingdates` 0.00098514556884766
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471949))) 0.00029611587524414
(27) DESCRIBE `ports` 0.0009000301361084
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029611587524414
(29) DESCRIBE `ports` 0.00090909004211426
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037193298339844
(31) DESCRIBE `ports` 0.00081801414489746
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00026893615722656
(33) DESCRIBE `ports` 0.00085282325744629
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00034594535827637
(35) DESCRIBE `ports` 0.00090193748474121
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031805038452148
(37) DESCRIBE `ports` 0.00092601776123047
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00024700164794922
(39) DESCRIBE `ports` 0.00084805488586426
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00040817260742188
(41) DESCRIBE `ports` 0.00096607208251953
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023412704467773
(43) DESCRIBE `ports` 0.0011560916900635
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00027608871459961
(45) DESCRIBE `ports` 0.00087904930114746
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023603439331055
(47) DESCRIBE `ports` 0.00089383125305176
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026798248291016
(49) DESCRIBE `ports` 0.0013751983642578
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00047922134399414
(51) DESCRIBE `ports` 0.0028741359710693
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.0003511905670166
(53) DESCRIBE `ports` 0.0010299682617188
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00025010108947754
(55) DESCRIBE `ports` 0.00094890594482422
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0003359317779541
(57) DESCRIBE `ports` 0.0010039806365967
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00026392936706543
(59) DESCRIBE `ports` 0.0009160041809082
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00027012825012207
(61) DESCRIBE `ports` 0.00097107887268066
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00026798248291016
(63) DESCRIBE `ports` 0.0011179447174072
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3719))) 0.00032711029052734
(65) DESCRIBE `ports` 0.0010209083557129
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3719') 0.00026512145996094
(67) DESCRIBE `ports` 0.00093984603881836
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00028204917907715
(69) DESCRIBE `ports` 0.0010581016540527
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00028610229492188
(71) DESCRIBE `ports` 0.0010440349578857
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00031399726867676
(73) DESCRIBE `ports` 0.0012681484222412
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028491020202637
(75) DESCRIBE `ports` 0.0018160343170166
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00043010711669922
(77) DESCRIBE `ports` 0.0013020038604736
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00030088424682617
(79) DESCRIBE `ports` 0.00098919868469238
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00029706954956055
(81) DESCRIBE `ports` 0.00092792510986328
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00024986267089844
(83) DESCRIBE `ports` 0.00091886520385742
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00028204917907715
(85) DESCRIBE `ports` 0.00081801414489746
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00021100044250488
(87) DESCRIBE `ports` 0.00095891952514648
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00029706954956055
(89) DESCRIBE `ports` 0.00099897384643555
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00025510787963867
(91) DESCRIBE `ports` 0.00093293190002441
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031304359436035
(93) DESCRIBE `ports` 0.0010249614715576
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002601146697998
(95) DESCRIBE `specialsmultipricing` 0.0010809898376465
(96) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1401465' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.0003809928894043
(97) DESCRIBE `leadpricing` 0.0011279582977295
(98) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1401465') LIMIT 1 0.00033807754516602
(99) DESCRIBE `specials` 0.0063419342041016
(100) SELECT `specials`.* FROM `specials` WHERE (id= '1401465') AND (specials.orchid_available = 1) LIMIT 1 0.00057697296142578
(101) DESCRIBE `currencies` 0.0011019706726074
(102) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00097513198852539
(103) DESCRIBE `cruiselines` 0.0059671401977539
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0042920112609863
(105) DESCRIBE `orchid_image` 0.0037829875946045
(106) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '23') 0.075165987014771
(107) DESCRIBE `cruiselines` 0.0050439834594727
(108) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.005126953125
(109) DESCRIBE `cruises` 0.0021419525146484
(110) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74766') 0.0003969669342041
(111) DESCRIBE `deckplans` 0.0011141300201416
(112) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '542') ORDER BY `level` ASC 0.0041859149932861
(113) DESCRIBE `cabins` 0.0012938976287842
(114) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '542') ORDER BY `cabin_order` ASC 0.030719041824341
(115) DESCRIBE `shipphotos` 0.001215934753418
(116) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '542') 0.0014829635620117
(117) DESCRIBE `cruiselines` 0.0014948844909668
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00049686431884766
(119) DESCRIBE `orchid_image` 0.0011579990386963
(120) DESCRIBE `cruiselines` 0.0013201236724854
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029993057250977
(122) DESCRIBE `cruises` 0.002586841583252
(123) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63786, 63787, 40591, 40596, 68831, 40593, 57675, 57673, 57674, 66748)) ORDER BY FIND_IN_SET(id, '63786,63787,40591,40596,68831,40593,57675,57673,57674,66748') 0.0013349056243896
(124) DESCRIBE `cruiselines` 0.0016839504241943
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('213', '191', '23', '33', '18', '26', '114', '15', '212', '216', '8', '101', '151', '91', '218', '28', '37', '14', '20', '29', '19', '24', '187', '258')) ORDER BY FIND_IN_SET(id, '213,191,23,33,18,26,114,15,212,216,8,101,151,91,218,28,37,14,20,29,19,24,187,258') 0.0013749599456787
(126) DESCRIBE `ships` 0.0024700164794922
(127) SELECT `ships`.* FROM `ships` WHERE (id IN ('1205', '1347', '1032', '1023', '163', '547', '1266', '1385', '1539', '855', '78', '780', '262', '451', '1013', '1282', '1526', '1579', '542', '616', '1154', '1672', '75', '82', '98', '258', '287', '290', '332', '341', '406', '580', '585', '678', '683', '790', '850', '968', '1022', '1029', '1135', '1402', '43', '74', '84', '105', '111', '223', '253', '286', '291', '335', '348', '349', '352', '389', '403', '404', '508', '573', '582', '652', '657', '711', '722', '748', '770', '776', '884', '888', '966', '1108', '1163', '1189', '1223', '1285', '1302', '1308', '1319', '1320', '1323', '1325', '1409', '1413', '1571')) ORDER BY FIND_IN_SET(id, '1205,1347,1032,1023,163,547,1266,1385,1539,855,78,780,262,451,1013,1282,1526,1579,542,616,1154,1672,75,82,98,258,287,290,332,341,406,580,585,678,683,790,850,968,1022,1029,1135,1402,43,74,84,105,111,223,253,286,291,335,348,349,352,389,403,404,508,573,582,652,657,711,722,748,770,776,884,888,966,1108,1163,1189,1223,1285,1302,1308,1319,1320,1323,1325,1409,1413,1571') 0.0045850276947021
(128) DESCRIBE `cruisetypes` 0.0011050701141357
(129) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.is_special = 1) AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.066511869430542
(130) DESCRIBE `destinations` 0.00160813331604
(131) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '43', '22', '54', '55', '8', '35', '12', '39', '50', '11', '21', '26', '40', '48', '25', '37', '49', '29', '53')) ORDER BY FIND_IN_SET(id, '2,43,22,54,55,8,35,12,39,50,11,21,26,40,48,25,37,49,29,53') 0.0034620761871338