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

Location

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

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

Utilities

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

Other

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

Tax Information

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

Parking

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

Basic Information

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

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

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

School Information

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

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

Exterior

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

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

Map Location

Listed by Melanie Cosgrove of RE/MAX Bentley's

The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. (MLSPIN) from third party sources, including sellers, lessors and public records, and were compiled by MLSPIN. The property listing data and information, and the Images, are for the personal, non-commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and may not be used for any purpose other than to identify prospective properties which such consumers may have a good faith interest in purchasing or leasing. MLSPIN and its subscribers disclaim any and all representations and warranties as to the accuracy of the property listing data and information, or as to the accuracy of any of the Images, set forth herein.

I agree to receive marketing and customer service calls and text messages from In Realty Inc. 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.

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.

$

Do not fill in this field:

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