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
Twin lakes safari Lodge is a beautiful accommodation located in serene surroundings of the magnificent Bunyaruguru crater area overlooking Queen Elizabeth national park with views of beautiful sunrises and sunsets.
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.