Soneva Jani
Inspired by the Sanskrit word meaning ‘Wisdom’ Soneva Jani, collection of Water Villas and Island Sanctuaries is located in the Medhufaru lagoon in the Noonu Atoll. With just a 40 minute seaplane ride away from the Ibrahim Nasir International Airport, this resort is surrounded by a 5.6 kilometre Private lagoon and the famous crystal clear waters of Maldives assured to bring a sense of calmness into your mind. Soneva Jani is one the most highly anticipated resort of 2016, all the more reason to convince your mind of spending your unforgettable holidays at this place.
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-15:2026-10-15' 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 ('578') )
) 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.