Ayada Maldives
Voted ‘Indian Ocean’s Leading Luxury Resort’ and the ‘Indian Ocean’s Leading Villa Resort & Spa’ Ayada Maldives offers a Maldivian style holiday set in Gaafu Dhaalu Atoll in south of the Maldives.
Famous for its gardens, tropical greenery and the pristine coral reef coral reefs where dolphins can often be found swimming joyfully this resort is also famous for its sunset weddings.
Ayada Maldives resort contains 122 well known spacious villas and suites. From beach villas to ocean suites the choices in the place to accommodate are many to choose from.
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-12-12:2026-12-12' 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 ('536') )
) 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.