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 > \'2017-03-27\') THEN \'3\' ELSE \'2\' END ELSE CASE WHEN EXISTS (SELECT 1 FROM jos_hp_prices WHERE property = p.id AND arrivaldate > \'2017-03-27\') THEN \'1\' ELSE \'0\' END END ) as availability FROM jos_hp_properties_new as p WHERE p.published = \'1\' AND p.site = \'verbierchalets.com\' AND ( weekly = \'X\' OR weekly = \'on\') AND propertytype = \'Apartment\' ORDER BY availability DESC, modified DESC LIMIT 20 OFFSET -20
54 Results found.
One of the great aspects of Verbier is the wide selection of self-catered Verbier apartments that are available through out the year. Apartments in Verbier come in many shapes and sizes and in a variety of town center and more remote locations. Whether you are seeking the height of luxury or a comfortable well appointed Verbier ski of summer apartment there is usually plenty to choose from. In the high season weeks at the end of December and for example, mid-February demand for Verbier self-catered apartments can be pretty high, so it is always an advantage , if possible, to book well ahead of time. That;s probably where Verbier Chalets and our team can come in an help progress your search for an ideal Verbier ski apartment or holiday letting.
Without much ado, we will send your enquiry to the best operators and apartment owners and provide you with a shortlist of suitable apartments for you to consider at any time of year.