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 = 128' at line 10
Carcavelos, Portugal Located in a quite place, near the Carcavelos beach, 20kms from Lisbon, it's a familiar hotel, surrounded by commercial stores and restaurants, providing a pleasant stay, for tourism, business or simply to rest. It's friendly staff will attend your needs as if you are in your own home. Services: Restaurant, Bar, Gifts Shop, Internet Room, Tennis Court (exterior), WIFI area, Rent-a-car. Near the Beach , Train Station, Weekly fairs and Nautic Sports.