or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

American Queen Steamboat Company
American Duchess
American Duchess

Valid: 21 Mar 2019 - 30 Apr 2019

8-Night accommodation aboard the American Duchess
Included shore excursions in every port of call
Included deluxe hotel stay before your voyage - including breakfast, taxes, porterage and transfers to the American Queen
Complimentary cappuccino, espresso, bottled water and soft drinks throughout your voyage
Complimentary wine and beer with dinner
Gracious service and warm hospitality from a friendly, all-American staff
Daily lectures by the Riverlorian, our onboard history and culture expert
Acclaimed entertainment worthy of Broadway - spectacular revues, cabaret, jazz and blues, six-piece orchestra and more
American Queen Steamboats own dedicated fleet of deluxe motorcoaches

Special Conditions

Cruise costs are in New Zealand Dollars (NZD). Offer subject to availability at time of booking. Prices are per person share twin based on best available cruise fare, inclusive of all discounts unless otherwise stated. Subject to availability and currency fluctuations. All fares and taxes are subject to change without notice up until full payment is received. Itinerary may be subject to change. Credit card payments will incur a fee. 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. Cruise Line reserves the right to re-instate the fuel supplement for all guests up to US$9 per person per day if the price of light sweet crude on the New York Mercantile Exchange (NYMEX) exceeds US$70 per barrel. Please consult cruise line website for current information.

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: 98

Total elapsed time: 0.1384973526001

