Hotels Santiago de Chile

Hotels Santiago de Chile

Offers

SELECT DISTINCT(t1.oferta_id) FROM ofertas as t1, ofertas_restricciones as t2, alojamientos as t4 WHERE t1.interna = 0 AND t1.oferta_id = t2.oferta_id AND t1.alojamiento_id = t4.id AND t4.member_id = 718 AND t2.f_fin>='2018-10-20' AND t2.f_inicio <= '2019-12-31' AND t1.tipo_oferta_id <> '7'

Hotel Vegas

Offer: 4% discount from 19/01/2018 to 31/12/2019

4% discount. Offer from reservation 19/01/2018 to 31/12/2019 ...

Discount 7%

Hotel Vegas

Offer Non Refundable - 5% discount from 20/04/2018 to 31/12/2019

Non Refundable - 5% discount. Offer from reservation 20/04/2018 to 31/12/2019 ...

Discount 8%

Apartamentos Vegas

Offer Non Refundable - 5% discount from 16/12/2017 to 31/12/2019

Non Refundable - 5% discount. Offer from reservation 16/12/2017 to 31/12/2019 ...

Discount 5%

Hotel Vegas

Offer Non Refundable - 3% discount from 01/02/2019 to 28/02/2019

Non Refundable - 3% discount. Offer from reservation 01/02/2019 to 28/02/2019 ...

Discount 9%
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.