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:2025-11-17:2027-11-17' 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 ('2068') )
) 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
5 Bedroom Hanimaadhoo Villa
Hanimaadhoo Local Island
From
US$
300
Searching for the perfect villa rental for a long stay holiday in Maldives? This 5 bedroom villa offers a lush backyard along with leisurely amenities and easy access to the beach for a spectacular stay at the beautiful island of Hanimaadhoo.
Kottafaru Guest House
Hanimaadhoo
From
US$
With the inclusion from their private rooms, guests will be able to enjoy all the common areas in the hotel such as the living room, swimming pool area and the outdoor dining area surrounded by trees at Kottafaru Guesthouse.
The Barefoot Eco Hotel
Hanimaadhoo
From
US$
A half mile private sandy beach and a turquoise lagoon frame the hotel inviting you to experience an authentic and relaxing holiday at outstanding value.
Unfortunately no tours were found.