Booking 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=95 OR t1.alojamiento_id IN (SELECT alojamientos_id FROM administradores_alojamientos WHERE members_id=95)) AND t1.alojamiento_id = t2.id AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2026-04-30' ORDER BY descuento DESC
SELECT DISTINCT(t1.oferta_id) as oferta_id, t1.alojamiento_id FROM ofertas as t1, ofertas_restricciones as t3 WHERE t1.alojamiento_id = 1424 AND t1.oferta_id=t3.oferta_id AND t3.f_fin>'2026-04-30' ORDER BY descuento DESC

Showing 1 - 10

  1. 1
Hostal JQ

Special offers in Hostal JQ

Book Online
Double bed. Private bathroom - Non Refundable0% discount on Double bed. Private bathroom. Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Twin. Private bathroom - Non Refundable0% discount on Twin. Private bathroom. Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Triple. Private bathroom - Non Refundable0% discount on Triple. Private bathroom. Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Four people room. Private bathroom - Non Refundable0% discount on Four people room. Private bathroom. Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Single. Private bathroom - Non Refundable0% discount on Single. Private bathroom. Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Double bed. Private bathroom - Non Refundable0% discount on Double bed. Private bathroom. Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Family Suite. Private bathroom. - Non Refundable0% discount on Family Suite. Private bathroom.. Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Estudio Doble Deluxe - Non Refundable0% discount on Estudio Doble Deluxe . Offer from reservation 24/03/2026 to 31/12/2027 - Non Refundable
Privacy Policy:
From: 999,00 €
Recommend this Offer
Hostal JQ

Special offers in Hostal JQ

Book Online
Offer: Double bed. Private bathroom by 999,00 € night from 24/03/2026 to 31/12/2027Double bed. Private bathroom by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Offer: Twin. Private bathroom by 999,00 € night from 24/03/2026 to 31/12/2027Twin. Private bathroom by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Offer: Triple. Private bathroom by 999,00 € night from 24/03/2026 to 31/12/2027Triple. Private bathroom by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Offer: Four people room. Private bathroom by 999,00 € night from 24/03/2026 to 31/12/2027Four people room. Private bathroom by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Offer: Single. Private bathroom by 999,00 € night from 24/03/2026 to 31/12/2027Single. Private bathroom by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Offer: Double bed. Private bathroom by 999,00 € night from 24/03/2026 to 31/12/2027Double bed. Private bathroom by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Offer: Family Suite. Private bathroom. by 999,00 € night from 24/03/2026 to 31/12/2027Family Suite. Private bathroom. by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Offer: Estudio Doble Deluxe by 999,00 € night from 24/03/2026 to 31/12/2027 Estudio Doble Deluxe by 999,00 € night. Offer from reservation 24/03/2026 to 31/12/2027. Minimum Stay 4 night
Privacy Policy:
From: 999,00 €
Recommend this Offer

Showing 1 - 10

  1. 1