Nestled along the peaceful banks of the Lamprey River, this 3,696 SF executive ranch is more than a home, it's a lifestyle. Situated on 13.2 acres of pastoral fields with direct water access, this unique oasis is a nature lover's dream! Upon entering this 3Bed/2.5Bath home through the oversized covered front porch you'll immediately be greeted with stunning water views. The large Kitchen is equipped with Stainless Steel appliances including a professional gas range; custom cabinetry, quartz countertops, breakfast bar, and a built-in life command center. The Dining Room flows seamlessly into the expansive Great Room with vaulted ceilings, wood beams, and walls of windows on both sides. Continue down the hall and you will find a primary bedroom with an ensuite bath including a tiled shower, soaking tub, walk-in closet; 2 additional bedrooms and a lovely light filled office. A bonus/entertainment room at the back of the property offers sweeping views of the river and boasts a wet-bar/coffee station and 1/2 bath. The property continues to amaze with a 2 car attached garage, an 820 SF equipment building, and a 1,540 SF 4-stall barn with a fenced in paddock and raised garden beds. This type of property is extremely rare and is located in the highly coveted Oyster River School District. Fall in love with this private waterfront sanctuary that feels worlds away, yet is only minutes from both downtown Durham and Newmarket, and just 15 minutes from Portsmouth.