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 ('208') 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:31' ) 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:31' ) 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 ('208') 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:31' ) 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:31' ) 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 > Destinations REVEA lacs et rivières
Destinations REVEA lacs et rivières

Destinations REVEA lacs et rivières

Vous cherchez un camping au bord d'un lac ?

Partir en camping en bord de lac ou en bord de rivière, c'est choisir un environnement calme et apaisant pour votre séjour.

Idéal pour partir en famille, ou entre amis, dans différentes régions de France, les destinations lacs et rivières sont synonymes de moments apaisants.

Pour profiter pleinement des joies de l'eau, vous pourrez vous adonner à une multitude d'activités  : base nautique (avec planche à voile, ski nautique, kayak, canoës, pédalos), pêche, et baignade en rivière.

Entre les joies de l'eau et la nature environnante, vous repartirez sans aucun doute la tête remplie de bons moments !

22 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
USSON EN FOREZ

USSON EN FOREZ - Loire

// Lodges

Artificial lake with direct access to the beach
The entire park is pedestrian
Fly Fishing

Check out Pre-booking Booking

From

149.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
CHATELUS MALVALEIX

CHATELUS MALVALEIX - Creuse

// Chalets

A warm and friendly welcome,
Very close to the village
Certified by FFCT (French Cycling Federation)

Check out Pre-booking Booking

From

142.50 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
TONNERRE

TONNERRE - Yonne

// Chalets

Close to the vineyards of Chablis and Tonnerre
Swimming in the river and in the new pool at the campsite
Campsite with trees and ideally located on the edge of the Burgundy Canal\

Check out Pre-booking Booking

From

149.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
SAINT JACQUES D\'AMBUR

SAINT JACQUES D'AMBUR - Puy-de-dôme

// Lodges

Beautiful site with lodges overlooking the lake
Very close to Vulcania - European Volcano Centre

Check out Pre-booking Booking

From

177.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
MONCLAR DE QUERCY

MONCLAR DE QUERCY - Tarn-et-Garonne

// Lodges

- 2 swimming-pools (including 1 indoor)
- Leisure base 200 m from the site with beach, water slides and many activities - New activitie 2017: Water Fun Park
- Chalets spacious and well equipped in the greenery for a stay in the Quercy any comfort

Check out Pre-booking Booking

From

189.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 Prev1 - 2 - 3 - 4Next

Book or request information with your advisor

WE CALL YOU BACK !