Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$2,400,000 Just Listed

  • For Sale
  • Active
  • Single Family
  • 4 Beds
  • 3 Full Baths
  • 1 Partial Bath
  • 3,230 Sq. Ft.
  • 0.13 Acres
  • Updated 1 hour ago
See This Home
Save This Home
See This Home
Save This Home
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!

Full Property Details for 174 Water St

General

  • Price: $2,400,000
  • Taxes: $19,781 (2026)
  • Status: Active
  • Type: Single Family
  • MLS ID: 73536972
  • Updated: Today (6/16/2026)
  • Added to Site: Today

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Bathroom 1: 5.00 x 4.42, Main, First
  • Bathroom 2: 8.25 x 8.42, Main, First
  • Bathroom 3: 10.00 x 7.00, Second

Bedrooms

  • Total Bedrooms: 4
  • Primary Bedroom: 15.67 x 19.75, Second
  • Bedroom 2: 11.25 x 12.75, Second
  • Bedroom 3: 16.75 x 12.25, Second
  • Bedroom 4: 15.67 x 20.33, Main, First

Other Rooms

  • Living Room: 19.50 x 19.58, Main, First
  • Kitchen: 25.42 x 15.00, Main, First
  • Dining Room: 15.17 x 12.58, Main, First

Parking

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

Location

  • County: Essex

Structural Information

  • Architectural Style: Colonial
  • Basement: Yes
  • Square Feet: 3,230
  • Year Built: 1710

Lot Features

  • Lot Size (Acres): 0.13

Financial Considerations

  • Tax Amount: $19,781
  • Tax Year: 2026

Disclosures and Reports

  • Exclusions: See Include / Exclude In Attached Documents.
  • Property ID: M:0026 B:0048 L:0000, 2085854

Listed by RE/MAX Bentley's, Melanie Cosgrove

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 174 Water St —

  • Melanie Cosgrove

    RE/MAX Bentley's

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 174 Water St

School District:Newburyport School District
NameGradesDistance
Edward G. Molin Elementary School
70 Low Street, Newburyport, MA 01950
4-51.4 mi
Francis T Bresnahan Elementary School
333 High Street, Newburyport, MA 01950
PK-32 mi
Rupert A Nock Middle School
70 Low Street, Newburyport, MA 01950
6-81.4 mi
Newburyport High School
241 High Street, Newburyport, MA 01950
9-121.4 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 174 Water St Get Price Alerts and Save Property

Date
Details
Price
Change
Source
6/16/2026
Listed
$2,400,000
41.18%
MLS
9/16/2021
Sold
$1,700,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 174 Water St

Year
Property Taxes
Change
Tax Assessment
Change
2025
$18,514
4%
$1,932,600
8%
2024
$17,763
1%
$1,781,600
9%
2023
$17,550
34%
$1,634,100
49%
2022
$13,145
56%
$1,094,500
64%
2021
$8,430
2%
$666,900
4%
2020
$8,268
6%
$643,900
8%
2019
$7,797
9%
$596,100
10%
2018
$7,163
7%
$540,200
9%
2017
$6,695
5%
$497,800
5%
2016
$6,350
15%
$474,200
15%
2015
$5,511
1%
$413,100
7%
2014
$5,457
—
$385,400
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 174 Water St

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by RE/MAX Bentley's, Melanie Cosgrove

Similar Properties near 174 Water St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

71 Purchase St, Newburyport, MA 01950 - Photo 1
$2,349,000

71 Purchase St  Newburyport, MA 01950

  • Single Family
  • Active
  • Updated 9 hours ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,503
    Sq. Ft.
105 High Rd, Newbury, MA 01951 - Photo 1
$2,195,000

105 High Rd  Newbury, MA 01951

  • Single Family
  • Active
  • Updated 10 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 3,676
    Sq. Ft.
1 Stanley Ave, Newburyport, MA 01950 - Photo 1
$2,400,000

1 Stanley Ave  Newburyport, MA 01950

  • Single Family
  • Active
  • 3
    Beds
  • 4
    Total Baths
  • 2,657
    Sq. Ft.
4 Northern Blvd, Newbury, MA 01951 - Photo 1
$2,249,000

