select [type] from [customtable_price_data] where NodeID='9825' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='9825' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about Karmiel
- The name Karmiel means ‘God’s Vineyards’.
- The city was established in 1964.
- In 1981 it won the ‘Beautiful Israel’ award.
- It suffered a major rocket attack from Lebanon in 2006.
- The city is a recognised environmentally friendly city.
Karmiel Mini Guide
What can you Tell me About Karmiel?
Karmiel was one of the first planned Israeli towns when it was first constructed in the 1960s. After many protests, the city began to grow on land expropriated from local farmers. Since its early days it has grown considerably due to the prevalence of successful agricultural ventures in the area and the pride that its inhabitants take in the city has led to it winning the ‘Beautiful Israel’ prize. There is little of interest in the city itself but it is a good base for exploring the surrounding area and, in particular, the archaeologically important areas around Tiberias and Lake Galilee. The city is also known for its green credentials and the sustainability of its services.
How do I get to Karmiel?
The closest airport is Haifa International Airport but, despite the name, it only takes flights from Ovda and Eilat
. The most accessible truly international airport to the city is Tel Aviv Ben Gurion Airport
, some hours away. Trains to Haifa
can get you to within a 45 minute bus journey of Karmiel or you may prefer to hire a car to get there independently.
What is There for Entertainment in Karmiel?
Apart from bars and coffee shops, there’s not much to entertain of an evening but once a year, for three days in July, the city and the surrounding area come alive to the sounds of the Karmiel Dance Festival. Originally a local festival, the doors have been opened to international dance competitors and now over twenty countries are represented. For the duration, the city is decorated with banners and pennants and impromptu dance spectacles break out all over the city, day and night. At other times of year, the city is content to remain a quiet backwater to the major cities of the coast.