Eden Villa
Coastal Rd. Pointe Lafayette4 Bedrooms | 3 Baths | 8 Pax
Beds: 2 King, 2 Queen, 1 Sofa
SELECT wpposts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wppostmeta price_meta2 WHERE price_meta2.post_id=wpposts.ID AND price_meta2.meta_key='_accommodation_min_price:2023-06-09:2025-06-09' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wppostmeta price_meta3 WHERE price_meta3.post_id=wpposts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpposts INNER JOIN wppostmeta ON ( wpposts.ID = wppostmeta.post_id )
WHERE 1=1 AND (
( wppostmeta.meta_key = 'accommodation_location_post_id' AND wppostmeta.meta_value IN ('5961') )
) AND wpposts.post_type = 'accommodation' AND ((wpposts.post_status = 'publish'))
GROUP BY wpposts.ID HAVING 1=1
ORDER BY wpposts.post_title ASC
Koki Bonheur (4Br)
Coastal Rd. Poste Lafayette
From
€
4 Bedrooms | 4 Baths | 8 Guests.
Bedding: 3 Queen, 2 Single.
Lafayette Villa 1
Coastal Rd. Poste Lafayette.
From
€
5 Bedrooms | 3 Baths | 12 Pax
Beds: 2 King, 2 Queen, 2 Doubles
Lafayette Villa 2
Coastal Rd. Poste Lafayette
From
€
3 Bedrooms | 3 Baths | 6 Pax
Beds: 3 Queen
Lafayette Villa 3
Coastal Rd. Poste Lafayette
From
€
3 Bedrooms | 3 Baths | 6 Pax
Beds: 3 Queen
Poste Lafayette
Poste Lafayette is a lovely and peaceful resort situated on the east coast, 1 kilometre south of Roches Noires, and about 75 minutes drive from SSR International Airport. Its coastal road is free from heavy traffic and is perfect for cycling, jogging and pleasant walks. The temperature is pleasant all the year round. When the west coast is suffering from the heat in summer months (November to February), this area stays cool, although it could be fairly windy in winter.
Splendid view over the lagoon with turquoise waters where swimming and snorkelling are safe. Scuba diving, parasailing and wind surfing are very popular all year round, while deep sea fishing is restricted to the summer months only. Kite-surfing tuition is given at Kite-2-Fly Club, promoting this quite young sport where beginners learn to take-off, jump and perform acrobatic figures…