Los Cristianos Holiday Rentals

Los Cristianos Holiday Rentals

Self catering holiday rental villas, apartments and other accommodation in Los Cristianos.
RENT DIRECT FROM THE OWNER.

Los Cristianos Holiday Rentals Offers / Late Deals

Offers / late deals on holiday rental accommodation in Los Cristianos, Tenerife.

request "Could not execute SQL query" SELECT 4is_accommodations.*,MIN(4is_accommodations_prices.price) as price, 4is_speacial_offers.description as late_desc, 4is_speacial_offers.discount as late_discount, 4is_speacial_offers.week_price as late_week_price , 4is_speacial_offers.date_apply_from as late_date_apply_from, 4is_speacial_offers.week_price2 as late_week_price2 , 4is_speacial_offers.date_apply_from as late_date_apply_from, 4is_speacial_offers.date_apply_to as late_date_apply_to FROM 4is_accommodations INNER JOIN 4is_accommodations_prices ON 4is_accommodations.id=4is_accommodations_prices.accommodation_id LEFT JOIN 4is_speacial_offers ON 4is_accommodations.id=4is_speacial_offers.property_id INNER JOIN 4is_cities ON 4is_accommodations.location_id=4is_cities.id WHERE 4is_accommodations.accommodation_status='Approved' AND 4is_accommodations.date_expiration>now() AND 4is_speacial_offers.date_apply_to > now() AND 4is_speacial_offers.date_apply_from <= now() AND (4is_accommodations.date_feature_expiration < NOW() OR 4is_accommodations.date_feature_expiration IS NULL) AND () AND () GROUP BY 4is_accommodations.id ORDER BY 4is_accommodations.type DESC, price