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_categories AS c ON c.id = i.catid LEFT JOIN jos_users AS u ON u.id = i.created_by WHERE rel.catid IN ('174') 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 <= '2017-11-19 12:37' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-11-19 12:37' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ie.language LIKE 'fr%' AND i.sectionid = 1 AND ( i.access <= 0 OR i.created_by = 0 OR i.modified_by = 0 ) ORDER BY i.title 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_categories AS c ON c.id = i.catid LEFT JOIN jos_users AS u ON u.id = i.created_by WHERE rel.catid IN ('174') 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 <= '2017-11-19 12:37' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-11-19 12:37' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ie.language LIKE 'fr%' AND i.sectionid = 1 AND ( i.access <= 0 OR i.created_by = 0 OR i.modified_by = 0 ) ORDER BY i.title 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_categories AS c ON c.id = i.catid LEFT JOIN jos_users AS u ON u.id = i.created_by WHERE rel.catid IN ('174') 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 <= '2017-11-19 12:37' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2017-11-19 12:37' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND ie.language LIKE 'fr%' AND i.sectionid = 1 AND ( i.access <= 0 OR i.created_by = 0 OR i.modified_by = 0 ) ORDER BY i.title ASC
Accueil > Sejours thematique > Activités sportives > Offrez-lui des vacances inoubliables > Séjours thématiques > Activités sportives

Envie de faire du vélo?

Le vélo est votre passion ? Découvrez nos sites ayant des chemins VTT ou des pistes cyclables à proximité

Séjour à thème "vélo"

Terrains de tennis à côté du camping

Chez REVEA Vacances, vous pouvez profiter du terrain de tennis situé dans le camping

Liste des destinations

Marches et randonnées

Où faire des randonnées, de la marche avec REVEA ?

Marches / randonnées

Où faire du golf?

Une partie de golf vous tente? Découvrez où vous pouvez pratiquer du golf pendant les vacances

Pratiquer le golf

Envie de faire du cheval?

Découvrez toutes nos destinations qui ont un centre équestre sur place ou à proximité!

Balades à cheval

DESTINATIONS PECHE

Découvrez toutes les destinations REVEA ayant un endroit pour pêcher à proximité.

Où pêcher en France

CANOE

Le canoë fait partie des activités préférées des vacanciers! Découvrez les destinations!

Activité canoë