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 = 100' at line 10 Travel Information and Hotel Reservations
Bremen, Germany Not far away from seagulls, plaices and the North Sea, the city of Bremen is located at the Weser. This busy city offers economic connections all over the world. But it keeps as well a romantic part for you: The Stadtmusikanten (musicians of the city of Bremen) the Schnoor (old city of Bremen), the Roland and of course ?Beck?s Beer?. You will find plenty of beds in this city. But the small Hotel Residence keeps a special status. Our hotel is an Oldbremer Patrizierhouse from the beginning of our century. It is situated in a quiet side street in the beautiful part of town Schwachausen near the Buergerpark. The individualy leaded house is large enough for up to 60 vistors an small enough to feel comfortable. The large amount of regular customers is estimating the position of our hotel in the city only 200 m away from central station, about 500 m to town centre, city hall and to the fait and congress centre. They like also the youth style atmosphere with our house confers.
