Honeymoon Villa
Coastal Rd, Roches Noires1 Bedroom | 1 Bath | 3 Pax
Beds: 1 Double, 1 Single.
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-08:2025-06-08' 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 ('5963') )
) AND wpposts.post_type = 'accommodation' AND ((wpposts.post_status = 'publish'))
GROUP BY wpposts.ID HAVING 1=1
ORDER BY wpposts.post_title ASC
Oceane Villa (5Br)
Coastal Rd. Roches Noires
From
€
5 Bedrooms | 4 Baths | 8 Pax
Beds: 2 King, 2 Queen, 1 Single
Oceania Villa (4Br.)
Coastal Rd. Roches Noires
From
€
4 Bedrooms | 2 Baths | 8 Pax
Beds: 1 Queen, 2 Doubles, 2 Bunks
Roches Noires
Roches Noires, situated in the East of the island, north of Poste Lafayette, and about 75 minutes from SSR International Airport, is an exclusive residential area consisting of several luxury villas with thatched roof reminiscent of a past era. They are ideal comfortable hideaways for those seeking tranquillity and peace, away from the urban buzz. The coastal road, free from heavy traffic, is perfect for cycling and jogging. All along its lagoon, there are several secluded tiny coves of white sandy beaches, creating private spots that are well appreciated. The picturesque lagoon, where the colour of the sea is a mixture of emerald and turquoise, is safe for swimming and snorkelling.
Water skiing, wind surfing and parasailing are all very popular activities in the area, but kite surfing is having an edge on them due to the promotion of this sport by Kite-2-Fly club in Poste Lafayette…