Kaashidhoo
SELECT F1Exf_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM F1Exf_postmeta price_meta2 WHERE price_meta2.post_id=F1Exf_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-09-14:2028-09-14' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM F1Exf_postmeta price_meta3 WHERE price_meta3.post_id=F1Exf_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM F1Exf_posts INNER JOIN F1Exf_postmeta ON ( F1Exf_posts.ID = F1Exf_postmeta.post_id )
WHERE 1=1 AND (
( F1Exf_postmeta.meta_key = 'accommodation_location_post_id' AND F1Exf_postmeta.meta_value IN ('5811') )
) AND F1Exf_posts.post_type = 'accommodation' AND ((F1Exf_posts.post_status = 'publish'))
GROUP BY F1Exf_posts.ID HAVING 1=1
ORDER BY F1Exf_posts.post_title ASC
Unfortunately no accommodations were found.
Kaashidhoo
Kaashidhoo (Dhivehi: ކާށިދޫ) is one of the inhabited islands of Kaafu Atoll. It is located at the northern tip of Malé atoll and is the fifth biggest island in the entire Maldivian archipelago. Kaashidhoo is well known for its wealth in coconut trees.
Kaashidhoo is included in the Malé Atoll. However it is an atoll by itself geographically. For the ease of administration the island is placed under Kaafu Atoll.
Source:Wikipedia
| Visa requirements | All tourists from all countries are granted a free 30-day visa upon arrival. However, all visitors need to have a valid passport. If a passport expiry date falls within 30 days of arrival, tourists cannot extend their stay beyond the passport’s expiry date. |
|---|---|
| Languages spoken | English, Dhivehi |
| Currency used | United States Dollar (USD), Maldivian Rufiyaa (MVR) |
| Country name | Maldives |
Unfortunately no tours were found.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.