4 Northern Blvd  Newbury, MA 01951

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 2,713
    Sq. Ft.

Just Listed near 174 Water St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

188 Beach Rd, Salisbury, MA 01952 - Photo 1 Just Listed
$615,000

188 Beach Rd  #16  Salisbury, MA 01952

  • Townhouse
  • Active
  • Updated 16 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,464
    Sq. Ft.
Listed by Robin Pagliarulo (781) 858-2412
12 Baker Rd, Salisbury, MA 01952 - Photo 1 Just Listed
$849,000

12 Baker Rd  Salisbury, MA 01952

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,752
    Sq. Ft.
36 Elm St, Salisbury, MA 01952 - Photo 1 Just Listed
$614,777
Open House

36 Elm St  #A  Salisbury, MA 01952

  • Condo
  • Active
  • Updated 16 hours ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,456
    Sq. Ft.
170 Beach Rd, Salisbury, MA 01952 - Photo 1 Just Listed
$739,900

170 Beach Rd  #36  Salisbury, MA 01952

  • Townhouse
  • Active
  • Updated 1 day ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,197
    Sq. Ft.

Price Reduced near 174 Water St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

12 Commonwealth Ave, Salisbury, MA 01952 - Photo 1 Price Reduced
-$200,000 (-10.03%)
$1,795,000

12 Commonwealth Ave  Salisbury, MA 01952

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 4
    Total Baths
  • 5,002
    Sq. Ft.
6 Courtney Dr, Newbury, MA 01951 - Photo 1 Price Reduced
-$25,000 (-1.25%)
$1,970,000
Open House

6 Courtney Dr  Newbury, MA 01951

  • Single Family
  • Active
  • Updated 1 day ago
  • 4
    Beds
  • 5
    Total Baths
  • 4,179
    Sq. Ft.
25 Clark's Rd, Amesbury, MA 01913 - Photo 1 Price Reduced
-$14,900 (-5.14%)
$275,000

25 Clark's Rd  #101  Amesbury, MA 01913

  • Condo
  • Active
  • Updated 8 hours ago
  • 2
    Beds
  • 1
    Total Bath
  • 735
    Sq. Ft.
30 Summit Ave, Amesbury, MA 01913 - Photo 1 Price Reduced
-$100,000 (-9.09%)
$999,999
Open House

30 Summit Ave  Amesbury, MA 01913

  • Single Family
  • Active
  • Updated 12 hours ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,825
    Sq. Ft.

Recent Sales near 174 Water St

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1 Lancaster Rd, Newburyport, MA 01950 - Photo 1 Sold
$2,400,000

1 Lancaster Rd  Newburyport, MA 01950

  • Single Family
  • Closed
  • 4
    Beds
  • 5
    Total Baths
  • 4,861
    Sq. Ft.
14 Dexter Ln, Newburyport, MA 01950 - Photo 1 Sold
$2,600,000

14 Dexter Ln  #A  Newburyport, MA 01950

  • Single Family
  • Closed
  • 5
    Beds
  • 5
    Total Baths
  • 3,775
    Sq. Ft.
231 Story Ave, Newburyport, MA 01950 - Photo 1 Sold
$2,600,000

231 Story Ave  Newburyport, MA 01950

  • Single Family
  • Closed
  • 4
    Beds
  • 3
    Total Baths
  • 4,100
    Sq. Ft.
103 Ocean Dr, Seabrook, NH 03874 - Photo 1 Sold
$2,635,000

103 Ocean Dr  Seabrook, NH 03874

  • Single Family
  • Closed
  • Updated 12 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,128
    Sq. Ft.
Listed by Carey Giampa, LLC/Seabrook Beach
Sold by Carey Giampa, LLC/Portsmouth

174 Water St, Newburyport, MA 01950 (MLS# 73536972) is a Single Family property with 4 bedrooms, 3 full bathrooms and 1 partial bathroom. 174 Water St is currently listed for $2,400,000 and was received on June 16, 2026. Want to learn more about 174 Water St? Do you have questions about finding other Single Family real estate for sale in Plum Island? You can browse all Plum Island real estate or contact a Coldwell Banker agent to request more information.

Tour this property