Quota apertura pratica: adulti € 40 | 2-18 anni € 20 | 0-2 anni gratuita
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 = 'SFR') and ( s.ShipCode = 'CO' or s.ShipCode = 'EP' or s.ShipCode = 'AP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU' or s.ShipCode = 'SA' or s.ShipCode = 'SP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2021' and s.SailDate <= '30/04/2021') OR (s.SailDate >= '01/05/2021' and s.SailDate <= '31/05/2021') OR (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') OR (s.SailDate >= '01/10/2021' and s.SailDate <= '31/10/2021') ) 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
5
Notti
Alaska Coral Princess
Partenza Selezionata
19 MAG 2021
€506
A partire da:
€ 219
Tasse Locali:
Quote per persona
in cabina doppia interna
Da Vancouver                     a Whittier                     Â
Vancouver                     | Cruising | Icy Strait Point              | Juneau                        | Skagway                       | Glacier...
Ordine dei porti soggetto a variazione
Date di partenza
2021
| MAG
19
Mostra tutte le date di partenza e le tipologie di sistemazione disponibili
MERCOLEDÌ
19 MAG 2021
Coral Princess
INTERNA
€ 506
ESTERNA
€ 566
BALCONE
€ 1.083
MINISUITE
€ 1.296
SUITE
€ 1.908
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 = 'SFR') and ( s.ShipCode = 'CO' or s.ShipCode = 'EP' or s.ShipCode = 'AP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU' or s.ShipCode = 'SA' or s.ShipCode = 'SP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2021' and s.SailDate <= '30/04/2021') OR (s.SailDate >= '01/05/2021' and s.SailDate <= '31/05/2021') OR (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') OR (s.SailDate >= '01/10/2021' and s.SailDate <= '31/10/2021') ) 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
2
Notti
Alaska Coral Princess
Partenza Selezionata
26 MAG 2021
€568
A partire da:
€ 213
Tasse Locali:
Quote per persona
in cabina doppia interna
Da Whittier                      a Vancouver                    Â
Whittier                      | Hubbard Glacier | Glacier Bay                   | Skagway                       | Juneau                        | ...
Ordine dei porti soggetto a variazione
Date di partenza
2021
| MAG
26
Mostra tutte le date di partenza e le tipologie di sistemazione disponibili
MERCOLEDÌ
26 MAG 2021
Coral Princess
INTERNA
€ 568
ESTERNA
€ 635
BALCONE
€ 1.196
MINISUITE
€ 1.449
SUITE
€ 2.259
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 = 'SFR') and ( s.ShipCode = 'CO' or s.ShipCode = 'EP' or s.ShipCode = 'AP' or s.ShipCode = 'MJ' or s.ShipCode = 'RP' or s.ShipCode = 'RU' or s.ShipCode = 'SA' or s.ShipCode = 'SP') and ( (s.CruiseLength > '5' AND s.CruiseLength <= '8') or (s.CruiseLength > '8' AND s.CruiseLength <= '15')) and ( (s.SailDate >= '01/04/2021' and s.SailDate <= '30/04/2021') OR (s.SailDate >= '01/05/2021' and s.SailDate <= '31/05/2021') OR (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') OR (s.SailDate >= '01/10/2021' and s.SailDate <= '31/10/2021') ) and s.PackageId = 'LVL07B' 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
18 SET 2021
€482
A partire da:
€ 201
Tasse Locali:
Quote per persona
in cabina doppia interna
Da Vancouver                     a Los Angeles                  Â
Vancouver                     | Victoria                      | Astoria                       | Cruising | San Francisco                 | Cruisin...
Ordine dei porti soggetto a variazione
Date di partenza
2021
| SET
18
Mostra tutte le date di partenza e le tipologie di sistemazione disponibili
SABATO
18 SET 2021
Grand Princess
INTERNA
€ 482
ESTERNA
€ 531
BALCONE
€ 779
MINISUITE
€ 972
SUITE
€ 1.004
Ai sensi dell'art 13 del D.Lgs. 196/2003 recante il 'Codice in materia di protezione dei dati personali', vi informiamo che i dati acquisiti con riferimento al servizio qui presente saranno oggetto di trattamento nel rispetto della normativa sopra richiamata. Il trattamento dei dati si svolge nel rispetto dei diritti delle libertà fondamentali, nonché nella dignità dell'interessato, con particolare riferimento alla riservatezza e all'identità personale e al diritto alla protezione dei dati personali. In ogni momento potrà esercitare i Suoi diritti nei confronti del titolare del trattamento, ai sensi dell'art.7 del D.lgs.196/2003, Titolare del trattamento è Gioco Viaggi Srl con domicilio eletto in Via B. Bosco 57 - 16121 Genova.