Golf del Sur Holiday Rentals

Golf del Sur Holiday Rentals

Self catering holiday rental villas, apartments and other accommodation in Golf del Sur.
RENT DIRECT FROM THE OWNER.

Golf del Sur Holiday Rentals Offers / Late Deals

Offers / late deals on holiday rental accommodation in Golf del Sur, 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