Hostal en Alicante - Mapa

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