Coral Coast - Oceans of Offers

Find Your Cruise

Clear DatesSailing Dates

From

Destination Cruise Line Cruise Ship Visiting Port

Show only special deals

or, enquire about your chosen options

Coral Coast - Oceans of Offers

Includes Beverage Package, WiFi & Onboard credit*

Sea, Coral Coast 2020 ex Perth Return

Nights	8	Ship	Sea Princess
Star Rating		Departs	Perth (Fremantle), WA Australia

Sailing	2020: 13 Sep
Ports of Call	Perth (Fremantle), Geraldton, Broome, Exmouth

Special Pricing SpecialsPrice (Cabins)

Sailing Dates

Select a cabin to get pricing. Pricing is approximate.

NZ $1,889

NZ $2,415

NZ $2,835

Sea Princess

Valid: 13 Dec 2019 - 12 Mar 2020

- 8 night cruise onboard Sea Princess
- All main meals & entertainment onboard
- Port charges & government fees

BONUS:
- Includes Premier Beverage Package plus WiFi*
- Plus receive an AU$60 onboard credit per stateroom*

Special Conditions

*Valid for sales until 12 Mar 2020 unless sold out prior. Fares are per person, in NZD, in complete twin accommodation based on the lead category for each stateroom type, inclusive of all discounts, taxes, fees and port expenses (which are subject to change). Supplements apply for other stateroom categories. Fares based on specific departure dates only. Higher fares may apply to other departure dates listed. Princess Cruises has set aside a reasonable number of staterooms which are available at these fares. Once these staterooms are sold, fares may revert to a higher fare, but may also be discounted. Valid for new bookings and not combinable with any other offer. All offers are subject to availability, not transferable and cannot be redeemed for cash. Some oceanview staterooms have obstructed views. Offer is valid for the first two guests in the stateroom when booking select cruises sailing between 5-37 nights departing after 01/04/20. Exclusions include select short getaways and all World Cruise voyages. Best Value fare includes the cruise fare bundled with access to the Premier Beverage Package and Internet at a packaged rate. Premier Beverage Package applies to the first 2 guests in the stateroom when aged 18 years or over (21 years on some international voyages) on the Best Value fare. Exclusions apply. Service of alcohol is always subject to Princess Cruises RSA Policies. Guests under legal drinking age will receive the Premier Coffee & Soda package. On Golden Princess, Sapphire Princess and Star Princess: guests receive 5000 minutes of internet access per person per cruise across multiple devices. On Sea Princess, Sun Princess, Majestic Princess, Diamond Princess and Pacific Princess: the Premium PrincessCONNECT Internet Package applies and usage is unlimited across multiple devices in a stateroom (accessed through one device at a time only). All Medallion class ships: unlimited MedallionNet package applies, which is limited to 1 device per passenger and up to 4 passengers in the stateroom. Onboard credit is in currency specified and is non-refundable, non-transferable, cannot be redeemed for cash, and cannot be used in the medical casino or medical centre. Further conditions apply.

