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:2024-07-27:2026-07-27' 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](https://i0.wp.com/safarike.com/wp-content/uploads/2019/01/14-Days-Kenya-Tanzania-Tour-Safari.jpg?resize=400%2C300&ssl=1)
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.
![5 Days Aberdares Naivasha and masai Mara Tour Packages Feature](https://i0.wp.com/safarike.com/wp-content/uploads/2019/01/5-Days-Aberdares-Naivasha-and-masai-Mara-Tour-Packages-Feature.jpg?resize=400%2C300&ssl=1)
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
Marsabit & Lake Turukana with Mbuzi Choma.
![Wildlife in Kenya](https://i0.wp.com/safarike.com/wp-content/uploads/2022/02/Safarike-Chalbi-Desert.jpg?resize=400%2C300&ssl=1)
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.
![7 Days Lamu Island Holiday Tour Safari](https://i0.wp.com/safarike.com/wp-content/uploads/2019/01/7-Days-Lamu-Island-Holiday-Tour-Safari.jpg?resize=400%2C300&ssl=1)
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 Tour Packages Feature](https://i0.wp.com/safarike.com/wp-content/uploads/2019/01/Ol-Pejeta-Tour-Packages-Feature.jpg?resize=400%2C300&ssl=1)
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
![Giraffe at the giraffe center](https://i0.wp.com/safarike.com/wp-content/uploads/2022/12/Giraffe-at-the-giraffe-center.jpg?resize=400%2C300&ssl=1)
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.
Unfortunately no cruises were found.
Unfortunately no car rentals were found.