Travel Kit
Processing
Login
|
Register
Welcome
(
Logout
) (
My data
)
Remember password
Processing
My bookings
|
Site Map
|
RSS
Home
Hotels
Destinations
Special offers
About Us
Contact us
Home
> Press releases
Book your holidays
Choose a country
SELECT DISTINCT pais.PAISNOM nombre, 'Z' || pais.PAISCODI codi,pais.PAISNOM paisnombre, paisorden.paisorden paisorden,'A' zonanombre, 0 zonaorden,'' hotelnombre,'' hotecodi, '' hoteseo, pais.paiscodi paiscodi FROM volgc.hotelmercado hm, volgc.hotelperiodomercado hpm,volgc.vwcentrosvol cv,volgc.paisesidioma pais, volgc.zonasidioma zona,volgc.paisorden,volgc.ordenacion WHERE cv.centcodi = hm.hotecodi AND hm.merccodi =3 AND hm.homevisible = 1 and hm.hopmcodi = hpm.hopmcodi and hm.hotecodi = hpm.hotecodi and trunc(sysdate) between hpm.hopmdesde and hpm.hopmhasta AND zona.idiocodi = 2 AND pais.IDIOCODI =2 AND cv.paiscodi = pais.PAISCODI AND cv.zonacodi = zona.ZONACODI AND paisorden.ordecodi(+)=1 AND paisorden.paiscodi(+)=pais.PAISCODI ORDER BY pais.PAISNOM
Brazil
Bulgaria
Cape Verde
Croatia
Cuba
Cyprus
Dominican Rep.
Greece
Italy
Jamaica
Mexico
Montenegro
Morocco
Spain
Tunisia
Turkey
Choose the area / hotel
1
2
3
Looking for hotels and resorts
Award to World's Third Best Hotel Chain granted by TripAdvisor users.
Experience our Resorts
Hotels for Adults only
Hotels for Groups & Incentives
Hotels for Weddings & Banquets
Hotels for Golf
Hotels for Wellness & Spa
Hotels for Nordic Walking
Hotels for Cyclotouring
About Iberostar
Our Commitments
Grupo Iberostar
Iberostar foundation
Job Opportunities
Hoteliers
News
Press releases
Search engine
Text:
From date:
To date:
Search
There were no matches for your search.
Hotels in Spain
ANDALUSIA
CADIZ
HUELVA
MALAGA
CANARY ISLANDS
FUERTEVENTURA
GRAN CANARIA
LANZAROTE
TENERIFE
MAJORCA
MAJORCA
Hotels in the Mediterranean
BULGARIA
GOLDEN SANDS
SUNNY BEACH
CAPE VERDE
BOAVISTA
CROATIA
CAVTAT
CYPRUS
PAPHOS
GREECE
CORFU
CRETA
KOS
RHODES
ZAKYNTHOS
ITALY
SARDINIA
MONTENEGRO
BUDVA
MOROCCO
AGADIR
BERKANE
TUNISIA
DJERBA
HAMMAMET
MAHDIA
SOUSSE
TOZEUR
ZARZIS
TURKEY
ANTALYA
Hotels in the Americas
BRAZIL
MANAUS
SALVADOR DE BAHIA
CUBA
CAYO COCO
TRINIDAD
VARADERO
DOMINICAN REPUBLIC
BAYAHIBE
PUERTO PLATA
PUNTA CANA
JAMAICA
MONTEGO BAY
MEXICO
COZUMEL
RIVIERA MAYA
© IBEROSTAR HOTELES Y APARTAMENTOS S.L.
|
Legal notice
|
Privacy Policy
|
Site Map
Processing
