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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (s.SailDate >= '01/05/2022' and s.SailDate <= '31/05/2022') OR (s.SailDate >= '01/06/2022' and s.SailDate <= '30/06/2022') OR (s.SailDate >= '01/07/2022' and s.SailDate <= '31/07/2022') OR (s.SailDate >= '01/08/2022' and s.SailDate <= '31/08/2022') OR (s.SailDate >= '01/09/2022' and s.SailDate <= '30/09/2022') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EBR11A' 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

11

Notti

Europa - Mediterraneo
Regal Princess

Partenza Selezionata

                6 NOV 2022

€659

A partire da:

€ 129

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Barcellona a Civitavecchia         

Barcellona | Tolone | Livorno      | Cruising | Cruising | Kotor                          | Dubrovnik                      | Corfu                    ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| NOV
6

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

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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (s.SailDate >= '01/05/2022' and s.SailDate <= '31/05/2022') OR (s.SailDate >= '01/06/2022' and s.SailDate <= '30/06/2022') OR (s.SailDate >= '01/07/2022' and s.SailDate <= '31/07/2022') OR (s.SailDate >= '01/08/2022' and s.SailDate <= '31/08/2022') OR (s.SailDate >= '01/09/2022' and s.SailDate <= '30/09/2022') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'EBR11B' 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

11

Notti

Europa - Mediterraneo
Regal Princess

Partenza Selezionata

                15 OTT 2022

€659

A partire da:

€ 133

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Barcellona a Civitavecchia         

Barcellona | Marsiglia | Livorno      | Cruising | Valletta                       | Cruising | Kotor                          | Corfu                 ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| OTT
15

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

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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (s.SailDate >= '01/05/2022' and s.SailDate <= '31/05/2022') OR (s.SailDate >= '01/06/2022' and s.SailDate <= '30/06/2022') OR (s.SailDate >= '01/07/2022' and s.SailDate <= '31/07/2022') OR (s.SailDate >= '01/08/2022' and s.SailDate <= '31/08/2022') OR (s.SailDate >= '01/09/2022' and s.SailDate <= '30/09/2022') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'ERB11C' 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

11

Notti

Europa - Mediterraneo
Regal Princess

Partenza Selezionata

                26 OTT 2022

€659

A partire da:

€ 219

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Cruising | Kotor                          | Cruising | Atene | Kusadasi                       | Mykonos                      ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| OTT
26

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

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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (s.SailDate >= '01/05/2022' and s.SailDate <= '31/05/2022') OR (s.SailDate >= '01/06/2022' and s.SailDate <= '30/06/2022') OR (s.SailDate >= '01/07/2022' and s.SailDate <= '31/07/2022') OR (s.SailDate >= '01/08/2022' and s.SailDate <= '31/08/2022') OR (s.SailDate >= '01/09/2022' and s.SailDate <= '30/09/2022') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'ERR14C' 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

14

Notti

Europa - Mediterraneo
Island Princess

Partenza Selezionata

                31 OTT 2022

€1.578

A partire da:

€ 200

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Civitavecchia         

Civitavecchia          | Cruising | Katakolon                      | Atene | Kusadasi                       | Cruising | Ashdod | Haifa      | Limasso...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| OTT
31

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

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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (s.SailDate >= '01/05/2022' and s.SailDate <= '31/05/2022') OR (s.SailDate >= '01/06/2022' and s.SailDate <= '30/06/2022') OR (s.SailDate >= '01/07/2022' and s.SailDate <= '31/07/2022') OR (s.SailDate >= '01/08/2022' and s.SailDate <= '31/08/2022') OR (s.SailDate >= '01/09/2022' and s.SailDate <= '30/09/2022') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'FRF14B' 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

14

Notti

Europa - Mediterraneo
Island Princess

Partenza Selezionata

                28 NOV 2022

€811

A partire da:

€ 121

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Fort Lauderdale               

Civitavecchia          | Cagliari          | Cruising | Malaga                         | Casablanca                     | Cruising | Funchal (Madeira)...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| NOV
28

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

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='MED' ) and ( s.DeparturePortCode = 'BCN' or s.DeparturePortCode = 'ATH' or s.DeparturePortCode = 'VCE' or s.DeparturePortCode = 'ROM') and ( s.ShipCode = 'IP' or s.ShipCode = 'GP' or s.ShipCode = 'YP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/03/2022' and s.SailDate <= '31/03/2022') OR (s.SailDate >= '01/04/2022' and s.SailDate <= '30/04/2022') OR (s.SailDate >= '01/05/2022' and s.SailDate <= '31/05/2022') OR (s.SailDate >= '01/06/2022' and s.SailDate <= '30/06/2022') OR (s.SailDate >= '01/07/2022' and s.SailDate <= '31/07/2022') OR (s.SailDate >= '01/08/2022' and s.SailDate <= '31/08/2022') OR (s.SailDate >= '01/09/2022' and s.SailDate <= '30/09/2022') OR (s.SailDate >= '01/10/2022' and s.SailDate <= '31/10/2022') OR (s.SailDate >= '01/11/2022' and s.SailDate <= '30/11/2022') OR (s.SailDate >= '01/12/2022' and s.SailDate <= '31/12/2022') ) and s.PackageId = 'FRF15A' 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

15

Notti

Europa - Mediterraneo
Regal Princess

Partenza Selezionata

                17 NOV 2022

€811

A partire da:

€ 129

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Fort Lauderdale               

Civitavecchia          | Livorno      | Genova                          | Ajaccio | Cruising | Gibilterra | Cruising | Santa Cruz De Tenerife         ...

Ordine dei porti soggetto a variazione

Date di partenza
2022
| NOV
17

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

Passeggeri
Destinazioni

Europa - Mediterraneo

Navi

Island Princess

Regal Princess

Periodo

2022

2023

2024

OTT

NOV

NOV

DIC

Durata

9 - 15 Giorni

Porto d'imbarco

Barcellona

Civitavecchia