Exceptional waterfront investment and lifestyle opportunity on the Piscataqua River, featuring a deep-water dock and three beautifully renovated units. This well-maintained multi-family property offers two 1-bedroom units and one spacious 2-bedroom, 2-bath unit, all updated with granite countertops, central air conditioning, and in-unit washers and dryers. Each unit enjoys its own private deck and breathtaking panoramic water views from nearly every room. Whether you're seeking an owner-occupied waterfront residence, a vacation retreat, or an income-producing investment, this property offers endless possibilities. Dock your boat at your doorstep, enjoy direct access to the water, and offset ownership costs with rental income from the additional units. the deep-water dock provides direct access to the Piscataqua River, Portsmouth Harbor, and the open Atlantic beyond. Spend your days cruising the Maine and New Hampshire coastline, then return home to your private waterfront retreat. A rare opportunity to own a premier waterfront property with strong income potential in a spectacular setting. A truly exceptional Seacoast offering not to be missed.