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-06-13:2027-06-13' 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 ('433') )
) 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.
Best Seller
Combo Package – Undersea Walk, Parasailing and Tube Ride
Coastal Road, Belle Mare
From
$
Enjoy a combination of three watersport activities at a packaged price. Make the most of the day by going for our combo package that comprise of Tube Ride, Undersea Walk and Parasailing. Equipped with all safety accessories you embark on a journey underwater, drifting along waves and flying over the blue turquoise lagoon of Belle Mare.
Parasailing
Coastal Road, Belle Mare
From
$
Launched with full power! Enjoy 1km of Parasailing Adventure with the exhilarating sensation of flight making this single moment an unforgettable experiment with a drone view of Belle Mare!!
Undersea Walk
Coastal Road, Belle Mare
From
$
Like Neptune and little Ariel, go down on the sand bed and spend 15-20 minutes journey with the fishes. An amazing opportunity to see the marine life in the crystal clear water in the lagoon of Belle Mare.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.