SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM jos_content AS i LEFT JOIN jos_flexicontent_items_ext AS ie ON ie.item_id = i.id LEFT JOIN jos_flexicontent_types AS ty ON ie.type_id = ty.id LEFT JOIN jos_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jos_flexicontent_fields_item_relations AS f ON f.item_id = i.id LEFT JOIN jos_categories AS c ON c.id = i.catid LEFT JOIN jos_users AS u ON u.id = i.created_by WHERE rel.catid IN ('25') AND ( i.state IN (1, -5) OR i.created_by = 0 OR i.modified_by = 0 ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-12-14 22:35' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-12-14 22:35' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND f.field_id = 50 AND ie.language LIKE 'en%' AND i.sectionid = 1 AND ( i.access <= 0 OR i.created_by = 0 OR i.modified_by = 0 ) ORDER BY f.value + 0 ASC
SELECT DISTINCT i.*, ie.*, u.name as author, ty.name AS typename, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug FROM jos_content AS i LEFT JOIN jos_flexicontent_items_ext AS ie ON ie.item_id = i.id LEFT JOIN jos_flexicontent_types AS ty ON ie.type_id = ty.id LEFT JOIN jos_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN jos_flexicontent_fields_item_relations AS f ON f.item_id = i.id LEFT JOIN jos_categories AS c ON c.id = i.catid LEFT JOIN jos_users AS u ON u.id = i.created_by WHERE rel.catid IN ('25') AND ( i.state IN (1, -5) OR i.created_by = 0 OR i.modified_by = 0 ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-12-14 22:35' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-12-14 22:35' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND f.field_id = 50 AND ie.language LIKE 'en%' AND i.sectionid = 1 AND ( i.access <= 0 OR i.created_by = 0 OR i.modified_by = 0 ) ORDER BY f.value + 0 ASC
Home > Mountain > Mountains accomodations > chalets or mobile home on campsite
Chalets or mobile home on campsite

Chalets or mobile home on campsite

Staying in a chalet or mobile home is choosing a holiday, short break or weekend close to nature, true nest fully equipped and located in a hamlet on a campsite in the montain.
3 Available stays // Filter by :
Sort out by :
Products by page : 6 - 12 - 24
THONON LES BAINS

THONON LES BAINS - Haute-Savoie

// Mobile homes

On the Leman lakeside
Beach with facilities for all the family
Entertainments on summertime with kid's club, sport, nigth themes

Check out Pre-booking Booking

From

208.25 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
SOUILLAC SUR DORDOGNE

SOUILLAC SUR DORDOGNE - Lot

// Mobile homes

The charm and beauty of the property, ideal for your countryside holiday in the Lot
Possibility for 10 and 11 night stays in July/August
Close to major sight-seeing sites: Rocamadour, Sarlat, Collonges-La-Rouge

Check out Pre-booking Booking

From

209.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
CHEMILLE SUR INDROIS

CHEMILLE SUR INDROIS - Indre-et-Loire

// Lodges, Chalets

- Ours is a special location adjacent to the lake in a verdant countryside and still close to the fabulous Loire Valley Chateaux and zoo Beauval
- Heated swimming pool
- Many nature activities: fishing, hiking, biking ...

Check out Pre-booking Booking

From

230.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites

THANKS FOR WAITING WE ARE SEARCHING YOUR DESTINATION



loader



Products by page : 6 - 12 - 24

Book or request information with your advisor

WE CALL YOU BACK !