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 = 'ROM') and ( s.ShipCode = 'EX') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND 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') OR (s.SailDate >= '01/10/2023' and s.SailDate <= '31/10/2023') OR (s.SailDate >= '01/11/2023' and s.SailDate <= '30/11/2023') OR (s.SailDate >= '01/12/2023' and s.SailDate <= '31/12/2023') ) and s.PackageId = 'EAB07B' 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

7

Notti

Mediterranean With Greek Isles & Italy
Enchanted Princess

Partenza Selezionata

                14 OTT 2023

€1.149

A partire da:

€ 106

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Atene a Barcellona

Atene | Santorini                      | Cruising | Kotor                          | Messina                        | Napoli | Cruising | Barcellona

Ordine dei porti soggetto a variazione

Date di partenza
2023
| OTT
14

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 = 'ROM') and ( s.ShipCode = 'EX') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND 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') OR (s.SailDate >= '01/10/2023' and s.SailDate <= '31/10/2023') OR (s.SailDate >= '01/11/2023' and s.SailDate <= '30/11/2023') OR (s.SailDate >= '01/12/2023' and s.SailDate <= '31/12/2023') ) 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

Grand Western Mediterranean
Enchanted Princess

Partenza Selezionata

                21 OTT 2023

€940

A partire da:

€ 135

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Barcellona a Civitavecchia         

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

Ordine dei porti soggetto a variazione

Date di partenza
2023
| OTT
21

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 = 'ROM') and ( s.ShipCode = 'EX') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND 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') OR (s.SailDate >= '01/10/2023' and s.SailDate <= '31/10/2023') OR (s.SailDate >= '01/11/2023' and s.SailDate <= '30/11/2023') OR (s.SailDate >= '01/12/2023' and s.SailDate <= '31/12/2023') ) 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

Grand Mediterranean
Enchanted Princess

Partenza Selezionata

                1 NOV 2023

€940

A partire da:

€ 150

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Civitavecchia          a Barcellona

Civitavecchia          | Cruising | Cruising | Santorini                      | Atene | Kusadasi                       | Mykonos                      ...

Ordine dei porti soggetto a variazione

Date di partenza
2023
| NOV
1

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

Passeggeri
Destinazioni

Europa - Mediterraneo

Navi

Enchanted Princess

Periodo

2023

2024

2025

OTT

NOV

Durata

6 - 8 Giorni

9 - 15 Giorni

Porto d'imbarco

Atene

Barcellona

Civitavecchia