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>'2024-05-20' ORDER BY descuento DESC

Showing 1 - 10

  1. 1
Hostal Barcelona

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
Privacy Policy:
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
Privacy Policy:
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
Privacy Policy:
Offer: Triple. Private bathroom from 10/04/2024 to 31/12/2024Triple. Private bathroom. Offer from reservation 10/04/2024 to 31/12/2024
Privacy Policy:
Recommend this Offer

Showing 1 - 10

  1. 1