Hostal en Benidorm - Mapa

Mapa - Hostal en Benidorm

SELECT DISTINCT(t1.id) FROM alojamientos as t1 WHERE t1.visible = '0' AND t1.ciudad_id = '23' 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 = '23' 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 = '23' 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 = '23' AND t1.tipo_alojamiento = 'casa' ORDER BY t1.nombre