SELECT DISTINCT(t1.oferta_id) as oferta_id, t1.alojamiento_id FROM ofertas as t1, ofertas_restricciones as t3 WHERE t1.alojamiento_id = 41 AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2024-04-26' ORDER BY descuento DESC
Offer description; Privacy Policy:
If you cancel the reservation up to 5 days before the arrival date, the accommodation will not charge additional charges. Within those 5 days, the entire reservation will be charged, if the card does not pass, the reservation will be canceled.
Discount: 27.00%
Offer description; Privacy Policy:
If you cancel the reservation up to 5 days before the arrival date, the accommodation will not charge additional charges. Within those 5 days, the entire reservation will be charged, if the card does not pass, the reservation will be canceled.
