Unparalleled Mixed-Use Opportunity on Portsmouth New Hampshire's Historic Waterfront. 54 Ceres Street is a one-of-a-kind property that is available for sale for the first time. This two-unit commercial property features an expansive waterfront commercial space currently occupied by a thriving local restaurant as well as a charming three bedroom residential unit with commanding views of the harbor and the iconic Portsmouth waterfront. Also included in the sale is a deep-water dock on the Piscataqua River for the boating enthusiast to explore the harbor, the Atlantic Ocean and beyond. The possibilities and opportunities for the future of 54 Ceres Street are endless.