ReservationOn-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>='2018-04-23' AND t2.f_inicio <= '2018-08-22' AND t1.tipo_oferta_id <> '7' ORDER BY t1.prioridad
Desarrollo: fnsRooms
Terms and Conditions | Privacy statement
Hostal Real

Hostel Aranjuez

C / Infantas, 4 and 6

28300 - Madrid

Phone: (+34) 91 809 03 69

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.