SELECT wp_sr576n_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_sr576n_postmeta price_meta2 WHERE price_meta2.post_id=wp_sr576n_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2024-12-23:2026-12-23' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wp_sr576n_postmeta price_meta3 WHERE price_meta3.post_id=wp_sr576n_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wp_sr576n_posts INNER JOIN wp_sr576n_postmeta ON ( wp_sr576n_posts.ID = wp_sr576n_postmeta.post_id )
WHERE 1=1 AND (
( wp_sr576n_postmeta.meta_key = 'accommodation_location_post_id' AND wp_sr576n_postmeta.meta_value IN ('1854') )
) AND wp_sr576n_posts.post_type = 'accommodation' AND ((wp_sr576n_posts.post_status = 'publish'))
GROUP BY wp_sr576n_posts.ID HAVING 1=1
ORDER BY wp_sr576n_posts.post_title ASC
Unfortunately no accommodations were found.
1 day Gorilla Trekking
Kigali-Volcanoes National Park-Musanze-Kigali
From
$
Embark on this extraordinary Gorilla Trekking adventure, and witness the wonders of Rwanda's wildlife in their natural habitat. This tour takes you to Volcanoes National Park and the gorillas and back to Kigali all in one day
12 days All of Rwanda Tour package
Kigali-Bugesera-Akagera-Nyanza-Huye-Nyungwe-Lake Kivu-Volcanoes
From
$
Explore everything Rwanda has to offer in this 12 day package
2 days Gorilla Trekking with Diane Fossey Tomb Visit
Kigali-Musanze-Volcanoes National Park
From
$
Combine hiking on the Virunga Volcanoes with gorilla trekking in Volcanoes National Park
5 days Package in Rwanda
Kigali-Volcanoes-Lake Kivu-Goma
From
$
Visit the main highlights of Rwanda, Volcanoes, Heritage and Wildlife while stay at 5* accommodation
Taylor made Packages
Rwanda
From
$
Contact us to design your own package depending on your interests, time or budget, just send us a request and we get back to you in 1 day to finalize on your desired package for Rwanda.
Unfortunately no car rentals were found.
