or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Your 'Cruise Ship' has been chosenClear this filter or visit another page to change

A-Rosa Brava

A-Rosa Cruises
A-Rosa Brava

Cruising on a river is certainly not the fastest mode of transportation. And the countless meanders of the Rhine, Danube and Rhône are not the fastest way to get from A to B either. But that’s precisely what we want to give you: a little time for you to relax and unwind. As you leisurely take in the breathtaking riverscape, you can really take time for yourself. Make yourself comfortable in your cosy cabin or simply daydream in SPA-ROSA and on the sun deck. If you like, you can also take part in our many exciting activities.

Enquire about this cruise ship »

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

Total elapsed time: 0.14661931991577

# Query Time
(1) connect 0.00081992149353027
(2) DESCRIBE `ships` 0.0032429695129395
(3) SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'a-rosa-brava') LIMIT 1 0.011338949203491
(4) DESCRIBE `avid_specials` 0.001439094543457
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1566 AND class = 'Ship') OR (item_id = 239 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011270046234131
(6) DESCRIBE `cruiselines` 0.0018229484558105
(7) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 239))) 0.00046300888061523
(8) DESCRIBE `orchid_image` 0.0018529891967773
(9) DESCRIBE `cruiselines` 0.0020267963409424
(10) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '239') 0.00035500526428223
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1566') 0.00035691261291504
(12) DESCRIBE `deckplans` 0.0015358924865723
(13) SELECT `deckplans`.* FROM `deckplans` WHERE (ship_id = '1566') ORDER BY `level` ASC 0.0043609142303467
(14) DESCRIBE `cabins` 0.0015358924865723
(15) SELECT `cabins`.* FROM `cabins` WHERE (ship_id = '1566') ORDER BY `cabin_order` ASC 0.050453901290894
(16) DESCRIBE `shipphotos` 0.0014669895172119
(17) SELECT `shipphotos`.* FROM `shipphotos` WHERE (ship_id = '1566') 0.001615047454834
(18) DESCRIBE `cruises` 0.0036520957946777
(19) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73053, 73051, 72819)) ORDER BY FIND_IN_SET(id, '73053,73051,72819') 0.00077581405639648
(20) DESCRIBE `cruiselines` 0.0019040107727051
(21) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('239')) ORDER BY FIND_IN_SET(id, '239') 0.00042104721069336
(22) DESCRIBE `cruisetypes` 0.0016789436340332
(23) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.ship_id = '1566') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.040612936019897
(24) DESCRIBE `destinations` 0.0025651454925537
(25) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50')) ORDER BY FIND_IN_SET(id, '50') 0.00050902366638184
(26) DESCRIBE `ships` 0.0035829544067383
(27) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1566))) 0.00048208236694336
(28) DESCRIBE `ships` 0.0040700435638428
(29) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1566))) 0.00055098533630371