DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 241' at line 10
Herten, Germany Our 3 star family owned and managed property with excellent location towards the Ruhr is perfect linked to the motorways A3, A43, A42 and the trade fair grounds of Bochum, Dortmund, D?sseldorf, Cologne and Essen as well as to the airports of D?sseldorf and Dortmund. Location right next to the Hertener Schlo?park with the gothic watercastle. The hotel has a restaurant, a very cosy bar, a conservatory and a summer terrace. Convention guests can use our conference room at ground level with daylight.