Hotel Stephan Schmarjestrasse 31 Hamburg
|
Hamburg
|
From |
USD | 51.92 |
EUR | 38.00 |
GBP | 34.14 |
|
|
About the hostel |
In this page you can find all the information about the hostel Hotel Stephan of Hamburg. With Viamundis.com you can reserve your hostel or cheap accommodation at the best possible price. See the description of the hostel Hotel Stephan with the facilities offered, photos, map with directions on how to get to the hostel Hotel Stephan, prices, reviews and comments on the hostel Hotel Stephan. Make your reservation with a credit card, anticipating only a 10 per cent of the total amount to secure the booking. At the end of the booking you will get the phone number and the email address of hostel Hotel Stephan. Also by email you will receive the booking number confirmation with a reminder. Print your reservation and show it at the reception of the hostel on your arrival’s day; the hostel have already the data details of the guests and you just have to start your holiday in Hamburg!
The hotel Stephan is located in a quiet side street, only a few minutes away from the Altona ICE rail station. Harbour, Elbe, Fish market and Reeperbahn can easily be reached on foot, exhibition centre and the musical theatres can be quickly reached by bus or underground.The famous Reeperbahn and the fish market can be reached on foot in no time. The hotel is the ideal base for all kinds of activities and sightseeing in this Hanseatic city.All rooms with shower/wc, tel., TV.We offer cost-free internet access via WLAN.Breakfast EUR 8,00 p.pers./p.day.
|
Address | Hotel Stephan - Schmarjestrasse 31 , 22767, Hamburg, , Germany |
Facilities |
Laundry |
Bicycle Hire |
Swimming Pool |
Children Friendly |
Telephone/Fax Facilities |
24 hour reception |
Lift / Elevator |
Breakfast Not Included |
24 Hour Check In |
| | |
|
1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'viamundi_viamundis.imp_hotels.perma_village' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select Geo_Village, perma_village from imp_hotels where id_country = 69 and id_city = 622 and perma_village != '' group by Geo_Village