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 = 235' at line 10 Travel Information and Hotel Reservations
Riga, Latvia Islande Hotel was opened on March 2006.The hotel is located in Kipsala, in the center of Riga - 10 minutes walk from the Old Town.For comfort of our guests we offer 205 well equipped rooms.All rooms are arranged in a modern reserved Scandinavian style.As well in the hotel you will find - 5 conference rooms, business centre, bowling hall,SPA and wellness center, gym, souvenir shop, closed parking lot. The Hotel offers rooms for non-smokers and smokers, 29 non-allergic rooms, and 7 rooms for guests with special needs.
