SELECT l3s3xGGA3_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM l3s3xGGA3_postmeta price_meta2 WHERE price_meta2.post_id=l3s3xGGA3_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-01-22:2027-01-22' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM l3s3xGGA3_postmeta price_meta3 WHERE price_meta3.post_id=l3s3xGGA3_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM l3s3xGGA3_posts INNER JOIN l3s3xGGA3_postmeta ON ( l3s3xGGA3_posts.ID = l3s3xGGA3_postmeta.post_id )
WHERE 1=1 AND (
( l3s3xGGA3_postmeta.meta_key = 'accommodation_location_post_id' AND l3s3xGGA3_postmeta.meta_value IN ('437') )
) AND l3s3xGGA3_posts.post_type = 'accommodation' AND ((l3s3xGGA3_posts.post_status = 'publish'))
GROUP BY l3s3xGGA3_posts.ID HAVING 1=1
ORDER BY l3s3xGGA3_posts.post_title ASC
Unfortunately no accommodations were found.
5 Islands Tour *East Coast – Ile aux Cerfs + Ile aux Flamants + Ile au Phare + Ile De La Passe + Ile aux Aigrettes + GRSE Waterfall + Lunch & Drinks
Coastal Road, Belle Mare
From
$
Seas the Day! With a unique experience in discovering the East Coast of Mauritius. An unforgettable trip from Trou D'eau Douce to the Blue Bay Marine Park, thus discovering the five islets in the turquoise Lagoon.
Any 2 activities + Full Day Speedboat – GRSE Waterfall + Lunch&Drinks + Ile Aux Cerfs
Coastal Road, Belle Mare
From
$
Any 2 Activities + Full Day Speedboat - GRSE Waterfall + Lunch&Drinks + Ile aux Cerfs
Full Day Adventure: Parasailing + Tube Ride + Underseawalk + Full Day Speedboat – G.R.S.E Waterfall + BBQ Lunch + Ile aux Cerfs
Coastal Road, Belle Mare
From
$
Full-Day Speed Boat & Water Activities + Lunch
Visit to GRSE Waterfall with Stop at Ile Aux Cerf & Lunch
Coastal Road, Belle Mare
From
$
- Visit of G.R.S.E Waterfalls
- Visit of Ile aux Cerfs
- Lunch
Unfortunately no cruises were found.
Unfortunately no car rentals were found.