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=wpml_translations_default.element_id AND price_meta2.meta_key='_accommodation_min_price:2026-04-27:2028-04-27' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_postmeta price_meta3 WHERE price_meta3.post_id=wpml_translations_default.element_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 ) JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) LEFT JOIN wp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND (wpml_translations_default.source_language_code IS NULL OR wpml_translations.source_language_code IS NULL)
WHERE 1=1 AND (
( wp_postmeta.meta_key = 'accommodation_location_post_id' AND wp_postmeta.meta_value IN ('17984','4202') )
) AND wp_posts.post_type = 'accommodation' AND ((wp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','room_type','accommodation','wpcf7_contact_form','ufaq','mc4wp-form' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','location','room_type','accommodation','wpcf7_contact_form','ufaq','mc4wp-form' ) )
GROUP BY wp_posts.ID HAVING 1=1
ORDER BY wp_posts.post_title ASC
Step into a world of vibrant luxury on a private tropical island. Perfect for families, this trendy resort offers the region's largest kids club and one of the Maldives' longest pools.
Kuda Vilingili Resort Maldives combines barefoot luxury with family-friendly comfort. Guests can enjoy spacious villas, a wide choice of dining options, one of the Maldives’ largest pools, and plenty of activities for both adults and children, from water sports and surfing to a kids’ club designed for younger travelers. It is only a 30 minute speedboat ride away from Male airport.
Niyama, a five-star paradise, offers dual islands – one for serene retreat, the other for thrilling adventures. Families love Play Island with nature-inspired activities.
Patina Maldives is a stylish resort with a strong focus on family well-being and connection. It embraces a holistic philosophy, with nourishing dining, wellness programs, and sustainable practices woven into the experience, allowing parents and children alike to reconnect with nature, themselves, and each other.
Six Senses Laamu is a luxury eco-resort in the Laamu Atoll, blending barefoot luxury with sustainability and natural beauty. With stylish overwater and beach villas, the resort offers privacy and comfort, while focusing on wellness, organic dining, and marine conservation.
Soneva Fushi is a barefoot-luxury sanctuary tucked away on its own private island in the Baa Atoll. Set amidst swaying palms and powder-white sands, the resort offers elegant villas constructed from reclaimed timber and local materials - following its strong focus on sustainability.
The Maldives are simply paradise on earth: they have sunshine, crystal clear waters, deserted beaches and many very nice family friendly resorts where you can relax during your stay. The best time to visit the islands is between November and April: the climate is dry and the weather is sunny, with beautiful blue cloudless skies.
