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 > '2020-12-12 19:51:49' 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
  • Next
  • Last
Fjords Short Break - Black Friday Offer!
ship - Balmoral
6 Nights
£749 pp
1 May 2021
itinerary - Newcastle | Cruising Lysefjord | Bergen | Eidfjord | Cruise Hardangerfjord | Furebergfoss Waterfall | Cruising | Newcastle
Quote Ref: 44209
Canary Island Cruise -
ship - Regal Princess
11 Nights
£1,299 pp
4 May 2021
itinerary - Southampton | Cruising | Cruising | Cruising | Gran Canaria | Santa Cruz de Tenerife | Amazon Lower River | Funchal | Cruising | Vigo | Cruising | Southampton
Quote Ref: 74920
Norwegian Fjords Cruise
ship - Anthem of the Seas
7 Nights
£889 pp
21 May 2021
itinerary - Southampton | CRUISING | Bergen | Alesund | Alanya | KRISTIANSAND | CRUISING | Southampton
Quote Ref: 10367
ALL INCLUSIVE MINI CRUISE
ship - MSC Magnifica
3 Nights
£424 pp
28 May 2021
itinerary - Southampton | Cherbourg | Zeebrugge | Southampton
Quote Ref: 81263
Med Fly Cruise from Birmingham
ship - Azura
7 Nights
£849 pp
3 June 2021
itinerary - Comino | Cruising | Ajaccio | Villefranche | Livorno (Florence/Pisa) | Civitavecchia (Rome) | Cruising | Comino
Quote Ref: 84258
European City Break Cruise
ship - Anthem of the Seas
7 Nights
£859 pp
4 June 2021
itinerary - Southampton | CRUISING | Bilbao | CRUISING | ROTTERDAM | ROTTERDAM | Brunsbuettel | Southampton
Quote Ref: 4308
Western Med Cruise
ship - Britannia
14 Nights
£1,249 pp
5 June 2021
itinerary - Southampton | Cruising | Cruising | Seville | Cruising | Barcelona | Cruising | Civitavecchia (Rome) | Livorno (Florence/Pisa) | Cruising | Cologne | Gibraltar | Cruising | Cruising | Southampton
Quote Ref: 16296
Norwegian Fjords Cruise
ship - MSC Magnifica
7 Nights
£529 pp
10 July 2021
itinerary - Southampton | AT Sea | Eidfjord | Stavanger | Flaam | Kristiansand | AT Sea | Southampton
Quote Ref: 17229
Scenic Scotland Cruise
ship - Borealis
6 Nights
£799 pp
28 August 2021
itinerary - Liverpool | Cruising | Kirkwall | Lerwick | Cruising past Duart Castle | Cruising Sound of Mull | Cruising by Dutchman's Cap (Bac Mòr) | Cruising Fingal's Cave | Liverpool
Quote Ref: 59322
  • First
  • Previous
  • 1
  • 2
  • Next
  • Last