Your Searchresults 1 -
15
of
sort by price
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=600 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=618 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=628 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=640 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=643 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=959 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1273 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=834 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=829 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=626 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1275 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=608 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=636 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1093 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1289 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=536 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=907 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=904 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=625 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1020 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1277 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1343 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=638 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=598 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=873 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=606 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1305 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=953 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=979 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1046 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=898 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=612 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=624 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=876 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1072 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1406 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=692 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=603 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=622 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=725 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=957 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1136 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=468 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=602 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=944 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=592 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=989 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=504 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=528 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=964 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=613 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1064 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=633 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=940 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1143 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1065 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=832 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1030 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=605 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1364 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=601 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=438 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=627 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=620 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=577 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=948 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1015 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1360 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=867 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=442 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=665 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=629 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1013 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1139 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1137 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1283 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1404 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1297 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=925 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=632 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1299 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1362 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=433 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
Hatari Lodge
The history of Mt Meru is ancient. Momella has been part of it for the last 100 years. In 1906 Margarete Trappe arrived on an ox wagon from the coast. Her courage and pioneering spirit set the tone......
Hatari Lodge
- Place: Tanzania, Arusha National Park, Arusha
- Price: starts with 240 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Kilimanjaro, Retro Style, Hardy Krüger & John Wayne, Meru Krater, luxury tents
- Description: The history of Mt Meru is ancient. Momella has been part of it for the last 100 years. In 1906 Margarete Trappe arrived on an ox wagon from the coast. Her courage and pioneering spirit set the tone...
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=587 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1057 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=831 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1008 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1295 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=842 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=467 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=634 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1366 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=609 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=590 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=749 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1381 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=596 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=614 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=455 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=641 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=646 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=899 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1066 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
40.9222
-2.2993
The Majlis Resort
The Majlis is a privately owned resort set on Manda Island in the Lamu archipelago off Kenya´s north coast. The Hotel is elegantly desined and boasts the best views of the Ras Kitau bay. Only a 10 minutes......
The Majlis Resort
- Place: Kenya, Lamu Archipelago, Lamu Islands
- Price: starts with 280 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Idyllic, luxurious, stylish & eco hotel
- Description: The Majlis is a privately owned resort set on Manda Island in the Lamu archipelago off Kenya´s north coast. The Hotel is elegantly desined and boasts the best views of the Ras Kitau bay. Only a 10 minutes...
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1047 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1392 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=866 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=946 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=635 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=694 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=888 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1132 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=615 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=883 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=540 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=623 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1368 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=942 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=576 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1111 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
19.2815770
-34.4080469
Birkenhead House
Birkenhead House & Villa is located in unspoilt natural surroundings and only 1 1/2 hour from Cape Town. This retreat offers uninterrupted views and finest international cuisine.Perched high on the Hermanus......
Birkenhead House
- Place: South Africa, Cape Town, Hermanus
- Price: starts with 325 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: whale watching, deep- sea fishing, unspoiled nature, wine farms
- Description: Birkenhead House & Villa is located in unspoilt natural surroundings and only 1 1/2 hour from Cape Town. This retreat offers uninterrupted views and finest international cuisine.Perched high on the Hermanus...
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=821 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=644 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=950 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1147 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1285 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1383 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=812 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=864 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1038 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=645 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=729 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1097 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=358 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=491 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1394 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=637 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
34.8431006
-2.2703050
Bilila Lodge
The opening of the Bilila Lodge was on the 1st of June 2009 in the heart of Tanzanias world-famous Serengeti National Park. A dream hideaway in the Central Serengeti, it is destined to become one of the......
Bilila Lodge
- Place: Tanzania, Serengeti, Robanda
- Price: starts with 460 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: The opening of the Bilila Lodge was on the 1st of June 2009 in the heart of Tanzanias world-famous Serengeti National Park. A dream hideaway in the Central Serengeti, it is destined to become one of the...
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1388 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=983 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=860 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=525 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=621 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=572 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=631 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1398 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=923 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1193 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=827 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1402 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=995 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
37.3390946
-3.3538024
The Retreat Selous
The Retreat, located in Northern Selous, is a twelve-suite exquisite hideaway that offers complete seclusion in the heart of remote bush lands. The Selous Game Reserve is the largest protected wildlife......
The Retreat Selous
- Place: Tanzania, Selous Game Reserve, Selous
- Price: starts with 780 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Hippos, luxury tents, outdoor bathtubs
- Description: The Retreat, located in Northern Selous, is a twelve-suite exquisite hideaway that offers complete seclusion in the heart of remote bush lands. The Selous Game Reserve is the largest protected wildlife...
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1179 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=874 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1019 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
31.1638
-24.516
Royal Malewane
Royal Malewane is situated on a private reserve within the greater Kruger National Park Area of South Africa. 13 000 hectares (30 000 Acres) provide a balance of spectacular game and wildlife viewing.Royal......
Royal Malewane
- Place: Southafrica, Kruger National Park, Hoedspruit
- Price: starts with 1020 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: safari, luxury & gourmet in the wilderness
- Description: Royal Malewane is situated on a private reserve within the greater Kruger National Park Area of South Africa. 13 000 hectares (30 000 Acres) provide a balance of spectacular game and wildlife viewing.Royal...
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=845 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_erlebnis t1 join hotels_hotel_erlebnis t2 on t1.id=t2.erlebnis_id
where t2.hotel_id=1009 and (t1.name='Safari' or t1.name_en='Safari')
order by t2.hotel_id
6
Finest Lodges Destinations
- Argentina
- Austria
- Barbados
- Belgium
- Brasil
- Croatia
- Czech Republic
- England
- France
- Germany
- Greece
- Italy
- Kenya
- Maldives
- Morocco
- Netherlands
- Portugal
- South Africa
- Southafrica
- Spain
- Switzerland
- Tanzania
- Turkey
- USA
Most Rated Holidays
- Finest Lodges
- About Finest Lodges
- Partners
- Blog
- Terms & Conditions
- Privileges
- Special Deals
- Gifts
- become a Member
- Incentives
- Contact
- Adress
- Jobs & Careers
- Imprint
- copyright
