SELECT DISTINCT(t1.oferta_id) as oferta_id, t1.alojamiento_id FROM ofertas as t1, ofertas_restricciones as t3 WHERE t1.alojamiento_id = 7397 AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2024-04-26' ORDER BY descuento DESC
Offer description;
10% discount on Estudio Planta Baja . Offer from reservation 16/02/2022 to 31/12/2023 - Non Refundable Privacy Policy:
Discount: 10.00%
Apartamento/Estudio Cama de Matrimonio - Non Refundable
Offer description;
10% discount on Apartamento/Estudio Cama de Matrimonio. Offer from reservation 16/02/2022 to 31/12/2023 - Non Refundable Privacy Policy:
Discount: 10.00%
Apartment 2 persons maximum - Non Refundable
Offer description;
10% discount on Apartment 2 persons maximum. Offer from reservation 16/02/2022 to 31/12/2023 - Non Refundable Privacy Policy:
