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 ('52') 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-12-14 20: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 >= '2017-12-14 20:47' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND f.field_id = 50 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 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 ('52') 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-12-14 20: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 >= '2017-12-14 20:47' ) OR i.created_by = 0 OR i.modified_by = 0 ) AND f.field_id = 50 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 f.value + 0 ASC
Accueil > Mer > Nos logements mer > Roulottes et logements insolites
Roulottes et logements insolites

Roulottes et logements insolites

Partir en hébergement insolite (roulotte, yourte,…) c’est choisir une manière originale et haut de gamme de goûter aux plaisirs des vacances, d’un court séjour ou d’un week-end de plein air à la mer.

1 séjour disponible // Filtrer par :
Trier par :
Produits par page : 6 - 12 - 24
PROMOTION
SAINT CLEMENT DES BALEINES

SAINT CLEMENT DES BALEINES - Charente-Maritime

// YOURTES

Destination "Insolite" pour ces yourtes à l'esprit nomade en pleine nature
- Accès direct à l'océan, plage à 3 km (navette* en saison), beauté de l'Ile de Ré
- Animations nature et soirées animées en saison pour animer vos vacances

Je découvre Je pré-réserve Je réserve

A partir de

329.00 €

la semaine

Partager sur Twitter Partager sur Facebook Ajouter aux favoris

MERCI DE PATIENTER NOUS RECHERCHONS VOTRE SÉJOUR



loader



Produits par page : 6 - 12 - 24

Réservez ou demandez des informations à votre conseiller

ON VOUS RAPPELLE !