or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

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

Avalon Waterways
Avalon Tranquility II
Avalon Tranquility II

Valid: 19 Dec 2018 - 19 Feb 2019

- 14 night river cruise between Amsterdam & Budapest
- Cruise from Amsterdam to Cologne, Rüdesheim, Würzburg, Marktbreit, Bamberg, Nuremberg, Roth, Regensburg, Passau, Linz, Melk and Vienna, ending in Budapest
- Gourmet cuisine with all meals onboard
- Onboard beverages include sparkling wine with breakfast, and wine & beer with lunch & dinner
- Expert Cruise Director & sightseeing with Local Guides
- Included daily excursions with your choice of Classic, Active or Discovery experiences
- Onboard Adventure Centre & Adventure Host
- Complimentary bicycles available for use on shore
- Onboard local entertainment
- WiFi access onboard
- Port charges & onboard gratuities

Special Conditions

*Terms and conditions: All care is taken to promote correct pricing at time of printing (14/01/19), is dependent upon availability and will be confirmed at time of reservation. Book a 2019 Europe river cruise and receive an Air Credit to use towards an airfare of your choice. Air Credit value is dependent on the cruise and departure booked and will range from $200 - $2,400 per person (any deck/cabin category). Select dates are not eligible for promotion. Availability will be confirmed at time of enquiry. Air Credit offer is valid for new 2019 Europe bookings made from 19/12/18 - 19/01/19 (or until sold out). To secure reservation and Air Credit a non-refundable, non-transferable deposit of $500per person/per cruise is required within 7 days of booking (or by 19/01/19; whichever comes first). The Air Credit will be processed as a discount off the booking invoice at time of reservation. Should you cancel or change your cruise, Air Credit becomes null and the full cost of any airfare purchased, or any associated change fees will be your responsibility. All airline payment and cancellation terms are completely independent of Avalon. Avalon is not responsible for any booking element of the airfare which you have utilised the credit for, even if SafetyNet Protection has been purchased. Full Avalon cancellation penalties apply. Air Credit is 100% non-refundable & non-transferable and is handled as a discount off the cruise portion. Offer not combinable with any other. Air Credit valid for Singles (single supplement applies). Offer can be withdrawn or amended at any time. Additional restrictions apply. For full terms and conditions visit avalonwaterways.co.nz.

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

Total elapsed time: 0.14528274536133

