Dhravandhoo
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 ('52') )
) 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
Blue World Dharavandhoo Guest House
Dharavandhoo Island
From
US$
Experience the island of Dharavandhoo in all its glory, lush tropical vegetation, simple Maldivian life, peaceful serene environment. All experienced at leisurely accommodations of Blue World Dharavandhoo Maldives.
Star Tree Guesthouse
Dharavandhoo Island
From
US$
Experience the beautiful island of Dharavandhoo, the lush tropical vegetation, the pristine white sandy beaches, and the azure water that surrounds. All at the comfort of the Star Tree Guesthouse
Unfortunately no tours were found.