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 ('7') 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 21:47' ) 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 21:47' ) 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 ('7') 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 21:47' ) 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 21:47' ) 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 > Countryside > Countryside stays > Great West
Great West

Great West

In the colorful campaign "Great West", the pine forests of Charentes to Brittany and Normandy through the castles of the Loire and Touraine, discover landscapes and extraordinary cultural wealth of these regions and enjoy with family the many activities: cycling, fishing, hiking, swimming.
11 Available stays // Filter by :
Sort out by :
Products by page : 6 - 12 - 24
PROMOTION
BROSSAC

BROSSAC - Charente

// Lodges

- New in 2017: indoor swimming pool with aquagym lessons
- Outdoor swimming pool
- Sandy beach of the Vallier pond and its nautical activities

Check out Pre-booking Booking

From

149.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
BEGARD

BEGARD - Côtes d'Armor

// Chalets

Close to the Armoripark leisure park: heated swimming pool, toboggan aquatic, pentogliss...
30 mins away from the ocean
Chalet all confort with TV and Wifi

Check out Pre-booking Booking

From

149.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
MONCONTOUR

MONCONTOUR - Vienne

// Lodges, Chalets

Unusually wide range of watersports
Charming lodges and chalets

Check out Pre-booking Booking

From

198.80 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
RICHELIEU

RICHELIEU - Indre-et-Loire

// Apartments

Eco-friendly Residence
Comfortable apartments

Check out Pre-booking Booking

From

199.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
SAINT VALERIEN

SAINT VALERIEN - Vendée

// Chalets

- Indoor and heated swimming-pool
- Lake fishing
- Family-friendly site

Check out Pre-booking Booking

From

199.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
LA ROCHE POSAY

LA ROCHE POSAY - Vienne

// Apartments

Welcome à La Roche Posay,
- Well-known spa
- Comfortable residence

Check out Pre-booking Booking

From

219.10 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites

THANKS FOR WAITING WE ARE SEARCHING YOUR DESTINATION



loader



Products by page : 6 - 12 - 24 Prev1 - 2Next

Book or request information with your advisor

WE CALL YOU BACK !