#	Query	Time
(1)	connect	0.0010550022125244
(2)	DESCRIBE `specials`	0.0067341327667236
(3)	SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'coral-coast-onboard-credit') AND (orchid_available = 1) LIMIT 1	0.0015189647674561
(4)	DESCRIBE `cruises`	0.0041918754577637
(5)	SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79639)))	0.00071501731872559
(6)	DESCRIBE `avid_specials`	0.0018651485443115
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1644280 and class = 'Special') OR (item_id = 79639 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 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.0012400150299072
(8)	SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1644280')	0.00040197372436523
(9)	DESCRIBE `ships`	0.0038621425628662
(10)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451)))	0.00057196617126465
(11)	DESCRIBE `ships`	0.00347900390625
(12)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451')	0.0003969669342041
(13)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00034904479980469
(14)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00047111511230469
(15)	DESCRIBE `itineraries`	0.0019121170043945
(16)	DESCRIBE `ports`	0.002216100692749
(17)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))	0.0004570484161377
(18)	DESCRIBE `ports`	0.0018768310546875
(19)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))	0.00043106079101562
(20)	DESCRIBE `ports`	0.0019290447235107
(21)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23')	0.00047492980957031
(22)	DESCRIBE `specialsailingdates`	0.0016961097717285
(23)	DESCRIBE `sailingdates`	0.0018539428710938
(24)	SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493198)))	0.00042510032653809
(25)	DESCRIBE `ports`	0.002007007598877
(26)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))	0.00044798851013184
(27)	DESCRIBE `ports`	0.0018289089202881
(28)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23')	0.00038695335388184
(29)	DESCRIBE `ports`	0.0018799304962158
(30)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480)))	0.00041413307189941
(31)	DESCRIBE `ports`	0.0017910003662109
(32)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480')	0.00037384033203125
(33)	DESCRIBE `ports`	0.0019910335540771
(34)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24)))	0.00043511390686035
(35)	DESCRIBE `ports`	0.0018479824066162
(36)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '24')	0.00038504600524902
(37)	DESCRIBE `ports`	0.0018310546875
(38)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2059)))	0.00039505958557129
(39)	DESCRIBE `ports`	0.0018091201782227
(40)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2059')	0.00039792060852051
(41)	DESCRIBE `ports`	0.0017330646514893
(42)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))	0.00042009353637695
(43)	DESCRIBE `ports`	0.0017900466918945
(44)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23')	0.00036001205444336
(45)	DESCRIBE `specialsmultipricing`	0.0018651485443115
(46)	DESCRIBE `leadpricing`	0.0017960071563721
(47)	DESCRIBE `specialspricing`	0.0018918514251709
(48)	DESCRIBE `cabins`	0.0017609596252441
(49)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7288)))	0.00040984153747559
(50)	DESCRIBE `cabins`	0.0018019676208496
(51)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7279)))	0.00042414665222168
(52)	DESCRIBE `cabins`	0.0020818710327148
(53)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7276)))	0.00040888786315918
(54)	DESCRIBE `currencies`	0.0014808177947998
(55)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00035905838012695
(56)	DESCRIBE `currencies`	0.0015408992767334
(57)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.0003509521484375
(58)	DESCRIBE `currencies`	0.001619815826416
(59)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00035190582275391
(60)	DESCRIBE `cruiselines`	0.0024731159210205
(61)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23)))	0.00042891502380371
(62)	DESCRIBE `orchid_image`	0.0019168853759766
(63)	DESCRIBE `cruiselines`	0.0024371147155762
(64)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23')	0.00039005279541016
(65)	DESCRIBE `cruises`	0.0034840106964111
(66)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79639')	0.00038409233093262
(67)	DESCRIBE `deckplans`	0.0017721652984619
(68)	DESCRIBE `cabins`	0.0023441314697266
(69)	DESCRIBE `shipphotos`	0.0018599033355713
(70)	DESCRIBE `cruiselines`	0.0027270317077637
(71)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23)))	0.00058197975158691
(72)	DESCRIBE `orchid_image`	0.0019328594207764
(73)	DESCRIBE `cruiselines`	0.002532958984375
(74)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23')	0.00040197372436523
(75)	DESCRIBE `cruises`	0.0041458606719971
(76)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (73876, 76093, 76999, 77004, 45259, 77188, 51215, 45258, 43678, 73877)) ORDER BY FIND_IN_SET(id, '73876,76093,76999,77004,45259,77188,51215,45258,43678,73877')	0.0017619132995605
(77)	DESCRIBE `cruiselines`	0.0029749870300293
(78)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '191', '20', '33', '8', '14', '151', '19', '26', '47', '91', '101', '114', '216', '15', '29', '24', '96', '37')) ORDER BY FIND_IN_SET(id, '23,191,20,33,8,14,151,19,26,47,91,101,114,216,15,29,24,96,37')	0.0021209716796875
(79)	DESCRIBE `ships`	0.0038762092590332
(80)	SELECT `ships`.* FROM `ships` WHERE (id IN ('1808', '517', '66', '855', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '290', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1672', '163', '287', '291', '332', '349', '434', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '124', '149', '160', '253', '262', '285', '286', '341', '389', '394', '406', '422', '508', '553', '559', '573', '674', '678', '726', '738', '768', '770', '907', '968', '1029', '1073', '1108', '1157', '1262', '1283', '1409', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '1808,517,66,855,1282,338,780,148,652,683,776,1021,1746,1766,290,404,448,542,616,966,1088,1159,1193,1321,1672,163,287,291,332,349,434,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,124,149,160,253,262,285,286,341,389,394,406,422,508,553,559,573,674,678,726,738,768,770,907,968,1029,1073,1108,1157,1262,1283,1409,1415,1587,1682,1721,1758')	0.011545896530151
(81)	DESCRIBE `cruisetypes`	0.0017211437225342
(82)	DESCRIBE `destinations`	0.0024900436401367
(83)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '2', '54', '35', '50', '26', '8', '25', '12', '48', '49', '29', '53', '11', '28', '37', '40')) ORDER BY FIND_IN_SET(id, '22,43,2,54,35,50,26,8,25,12,48,49,29,53,11,28,37,40')	0.001823902130127

