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:2025-06-23:2027-06-23' 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 ('4688') )
) 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
Cape Coast
Cape Coast, or Cabo Corso, is a city and fishing port, and the capital of Cape Coast Metropolitan District and Central Region of south Ghana. Cape Coast is situated on its south to the Gulf of Guinea. Cape Coast had a settlement population of 169,894 people (2010 census).[1] From the 16th century until Ghanaian independence, the city and fishing port changed hands between the British, the Portuguese, the Swedish, the Danish and the Dutch. Hotels in Cape Coast are generally affordable and can start from as low as $20 per night.
Book hotels in Cape Coast. Find the lowest room rates, book online and pay at the hotel. Cape Coast is one Ghana’s most popular tourist destinations with its many castles and forts.
