SELECT bc.strike_price,bl.reff_code,bc.basepoke_id,bc.offer_short_summery,bl.ship_id,bc.cruise_id,bc.offer_title,bc.cruise_nights,bc.offer_price,bc.departure_date FROM crul_basepoke_list as bl INNER JOIN crul_basepoke_cruises as bc ON bl.id = bc.basepoke_id WHERE bc.offer_start_date <= curdate() and bc.offer_end_date > curdate() and bc.departure_date > '2019-05-27 08:38:40' AND bl.basepoke_status = 1 AND bc.base_cruise_status = 1 GROUP BY bc.basepoke_id ORDER BY departure_date ASC
  • First
  • Previous
  • 1
  • 2
  • 3
  • Next
  • Last
Iceland and the Faroe Islands
ship - Ventura
14 Nights
£899 pp
23 June 2019
itinerary - Southampton | AT SEA | AT SEA | Torshavn | AT SEA | Akureyri | Isafjord | Reykjavik | Reykjavik | AT SEA | AT SEA | Greenock (Glasgow) | Belfast | AT SEA | Southampton
Quote Ref: 79637
Western Med cruise including Italy & Spain
ship - Azura
14 Nights
£1,299 pp
29 June 2019
itinerary - Southampton | AT SEA | AT SEA | Cadiz (Seville) | AT SEA | Barcelona | AT SEA | Livorno (Florence/Pisa) | Civitavecchia (Rome) | AT SEA | Cartagena | Gibraltar | AT SEA | AT SEA | Southampton
Quote Ref: 7842
Exploring the Scenic Moselle Valley including flights from Heathrow
ship - Brabant
7 Nights
£999 pp
4 July 2019
itinerary - Dusseldorf | Cologne | Remagen | Bernkastel-Kues | Cochem | Koblenz | Speyer | Strasbourg | Basel
Quote Ref: 14215
7 night Med Fly Cruise from Birmingham
ship - Oceana
7 Nights
£770 pp
4 July 2019
itinerary - Valletta | AT SEA | Civitavecchia (Rome) | Livorno (Florence/Pisa) | Toulon | Ajaccio | AT SEA | Valletta
Quote Ref: 61130
Cruise the Norwegian Fjords with Gok Wan
ship - Sapphire Princess
7 Nights
£699 pp
6 July 2019
itinerary - London (Southampton) | At Sea | Stavanger | Olden | Hellesylt | Geiranger | Bergen | At Sea | London (Southampton)
Quote Ref: 88511
Italian Mediterranean Cruise
ship - Independence of the Seas
14 Nights
£1,299 pp
13 July 2019
itinerary - Southampton | AT SEA | AT SEA | Gibraltar | AT SEA | Villefranche | La Spezia (Cinque Terre) | Civitavecchia (Rome) | Naples | Cagliari | AT SEA | Cadiz (Seville) | AT SEA | AT SEA | Southampton
Quote Ref: 44517
5 Star Short break from Southampton with return flight to Heathrow
ship - Queen Victoria
2 Nights
£229 pp
14 July 2019
itinerary - Southampton | AT SEA | Hamburg
Quote Ref: 68279
Iceland, Canada & New York & flights back to Heathrow
ship - Queen Mary 2
12 Nights
£1,399 pp
16 July 2019
itinerary - Liverpool | At Sea | At Sea | Reykjavik | Reykjavik | At Sea | At Sea | At Sea | Corner Brook | At Sea | Halifax | At Sea | New York
Quote Ref: 33934
Spain & Bordeaux
ship - Braemar
8 Nights
£949 pp
23 July 2019
itinerary - Southampton | AT SEA | AT SEA | Bordeaux | Bordeaux | Santander | AT SEA | AT SEA | Southampton
Quote Ref: 24723
  • First
  • Previous
  • 1
  • 2
  • 3
  • Next
  • Last