Query

Time

(1)

connect

0.0010550022125244

(2)

DESCRIBE `specials`

0.0067341327667236

(3)

SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'coral-coast-onboard-credit') AND (orchid_available = 1) LIMIT 1

0.0015189647674561

(4)

DESCRIBE `cruises`

0.0041918754577637

(5)

SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79639)))

0.00071501731872559

(6)

DESCRIBE `avid_specials`

0.0018651485443115

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1644280 and class = 'Special') OR (item_id = 79639 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 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.0012400150299072

(8)

SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1644280')

0.00040197372436523

(9)

DESCRIBE `ships`

0.0038621425628662

(10)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451)))

0.00057196617126465

(11)

DESCRIBE `ships`

0.00347900390625

(12)

SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451')

0.0003969669342041

(13)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00034904479980469

(14)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00047111511230469

(15)

DESCRIBE `itineraries`

0.0019121170043945

(16)

DESCRIBE `ports`

0.002216100692749

(17)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))

0.0004570484161377

(18)

DESCRIBE `ports`

0.0018768310546875

(19)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))

0.00043106079101562

(20)

DESCRIBE `ports`

0.0019290447235107

(21)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23')

0.00047492980957031

(22)

DESCRIBE `specialsailingdates`

0.0016961097717285

(23)

DESCRIBE `sailingdates`

0.0018539428710938

(24)

SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493198)))

0.00042510032653809

(25)

DESCRIBE `ports`

0.002007007598877

(26)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))

0.00044798851013184

(27)

DESCRIBE `ports`

0.0018289089202881

(28)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23')

0.00038695335388184

(29)

DESCRIBE `ports`

0.0018799304962158

(30)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480)))

0.00041413307189941

(31)

DESCRIBE `ports`

0.0017910003662109

(32)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480')

0.00037384033203125

(33)

DESCRIBE `ports`

0.0019910335540771

(34)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24)))

0.00043511390686035

(35)

DESCRIBE `ports`

0.0018479824066162

(36)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '24')

0.00038504600524902

(37)

DESCRIBE `ports`

0.0018310546875

(38)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2059)))

0.00039505958557129

(39)

DESCRIBE `ports`

0.0018091201782227

(40)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2059')

0.00039792060852051

(41)

DESCRIBE `ports`

0.0017330646514893

(42)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23)))

0.00042009353637695

(43)

DESCRIBE `ports`

0.0017900466918945

(44)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23')

0.00036001205444336

(45)

DESCRIBE `specialsmultipricing`

