Polar regions
SELECT wpuc_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpuc_postmeta price_meta2 WHERE price_meta2.post_id=wpuc_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2025-10-10:2027-10-10' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpuc_postmeta price_meta3 WHERE price_meta3.post_id=wpuc_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpuc_posts INNER JOIN wpuc_postmeta ON ( wpuc_posts.ID = wpuc_postmeta.post_id )
WHERE 1=1 AND (
( wpuc_postmeta.meta_key = 'accommodation_location_post_id' AND wpuc_postmeta.meta_value IN ('147') )
) AND wpuc_posts.post_type = 'accommodation' AND ((wpuc_posts.post_status = 'publish'))
GROUP BY wpuc_posts.ID HAVING 1=1
ORDER BY wpuc_posts.post_title ASC
Unfortunately no accommodations were found.
Kenya - Tanzania
14 Days Kenya Tanzania Tour Safari
Samburu Game reserve, Lake Naivasha, Masai Mara Game, Lake Victoria, Serengeti National Park, Ngorongoro Crater, Amboseli National park.
From
$
Samburu Game reserve, Lake Naivasha,
Masai Mara Game Reserve, Serengeti National Park,
Ngorongoro Crater, Amboseli National park.
Amboseli & Mt Kilimanjaro
3 Days Amboseli and Mount Kilimanjaro Tour Safari
Amboseli National Park and Mount Kilimanjaro.
From
$
This is Amboseli National Park – known as the best place in Africa and indeed, the world to view wild, magnificent herds of elephants.
Join us on this 3-day, 2-night tour through the park viewing elephants, Cape buffalo, impala, lion, cheetah and much more.
Aberdares, Naivasha, Mara
5 Days Aberdares Naivasha and masai Mara Tour Safari
Aberdare National Park, Lake Naivasha national park and Masai Mara Game Reserve
From
$
Transport: 4x4 Landcruiser
Activity level: Moderate
Group size: Private group
Turkana - Chalbi Choma.
5-Days-Turkana-Chalbi Desert-Loiyangalani-Marsabit-Northern-Kenya
Lake Turkana, Chalbi Desert, Loiyangalani, and Marsabit Northern Kenya. | 5 Days
From
$
Transport: Overload Truck.
Activity level: Moderate.
Group size: Medium Private Group.
6 Days Tsavo Ambo
6 Days Tsavo Parks and Amboseli Holiday Tour Safari
Nairobi, Kenya.
From
$
Transport: 4x4 Landcruiser
Activity level: Moderate
Group size: Private group
Lamu Island
7 Days Lamu Island Holiday Tour Safari
Lamu Island, Kenya Coast.
From
$
Tour Departure: Weekly / Custom
Transport: Flying Package
Group size: Private group
Ol Pejeta & Mara
8 Days Ol Pejeta and Masai Mara Kenya Classic Tour Safari
Ol Pejeta Conservancy, Masai Mara National Reserve.
From
$
Transport: 4x4 Landcruiser
Activity level: Moderate
Group size: Private group
Nairobi City Tour
Nairobi National Park, Elephant Orphanage, Giraffe Centre City Tour
Nairobi National Park, Elephant Orphanage and Giraffe Centre Nairobi Kenya.
From
$
- Nairobi City
- Giraffe Centre
- David Sheldrick Wildlife Trust
- Nairobi National Park.