Hostal Menorca

Mapa - Hostal en Menorca

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