You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'-20\' at line 1 SQL=SELECT id, name, alias, site, type, Catering, Bedrooms, Bathrooms, Resort, Quality, propertytype, summary, ski_in_out, hottub, sauna, logfire, woodstove, pool_indoor, pool_outdoor_year, pool_outdoor_summer, gym, shared_use, ( CASE WHEN availabilityURL LIKE \'%.ics%\' THEN CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2020-08-12\') THEN \'3\' ELSE \'2\' END ELSE CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2020-08-12\') THEN \'1\' ELSE \'0\' END END ) as availability FROM jos_hp_properties_new as p WHERE p.published = \'1\' AND p.site = \'chamonixskichalets.com\' AND id NOT IN ("242", "953", "1452", "1445", "1444", "950", "1441", "1443", "942", "942", "1456", "952", "1392", "1455") AND id IN ("517", "1479", "442", "961", "1369", "246", "964", "115", "316", "1522", "100", "123", "1494", "726", "70", "1371", "228", "1372", "141", "1430", "81", "296", "86") AND ( weekly = \'X\' OR weekly = \'on\') ORDER BY availability DESC, modified DESC LIMIT 20 OFFSET -20
22 Results found. 

Chalets available for February Half-Term 2019

Call for booking information

No Property exists
22 Results found.