Broker Information
Office Attribution
{property.system.OfficeAttribution}
Listing Agent
{property.system.ListingAgentName}
Listing Office
{property.system.OfficeListingName}
Selling Office
{property.system.SellingOfficeName}
School Information
School District
{property.system.SchoolDistrict}
High School
{property.feed.LM_Char25_8}
Junior High School
{property.feed.LM_Char25_7}
Elementary School
{property.feed.LM_Char25_6}

{property.extra.comment}

{property.system.PublicRemarks}

Property Information
  • Address: {property.feed.L_Address}
  • Unit/Lot #: {property.feed.L_Address2}
  • City: {property.feed.L_City}
  • State: {property.feed.L_State}
  • Zip: {property.feed.L_Zip}
  • County: {property.feed.L_Area}
  • MLS #: {property.feed.L_DisplayId}
  • Property Class: {property.feed.L_Class}
  • Property Type: {property.feed.L_Type_}
  • Listing Status: {property.feed.L_Status}
  • Lot size (Acres): {property.feed.L_NumAcres}
  • Zoning: {property.feed.LM_Char25_17}
  • Construction Status: {property.feed.LM_char50_8}
  • Pre-Construction: {property.feed.LM_char1_54}
  • SqFt-Apx Total: {property.feed.LM_Int4_5}
  • SqFt-Apx Fin Above Grade: {property.feed.LM_Dec_21}
  • SqFt-Apx Fin Below Grade: {property.feed.LM_Dec_22}
  • Seasonal: {property.feed.LM_char5_60}
  • Roads: {property.feed.LFD_Roads_28}
  • Roads Frontage: {property.feed.LM_char1_60}
  • Road Frontage Length: {property.feed.LM_Int4_7}
  • Development / Subdivision: {property.feed.LM_Char50_4}
  • Condo Name: {property.feed.LM_Char25_8}
  • Mobile Park Name: {property.feed.LM_char50_16}
  • Units Per Building: {property.feed.L_NumUnits}
  • Amenities: {property.feed.LFD_Amenities_1}
  • Covenants: {property.feed.LM_Char1_12}
Land / Water Body
  • Lot Description: {property.feed.LFD_LotDescription_24}
  • Current Use: {property.feed.LM_char1_44}
  • Area Description: {property.feed.LFD_AreaDescription_203}
  • Suitable Use: {property.feed.LFD_SuitableUse_33}
  • Surveyed: {property.feed.LM_char1_26}
  • Water Body Access: {property.feed.LM_char10_55}
  • Water Body Name: {property.feed.LM_char50_25}
  • Water Body Type: {property.feed.LM_char10_54}
  • Water Frontage Length: {property.feed.LM_int4_40}
Building
  • Style: {property.feed.LFD_Style_32}
  • Total Stories: {property.feed.LM_char5_54}
  • Year Built: {property.feed.LM_Int2_4}
  • Exterior: {property.feed.LFD_Exterior_12}
  • Color: {property.feed.LM_Char10_16}
  • Roof: {property.feed.LFD_Roof_29}
  • Construction: {property.feed.LFD_Construction_4}
  • Foundation: {property.feed.LFD_Foundation_20}
  • Basement: {property.feed.LM_Char1_6}
  • Basement Access Type: {property.feed.LM_Char10_5}
  • Basement Description: {property.feed.LFD_BasementDescription_3}
  • Exterior Features: {property.feed.LFD_FeaturesExterior_14}
  • Interior Features: {property.feed.LFD_FeaturesInterior_15}
  • Flooring: {property.feed.LFD_Flooring_19}
  • Appliances: {property.feed.LFD_Appliances_2}
  • Features - Accessibility: {property.feed.LFD_FeaturesAccessibility_13}
Garage / Parking / Easements
  • Garage: {property.feed.LM_Char1_2}
  • Garage Type: {property.feed.LM_Char10_26}
  • Garage Description: {property.feed.LFD_GarageDescription_21}
  • Garage Capacity: {property.feed.LM_Dec_8}
  • Driveway: {property.feed.LFD_Driveway_8}
  • Parking: {property.feed.LFD_Parking_25}
  • ROW - Parcel Access: {property.feed.LM_char1_39}
  • ROW to other Parcel: {property.feed.LM_char1_40}
  • Easements: {property.feed.LM_Char1_17}
