Holiday in Pemba Island Zanzibar
Holiday in Pemba Islands Zanzibar
Located north of Zanzibar itself, Pemba has only a scattering of top properties but a wonderfully off the beaten track feel and laid back approach to island life. It is not a classic beach destination, as the beaches are not nearly as good as on Zanzibar. However, the diving is world-class and there are some beautiful offshore islands with powder-white beaches. This is a good place for the active, untouched coral and an abundance of marine life make Pemba perfect for snorkelling, diving and fishing, while boat trips can be taken to explore some of the offshore islands.
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:2024-12-30:2026-12-30' 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 ('2187') )
) 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
Unfortunately no accommodations were found.
Unfortunately no tours were found.
.
