Sun Island Resort
The Exotic World of Sun Island Resort
Set in the sapphire lagoon, this 5 star resort is 113km away from Ibrahim Nasir International airport. The Resort is accessible through a 17 minute airplane ride which you will find quite enjoyable and a great opportunity to capture some awesome snaps.
Winner of the world travel award 2013, Maldives travel Awards 2012 and trip Advisor 2013, the resort is one of the biggest in Maldives and is filled with luxury and excitement for you to engage in. You can have the choice of accommodations from beach bungalows to water bungalows. Experience what this 5 star resort has to offer.
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-09:2026-10-09' 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 ('585') )
) 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
