or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

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

Avalon Waterways
Avalon Panorama
Avalon Panorama

Avalon Panorama

Launched in May 2011, the Avalon Panorama is a unique "Suite Ship" - the first of its kind in the industry. The Panorama features two full decks of Panorama Suites with Wall-to-Wall Panoramic Windows opening to create unique Open-Air Balconies; upgrades and enhancements throughout the ship; a host of new on-board amenities and services; and so much more. It's an experience like no other.

Detailed information about Avalon Panorama

Star Rating River
Currency Used

Euro

Cruise Type River
Maiden Voyage 2011
Length 443 feet
Passenger Capacity 166
Crew Nationality European
Cuisine European

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

Total elapsed time: 0.071834564208984

# Query Time
(1) connect 0.00058102607727051
(2) DESCRIBE `specials` 0.0023908615112305
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'active-discovery-on-the-danube-2-400-air-credit-per-couple') AND (orchid_available = 1) LIMIT 1 0.00084686279296875
(4) DESCRIBE `cruises` 0.0013039112091064
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74790))) 0.00030708312988281
(6) DESCRIBE `avid_specials` 0.00064516067504883
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1442170 and class = 'Special') OR (item_id = 74790 and class = 'Cruise') OR (item_id = 888 AND class = 'Ship') OR (item_id = 101 AND class = 'CruiseLine') OR (item_id = 50 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.0010669231414795
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1442170') 0.00020098686218262
(9) DESCRIBE `ships` 0.0016880035400391
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 888))) 0.00026297569274902
(11) DESCRIBE `ships` 0.0015079975128174
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '888') 0.0002439022064209
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002291202545166
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022602081298828
(15) DESCRIBE `itineraries` 0.00099301338195801
(16) DESCRIBE `ports` 0.0010321140289307
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00029206275939941
(18) DESCRIBE `ports` 0.00099897384643555
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00026607513427734
(20) DESCRIBE `ports` 0.00096011161804199
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00023484230041504
(22) DESCRIBE `specialsailingdates` 0.00082015991210938
(23) DESCRIBE `sailingdates` 0.00076580047607422
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 472038))) 0.00023102760314941
(25) DESCRIBE `ports` 0.00067281723022461
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00020098686218262
(27) DESCRIBE `ports` 0.00066184997558594
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00019288063049316
(29) DESCRIBE `ports` 0.00070309638977051
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2917))) 0.0002601146697998
(31) DESCRIBE `ports` 0.00091695785522461
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2917') 0.00023508071899414
(33) DESCRIBE `ports` 0.00085306167602539
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00021791458129883
(35) DESCRIBE `ports` 0.00084090232849121
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00019502639770508
(37) DESCRIBE `ports` 0.00077199935913086
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 938))) 0.00021004676818848
(39) DESCRIBE `ports` 0.00072288513183594
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '938') 0.0001828670501709
(41) DESCRIBE `ports` 0.00097489356994629
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3775))) 0.00026392936706543
(43) DESCRIBE `ports` 0.0010430812835693
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3775') 0.00022196769714355
(45) DESCRIBE `ports` 0.00086879730224609
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.000244140625
(47) DESCRIBE `ports` 0.00070309638977051
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018095970153809
(49) DESCRIBE `ports` 0.00066709518432617
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00021791458129883
(51) DESCRIBE `ports` 0.0008540153503418
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00037980079650879
(53) DESCRIBE `ports` 0.00092506408691406
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00020980834960938
(55) DESCRIBE `ports` 0.00070691108703613
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018095970153809
(57) DESCRIBE `ports` 0.00068092346191406
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4277))) 0.00022602081298828
(59) DESCRIBE `ports` 0.00091099739074707
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4277') 0.00025200843811035
(61) DESCRIBE `ports` 0.00080680847167969
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00021195411682129
(63) DESCRIBE `ports` 0.00073599815368652
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00021719932556152
(65) DESCRIBE `ports` 0.00080299377441406
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00022482872009277
(67) DESCRIBE `ports` 0.00071406364440918
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018978118896484
(69) DESCRIBE `ports` 0.0007021427154541
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0002140998840332
(71) DESCRIBE `ports` 0.00072789192199707
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00018692016601562
(73) DESCRIBE `specialsmultipricing` 0.00066590309143066
(74) DESCRIBE `leadpricing` 0.00063395500183105
(75) DESCRIBE `specials` 0.0022008419036865
(76) DESCRIBE `currencies` 0.00072097778320312
(77) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00026202201843262
(78) DESCRIBE `cruiselines` 0.0009770393371582
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00026106834411621
(80) DESCRIBE `orchid_image` 0.00082492828369141
(81) DESCRIBE `cruiselines` 0.0012280941009521
(82) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00022983551025391
(83) DESCRIBE `cruises` 0.0013148784637451
(84) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74790') 0.00023198127746582
(85) DESCRIBE `deckplans` 0.00067591667175293
(86) DESCRIBE `cabins` 0.00077509880065918
(87) DESCRIBE `shipphotos` 0.00082993507385254
(88) DESCRIBE `cruiselines` 0.00098681449890137
(89) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00028300285339355
(90) DESCRIBE `orchid_image` 0.00076794624328613
(91) DESCRIBE `cruiselines` 0.0009300708770752
(92) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00019598007202148
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(94) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(95) DESCRIBE `cruises` 0.0024840831756592
(96) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66959, 11517, 45259, 69465, 66859, 66414, 67892, 69524, 66478, 66529)) ORDER BY FIND_IN_SET(id, '66959,11517,45259,69465,66859,66414,67892,69524,66478,66529') 0.0010910034179688
(97) DESCRIBE `cruiselines` 0.0016961097717285
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('47', '33', '101', '19', '18', '8', '15', '218', '23', '151', '114', '20', '24', '120', '212', '30', '180', '262')) ORDER BY FIND_IN_SET(id, '47,33,101,19,18,8,15,218,23,151,114,20,24,120,212,30,180,262') 0.0010571479797363
(99) DESCRIBE `ships` 0.0021300315856934
(100) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '160', '1359', '1139', '888', '1266', '78', '1282', '683', '780', '1237', '406', '521', '616', '1029', '1303', '1672', '1676', '45', '258', '313', '404', '585', '669', '973', '1163', '5', '74', '98', '150', '163', '335', '349', '441', '580', '582', '652', '678', '722', '766', '769', '795', '968', '977', '1013', '1088', '1159', '1262', '1302', '1492', '1539', '1587', '1673', '1674')) ORDER BY FIND_IN_SET(id, '517,160,1359,1139,888,1266,78,1282,683,780,1237,406,521,616,1029,1303,1672,1676,45,258,313,404,585,669,973,1163,5,74,98,150,163,335,349,441,580,582,652,678,722,766,769,795,968,977,1013,1088,1159,1262,1302,1492,1539,1587,1673,1674') 0.0027470588684082
(101) DESCRIBE `cruisetypes` 0.00087714195251465
(102) DESCRIBE `destinations` 0.00091195106506348
(103) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '50', '35', '54', '48', '11', '29', '12', '26', '28', '39', '49', '2', '21', '25', '37', '40', '8', '38', '53')) ORDER BY FIND_IN_SET(id, '22,43,50,35,54,48,11,29,12,26,28,39,49,2,21,25,37,40,8,38,53') 0.0011241436004639