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 #6
Search an hotel Destination Search »
orderby icon by hotel's parameter
Hotel Villa Guama preview
Address : Laguna del Tesoro, Peninzula de Zapata, Matanzas, Cuba.
Destination : Playa Giron
Chain : Cubanacan
from 21 €
See details »
Hotel Playa Giron preview
Address : Playa Girón, Matanzas, Cuba.
Destination : Playa Giron
Chain : Cubanacan
from 24 €
See details »
Hotel Brisas Guardalavaca  preview
Address : Calle 2 No. 1, Playa Guardalavaca, Banes, Holguin, Cuba.
Destination : Guardalavaca
Chain : Cubanacan
from 43 €
See details »
Hotel Club Amigo Guardalavaca  preview
Address : Playa Guardalavaca, Banes, Holguin, Cuba
Destination : Guardalavaca
Chain : Cubanacan
from 31 €
See details »
Hotel Paradisus Rio de Oro  preview
Address : Playa Esmeralda, Carretera Guardalavaca, Holguin, Cuba.
Destination : Playa Esmeralda
Chain : Sol Melia
from 111 €
See details »
Hotel Sol Rio de Luna y Mares Resort  preview
Address : Playa Esmeralda, Carretera Guardalavaca, Holguin, Cuba.
Destination : Playa Esmeralda
Chain : Sol Melia
from 53 €
See details »
Hotel Faro Luna   preview
Address : Carretera Rancho Luna, Km. 18, Cienfuegos, Cuba.
Destination : Cienfuegos
Chain : Cubanacan
from 25 €
See details »
Hotel Casa Verde preview
Address : Calle 37 N º 1 entre 0 y 2, Punta Gorda, Cienfuegos, Cuba.
Destination : Cienfuegos
Chain : Cubanacan
from 29 €
See details »
Hotel Jagua   preview
Address : Calle 37 N º 1 entre 0 y 2, Punta Gorda, Cienfuegos, Cuba.
Destination : Cienfuegos
Chain : Gran Caribe
from 34 €
See details »
Hotel La Union  preview
Address : Calle 31 Esquina A-54, Cienfuegos, Cuba.
Destination : Cienfuegos
Chain : Cubanacan
from 39 €
See details »
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17