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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'ANG07A' 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

Alaska
Grand Princess

Partenza Selezionata

                17 AGO 2022

€541

A partire da:

€ 224

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Whittier                      

Vancouver                      | Cruising | Ketchikan                      | Juneau                         | Skagway                        | Glacier...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| AGO
17

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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'ASG070' 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

Alaska
Crown Princess

Partenza Selezionata

                20 AGO 2022

€1.058

A partire da:

€ 259

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Seattle                        a Seattle                       

Seattle                        | Cruising | Juneau                         | Skagway                        | Glacier Bay                    | Icy Str...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| AGO
20

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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'ASV07A' 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

Alaska
Discovery Princess

Partenza Selezionata

                18 SET 2022

€450

A partire da:

€ 199

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Seattle                        a Vancouver                     

Seattle                        | Cruising | Ketchikan                      | Endicott Arm                   | Juneau                         | Sitka  ...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| SET
18

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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'AVR12A' 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

12

Notti

Alaska
Grand Princess

Partenza Selezionata

                14 SET 2022

€902

A partire da:

€ 309

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Vancouver                     

Vancouver                      | Cruising | Juneau                         | Skagway                        | Icy Strait Point               | Glacier...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| SET
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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'AWG070' 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

Alaska
Majestic Princess

Partenza Selezionata

                20 AGO 2022

€604

A partire da:

€ 228

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Whittier                       a Vancouver                     

Whittier                       | Hubbard Glacier | Glacier Bay                    | Icy Strait Point               | Juneau                         | ...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| AGO
20

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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'AYR14A' 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

Alaska
Grand Princess

Partenza Selezionata

                17 AGO 2022

€1.083

A partire da:

€ 415

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Vancouver                     

Vancouver                      | Cruising | Ketchikan                      | Juneau                         | Skagway                        | Glacier...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| AGO
17

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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'LVL060' 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

6

Notti

Alaska
Discovery Princess

Partenza Selezionata

                25 SET 2022

€342

A partire da:

€ 174

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Los Angeles                   

Vancouver                      | Cruising | Cruising | San Francisco                  | Cruising | Santa Barbara                  | Los Angeles       ...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| 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='ALCAN' ) and ( s.DeparturePortCode = 'LAX' or s.DeparturePortCode = 'SEA' or s.DeparturePortCode = 'YVR' or s.DeparturePortCode = 'WH1' or s.DeparturePortCode = 'SFO') and ( s.ShipCode = 'KP' or s.ShipCode = 'AP' or s.ShipCode = 'XP' or s.ShipCode = 'RU' or s.ShipCode = 'MJ' or s.ShipCode = 'SA') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (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') ) and s.PackageId = 'LVL07C' 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

Alaska
Grand Princess

Partenza Selezionata

                26 SET 2022

€380

A partire da:

€ 241

Tasse Locali:

Quote per persona

in cabina doppia interna

Da Vancouver                      a Los Angeles                   

Vancouver                      | Astoria                        | Cruising | San Francisco                  | Cruising | San Diego                    ...

Ordine dei porti soggetto a variazione
Date di partenza
2022
| SET
26

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

Alaska

Navi

Crown Princess

Discovery Princess

Grand Princess

Majestic Princess

Periodo

2022

2023

2024

AGO

APR

SET

MAG

NOV

GIU

LUG

AGO

SET

OTT
Durata

6 - 8 Giorni

9 - 15 Giorni

Porto d'imbarco

Seattle                       

Vancouver                     

Whittier                      

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