SELECT h_hoteles.idhotel,h_hoteles.nombre,h_hoteles.estrellas,h_destinos.destino, h_cadenas.cadena,h_hoteles.direccion_en,h_hoteles.direccion_es,h_hoteles.precio FROM h_hoteles,h_destinos,h_cadenas WHERE h_hoteles.idcadena = h_cadenas.idcadena AND h_hoteles.iddestino = h_destinos.iddestino ORDER BY rating DESC Cuba hotels order by rating DESC Pag #9
Search an hotel Destination Search »
orderby icon by hotel's parameter
Hotel Husa Cayo Santa Maria preview
Address : Cayo Santa Maria, Caibarien, Villa Clara, Cuba.
Destination : Cayo Santa Maria
Chain : Barceló
from 58 €
See details »
Hotel Gaviota Cayo Santa Maria preview
Address : Cayo Santa Maria, Caibarien, Villa Clara, Cuba.
Destination : Cayo Santa Maria
Chain : Gaviota
from 41 €
See details »
Hotel Blau Costa Verde Beach Resort Cuba  preview
Address : Playa Pesquero, Holguín, Cuba.
Destination : Playa Pesquero
Chain : Blau
from 48 €
See details »
Hotel Playa Costa Verde   preview
Address : Playa Pesquero, Rafael Freyre, Holguín, Cuba.
Destination : Playa Pesquero
Chain : Gaviota
from 41 €
See details »
Hotel Gaviota Playa Pesquero  preview
Address : Playa Pesquero, Rafael Freyre, Holguín, Cuba.
Destination : Playa Pesquero
Chain : Gaviota
from 49 €
See details »
Hotel Copacabana  preview
Address : Ave. 1ra. No. 4404 e/ 44 y 46, Miramar, Playa, Ciudad de La Habana, Cuba.
Destination : Miramar
Chain : Cubanacan
from 29 €
See details »
Hotel Chateau Miramar  preview
Address : Avenida 1ra y 62, Miramar, Playa, Habana, Cuba.
Destination : Miramar
Chain : Cubanacan
from 31 €
See details »
Hotel Comodoro  preview
Address : Calle 3ra y 84, Miramar, Playa, Habana, Cuba
Destination : Miramar
Chain : Cubanacan
from 41 €
See details »
Hotel Tropicoco  preview
Address : Ave. Sur y Las Terrazas, Playa Santa Maria del Mar, Ciudad de La Habana, Cuba.
Destination : Playas del este
Chain : Cubanacan
from 50 €
See details »
Hotel Mercure Sevilla Havana  preview
Address : Trocadero No 55, Old Havana, Cuba.
Destination : Havana Vieja
Chain : Accor
from 39 €
See details »
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17