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-07-20 10:33:53' 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
Spain France & Portugal Cruise - Last few cabins!
ship - Explorer of the Seas
13 Nights
£1,279 pp
18 August 2019
itinerary - Southampton | AT SEA | AT SEA | Gibraltar | Alicante | Ibiza | Barcelona | Marseille | AT SEA | AT SEA | Lisbon | AT SEA | Cherbourg | Southampton
Quote Ref: 81548
Spain, Portugal and Madeira
ship - Braemar
11 Nights
£999 pp
27 August 2019
itinerary - Southampton | At Sea | La Coruna | Vigo | At Sea | Funchal | Funchal | At Sea | Lisbon | At Sea | Southampton
Quote Ref: 17175
Canaries & Azores Cruise
ship - Explorer of the Seas
13 Nights
£1,249 pp
31 August 2019
itinerary - Southampton | AT SEA | AT SEA | Ponta Delgada | AT SEA | Funchal | Gran Canaria | Tenerife | Arrecife | AT SEA | Lisbon | AT SEA | AT SEA | Southampton
Quote Ref: 17127
Norwegian Fjords - New 5* Offer!
ship - Celebrity Silhouette
7 Nights
£749 pp
1 September 2019
itinerary - Southampton | | Bergen | Alesund | Flaam | Stavanger | | Southampton
Quote Ref: 82107
Baltic Cruise includes overnight in St Petersburg
ship - Arcadia
14 Nights
£1,499 pp
2 September 2019
itinerary - Southampton | AT SEA | Kristiansund | Copenhagen | AT SEA | AT SEA | St. Petersburg | St. Petersburg | Tallinn | Riga | AT SEA | Warnemunde | AT SEA | AT SEA | Southampton
Quote Ref: 45778
Spanish Mediterranean Cruise
ship - Independence of the Seas
12 Nights
£1,099 pp
2 September 2019
itinerary - Southampton | AT SEA | Vigo | Lisbon | AT SEA | Ibiza | Palma de Mallorca | Barcelona | Cartagena | Cadiz (Seville) | AT SEA | AT SEA | Southampton
Quote Ref: 24416
Norwegian Fjords
ship - Ventura
7 Nights
£899 pp
6 September 2019
itinerary - Southampton | AT SEA | Stavanger | Olden | Innvikfjorden | Nordfjord | Alesund | Bergen | AT SEA | Southampton
Quote Ref: 51642
The Waterways of Holland & Belgium
ship - Boudicca
7 Nights
£799 pp
26 September 2019
itinerary - Dover (London) | Amsterdam | Amsterdam | | Rotterdam | | Ghent | | | Antwerp | Antwerp | Dover (London)
Quote Ref: 11983
Mediterranean Cities Cruise
ship - Independence of the Seas
12 Nights
£1,139 pp
26 September 2019
itinerary - Southampton | AT SEA | AT SEA | Malaga | AT SEA | Cannes | Barcelona | Palma de Mallorca | AT SEA | Lisbon | Vigo | AT SEA | Southampton
Quote Ref: 61319
  • First
  • Previous
  • 1
  • 2
  • 3
  • Next
  • Last