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.

View All Los Cristianos Holiday Rental Accommodation.

View rental accommodation in the Los Cristianos area of 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_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