If you have been looking for a special waterfront property, welcome home! Nestled just a few feet from the St. John/Wolastoq River, this property offers a breathtaking view from the walls of windows in all the rooms at the front of the home. To the left of the home, the waterfrontage also features a small covea perfect, sheltered spot for a watercraft dock. The main floor boasts over 2,400 sq/ft of living space, plus a finished basement. The open, sweeping layout of the main floor includes a kitchen with granite countertops, an extended sun room with heated hardwood flooring, a butlers pantry, dining area, Primary bedroom with ensuite and walk-in closet, two additional bedrooms, a large main bath complete with a steam shower and sauna, a den, and a laundry room. The finished basement adds even more value, featuring a rec room on one side, and a family room, full bathroom, and office on the other side. This section is also plumbed and wired for a potential small kitchen area. Additional highlights of this property include a Generac generator system that automatically restores power to your whole home during an outage, cathedral ceilings, propane fireplace, ductless heat pump, concrete patio, 2 car garage, a half-acre lot, paved driveway and lots of beautiful trees and greenery for added privacy at your oasis. Located only 15 minutes from Woodstock and 45 minutes from Fredericton, this home and property offers an incredible opportunity for a cottage or a year round home. (id:51532)