SELECT wpoh_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpoh_postmeta price_meta2 WHERE price_meta2.post_id=wpoh_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-08-28:2027-08-28' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpoh_postmeta price_meta3 WHERE price_meta3.post_id=wpoh_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpoh_posts INNER JOIN wpoh_postmeta ON ( wpoh_posts.ID = wpoh_postmeta.post_id )
WHERE 1=1 AND (
( wpoh_postmeta.meta_key = 'accommodation_location_post_id' AND wpoh_postmeta.meta_value IN ('4602') )
) AND wpoh_posts.post_type = 'accommodation' AND ((wpoh_posts.post_status = 'publish'))
GROUP BY wpoh_posts.ID HAVING 1=1
ORDER BY wpoh_posts.post_title ASC
Nzema
Home to Ghana’s founding father, Osagyefo Dr.Kwame Nkrumah and also one of the most popular tourist destinations in Ghana. Nzema is home to the Nzema speaking people which is a subset of the Akan group. The most popular tourist attraction here is the Nzulezo village as know as the stilt village on water.
Although Nzema is not a location, but a sub-group of the Akan people located mainly on western-most coastal region of the country, there are several tourist and historic sites located within several Nzema communities. A few but important ones include the famouse Nzulezu village on water, Ankasa forest, fort orange etc.
Unfortunately no tours were found.
Unfortunately no car rentals were found.