Majestic five-bedroom apartment on the Douro river's waterfront area, with a gross floor area of 286 square meters and sweeping river views, located in a prestigious gated community with 24/7 concierge service. The apartment features five suites and an amazing 70-square-meter living room with various environments, a heat stove, and a magnificent 31-square-meter balcony with a dining area. There is also a separate 22-square-meter dining room with direct access to the kitchen. The spacious kitchen offers abundant natural light and includes a laundry room. Unfinished apartment, sold with the existing finishes: pre-installed air conditioning in all rooms, underfloor heating in the bathrooms, and pre-installed central vacuum cleaning system. It includes one parking space and a storage room. Extraordinary location, just a few minutes away from Foz do Douro and very close to the city center. Perfect for those looking for a cosmopolitan living experience, close to shops, supermarkets, and a variety of services. It is situated a short distance away from the German School, the Nossa Senhora de Lurdes School and the Faculties of Architecture, Science, and Arts of the University of Porto. It is also located about two kilometers away from the Bom Sucesso Market and Casa da Música. There are green areas and leisure areas nearby, such as Porto's Botanical Garden, the Crystal Palace Gardens and the Serralves Gardens. The area is well served by public transportation, with bus and tram stops a few meters away. It is four minutes away from the accesses to the VCI, allowing for quick commute to other points of interest in the city.