Welcome to your riverfront oasis, offering 200 of frontage on the Saint John River where youll enjoy breathtaking sunrises & sunsets just 1215 min from the heart of Fredericton. This executive home sits on approx. 3 acres (to be subdivided) & features 6+ bedrms & multiple living spaces. Step inside to an open-concept great room with 18 ceilings, stained oak floors w/in-floor heating, & huge windows that flood the home with natural light. To the right, a main-floor bedrm w/private 4-piece ensuite. Nearby, the primary features garden doors to the deck, a huge walk-in closet w/built-in laundry & a spa-like ensuite w/jacuzzi tub & separate shower. Above the primary is a bonus room, perfect for a home office or family room. To the left of the great room, youll find a separate dining room leading to a chefs dream kitchen, complete with granite countertops, birch cabinetry, an island w/breakfast bar & access to outdoors. Off the kitchen is a huge rec room, half bath, utility room w/400-amp electrical, water treatment system, 2 heat pumps & security system. Movie nights are a dream in your private theatre room w/ductless heat pump, located off the family room & w/direct access to a double car garage. Upstairs, youll find 3 more bedrms, a full 4-piece bath, a 2nd laundry area, & a huge bonus room over the garage complete w/kitchenette, bedrm, & sitting area - perfect for guests, extended family or an in-law suite. New roof shingles July 2025. (id:59126)