Book Online.

Offers

SELECT DISTINCT(t1.oferta_id) as oferta_id, t1.alojamiento_id FROM ofertas as t1, ofertas_restricciones as t3, alojamientos as t2 WHERE (t2.member_id=216 OR t1.alojamiento_id IN (SELECT alojamientos_id FROM administradores_alojamientos WHERE members_id=216)) AND t1.alojamiento_id = t2.id AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2017-10-23' ORDER BY descuento DESC

Showing 1 - 10

  1. 1
Hostal Arteaga

Special offers in Hostal Arteaga

Book Online
Offer: 5% discount on Double or Twin Room - With bathroom from 28/03/2016 to 31/12/20175% discount on Double or Twin Room - With bathroom. Offer from reservation 28/03/2016 to 31/12/2017
Privacy Policy:
Discount: 5%
Offer: 5% discount on Triple. Complete bathroom from 28/03/2016 to 31/12/20175% discount on Triple. Complete bathroom. Offer from reservation 28/03/2016 to 31/12/2017
Privacy Policy:
Discount: 5%
Offer: 5% discount on Cuadruple - With bathroom from 28/03/2016 to 31/12/20175% discount on Cuadruple - With bathroom. Offer from reservation 28/03/2016 to 31/12/2017
Privacy Policy:
Discount: 5%
Offer: 5% discount on Single. Private bathroom from 28/03/2016 to 31/12/20175% discount on Single. Private bathroom. Offer from reservation 28/03/2016 to 31/12/2017
Privacy Policy:
Discount: 5%
Recommend this Offer

Showing 1 - 10

  1. 1
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.
Cookies Policy +