Hostal Barcelona - Salamanca Hostels

Hostal Barcelona - Salamanca Hostels

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=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>'2021-10-28' ORDER BY descuento DESC

Showing 1 - 10

  1. 1
Hostal Barcelona

Special offers in Hostal Barcelona

Book Online
Offer: Single. Private bathroom from 21/10/2020 to 31/12/2022Single. Private bathroom. Offer from reservation 21/10/2020 to 31/12/2022
Privacy Policy:
Offer: 2 beds or double (subject to availability). Private bathroom from 21/10/2020 to 31/12/20222 beds or double (subject to availability). Private bathroom. Offer from reservation 21/10/2020 to 31/12/2022
Privacy Policy:
Offer: Twin + 1 extra bed. Private bathroom from 21/10/2020 to 31/12/2022Twin + 1 extra bed. Private bathroom. Offer from reservation 21/10/2020 to 31/12/2022
Privacy Policy:
Offer: Triple. Private bathroom from 21/10/2020 to 31/12/2022Triple. Private bathroom. Offer from reservation 21/10/2020 to 31/12/2022
Privacy Policy:
Recommend this Offer

Showing 1 - 10

  1. 1