The waterfront oasis everyone dreams to own - 102 feet of private Piscataqua River frontage! Includes a 164 foot long (including the float) deep water pier with electricity and water, the deck at the end measures 16' x 36'. There is also a mooring. The views are spectacular and the house is move-in ready and loaded with charm. The chef's kitchen is spacious with a grand island and convenient layout plus a lot of glass to bring in the view and light. The formal dining room has a large bay window overlooking the flower gardens. A gracious living room has many angles and seating areas for reading or just soaking in the dramatic views. There are 3 bedrooms on the second floor of the main house. The attached in-law apartment is privately located with 1 bedroom, 1 bath and sweeping views. It could be a great master suite if not used as an in-law apartment. There are 3 garage bays, paved guest parking for up to 6 guests and space on the side of house to park your boat. The location is a 5 minute walk over the Memorial Bridge into downtown Portsmouth while being very quiet and well hidden behind a fence affording total privacy. You do not have to be a boater to enjoy this home, just enjoy the water and the convenient location. Call to see this amazing listing!