SELECT s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode,p.italiano AS PortName, s.PackageId As ItineraryCode, iti.Nnoches As Nnoches, z.italiano as Destino, r.Destino AS ZonaRegion FROM PrincessPricingFeedEur s, ZonasAPI z, PuertosAPI p,BarcosAPI b, RelacionSubregionRegion AS r, PrincessItineraryEUR as iti WHERE s.SubRegion = z.Region and p.Code = s.DeparturePortCode and b.ShipCode = s.ShipCode and r.REGION = s.RegionCode AND s.BrandCode = 'PCL' and iti.PackageId=s.PackageId and ( s.RegionCode='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'YP' or s.ShipCode = 'IP' or s.ShipCode = 'GP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/04/2023' and s.SailDate <= '30/04/2023') OR (s.SailDate >= '01/05/2023' and s.SailDate <= '31/05/2023') OR (s.SailDate >= '01/06/2023' and s.SailDate <= '30/06/2023') OR (s.SailDate >= '01/07/2023' and s.SailDate <= '31/07/2023') OR (s.SailDate >= '01/08/2023' and s.SailDate <= '31/08/2023') OR (s.SailDate >= '01/09/2023' and s.SailDate <= '30/09/2023') ) and s.PackageId = 'FFS25B' GROUP BY s.PackageId, s.SailDate, s.SailingId, s.ShipCode, b.ShipName, s.DeparturePortCode, p.italiano, iti.Nnoches, z.italiano, r.Destino ORDER BY s.PackageId

25

Notti

British Isles Grand Adventure
Regal Princess

Partenza Selezionata

                29 SET 2023

€2.782

A partire da:

€ 339

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Fort Lauderdale               

Southampton  | Portland, England | St Peter Port (Guernsey)       | Cobh (Cork)                    | Cruising | Belfast                        | Green...

Ordine dei porti soggetto a variazione

Date di partenza
2023
| SET
29

Mostra tutte le date di partenza e le tipologie di sistemazione disponibili

Passeggeri
Destinazioni

Europa - Nord Europa

Navi

Regal Princess

Periodo

2023

2024

2025

SET

MAR

MAR

OTT

APR

APR

NOV

MAG

MAG

GIU

GIU

LUG

LUG

AGO

AGO

SET

SET

OTT

OTT

NOV

NOV

Durata

16 o più Giorni

Porto d'imbarco

Southampton