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 = 180' at line 10
Sao Vicente, Portugal Ideally situated in one of the most beautiful valleys of Madeira, Estalagem do Vale consists of an XVIII century manor house, with great historical value, which has been restored and enlarged to become a modern and luxurious four star hotel-inn. The hotel has 41 rooms (one of which has been specially adapted for the disabled), restaurant, bar, wine-cellar, games room, library, internet zone, children?s playground, heated indoor & outdoor swimming pool, mini-golf course, croquet field, bowling green, sauna, Turkish bath, gymnasium & jacuzzi. We also have a 24 hr reception service & free car park. In addition to its own gardens, the property is set in rural surroundings, in the valley of S?o Vicente, which is part of the 'Laurissilva' or forest of lauraceas madeirense, today a UNESCO World Heritage Nature Site, because of the rare and the richness of its flora of the Tertiary Period. From the Estalagem you are able to appreciate the magnificent views of the valley, which is set against a contrasting backdrop of huge mountains that end, as if by magic, as they descend towards the deep blue waters of the Atlantic Ocean to the north. The wide horizons, sun-drenched location and surrounding nature create a peerless setting of uncommon beauty.