Perched high above the tranquil banks of the Oyster River, this picturesque 1.61-acre waterfront property with mooring offers 258 feet of direct river frontage and breathtaking views. Built above a small granite quarry, the house is near but above the water, giving it a commanding view. The main level features an updated kitchen with farmers' sink, island, and great natural light. Enjoy meals in the dining room with views of the river. Relax or entertain in the front to back living room with a wood stove. Watch boats drift from your screened-in porch where you can take in the serene beauty of the river and yard. First floor is finished with 2 bedrooms and a newly updated 3/4 bath featuring soapstone counters and tiled shower and floor as well as a laundry room. Continue upstairs where you will find a primary en-suite with expansive windows that capture the beauty of the water. A sunny office, an additional en-suite bedroom, a fourth bedroom completes the second floor living area. Need additional space, the large attic provides room for storage or the potential to expand. A legal apartment offers flexibility for guests or rental income with a private entrance, mudroom with laundry, kitchen, living and dining rooms, bedroom, office, and its own patio with River views. Just minutes to downtown Durham and schools, and a short commute to Portsmouth. Living here you will feel like you are on a permanent vacation - this is the waterfront living at its best, simply magical.