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
> Downloads
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
You need the flash player.
Downloads
Want to learn more about your destination? Here you´ll find all the information you need on your Iberostar hotel of choice. Relevant facts, technical files, and all you need to know, at Iberostar Hotels & Resorts.
New 2010 brochure
PDF
Catalogue
COM
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
