Nika Island
NIKA ISLAND RESORT is the only island in the Maldives where you will find private beaches in every villa, it’s the ideal place for complete relaxation.
Only 43 villas, all of which boast unique architecture: 6 Garden room, 10 Beach Villas, 10 Deluxe Beach Villas, 3 Family Beach Villas, 3 Family Deluxe Beach Villas, 1 Sultan Suite and 10 Water Villas on an island surrounded by a stunning house reef, luxurious vegetation and all enhanced by our friendly staff who will make you feel right at home.
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 ('785') )
) 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.