Skip main navigation
Pending
  • $2,400,000

    174 Water St, Newburyport, MA 01950

    4beds
    3,230sqft
    : 
    $14,388/mo
    Get pre-qualified
    Single Family Residence
    Built in 1710
    5,530 Square Feet Lot
    $2,484,600 Zestimate®
    $743/sqft
    $-- HOA

    What's special

    Waterfront residenceThree and one-half bathRich architectural elementsPeriod detailsHistoric characterBeautifully appointed living spaceCarefully curated updates
    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!
    38 days
    |
    218
    |
    3
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Melanie Cosgrove 978-835-6328,

    RE/MAX Bentley's 978-572-1200,

    Melanie Cosgrove 978-835-6328

    Source: MLS PIN,MLS#: 73536972

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      • Main level bathrooms: 2
      • Main level bedrooms: 1
      Primary bedroom
      • Features: Bathroom - Full, Walk-In Closet(s), Closet, Flooring - Hardwood, Double Vanity, Recessed Lighting, Lighting - Sconce, Lighting - Pendant
      • Level: Second
      • Area: 309.42
      • Dimensions: 15.67 x 19.75
      Bedroom 2
      • Features: Closet, Flooring - Hardwood, Recessed Lighting, Lighting - Overhead
      • Level: Second
      • Area: 143.44
      • Dimensions: 11.25 x 12.75
      Bedroom 3
      • Features: Flooring - Hardwood, Recessed Lighting, Lighting - Overhead, Closet - Double
      • Level: Second
      • Area: 205.19
      • Dimensions: 16.75 x 12.25
      Bedroom 4
      • Features: Bathroom - Full, Flooring - Hardwood, Recessed Lighting, Lighting - Sconce, Lighting - Overhead, Closet - Double
      • Level: Main,First
      • Area: 318.56
      • Dimensions: 15.67 x 20.33
      Primary bathroom
      • Features: Yes
      Bathroom 1
      • Features: Bathroom - Half, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Countertops - Upgraded, Cabinets - Upgraded, Lighting - Sconce, Pedestal Sink
      • Level: Main,First
      • Area: 22.08
      • Dimensions: 5 x 4.42
      Bathroom 2
      • Features: Bathroom - 3/4, Bathroom - Tiled With Shower Stall, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Countertops - Upgraded, Cabinets - Upgraded, Recessed Lighting, Lighting - Sconce
      • Level: Main,First
      • Area: 69.44
      • Dimensions: 8.25 x 8.42
      Bathroom 3
      • Features: Bathroom - Full, Bathroom - Tiled With Tub & Shower, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Countertops - Upgraded, Cabinets - Upgraded, Recessed Lighting, Lighting - Sconce, Half Vaulted Ceiling(s)
      • Level: Second
      • Area: 70
      • Dimensions: 10 x 7
      Dining room
      • Features: Flooring - Hardwood, Open Floorplan, Recessed Lighting, Lighting - Overhead
      • Level: Main,First
      • Area: 190.85
      • Dimensions: 15.17 x 12.58
      Kitchen
      • Features: Flooring - Hardwood, Countertops - Stone/Granite/Solid, Countertops - Upgraded, Kitchen Island, Wet Bar, Exterior Access, Open Floorplan, Recessed Lighting, Stainless Steel Appliances, Gas Stove, Lighting - Overhead
      • Level: Main,First
      • Area: 381.25
      • Dimensions: 25.42 x 15
      Living room
      • Features: Coffered Ceiling(s), Flooring - Hardwood, Open Floorplan, Recessed Lighting
      • Level: Main,First
      • Area: 381.88
      • Dimensions: 19.5 x 19.58
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Gas Water Heater, Water Heater, Range, Dishwasher, Disposal, Microwave, Refrigerator, Washer, Dryer
      • Laundry: Gas Dryer Hookup, Washer Hookup, Second Floor, Electric Dryer Hookup
      Features
      • Bathroom - Full, Bathroom - Double Vanity/Sink, Bathroom - Tiled With Shower Stall, Countertops - Stone/Granite/Solid, Countertops - Upgraded, Cabinets - Upgraded, Recessed Lighting, Lighting - Sconce, Soaking Tub, Lighting - Overhead, Ceiling - Half-Vaulted, Open Floorplan, Bathroom, Den, Sitting Room, Wet Bar
      • Flooring: Tile, Hardwood, Flooring - Stone/Ceramic Tile, Flooring - Hardwood
      • Basement: Full,Interior Entry,Concrete,Unfinished
      • Number of fireplaces: 1
      • Fireplace features: Living Room
      Interior area
      • Total structure area: 3,230
      • Total interior livable area: 3,230 sqft
      • Finished area above ground: 3,230

      Property

      Parking
      • Total spaces: 2
      • Parking features: Off Street, Deeded, Stone/Gravel
      • Uncovered spaces: 2
      Features
      • Patio & porch: Patio
      • Exterior features: Patio, Rain Gutters, Storage, Fenced Yard, Garden
      • Fencing: Fenced/Enclosed,Fenced
      • Has view: Yes
      • View description: Scenic View(s), Water, Ocean, River
      • Has water view: Yes
      • Water view: Ocean,River,Water
      • Waterfront features: Waterfront, Sound, Direct Access, Public, Ocean, 1 to 2 Mile To Beach
      Lot
      • Size: 5,530 Square Feet
      • Features: Level
      Details
      • Parcel number: M:0026 B:0048 L:0000,2085854
      • Zoning: R3

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence
      Materials
      • Foundation: Stone
      • Roof: Shingle
      Condition
      • Year built: 1710

      Utilities & green energy

      • Electric: 200+ Amp Service
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: for Gas Range, for Electric Dryer, Washer Hookup

      Community & HOA

      Community
      • Features: Public Transportation, Park, Walk/Jog Trails, Bike Path
      HOA
      • Has HOA: No
      Location
      • Region: Newburyport

      Financial & listing details

      • Price per square foot: $743/sqft
      • Tax assessed value: $2,136,200
      • Annual tax amount: $19,781
      • Date on market: 6/16/2026
      • Listing terms: Contract
      • Exclusions: See Include / Exclude In Attached Documents.
      • Road surface type: Paved

        Estimated market value

        $2,484,600

        $2.36M - $2.61M

        $6,827/mo

        Price history

        DateEventPrice
        6/25/2026Pending sale$2,400,000$743/sqft
        Source: MLS PIN #73536972 Report a problem
        6/18/2026Contingent$2,400,000$743/sqft
        Source: MLS PIN #73536972 Report a problem
        6/16/2026Listed for sale$2,400,000+41.2%$743/sqft
        Source: MLS PIN #73536972 Report a problem
        9/17/2021Sold$1,700,000$526/sqft
        Source: MLS PIN #72816279 Report a problem
        7/23/2021Pending sale$1,700,000$526/sqft
        Source: MLS PIN #72816279 Report a problem
        7/12/2021Listing removed--
        Source: MLS PIN #72816279 Report a problem
        4/17/2021Pending sale$1,700,000$526/sqft
        Source: Keller Williams #72816279 Report a problem
        4/16/2021Contingent$1,700,000$526/sqft
        Source: MLS PIN #72816279 Report a problem
        4/16/2021Listed for sale$1,700,000+157.6%$526/sqft
        Source: MLS PIN #72816279 Report a problem
        9/16/2020Sold$660,000-12%$204/sqft
        Source: Public Record Report a problem
        6/2/2020Listing removed$750,000$232/sqft
        Source: Coleman Real Estate #72604059 Report a problem
        5/19/2020Pending sale$750,000$232/sqft
        Source: Coleman Real Estate #72604059 Report a problem
        12/31/2019Listed for sale$750,000$232/sqft
        Source: Coleman Real Estate #72603235 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$18,514 +4.2%$1,932,600 +8.5%
        2024$17,763 +1.2%$1,781,600 +9%
        2023$17,550 $1,634,100
        2022$17,550 +108.2%$1,634,100 +145%
        2021$8,430 +2%$666,900 +3.6%
        2020$8,268 +6%$643,900 +8%
        2019$7,797 +8.9%$596,100 +10.3%
        2018$7,163 +7%$540,200 +8.5%
        2017$6,695 +5.4%$497,800 +5%
        2016$6,350 +15.2%$474,200 +14.8%
        2015$5,511 +1%$413,100 +7.2%
        2014$5,457 +4.8%$385,400 -1.4%
        2013$5,207 +4.1%$390,900
        2012$5,004 +2.8%$390,900 -3.1%
        2011$4,869 -5.1%$403,400 -8.3%
        2010$5,128 -1.4%$439,800 -7.6%
        2009$5,202 -0.3%$475,900 -7.6%
        2008$5,217 -11.5%$515,000 -11.8%
        2007$5,895 +13.7%$584,200 +15.6%
        2006$5,185 -2.5%$505,400
        2005$5,317 +15.8%$505,400 +57.2%
        2004$4,593 +4.7%$321,400
        2003$4,387 +4.1%$321,400
        2002$4,214 +24.9%$321,400 +60.1%
        2000$3,375 +20.7%$200,800 +19.6%
        1996$2,796 $167,900
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 01950

        Getting around

        75 / 100
        Very Walkable
        47 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Bresnahan
        • Middle: Nock
        • High: Newburyport

        Source: MLS PIN. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes