reservaon-line

SELECT DISTINCT(t1.oferta_id) FROM ofertas as t1, ofertas_restricciones as t2 WHERE t1.interna = 0 AND t1.oferta_id = t2.oferta_id AND t1.alojamiento_id = '1664' AND t2.f_fin>='2017-09-25' AND t2.f_inicio <= '2018-01-23' AND t1.tipo_oferta_id <> '7' ORDER BY t1.prioridad
Hostal real

Hostel Aranjuez

C / Infantas, 4 e 6

28300 - Madrid

Telefone: (+34) 91 809 03 69

+