SELECT SQL_CALC_FOUND_ROWS 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:2023-09-26:2025-09-26' 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 LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (81,91)
) 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
LIMIT 0, 2
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.
Zanzibar is everything you imagine of an Indian Ocean island – mile upon mile of beautiful beaches lined with palm trees and turquoise waters. The relaxed pace of island life is evident the moment you step off the plane.
Book African gorilla tours & gorilla trekking safaris with us; to visit mountain gorillas in Uganda, Rwanda & Congo (in bwindi & the virunga mountains and have your safari planned with the right care and attention.
We offer options for both high-end & mid-range gorilla trekking tours to all Africa Gorilla parks with gorilla permits. We also organize African wildlife safaris to all East African countries at pocket friendly rates. Some of our experiences include big five safaris, group tours, solo travel, honeymoon holidays, Photography safaris and Cultural Adventures.