Adaaran Select Hudhuranfushi
Adaaran Select Hudhuranfushi is set in 83 acres of lush tropical beach property near Kani Beach on Lhohifushi Island, the resort’s design enables it to blend into its surroundings creating a tranquil aura around it.
The 165 air conditioned villas are equipped with contemporary amenities, elegant furnishings and décor complimented by tropical themes.
Savour a slice of paradise at the 37 Ocean Villas exude a world of refinement and luxury coupled with a host of exclusive facilities . The air conditioned villas are complete with modern amenities and a private sun deck with 24 hour access to the surrounding ocean.
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-13:2026-10-13' 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 ('1276') )
) 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.