0.0018651485443115

(46)

DESCRIBE `leadpricing`

0.0017960071563721

(47)

DESCRIBE `specialspricing`

0.0018918514251709

(48)

DESCRIBE `cabins`

0.0017609596252441

(49)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7288)))

0.00040984153747559

(50)

DESCRIBE `cabins`

0.0018019676208496

(51)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7279)))

0.00042414665222168

(52)

DESCRIBE `cabins`

0.0020818710327148

(53)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 7276)))

0.00040888786315918

(54)

DESCRIBE `currencies`

0.0014808177947998

(55)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00035905838012695

(56)

DESCRIBE `currencies`

0.0015408992767334

(57)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.0003509521484375

(58)

DESCRIBE `currencies`

0.001619815826416

(59)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00035190582275391

(60)

DESCRIBE `cruiselines`

0.0024731159210205

(61)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23)))

0.00042891502380371

(62)

DESCRIBE `orchid_image`

0.0019168853759766

(63)

DESCRIBE `cruiselines`

0.0024371147155762

(64)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23')

0.00039005279541016

(65)

DESCRIBE `cruises`

0.0034840106964111

(66)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79639')

0.00038409233093262

(67)

DESCRIBE `deckplans`

0.0017721652984619

(68)

DESCRIBE `cabins`

0.0023441314697266

(69)

DESCRIBE `shipphotos`

0.0018599033355713

(70)

DESCRIBE `cruiselines`

0.0027270317077637

(71)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23)))

0.00058197975158691

(72)

DESCRIBE `orchid_image`

0.0019328594207764

(73)

DESCRIBE `cruiselines`

0.002532958984375

(74)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23')

0.00040197372436523

(75)

DESCRIBE `cruises`

0.0041458606719971

(76)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (73876, 76093, 76999, 77004, 45259, 77188, 51215, 45258, 43678, 73877)) ORDER BY FIND_IN_SET(id, '73876,76093,76999,77004,45259,77188,51215,45258,43678,73877')

0.0017619132995605

(77)

DESCRIBE `cruiselines`

0.0029749870300293

(78)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '191', '20', '33', '8', '14', '151', '19', '26', '47', '91', '101', '114', '216', '15', '29', '24', '96', '37')) ORDER BY FIND_IN_SET(id, '23,191,20,33,8,14,151,19,26,47,91,101,114,216,15,29,24,96,37')

0.0021209716796875

(79)

DESCRIBE `ships`

0.0038762092590332

(80)

SELECT `ships`.* FROM `ships` WHERE (id IN ('1808', '517', '66', '855', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '290', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1672', '163', '287', '291', '332', '349', '434', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '124', '149', '160', '253', '262', '285', '286', '341', '389', '394', '406', '422', '508', '553', '559', '573', '674', '678', '726', '738', '768', '770', '907', '968', '1029', '1073', '1108', '1157', '1262', '1283', '1409', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '1808,517,66,855,1282,338,780,148,652,683,776,1021,1746,1766,290,404,448,542,616,966,1088,1159,1193,1321,1672,163,287,291,332,349,434,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,124,149,160,253,262,285,286,341,389,394,406,422,508,553,559,573,674,678,726,738,768,770,907,968,1029,1073,1108,1157,1262,1283,1409,1415,1587,1682,1721,1758')

0.011545896530151

(81)

DESCRIBE `cruisetypes`

0.0017211437225342

(82)

DESCRIBE `destinations`

0.0024900436401367

(83)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '2', '54', '35', '50', '26', '8', '25', '12', '48', '49', '29', '53', '11', '28', '37', '40')) ORDER BY FIND_IN_SET(id, '22,43,2,54,35,50,26,8,25,12,48,49,29,53,11,28,37,40')

0.001823902130127

Find Your Cruise

Coral Coast - Oceans of Offers

Special Pricing SpecialsPrice (Cabins)

Special Conditions

Database Profiling Report