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 = 183' at line 10 Travel Information and Hotel Reservations
Hamburg, Germany Individual, informal, close to the city center! The Apartment-Hotel is a privately owned and managed, certified 3-Star-Superior-Hotel. It offers a total of 119 generously proportioned guest rooms with a home-from-home ambiance. The hotel is conveniently located for downtown Hamburg, the congress and exhibition centers, the Port of Hamburg and St. Pauli landing stages, the historic Warehouse City, the musical theaters and many others of the citys attractions. All of them are easy to reach by public transport. For guests who arrive by car, there is ample parking on the parking deck or in the secure underground car park. Living well does not need to be expensive, as you will see from the value you get for your money, and the friendly, guest-oriented staff will make you feel welcome and at home. No matter whether you are spending just one night or an entire month at the Apartment-Hotel. The hotel is the ideal place for a short stay for business or private reasons or as a long term domicile. All rooms feature kitchenettes with refrigerator and microwave, partly also with cooking facilities. Special offers are available for stays longer than 30 days. 3 complete floors with a total of 45 rooms are reserved for non-smokers and also the breakfast restaurant is non smoking area.
