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 prestigious restaurants, amenities, private schools, and an extensive promenade where you can enjoy long walks and do some physical exercise.