Listing Tools

Nestled along the waterfront in Newburyport's coveted South End, this extraordinary waterfront residence seamlessly blends historic character with refined modern living. Originally dating back to 1710 and thoughtfully renovated in 2021 this home offers beautifully appointed living space designed for both everyday comfort and effortless entertaining. Interiors frame captivating river views from many the home's rooms, while period details, rich architectural elements and carefully curated updates create a setting that is both timeless and sophisticated. The spacious floor plan features four bedrooms, three and one-half bath, inviting gathering spaces and well appointed kitchen with Thermidor appliances designed for today's lifestyle. Outside enjoy a beautiful backyard or enjoy dinner by the stone fireplace under the pergola and end your day watching the sunset or fireworks on Saturdays from the rooftop retreat! Just moments to downtown, the rail trail and short drive to Plum Island!

More Info

Basic Information

  • Bedrooms4
  • Mls StatusNew
  • Bathroom4
  • Listing Terms Contract
  • Lot Features Level
  • Parcel Number M:0026 B:0048 L:0000,2085854
  • Road Frontage DescriptionPaved

Tax Information

  • Tax Assessed Value $2,136,200
  • Tax Year 2026
  • Taxes$19,781

School Information

  • High School Newburyport
  • Elementary SchoolBresnahan
  • High SchoolNewburyport
  • Junior HighNock

Parking

  • Parking Spaces2
  • Parking Features Off Street, Deeded, Stone/Gravel

Rooms

  • Bathroom 1 Main, First,5 x 4.416666666
  • Bathroom 2 Main, First,8.25 x 8.416666666
  • Bathroom 3 Second,10 x 7
  • Bathrooms Total Decimal 3.5
  • Bedroom 2 Second,11.25 x 12.75
  • Bedroom 3 Second,16.75 x 12.25
  • Bedroom 4 Main, First,15.666666666 x 20.333333333
  • Dining Room Main, First,15.166666666 x 12.583333333
  • Full Bath3
  • Half Baths1
  • Kitchen Main, First,25.416666666 x 15
  • Living Room Main, First,19.5 x 19.583333333
  • Main Level Bathrooms 2
  • Main Level Bedrooms 1
  • Master Bedroom Second,15.666666666

Basic Information

  • List Price$2,400,000
  • MLS Number73536972
  • Modification Date06/16/2026
  • Property SubTypeSingle Family Residence

Location

  • Address174 Water Street
  • Building Number174
  • CountyEssex
  • StateMA
  • StreetWater Street
  • TownNewburyport
  • Zip01950

Building

  • BasementFull, Interior Entry, Concrete, Unfinished
  • Building Area Units Square Feet
  • FireplaceYes
  • Fireplace Features Living Room
  • Fireplaces Total 1
  • FoundationStone
  • Patio And Porch Features Patio
  • Property StyleColonial
  • Rooms9
  • Utilities For Gas Range, For Electric Dryer, Washer Hookup
  • Year Built1710
  • Year Built Details Actual
  • Year Built Source Public Records

Property

  • Acreage0.13

Interior

  • Flooring Tile, Hardwood, Flooring - Stone/Ceramic Tile, Flooring - Hardwood
  • Interior Features
    • Bathroom
    • Bathroom - Double Vanity/Sink
    • Bathroom - Full
    • Bathroom - Tiled With Shower Stall
    • Cabinets - Upgraded
    • Ceiling - Half-Vaulted
    • Countertops - Stone/Granite/Solid
    • Countertops - Upgraded
    • Den
    • Lighting - Overhead
    • Lighting - Sconce
    • Open Floorplan
    • Recessed Lighting
    • Sitting Room
    • Soaking Tub
    • Wet Bar

Exterior

  • Exterior Features Patio, Rain Gutters, Storage, Fenced Yard, Garden
  • Fencing Fenced/Enclosed, Fenced
  • RoofShingle

Utilities

  • Cooling Central Air
  • Cooling YN Yes
  • Electric 200+ Amp Service
  • Heat SystemYes
  • Heating Forced Air, Natural Gas
  • Sewer Public Sewer
  • Water Source Public

Property Information

  • Square Feet3,230
  • Building Area Source Public Records
  • Living Area 3,230
  • Lot Size Square Feet 5,530
  • Lot Size Units Acres
  • View YN Yes

Amenities

  • AmenitiesPublic Transportation, Park, Walk/Jog Trails, Bike Path
  • Appliances IncludedGas Water Heater, Water Heater, Range, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer

Water Body

  • Miles to Beach2
  • WaterfrontYes
  • Waterfront Features Waterfront, Sound, Direct Access, Public, Ocean,1 to 2 Mile To Beach

Other

  • Date Listed06/16/2026
  • Farm Land Area Units Square Feet

Map Location

Driving Directions

Listed by Melanie Cosgrove of RE/MAX Bentley's

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Castles Unlimited. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.