SELECT wppp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wppp_postmeta price_meta2 WHERE price_meta2.post_id=wppp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-03-07:2028-03-07' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wppp_postmeta price_meta3 WHERE price_meta3.post_id=wppp_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wppp_posts INNER JOIN wppp_postmeta ON ( wppp_posts.ID = wppp_postmeta.post_id )
WHERE 1=1 AND (
( wppp_postmeta.meta_key = 'accommodation_location_post_id' AND wppp_postmeta.meta_value IN ('5174') )
) AND wppp_posts.post_type = 'accommodation' AND ((wppp_posts.post_status = 'publish'))
GROUP BY wppp_posts.ID HAVING 1=1
ORDER BY wppp_posts.post_title ASC
Koforidua
Known for its vast expanse of greenery and mountainous terrains. Koforidua is one of the most peaceful places to live in the country.
Unfortunately no tours were found.
Unfortunately no car rentals were found.