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 #4
Search an hotel Destination Search »
orderby icon by hotel's parameter
Hotel Sol Cayo Largo  preview
Address : Cayo Largo del Sur, Archipielago de los Canarreos, Cuba.
Destination : Cayo Largo
Chain : Sol Melia
from 61 €
See details »
Hotel Sol Pelicano  preview
Address : Cayo Largo, Archipielago de los Canarreos, Cuba.
Destination : Cayo Largo
Chain : Sol Melia
from 51 €
See details »
Diving Center Maria La Gorda preview
Address : Peninsula de Guanahacabibes, Sandino, Pinar del Rio, Cuba.
Destination : Maria la Gorda
Chain : Gaviota
from 22 €
See details »
Hotel Cayo Levisa preview
Address : Palma Rubia, La Palma, Pinar del Rio, Cuba.
Destination : Cayo Levisa
Chain : Cubanacan
from 43 €
See details »
Hotel Rancho San Vicente  preview
Address : Carretera a Puerto Esperanza km. 33. Viñales, Pinar del Río, Cuba.
Destination : Pinar del Rio
Chain : Cubanacan
from 29 €
See details »
Hotel La Ermita  preview
Address : Carretera de La Ermita km1,5. Pinar del Río, Cuba
Destination : Vinales
Chain : Cubanacan
from 31 €
See details »
Hotel Moka Las Terrazas preview
Address : Km 51 Autopista a Pinar del Río, Las Terrazas, Candelaria, Pinar del Rí­o.
Destination : Soroa
Chain : Cubanacan
from 31 €
See details »
Hotel Los Jazmines  preview
Address : Carretera de Vinales km. 25. Pinar del Rio, Cuba.
Destination : Vinales
Chain : Cubanacan
from 43 €
See details »
Hotel Soroa preview
Address : Carretera de Soroa km. 8. Candelaria, Pinar del Rí­o, Cuba.
Destination : Soroa
Chain : Cubanacan
from 25 €
See details »
Hotel del Rijo  preview
Address : Honorato del Castillo, No. 12 esq. a Maximo Gomez, Sancti Spiritus, Cuba.
Destination : Sancti Spiritus
Chain : Islazul
from 27 €
See details »
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17