# Query Time
(1) connect 0.00077199935913086
(2) DESCRIBE `specials` 0.0047671794891357
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '8-night-american-music-river-cruise-from-nashville-to-memphis') AND (orchid_available = 1) LIMIT 1 0.001406192779541
(4) DESCRIBE `cruises` 0.0039129257202148
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82068))) 0.00052094459533691
(6) DESCRIBE `avid_specials` 0.0017750263214111
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1545784 and class = 'Special') OR (item_id = 82068 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0017299652099609
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1545784') 0.00063586235046387
(9) DESCRIBE `ships` 0.004127025604248
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00060200691223145
(11) DESCRIBE `ships` 0.003324031829834
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00049901008605957
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00011706352233887
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028395652770996
(15) DESCRIBE `itineraries` 0.001945972442627
(16) DESCRIBE `ports` 0.002263069152832
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.0005040168762207
(18) DESCRIBE `ports` 0.0019190311431885
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.0004429817199707
(20) DESCRIBE `ports` 0.0018410682678223
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 0.00055503845214844
(22) DESCRIBE `specialsailingdates` 0.0015590190887451
(23) DESCRIBE `sailingdates` 0.0018420219421387
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515303))) 0.00047087669372559
(25) DESCRIBE `ports` 0.0020170211791992
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1412))) 0.00049304962158203
(27) DESCRIBE `ports` 0.0018999576568604
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1412') 0.00046300888061523
(29) DESCRIBE `ports` 0.0017561912536621
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3416))) 0.00040507316589355
(31) DESCRIBE `ports` 0.0020489692687988
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3416') 0.00039887428283691
(33) DESCRIBE `ports` 0.0017440319061279
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3416))) 0.0003199577331543
(35) DESCRIBE `ports` 0.0013988018035889
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3416') 0.00031208992004395
(37) DESCRIBE `ports` 0.0013198852539062
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1377))) 0.00029897689819336
(39) DESCRIBE `ports` 0.0014610290527344
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1377') 0.00029587745666504
(41) DESCRIBE `ports` 0.0015740394592285
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1361))) 0.00048184394836426
(43) DESCRIBE `ports` 0.0015518665313721
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1361') 0.00039911270141602
(45) DESCRIBE `ports` 0.0016300678253174
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1360))) 0.00038695335388184
(47) DESCRIBE `ports` 0.0022377967834473
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1360') 0.00045394897460938
(49) DESCRIBE `ports` 0.0017528533935547
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3413))) 0.00056099891662598
(51) DESCRIBE `ports` 0.0014188289642334
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3413') 0.00035285949707031
(53) DESCRIBE `ports` 0.0013890266418457
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00032687187194824
(55) DESCRIBE `ports` 0.0013289451599121
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00037193298339844
(57) DESCRIBE `ports` 0.001572847366333
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00030803680419922
(59) DESCRIBE `ports` 0.0016591548919678
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00040698051452637
(61) DESCRIBE `specialsmultipricing` 0.0015199184417725
(62) SELECT `specialsmultipricing`.* FROM `specialsmultipricing` WHERE (special_id = '1545784' AND sailingdate >= NOW()) ORDER BY `sailingdate` ASC 0.00029492378234863
(63) DESCRIBE `leadpricing` 0.0044949054718018
(64) SELECT `leadpricing`.* FROM `leadpricing` WHERE (special_id = '1545784') LIMIT 1 0.00066804885864258
(65) DESCRIBE `specialspricing` 0.002004861831665
(66) SELECT `specialspricing`.* FROM `specialspricing` WHERE (special_id = '1545784') 0.001039981842041
(67) DESCRIBE `cabins` 0.0023617744445801
(68) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 13736))) 0.00066995620727539
(69) DESCRIBE `cabins` 0.0019149780273438
(70) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 13737))) 0.0005340576171875
(71) DESCRIBE `currencies` 0.0015971660614014
(72) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.0005030632019043
(73) DESCRIBE `currencies` 0.001039981842041
(74) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00030398368835449
(75) DESCRIBE `cruiselines` 0.0018520355224609
(76) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00033807754516602
(77) DESCRIBE `orchid_image` 0.0015060901641846
(78) DESCRIBE `cruiselines` 0.0018689632415771
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00029897689819336
(80) DESCRIBE `cruises` 0.0027439594268799
(81) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82068') 0.00032615661621094
(82) DESCRIBE `deckplans` 0.0013010501861572
(83) DESCRIBE `cabins` 0.0017130374908447
(84) DESCRIBE `shipphotos` 0.0014188289642334
(85) DESCRIBE `cruiselines` 0.0025219917297363
(86) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00044512748718262
(87) DESCRIBE `orchid_image` 0.0017459392547607
(88) DESCRIBE `cruiselines` 0.0019690990447998
(89) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00034785270690918
(90) DESCRIBE `cruises` 0.0030410289764404
(91) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45260, 45259, 71399, 71400, 11517, 56860, 56889, 67266, 67378, 67915)) ORDER BY FIND_IN_SET(id, '45260,45259,71399,71400,11517,56860,56889,67266,67378,67915') 0.0015771389007568
(92) DESCRIBE `cruiselines` 0.0023889541625977
(93) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '212', '218', '47', '264', '33', '191', '18', '14', '20', '23', '29', '24', '114', '8', '213', '4')) ORDER BY FIND_IN_SET(id, '120,212,218,47,264,33,191,18,14,20,23,29,24,114,8,213,4') 0.0015358924865723
(94) DESCRIBE `ships` 0.0031859874725342
(95) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '1163', '627', '1526', '517', '1767', '1013', '701', '441', '163', '1032', '1205', '401', '1168', '1398', '1788', '66', '390', '451', '461', '683', '1303', '9', '10', '21', '22', '24', '25', '27', '105', '404', '439', '547', '582', '970', '1008', '1320', '1372', '1579', '1749', '1773', '1791', '3', '4', '11', '28', '74', '148', '160', '327', '332', '333', '335', '340', '626', '669', '678', '739', '792', '1073', '1243', '1262', '1302', '1347', '1385', '1539', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '521,520,1163,627,1526,517,1767,1013,701,441,163,1032,1205,401,1168,1398,1788,66,390,451,461,683,1303,9,10,21,22,24,25,27,105,404,439,547,582,970,1008,1320,1372,1579,1749,1773,1791,3,4,11,28,74,148,160,327,332,333,335,340,626,669,678,739,792,1073,1243,1262,1302,1347,1385,1539,1540,1569,1711') 0.0073652267456055
(96) DESCRIBE `cruisetypes` 0.0014750957489014
(97) DESCRIBE `destinations` 0.0023541450500488
(98) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '39', '43', '12', '8', '2', '53', '35', '9', '29', '40', '48', '55', '22', '26', '34', '7', '25', '30', '49', '56')) ORDER BY FIND_IN_SET(id, '54,39,43,12,8,2,53,35,9,29,40,48,55,22,26,34,7,25,30,49,56') 0.001615047454834