Puerto del Carmen Holiday Rentals

Puerto del Carmen Property for Sale

Property for Sale and property selling services in
Puerto del Carmen
Puerto del Carmen Property Owners
Advertise Free Now!

Puerto del Carmen Holiday Rentals Offers / Late Deals

Offers / late deals on holiday rental accommodation in Puerto del Carmen, Lanzarote.

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