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 ('44') 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:50' ) 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:50' ) 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 ('44') 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:50' ) 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:50' ) 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 > Sea > Seaside stays > Great West
Great West

Great West

Pinewoods Charentaises the mysterious Britain through the Ile d'Oleron and the vendee or Normandy beaches, we welcome you in lodge, cottage, mobile home, apartment or unusual accommodation for a holiday, a short break or a weekend end closest to the nature and the Atlantic Ocean.
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
PROMOTION
PENTREZ

PENTREZ - Finistère

// VILLAS

You'll love...
High-quality Residence with sea-view
Heated, indoor swimming pool on-site in Pentrez

Check out Pre-booking Booking

From

186.30 €

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 DENIS D OLERON

SAINT DENIS D OLERON - Charente-Maritime

// Lodges

Beaches 300 m away
Good-sized indoor swimming pool on-site

Check out Pre-booking Booking

From

229.00 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
CAMIERS

CAMIERS - Pas-de-Calais

// Mobile homes

- Close to the sea 3 km away (free shuttles on summer)
- Heated outdoor pool
- Beautiful landscapes

Check out Pre-booking Booking

From

232.05 €

the week

PARTAGER_TWITTER PARTAGER_FACEBOOK Add to favourites
PROMOTION
FOUESNANT

FOUESNANT - Finistère

// Mobile homes

2 swimming pool
Campside situated at the heart of a delight fall area

Check out Pre-booking Booking

From

264.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 - 2Next

Book or request information with your advisor

WE CALL YOU BACK !