Pension Madrid

Pension Madrid

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=2686 OR t1.alojamiento_id IN (SELECT alojamientos_id FROM administradores_alojamientos WHERE members_id=2686)) AND t1.alojamiento_id = t2.id AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2021-07-27' ORDER BY descuento DESC

Showing 1 - 10

  1. 1
CH Chelo

Special offers in CH Chelo

Book Online
Offer: 5% discount on Twin. Private bathroom from 27/10/2016 to 31/12/20195% discount on Twin. Private bathroom. Offer from reservation 27/10/2016 to 31/12/2019
Privacy Policy:
Discount: 5%
Offer: 5% discount on Family of 3 people. Private bathroom from 27/10/2016 to 31/12/20195% discount on Family of 3 people. Private bathroom. Offer from reservation 27/10/2016 to 31/12/2019
Privacy Policy:
Discount: 5%
Offer: 5% discount on Family of 4. Private bathroom from 27/10/2016 to 31/12/20195% discount on Family of 4. Private bathroom. Offer from reservation 27/10/2016 to 31/12/2019
Privacy Policy:
Discount: 5%
Offer: 5% discount on Single . Private bathroom from 27/10/2016 to 31/12/20195% discount on Single . Private bathroom. Offer from reservation 27/10/2016 to 31/12/2019
Privacy Policy:
Discount: 5%
Offer: 5% discount on Double bed. Private bathroom from 27/10/2016 to 31/12/20195% discount on Double bed. Private bathroom. Offer from reservation 27/10/2016 to 31/12/2019
Privacy Policy:
Discount: 5%
Offer: 5% discount on Single. Shared bathroom from 27/10/2016 to 31/12/20195% discount on Single. Shared bathroom. Offer from reservation 27/10/2016 to 31/12/2019
Privacy Policy:
Discount: 5%
Recommend this Offer
CH Chelo

Special offers in CH Chelo

Book Online
Offer: 40% discount on Twin. Private bathroom from 15/03/2021 to 30/06/202240% discount on Twin. Private bathroom. Offer from reservation 15/03/2021 to 30/06/2022
Privacy Policy:
Discount: 40%
Offer: 40% discount on Family of 3 people. Private bathroom from 15/03/2021 to 30/06/202240% discount on Family of 3 people. Private bathroom. Offer from reservation 15/03/2021 to 30/06/2022
Privacy Policy:
Discount: 40%
Offer: 40% discount on Family of 4. Private bathroom from 15/03/2021 to 30/06/202240% discount on Family of 4. Private bathroom. Offer from reservation 15/03/2021 to 30/06/2022
Privacy Policy:
Discount: 40%
Offer: 35% discount on Single . Private bathroom from 15/03/2021 to 30/06/202235% discount on Single . Private bathroom. Offer from reservation 15/03/2021 to 30/06/2022
Privacy Policy:
Discount: 35%
Offer: 40% discount on Double bed. Private bathroom from 15/03/2021 to 30/06/202240% discount on Double bed. Private bathroom. Offer from reservation 15/03/2021 to 30/06/2022
Privacy Policy:
Discount: 40%
Recommend this Offer

Showing 1 - 10

  1. 1