Impressive WATERFRONT home with exceptional versatility, featuring an IN-LAW suite for a mortgage helper, Airbnb opportunity, or private accommodation for extended family. You will find the perfect balance of rustic charm and contemporary luxury in this stunning, restored century home. Pre-inspected, the property boasts a rare setup: A 3-bedroom home, rebuilt from the inside out, with extensive upgrades (list available), paired with a spectacular integrated in-law suite. The main home features chef-ready kitchen, formal dining, a sun-soaked 4 season porch office, a walk-out basement, double garage, parking for 6 vehicles, and 2 large walk-in pantries offering plenty of storage space. The private, 1 bedroom loft built in 2022 boasts open-concept living, and a large versatile den. You will feel inspired by the craftmanship of this home, to include crown moldings throughout, French doors adding character and elegance. Enjoy breathtaking panoramic views and your morning coffee on the pergola covered deck with direct access to the Rusagonis stream. Conveniently located just minutes from uptown Fredericton, you are close to ATV trails, lakes and rivers. This is truly a must-see property. Contact your REALTOR® today to schedule a private viewing. (id:60457) Location - 101N turn left onto Phillips