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
> Our commitments
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
Iberostar's guiding principles
On the best beaches in the world
Ideal for holidays alone or with children
The greatest of care for our surroundings
Exquisite cuisine
Large gardens with swimming pools
Highly qualified team
Excellent decoration
Exceptional upkeep of premises
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
On the best beaches in the world
