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 = 54' at line 10
Bodrum, Turkey A friendly hotel which enjoys a fantastic location in Turgutreis. From the balcony of the hotel you can enjoy the spectacular views, while drinking your Turkish tea or coffee. The beach is just past the harbour and there is a promenade lined with bars, cafes, shops and restaurants. The main town shops and market are within walking distances. Alba Marin Hotel offers its guests all year round, an unmatched personalized service in an cosy and comfortable atmosphere.