SELECT wpbu_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpbu_postmeta price_meta2 WHERE price_meta2.post_id=wpbu_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-09-17:2026-09-17' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpbu_postmeta price_meta3 WHERE price_meta3.post_id=wpbu_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpbu_posts INNER JOIN wpbu_postmeta ON ( wpbu_posts.ID = wpbu_postmeta.post_id )
WHERE 1=1 AND (
( wpbu_postmeta.meta_key = 'accommodation_location_post_id' AND wpbu_postmeta.meta_value IN ('4775') )
) AND wpbu_posts.post_type = 'accommodation' AND ((wpbu_posts.post_status = 'publish'))
GROUP BY wpbu_posts.ID HAVING 1=1
ORDER BY wpbu_posts.post_title ASC
AMIS Monicana
Mauritius, Cap Malheureux, Bain Boeuf, 31702
From
$
This lovely unit offers guests an ideal location, especially for sea adventurers, with Just Diving Mauritius 100m away offering diving and snorkeling excursions, as well as diving lessons, opposite the beach. The nearby beach provides the ideal area for a stroll, while you enjoy the view that will be sure to leave you feeling relaxed and refreshed.
Athena Villamoya
Mauritius, Grand Baie, Pereybere, 30501
From
$
For a unique perspective of the island, consider taking a boat tour, offering breathtaking views of Mauritius' coastline. This Villa not only provides a luxurious stay but also serves as a gateway to the diverse and exciting experiences that Pereybere has to offer. Indulge in the beauty of this paradise on earth, where the crisp blue skies and pristine clear beaches await your arrival.
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.