DI 2 
1
 PAGINA 

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 = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ECS16A' 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

16

Notti

Europa - Nord Europa
Island Princess

Partenza Selezionata

                11 LUG 2021

€2.476

A partire da:

€ 214

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Copenhagen                     a Southampton 

Copenhagen                     | Kristiansand                   | Haugesund, Norway | Aalesund                       | Lerwick (Shetland Islands)     ...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| LUG
11

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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'EIN14A' 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 - Nord Europa
Regal Princess

Partenza Selezionata

                26 GIU 2021

€1.534

A partire da:

€ 128

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | Cruising | Skjolden                       | Olden                          | Aalesund                       | Cruising | Aku...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| GIU
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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ENN07A' 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

Europa - Nord Europa
Regal Princess

Partenza Selezionata

                7 AGO 2021

€716

A partire da:

€ 87

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | Haugesund, Norway | Skjolden                       | Olden                          | Bergen                         | Cruis...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| AGO
7

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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ENN14B' 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 - Nord Europa
Regal Princess

Partenza Selezionata

                12 GIU 2021

€1.534

A partire da:

€ 123

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | Haugesund, Norway | Skjolden                       | Aalesund                       | Trondheim                      | Cruis...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| GIU
12

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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ESC14A' 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 - Nord Europa
Island Princess

Partenza Selezionata

                27 GIU 2021

€2.118

A partire da:

€ 255

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Copenhagen                    

Southampton  | Cruising | Cruising | Bornholm                       | Visby                          | Stoccolma | Helsinki                       | Sa...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| GIU
27

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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ESC14B' 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 - Nord Europa
Island Princess

Partenza Selezionata

                26 AGO 2021

€2.118

A partire da:

€ 234

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Copenhagen                    

Southampton  | Cruising | Skagen, Denmark | Cruising | Klaipeda                       | Riga                           | Helsinki                     ...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| AGO
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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ESN07B' 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

Europa - Nord Europa
Regal Princess

Partenza Selezionata

                14 AGO 2021

€716

A partire da:

€ 201

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | Kristiansand                   | Copenhagen                     | Skagen, Denmark | Oslo                           | Cruisin...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| AGO
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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ESR10C' 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

10

Notti

Europa - Nord Europa
Island Princess

Partenza Selezionata

                25 SET 2021

€1.519

A partire da:

€ 181

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | Amburgo | Cruising | Gotenborg                     | Copenhagen                     | Oslo                           | Cruis...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| SET
25

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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ESR14A' 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 - Nord Europa
Regal Princess

Partenza Selezionata

                24 LUG 2021

€1.534

A partire da:

€ 177

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | Cruising | Cadice (Siviglia) | Cruising | Barcellona | Marsiglia | Livorno      | Civitavecchia          | Cagliari         ...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| LUG
24

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='EUNOR' ) and ( s.DeparturePortCode = 'CPH' or s.DeparturePortCode = 'SOU') and ( s.ShipCode = 'GP' or s.ShipCode = 'KP' or s.ShipCode = 'IP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15') or (s.CruiseLength > '15')) and ( (s.SailDate >= '01/06/2021' and s.SailDate <= '30/06/2021') OR (s.SailDate >= '01/07/2021' and s.SailDate <= '31/07/2021') OR (s.SailDate >= '01/08/2021' and s.SailDate <= '31/08/2021') OR (s.SailDate >= '01/09/2021' and s.SailDate <= '30/09/2021') ) and s.PackageId = 'ESR14C' 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 - Nord Europa
Regal Princess

Partenza Selezionata

                4 SET 2021

€1.534

A partire da:

€ 197

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Southampton  a Southampton 

Southampton  | Cruising | Kristiansand                   | Copenhagen                     | Cruising | Tallinn                        | San Petersburg...

Ordine dei porti soggetto a variazione
Date di partenza
2021
| SET
4

Mostra tutte le date di partenza e le tipologie di sistemazione disponibili
 DI 2 
1
 PAGINA 

Passeggeri
Destinazioni

Europa - Nord Europa

Navi

Island Princess

Regal Princess

Periodo

2021

2022

2023

MAG

MAG

GIU

GIU

LUG

LUG

AGO

AGO

SET

SET

OTT

OTT

NOV
Durata

6 - 8 Giorni

9 - 15 Giorni

16 o più Giorni

Porto d'imbarco

Copenhagen                    

Southampton 

GIOCO VIAGGI
TOUR & CRUISE OPERATOR
Via B. Bosco 57 - 16121 Genova (GE)
Tel 010 5531169
princess@giocoviaggi.com www.crociereprincess.it

  • SEI UN AGENTE DI VIAGGI

  • SEI UN CLIENTE PRIVATO


Copyright © 2012 - GIOCO VIAGGI SRL - P.I.02884880101
Privacy Policy