Map - Salou Guesthouse

SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '29' AND t1.zona_id = '117' AND t1.tipo_alojamiento = 'hostal' ORDER BY t1.nombre
SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '29' AND t1.zona_id = '117' AND t1.tipo_alojamiento = 'apartamento' ORDER BY t1.nombre
SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '29' AND t1.zona_id = '117' AND t1.tipo_alojamiento = 'hotel' ORDER BY t1.nombre
SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '29' AND t1.zona_id = '117' AND t1.tipo_alojamiento = 'casa' ORDER BY t1.nombre
This website uses cookies to ensure you get the best experience on our website. Read the Cookies Policy. By clicking any link on this page you are giving your consent for us to set cookies.