Unparalleled Mixed-Use Opportunity on Portsmouth New Hampshire's Historic Waterfront. Now offered at an improved price, 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 previously 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.
Active
Listed by:
Ricardo Rodriguez & Associates,
Coldwell Banker Realty - Portsmouth Off:603-334-1900,
Laura Cote,
Coldwell Banker Realty - Portsmouth
$6,200,000
54 Ceres Street, Portsmouth, NH 03801
3beds
2,740sqft
Est.:
Single Family Residence
Built in 1949
3,920.4 Square Feet Lot
$-- Zestimate®
$2,263/sqft
$-- HOA
What's special
Expansive waterfront commercial space
- 355 days
- on Zillow |
- 2,448 |
- 33 |
Zillow last checked: 7 hours ago
Listing updated: March 24, 2025 at 01:47pm
Listed by:
Ricardo Rodriguez & Associates,
Coldwell Banker Realty - Portsmouth Off:603-334-1900,
Laura Cote,
Coldwell Banker Realty - Portsmouth
Source: PrimeMLS,MLS#: 5013068

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 1
- 1/2 bathrooms: 2
Heating
- Natural Gas, Hot Water
Cooling
- Mini Split
Features
- Has basement: No
Interior area
- Total structure area: 3,938
- Total interior livable area: 2,740 sqft
- Finished area above ground: 2,740
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Paved
- Garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Deep Water Access, Waterfront
- Body of water: Piscataqua River
- Frontage length: Road frontage: 60
Lot
- Size: 3,920.4 Square Feet
- Features: City Lot
Details
- Parcel number: PRSMM0106B0044L
- Zoning description: CD4
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence
Materials
- Wood Frame
- Foundation: Concrete
- Roof: Asphalt Shingle
Condition
- New construction: No
- Year built: 1949
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Utilities for property: Cable
Community & HOA
Location
- Region: Portsmouth
Financial & listing details
- Price per square foot: $2,263/sqft
- Tax assessed value: $994,300
- Annual tax amount: $16,038
- Date on market: 9/6/2024
- Loading
- Loading