Lily Beach Resort & Spa
Experience one of the finest resorts in Maldives at Lily Beach Resort and Spa as this place is known for its pristine beaches, lush tropical vegetation and the exquisite house reefs set just a few meters away from the shore.
Located in Huvahendhoo Island in the spectacular Alifu Dhaalu Atoll, the place is one of the top All-inclusive Resorts in Maldives, famous for its excellent platinum plan and family friendly activities. Enjoy pure relaxation at Tamara Spa, hit the gym and enjoy some time at the playground, tennis and volley courts. This 5 star All-inclusive Maldives experience is just a spectacular seaplane ride away.
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 ('660') )
) 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.