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=495 OR t1.alojamiento_id IN (SELECT alojamientos_id FROM administradores_alojamientos WHERE members_id=495)) AND t1.alojamiento_id = t2.id AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2024-09-15' ORDER BY descuento DESC
Special offers in Hostal Barcelona
Book Online
Offer: Single. Private bathroom from 10/04/2024 to 31/12/2024Single. Private bathroom. Offer from reservation 10/04/2024 to 31/12/2024
Offer: 2 beds or double (subject to availability). Private bathroom from 10/04/2024 to 31/12/20242 beds or double (subject to availability). Private bathroom. Offer from reservation 10/04/2024 to 31/12/2024
Offer: Twin + 1 extra bed. Private bathroom from 10/04/2024 to 31/12/2024Twin + 1 extra bed. Private bathroom. Offer from reservation 10/04/2024 to 31/12/2024
Offer: Triple. Private bathroom from 10/04/2024 to 31/12/2024Triple. Private bathroom. Offer from reservation 10/04/2024 to 31/12/2024