Rooms
  • Rooms - Total: {property.feed.LM_Int1_16}
  • Total Bedrooms: {property.feed.LM_Int1_6}
  • Total Bathrooms: {property.feed.LM_int4_36}
  • Full Bathrooms: {property.feed.LM_Int1_1}
  • Rooms Level 1: {property.feed.LFD_RoomsLevel1_274}
  • Rooms Level 2: {property.feed.LFD_RoomsLevel2_275}
  • Rooms Level 3: {property.feed.LFD_RoomsLevel3_276}
  • Rooms Level 4: {property.feed.LFD_RoomsLevel4_277}
  • Rooms Level B: {property.feed.LFD_RoomsLevelB_273}
  • Room 1 Type: {property.feed.LM_char5_14}
  • Room 1 Level: {property.feed.LM_char5_34}
  • Room 1 Dimensions: {property.feed.LM_char30_11}
  • Room 2 Type: {property.feed.LM_char5_15}
  • Room 2 Level: {property.feed.LM_char5_35}
  • Room 2 Dimensions: {property.feed.LM_char30_12}
  • Room 3 Type: {property.feed.LM_char5_16}
  • Room 3 Level: {property.feed.LM_char5_36}
  • Room 3 Dimensions: {property.feed.LM_char30_13}
  • Room 4 Type: {property.feed.LM_char5_17}
  • Room 4 Level: {property.feed.LM_char5_37}
  • Room 4 Dimensions: {property.feed.LM_char30_14}
  • Room 5 Type: {property.feed.LM_char5_18}
  • Room 5 Level: {property.feed.LM_char5_38}
  • Room 5 Dimensions: {property.feed.LM_char30_15}
  • Room 6 Type: {property.feed.LM_char5_19}
  • Room 6 Level: {property.feed.LM_char5_39}
  • Room 6 Dimensions: {property.feed.LM_char30_16}
  • Room 7 Type: {property.feed.LM_char5_20}
  • Room 7 Level: {property.feed.LM_char5_40}
  • Room 7 Dimensions: {property.feed.LM_char30_17}
  • Room 8 Type: {property.feed.LM_char5_21}
  • Room 8 Level: {property.feed.LM_char5_41}
  • Room 8 Dimensions: {property.feed.LM_char30_18}
  • Room 9 Type: {property.feed.LM_char5_22}
  • Room 9 Level: {property.feed.LM_char5_42}
  • Room 9 Dimensions: {property.feed.LM_char30_19}
  • Room 10 Type: {property.feed.LM_char5_23}
  • Room 10 Level: {property.feed.LM_char5_43}
  • Room 10 Dimensions: {property.feed.LM_char30_20}
  • Room 11 Type: {property.feed.LM_char5_24}
  • Room 11 Level: {property.feed.LM_char5_44}
  • Room 11 Dimensions: {property.feed.LM_char30_21}
  • Room 12 Type: {property.feed.LM_char5_25}
  • Room 12 Level: {property.feed.LM_char5_45}
  • Room 12 Dimensions: {property.feed.LM_char30_22}
  • Room 13 Type: {property.feed.LM_char5_26}
  • Room 13 Level: {property.feed.LM_char5_46}
  • Room 13 Dimensions: {property.feed.LM_char30_23}
  • Room 14 Type: {property.feed.LM_char5_27}
  • Room 14 Level: {property.feed.LM_char5_47}
  • Room 14 Dimensions: {property.feed.LM_char30_24}
  • Room 15 Type: {property.feed.LM_char5_28}
  • Room 15 Level: {property.feed.LM_char5_48}
  • Room 15 Dimensions: {property.feed.LM_char30_25}
  • Room 16 Type: {property.feed.LM_char5_29}
  • Room 16 Level: {property.feed.LM_char5_49}
  • Room 16 Dimensions: {property.feed.LM_Char25_1}
  • Room 17 Type: {property.feed.LM_char5_30}
  • Room 17 Level: {property.feed.LM_char5_51}
  • Room 17 Dimensions: {property.feed.LM_Char25_9}
  • Room 18 Type: {property.feed.LM_char5_50}
  • Room 18 Level: {property.feed.LM_char5_31}
  • Room 18 Dimensions: {property.feed.LM_Char25_20}
  • Room 19 Type: {property.feed.LM_char5_32}
  • Room 19 Level: {property.feed.LM_char5_52}
  • Room 19 Dimensions: {property.feed.LM_Char25_21}
  • Room 20 Type: {property.feed.LM_char5_33}
  • Room 20 Level: {property.feed.LM_char5_53}
  • Room 20 Dimensions: {property.feed.LM_Char25_23}
  • Room 21 Type: {property.feed.LM_char5_10}
  • Room 21 Level: {property.feed.LM_char5_1}
  • Room 21 Dimensions: {property.feed.LM_Char25_29}
  • Room 22 Type: {property.feed.LM_char5_6}
  • Room 22 Level: {property.feed.LM_char5_11}
  • Room 22 Dimensions: {property.feed.LM_char30_3}
