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 > \'2024-08-28\') THEN \'3\' ELSE \'2\' END ELSE CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2024-08-28\') 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 ( weekly = \'X\' OR weekly = \'on\') AND ( ski_in_out = \'X\' OR ski_in_out = \'o\') ORDER BY availability DESC, modified DESC LIMIT 20 OFFSET -20
42 Results found.
Ski in, ski out chalets...
Imagine a ski holiday where you can walk out your front door and straight onto the slopes. No walking in ski boots, no bus rides, simply step into your skis or snowboard and start skiing.
If this sounds like your ideal skiing holiday, then take a look at our selection of ski-in, ski-out chalets and hotels. Not only are these chalets and apartments located right by the pistes, their locations also offer breathtaking views of the surrounding slopes and snow covered mountains.
Every one of these properties is a favourite of one of the team, so do call us for exact details and distances