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=422 OR t1.alojamiento_id IN (SELECT alojamientos_id FROM administradores_alojamientos WHERE members_id=422)) AND t1.alojamiento_id = t2.id AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2024-04-26' ORDER BY descuento DESC
Special offers in Hostal Bonany
Book Online
Offer: 11% discount on Double Room with Balcony from 01/03/2022 to 31/12/202311% discount on Double Room with Balcony. Offer from reservation 01/03/2022 to 31/12/2023. Minimum Stay 7 night
Discount: 10.00%
Offer: 11% discount on Economy Double Room from 01/03/2022 to 31/12/202311% discount on Economy Double Room. Offer from reservation 01/03/2022 to 31/12/2023. Minimum Stay 7 night
Discount: 10.00%
Special offers in Hostal Bonany
Book Online
Offer: Double Room with Balcony from 15/02/2022 to 31/12/2023Double Room with Balcony. Offer from reservation 15/02/2022 to 31/12/2023
Discount: -10.00%
Offer: Economy Double Room from 15/02/2022 to 31/12/2023Economy Double Room. Offer from reservation 15/02/2022 to 31/12/2023
Discount: -10.00%