Mechanicals
  • Water: {property.feed.LFD_Water_35}
  • Sewer: {property.feed.LFD_Sewer_30}
  • Electric: {property.feed.LFD_Electric_9}
  • Heating: {property.feed.LFD_Heating_23}
  • Heat Fuel Type: {property.feed.LFD_HeatFuel_22}
  • Water Heater: {property.feed.LFD_WaterHeater_36}
  • Cooling: {property.feed.LFD_Cooling_6}
  • Utilities: {property.feed.LFD_Utilities_200}
  • Equipment: {property.feed.LFD_Equipment_10}
School Information
  • School District: {property.feed.LM_char10_32}
  • Elementary School: {property.feed.LM_char10_68}
  • High School: {property.feed.LM_Char10_2}
  • Middle / Jr. High School {property.feed.LM_char10_69}
Financial Information
  • Tax Rate: {property.feed.LM_Dec_2}%
  • Tax Year: {property.feed.LM_int4_41}
  • Taxes TBD: {property.feed.LM_char1_27}
  • Tax - Gross Amount: ${as_dollars(property.feed.LM_Dec_29)}
  • Price Per SQFT: ${as_dollars(property.feed.PricePerSF)}
  • Price Per SqFt: ${as_dollars(property.feed.LM_Dec_26)}
  • Price SqFt: ${as_dollars(property.feed.PriceSF)}
  • Fee: ${as_dollars(property.feed.LM_Dec_10)}
  • Fee Frequency: {property.feed.LM_char5_5}
  • TenantPays: ${as_dollars(property.feed.LFD_TenantPays_270)}
  • Tenant Pays: ${as_dollars(property.feed.LFD_TenantPays_271)}
  • RentIncludes: {property.feed.LFD_RentIncludes_132}
  • Rent Includes: {property.feed.LFD_RentIncludes_186}
  • Gross Income: ${as_dollars(property.feed.LM_Int4_11)}
  • Monthly Lease Amount: ${as_dollars(property.feed.LseAmt)}
  • Foreclosed/Bank-Owned/REO: {property.feed.LM_char30_28}
  • Assessment Amount: ${as_dollars(property.feed.LM_Int4_1)}
  • Assessment Year: {property.feed.LM_Int2_1}
  • Assessments - Special: {property.feed.LM_Char1_16}

54 Ceres, Portsmouth, NH 03801

MLS #5012974

City:Portsmouth, State:NH

Price: $6200000

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.

66daed2d34e2b557c7367774 0.09 290467 3938 Portsmouth CS_3 NH-Rockingham 54 Ceres Street neren3 66daecd434e2b557b401ed52 1 1 1 1 1725623336 1725623335 6200000 Ricardo Rodriguez & Associates 5012974 Active 3920 5012974 2247 54 Ceres, Portsmouth, NH 03801 1753479589 Off: 603-334-1900 Coldwell Banker Realty - Portsmouth 22 1574 Commercial 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. NH Ceres 54 2 1753479796 Piscataqua River Yes 1 Exclusively Owned 1949 03801 ListPrice 6200000 1742849598 6200000 1728657798 6800000 1725623597 7800000 ListingStatus Active 1725623597 Active https://s3.us-central-1.wasabisys.com/apiv1.photos.master/1877-5012974-1-neren3.jpg 1 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/f16b-5012974-2-neren3.jpg 2 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/c529-5012974-3-neren3.jpg 3 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/f7ea-5012974-4-neren3.jpg 4 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/6ae5-5012974-5-neren3.jpg 5 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/5437-5012974-6-neren3.jpg 6 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/9707-5012974-7-neren3.jpg 7 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/523b-5012974-8-neren3.jpg 8 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/cbb0-5012974-9-neren3.jpg 9 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/66e2-5012974-10-neren3.jpg 10 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/f3ab-5012974-11-neren3.jpg 11 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/98f0-5012974-12-neren3.jpg 12 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/a414-5012974-13-neren3.jpg 13 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/b05e-5012974-14-neren3.jpg 14 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/cc83-5012974-15-neren3.jpg 15 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/85bd-5012974-16-neren3.jpg 16 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/20ce-5012974-17-neren3.jpg 17 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/971a-5012974-18-neren3.jpg 18 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/3821-5012974-19-neren3.jpg 19 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/9b0b-5012974-20-neren3.jpg 20 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/9807-5012974-21-neren3.jpg 21 1725642937 https://s3.us-central-1.wasabisys.com/apiv1.photos.master/518f-5012974-22-neren3.jpg 22 1725642937 1725642937 1725642965 43.0790820 -70.7579210 Point -70.757921 43.079082 RETS -9.68 1742849598 1725580800 Laura E Cote Coldwell Banker Realty - Portsmouth 68888888