Magnificent villa located in Oliveira do Douro, set on a plot of approximately 12,000 square meters with around 140 meters of riverfront. The terraced terrain, supported by imposing concrete walls covered with granite stone, allows for breathtaking and majestic views of the Douro River. The villa is spread across two floors, with the ground floor hosting all the social areas and the first floor housing the private zone with bedrooms. In the social area, there are two living rooms, both featuring fireplaces, a dining room, a kitchen, a bar area, a gym, an office, and a guest bathroom. Additionally, on this floor, there is a changing room area supporting the outdoor pool, equipped with a Turkish bath (hammam). The recently remodeled kitchen is fully equipped and stands out for its use of high-quality materials, including Corian countertops and island, and cabinets with "Pau Ferro" details. Adjacent to the kitchen, there is a spacious pantry room with ample storage. On the first floor, there are two suites, with the master suite boasting a spacious closet and a balcony with a river view, as well as three bedrooms supported by a complete bathroom. Throughout the house, including the bathrooms, there is solid Afizélia wood flooring, and the walls have air-filled clay "Leca" for perfect thermal insulation. The property is equipped with Central Vacuum System and Ducted Air Conditioning from the brand Daikin, with individual control for each division. The house's energy efficiency is well taken care of, featuring double exterior walls with polyurethane foam insulation in between, and the water heating is done through a heat pump connected to six solar panels. Outside the house, there is a laundry annex and an en-suite room for the maid. The idyllic outdoor pool area, located to the south/west of the house, is surrounded by a large and well-maintained lawn space and supported by a porch with a barbecue area and an observation deck that invites you to enjoy moments of contemplation of the river landscape. The entire 12,000 square meter plot is landscaped and fenced, including some fruit trees, and features an automatic irrigation system. The villa is conveniently located just a 5-minute drive from Ponte do Freixo and 15 minutes from the center of Porto.