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 > \'2019-03-20\') THEN \'3\' ELSE \'2\' END ELSE CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2019-03-20\') 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 ( Catering = \'Catered\' OR Catering = \'Optional Catered or Self Catered\' OR Catering = \'Self-Catered in Summer & Catered in Winter\' ) ORDER BY availability DESC, modified DESC LIMIT 20 OFFSET -20
91 Results found. 
 

Catered Chamonix Chalets

 

Here is a list of wonderful catered Chamonix chalet holidays to suit all preferences and budgets throughout the Chamonix valley. We offer a wide selection of catered Chamonix Chalets. For more details  please make an enquiry (at the top of ever property listing) so we can advise you whether you are looking for your ski holiday, corporate ski trip, family skiing, company ski event, ski weekend or summer trip to Chamonix with friends and family. 

 

Booking Line: +44 (0) 845 460 0606 | info@chamonixskichalets.com 


No Property exists
91 Results found.