Discover this elegant 4-bedroom, 2.5-bathroom waterfront home, perfectly situated minutes from Fredericton and Oromocto. With approximately 374 feet of frontage on the St. John River, this property combines classic design with modern farmhouse flair. The main level features a bright, traditional layout with decorative tin ceiling tiles, a cozy living room with a 2019 propane fireplace, a dining room leading to a private deck, and a spacious kitchen with quartz countertops and an island. New flooring was added in 2019. Upstairs, enjoy three bedrooms and a spa-like bathroom with a custom shower and soaker tub. The upper-level laundry is a convenient bonus. A ducted heat pump and central air, both installed in 2019, provide year-round comfort. The finished loft offers a flexible space with a full bath, ideal as a master suite or guest area. An attached garage and ample storage options enhance the property's appeal. Additional features include a mini home pad with its own septic tank, a 40x28 concrete pad for potential garage use, a metal roof from 2011, and a new foundation installed in 2018. A 2022 inspection report is available. (id:7526)