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 ('35','1','16','29','30','31','32','40','41','53','54','138','139','152','160','161','165','166','167','168','169','170','182','183','184','185','201','203','205','206','208','209','211','212') 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:15' ) 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:15' ) 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 ) AND i.id IN (251,285,310,475,501,543,1100,1102,1139,1149) 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 ('35','1','16','29','30','31','32','40','41','53','54','138','139','152','160','161','165','166','167','168','169','170','182','183','184','185','201','203','205','206','208','209','211','212') 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:15' ) 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:15' ) 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 ) AND i.id IN (251,285,310,475,501,543,1100,1102,1139,1149) ORDER BY f.value + 0 ASC
Home > Destinations > Weekend breaks in the Pays de la Loire > Offer unforgettable holidays
Offer unforgettable holidays

REVEA VACANCES : color your desires


Sports, relaxation, fun ? What do you expect from your holidays?

In the countryside or in the mountains, near the sea or lake, with friends or family, there will be something for everyone!

Discover our destinations in unspoilt nature, colored to your wishes for a weekend or a week!


2 Available stays // Filter by :
Sort out by :
Products by page : 6 - 12 - 24
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
PROMOTION
LA BOISSIERE DE MONTAIGU

LA BOISSIERE DE MONTAIGU - Vendée

// Chalets

Property with private lake

Heated outdoor swimming pool and large slide
Puy du Fou medieval theme park 20 kms away
Numerous summer activities with organized evenings and children's club

Check out Pre-booking Booking

From

304.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 !