Charming and sun-filled raised ranch in the Oyster River school district tucked back in a large wooded lot for privacy features 150 feet of owned water frontage on the Lamprey River! Enter easily through the 2-car garage or the front doorway into a practical floorplan designed to maximize living space with a large family / recreation room on the lower level with a gas stove, along with a laundry room and 3/4 bathroom. The main level includes a bright and spacious, open-concept eat-in kitchen and living room highlighted by a cozy wood stove, granite counters, and lots of cabinets! A versatile sunroom / dining room off the kitchen is a lovely place to enjoy meals or read a book! The nicely-sized primary bedroom and two guest bedrooms round out the main level along with a beautifully updated full bathroom. Hardwood floors throughout. Massive screened in porch provides an extraordinary opportunity to enjoy shelter and nature at the same time! Extensive list of recent updates attached, including new windows and skylight, hot water tank, radon mitigation system, well components, appliances & recessed lighting and new wood flooring in 3 bedrooms! TLC needed on exterior, but there is a TON of potential for the river front property you've always wanted in the coveted Durham zip code! Bring your kayak! Some photos have been virtually staged.