Constance Halaveli
Floating in the North Ari atoll and shaped like a curved Dhoni; (Maldivian boat) Constance Halaveli is a magical place where water and sand lie in contrast to the exuberant green foliage.
Indulge in fine food and sumptuous flavours at Jahaz, Jing and Meeru restaurants
For palate pleasing cocktails; divine vinous experiences, step in Jahaz, Jing Bar & Wine Cellars
Be prepared for a memorable escape at Constance Halaveli Maldives!
SELECT wp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_postmeta price_meta2 WHERE price_meta2.post_id=wp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-10-14:2026-10-14' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('675') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish'))
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Unfortunately no tours were found.