Búsqueda de cruceros.

select distinct s.shipcode, a.shipname, s.SailDate, s.brandcode, s.departurePortCode, b.castellano as PortName, i.LocationCode AS ArrivalPortCode, p.castellano as ArrivalPortName, s.packageid, i.Nnoches as noches, s.regioncode, s.Flight, s.MandatoryFlight, s.FlightPrice, s.Gateways from SPAESPEURPricingFeed s, barcosapi a, puertosapi b, itinerary i, puertosapi p where (s.brandcode='R') and s.packageid = i.packageid AND i.Activity LIKE 'DEBARK%' and (s.ShipCode = 'EX') and s.SailingOnlyFlag = 'Y' and s.shipcode = a.shipcode and s.departurePortCode = b.code and i.LocationCode = p.code group by s.shipcode, a.shipname,s.SailDate, s.brandcode, s.departurePortCode, b.castellano, i.LocationCode, p.castellano, s.packageid, i.Nnoches, s.regioncode, s.Flight, s.MandatoryFlight, s.FlightPrice, s.Gateways order by s.SailDate Asc
driver={SQL Server};server=.;uid=la;pwd=la;database=BDPricingFeed

Precios desde por persona en ocupación doble, tasas incluidas.

Barco Fecha de salida Puerto embarque Puerto desembarque Noches Suite Balcón Exterior Interior  
Explorer of the Seas 24 Enero 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 N/D 1501€ 938€ N/D Ver itinerario solo crucero
Explorer of the Seas 02 Febrero 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 N/D 1493€ N/D N/D Ver itinerario solo crucero
Explorer of the Seas 07 Febrero 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 1488€ 974€ 781€ N/D Ver itinerario solo crucero
Explorer of the Seas 12 Febrero 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 4 N/D 1365€ 1095€ 880€ Ver itinerario solo crucero
Explorer of the Seas 16 Febrero 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 4538€ 2221€ N/D 946€ Ver itinerario solo crucero
Explorer of the Seas 21 Febrero 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 3038€ 1170€ N/D 969€ Ver itinerario solo crucero
Explorer of the Seas 26 Febrero 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 4 2047€ 1303€ 1186€ 804€ Ver itinerario solo crucero
Explorer of the Seas 02 Marzo 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 1864€ 1547€ 1157€ 983€ Ver itinerario solo crucero
Explorer of the Seas 07 Marzo 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 2733€ 1319€ 1462€ 950€ Ver itinerario solo crucero
Explorer of the Seas 12 Marzo 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 4 2153€ 1360€ 1147€ 998€ Ver itinerario solo crucero
Explorer of the Seas 16 Marzo 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 4018€ 1950€ 1454€ 1196€ Ver itinerario solo crucero
Explorer of the Seas 21 Marzo 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 2209€ 1076€ 1025€ 715€ Ver itinerario solo crucero
Explorer of the Seas 26 Marzo 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 4 1955€ 1088€ 813€ 785€ Ver itinerario solo crucero
Explorer of the Seas 30 Marzo 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 2074€ 1840€ 1518€ 1391€ Ver itinerario solo crucero
Explorer of the Seas 04 Abril 2026 Puerto Cañaveral, Flori... Puerto Cañaveral, Flori... 5 3645€ 1613€ 1600€ 1205€ Ver itinerario solo crucero
Siguenos en
Contáctanos

900 759 225

  • lunes a viernes de 9 a 19.30
  • sábados de 10 a 13 horas