# Query Time
(1) connect 0.0013279914855957
(2) DESCRIBE `specials` 0.004525899887085
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'magnificent-europe-4-800-air-credit-per-couple') AND (orchid_available = 1) LIMIT 1 0.0042819976806641
(4) DESCRIBE `cruises` 0.0030608177185059
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74773))) 0.00058197975158691
(6) DESCRIBE `avid_specials` 0.0012631416320801
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1516327 and class = 'Special') OR (item_id = 74773 and class = 'Cruise') OR (item_id = 1224 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.0011889934539795
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1516327') 0.0003199577331543
(9) DESCRIBE `ships` 0.0030629634857178
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1224))) 0.00054311752319336
(11) DESCRIBE `ships` 0.0032079219818115
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1224') 0.00040793418884277
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028395652770996
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033116340637207
(15) DESCRIBE `itineraries` 0.0013959407806396
(16) DESCRIBE `ports` 0.0017650127410889
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00036501884460449
(18) DESCRIBE `ports` 0.001323938369751
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00031304359436035
(20) DESCRIBE `ports` 0.0013279914855957
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00031805038452148
(22) DESCRIBE `specialsailingdates` 0.0011179447174072
(23) DESCRIBE `sailingdates` 0.0012731552124023
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471981))) 0.0018310546875
(25) DESCRIBE `ports` 0.0016188621520996
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00043010711669922
(27) DESCRIBE `ports` 0.00067496299743652
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00036311149597168
(29) DESCRIBE `ports` 0.0019910335540771
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00042414665222168
(31) DESCRIBE `ports` 0.0019018650054932
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00029683113098145
(33) DESCRIBE `ports` 0.001906156539917
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0
(35) DESCRIBE `ports` 0.0015568733215332
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00037598609924316
(37) DESCRIBE `ports` 0.0017998218536377
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00038695335388184
(39) DESCRIBE `ports` 0.0013859272003174
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0
(41) DESCRIBE `ports` 0.0011880397796631
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029492378234863
(43) DESCRIBE `ports` 0.0018289089202881
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00029683113098145
(45) DESCRIBE `ports` 0.0015220642089844
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.0003809928894043
(47) DESCRIBE `ports` 0.0015590190887451
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00033688545227051
(49) DESCRIBE `ports` 0.001305103302002
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5928))) 0.00030612945556641
(51) DESCRIBE `ports` 0.0013241767883301
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5928') 0.00028395652770996
(53) DESCRIBE `ports` 0.0018181800842285
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.0003960132598877
(55) DESCRIBE `ports` 0.002223014831543
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00047397613525391
(57) DESCRIBE `ports` 0.0026190280914307
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1022))) 0.00044703483581543
(59) DESCRIBE `ports` 0.0017750263214111
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1022') 0
(61) DESCRIBE `ports` 0.0014619827270508
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00034308433532715
(63) DESCRIBE `ports` 0.0017349720001221
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00030398368835449
(65) DESCRIBE `ports` 0.0012879371643066
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00086402893066406
(67) DESCRIBE `ports` 0.00118088722229
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00027585029602051
(69) DESCRIBE `ports` 0.0019950866699219
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.0002589225769043
(71) DESCRIBE `ports` 0.0012960433959961
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00035881996154785
(73) DESCRIBE `ports` 0.0017280578613281
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0004279613494873
(75) DESCRIBE `ports` 0.0019009113311768
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00040888786315918
(77) DESCRIBE `ports` 0.0024020671844482
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00044703483581543
(79) DESCRIBE `ports` 0.0018188953399658
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0
(81) DESCRIBE `ports` 0.00160813331604
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00036001205444336
(83) DESCRIBE `ports` 0.0013480186462402
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00027799606323242
(85) DESCRIBE `ports` 0.0015521049499512
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0
(87) DESCRIBE `ports` 0.0016441345214844
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0003809928894043
(89) DESCRIBE `specialsmultipricing` 0.00078296661376953
(90) DESCRIBE `leadpricing` 0.0017762184143066
(91) DESCRIBE `specials` 0.0040998458862305
(92) DESCRIBE `currencies` 0.0011899471282959
(93) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00034213066101074
(94) DESCRIBE `cruiselines` 0.0018749237060547
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00031805038452148
(96) DESCRIBE `orchid_image` 0.0014669895172119
(97) DESCRIBE `cruiselines` 0.0021708011627197
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00038695335388184
(99) DESCRIBE `cruises` 0.0025758743286133
(100) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74773') 0.00040507316589355
(101) DESCRIBE `deckplans` 0.0012581348419189
(102) DESCRIBE `cabins` 0.0013649463653564
(103) DESCRIBE `shipphotos` 0.0014560222625732
(104) DESCRIBE `cruiselines` 0.0019690990447998
(105) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00035810470581055
(106) DESCRIBE `orchid_image` 0.0014009475708008
(107) DESCRIBE `cruiselines` 0.0019450187683105
(108) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00032305717468262
(109) DESCRIBE `cruises` 0.0031111240386963
(110) SELECT `cruises`.* FROM `cruises` WHERE (id IN (74697, 40591, 48300, 57672, 11517, 47190, 52584, 56860, 57716, 67266)) ORDER BY FIND_IN_SET(id, '74697,40591,48300,57672,11517,47190,52584,56860,57716,67266') 0.0013110637664795
(111) DESCRIBE `cruiselines` 0.0025119781494141
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '191', '23', '101', '120', '4', '212')) ORDER BY FIND_IN_SET(id, '218,191,23,101,120,4,212') 0.00078415870666504
(113) DESCRIBE `ships` 0.0026688575744629
(114) SELECT `ships`.* FROM `ships` WHERE (id IN ('1205', '441', '390', '1032', '1303', '10', '451', '582', '669', '1237', '3', '9', '11', '21', '27', '333', '439', '521', '854', '970', '1320', '1579', '4', '22', '24', '25', '28', '105', '327', '461', '739', '1163', '1224', '1773')) ORDER BY FIND_IN_SET(id, '1205,441,390,1032,1303,10,451,582,669,1237,3,9,11,21,27,333,439,521,854,970,1320,1579,4,22,24,25,28,105,327,461,739,1163,1224,1773') 0.0037078857421875
(115) DESCRIBE `cruisetypes` 0.0027549266815186
(116) DESCRIBE `destinations` 0.0010709762573242
(117) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '54', '48', '29', '9', '53', '40', '55', '8', '39', '50')) ORDER BY FIND_IN_SET(id, '12,54,48,29,9,53,40,55,8,39,50') 0.0013189315795898