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 #17
Search an hotel Destination Search
orderby icon by hotel's parameter
Hotel Aguas Azules preview
Address : Carretera Las Morlas Km 14, Varadero, Matanzas, Cuba.
Destination : Varadero
Chain : Cubanacan
from 37
See details
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17