KHUN HABIBI
KHUN HABIBI
KHUN HABIBI
KHUN HABIBI

Maafushi

Maafushi (Dhivehi: ) is an inhabited island in Kaafu Atoll and the suggested capital of the Maldives' Medhu Uthuru Province. It is known for the Maafushi Prison.

Tourists from neighboring resort islands visit Maafushi for island hopping, and Maafushi provides them with shopping opportunities at designated areas of the island.

Maafushi

WordPress database error: [Not unique table/alias: 'tb']
SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id WHERE 1=1 AND ((wpsr_posts.post_type = 'st_tours' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_hotel')) AND tb.check_in >= 1781049600 AND tb.check_out <= 1781136000 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_tours')) AND CASE WHEN ISNULL(tb.max_people) THEN 1=1 WHEN tb.max_people = '' THEN 1=1 WHEN tb.max_people = '0' THEN 1=1 ELSE tb.max_people >= 1 END GROUP BY wpsr_posts.ID ORDER BY tb_st_tours.is_featured desc LIMIT 0, 4

WordPress database error: [Not unique table/alias: 'tb']
SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id INNER JOIN wpsr_st_activity as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_activity as tb_st_activity ON wpsr_posts.ID = tb_st_activity.post_id WHERE 1=1 AND ((wpsr_posts.post_type = 'st_activity' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_hotel')) AND tb.check_in >= 1781049600 AND tb.check_out <= 1781136000 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_tours')) AND CASE WHEN ISNULL(tb.max_people) THEN 1=1 WHEN tb.max_people = '' THEN 1=1 WHEN tb.max_people = '0' THEN 1=1 ELSE tb.max_people >= 1 END AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_activity')) GROUP BY wpsr_posts.ID ORDER BY tb_st_activity.is_featured desc LIMIT 0, 4

WordPress database error: [Not unique table/alias: 'tb']
SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id INNER JOIN wpsr_st_activity as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_activity as tb_st_activity ON wpsr_posts.ID = tb_st_activity.post_id INNER JOIN wpsr_st_cars as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON wpsr_posts.ID = tb_postmeta.post_id WHERE 1=1 AND ((wpsr_posts.post_type = 'st_cars' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_hotel')) AND tb.check_in >= 1781049600 AND tb.check_out <= 1781136000 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_tours')) AND CASE WHEN ISNULL(tb.max_people) THEN 1=1 WHEN tb.max_people = '' THEN 1=1 WHEN tb.max_people = '0' THEN 1=1 ELSE tb.max_people >= 1 END AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_activity')) AND tb_postmeta.meta_key = 'car_type' AND tb_postmeta.meta_value = 'normal' GROUP BY wpsr_posts.ID ORDER BY tb.is_featured desc LIMIT 0, 4

Stories, tips, and guides

WordPress database error: [Not unique table/alias: 'tb']
SELECT SQL_CALC_FOUND_ROWS wpsr_posts.*, min(CAST(CASE WHEN IFNULL(tb.adult_price, 0) = 0 THEN tb.price ELSE tb.adult_price END AS DECIMAL) ) as st_price FROM wpsr_posts INNER JOIN wpsr_st_room_availability as tb ON wpsr_posts.ID = tb.parent_id AND status = 'available' INNER JOIN wpsr_hotel_room as tb3 ON (tb.post_id = tb3.post_id and tb3.`status` IN ('publish', 'private')) INNER JOIN wpsr_st_hotel as tb2 ON wpsr_posts.ID = tb2.post_id INNER JOIN wpsr_st_tours as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_tours as tb_st_tours ON wpsr_posts.ID = tb_st_tours.post_id INNER JOIN wpsr_st_activity as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wpsr_st_activity as tb_st_activity ON wpsr_posts.ID = tb_st_activity.post_id INNER JOIN wpsr_st_cars as tb ON wpsr_posts.ID = tb.post_id INNER JOIN wpsr_postmeta as tb_postmeta ON wpsr_posts.ID = tb_postmeta.post_id WHERE 1=1 AND ((wpsr_posts.post_type = 'post' AND (wpsr_posts.post_status = 'publish'))) AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_hotel')) AND tb.check_in >= 1781049600 AND tb.check_out <= 1781136000 AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_tours')) AND CASE WHEN ISNULL(tb.max_people) THEN 1=1 WHEN tb.max_people = '' THEN 1=1 WHEN tb.max_people = '0' THEN 1=1 ELSE tb.max_people >= 1 END AND wpsr_posts.ID IN (SELECT post_id FROM wpsr_st_location_relationships WHERE 1=1 AND location_from IN ('14510') AND post_type IN ('st_activity')) AND tb_postmeta.meta_key = 'car_type' AND tb_postmeta.meta_value = 'normal' GROUP BY wpsr_posts.ID ORDER BY tb.is_featured desc LIMIT 0, 8

Get special offers, and more from Traveler

Subscribe to see secret deals prices drop the moment you sign up!

[mc4wp_form id="92"]