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 #3
Search an hotel Destination Search
orderby icon by hotel's parameter
Hotel Americas preview
Address : Centro Ciudad, Santa Clara, Cuba.
Destination : Santa Clara
Chain : Cubanacan
from 24
See details
Hotel Los Caneyes  preview
Address : Ave. de los Eucaliptos y Circunvalacion, Santa Clara, Cuba.
Destination : Santa Clara
Chain : Cubanacan
from 28
See details
Hotel La Granjita  preview
Address : Carretera Camajuani, km 5, Santa Clara, Cuba.
Destination : Santa Clara
Chain : Cubanacan
from 28
See details
Hotel Villa Cabo San Antonio preview
Address : Playa de Las Tumbas, Cabo de San Antonio, Pinar del Rio, Cuba.
Destination : Cabo San Antonio
Chain : Gaviota
from 26
See details
Hotel Brisas Santa Lucia  preview
Address : Ave. Turistica, Playa Santa Lucia, Camaguey, Cuba.
Destination : Camaguey
Chain : Cubanacan
from 33
See details
Hotel Camino de Hierro  preview
Address : 67 Maceo, Plaza del Gallo, Camaguey, Cuba.
Destination : Camaguey
Chain : Islazul
from 30
See details
Hotel Club Amigo Caracol  preview
Address : Playa Santa Lucia, Nuevitas, Camaguey, Cuba.
Destination : Camaguey
Chain : Cubanacan
from 30
See details
Hotel Club Amigo Mayanabo  preview
Address : Playa Santa Lucia, Nuevitas, Camaguey, Cuba.
Destination : Camaguey
Chain : Cubanacan
from 29
See details
Hotel Gran Club Santa Lucia  preview
Address : Avenida Tararaco, Playa Santa Lucia, Nuevitas, Camaguey, Cuba.
Destination : Camaguey
Chain : Cubanacan
from 32
See details
Hotel Playa Blanca preview
Address : Cayo Largo del Sur, Archipielago de los Canarreos, Cuba.
Destination : Cayo Largo
Chain : Gran Caribe
from 50
See details
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17