Overview Property Details Payment Calculator Walkability

Add to favorites

Remove from favorites
Send to Friend
Watch changes on this property

Active Under Contract

174 Water St, Newburyport MA 01950

$2,400,000

Estimated $16,436/month Calculator

Single Family

4 Bedrooms

Baths

3230

Total Parking: 2

5,530 (0.13)

Built in 1710

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!

This home has been viewed 3 times

Last Checked: June 19th, 2026 at 8:38am (Source: MLS PIN #73536972)

Air Conditioning

Waterview

Waterfront

Lead Paint Free

General Information for 174 Water St, Newburyport MA 01950

Listing ID73536972

Property TypeSingle Family / Detached

Price$2,400,000 ($743.03/SqFt)

StyleColonial

CityNewburyport

CountyEssex

Neighborhood(s)Ipswich

Garage Parking0

ZoningR3

Year Built1710

Year Built SourcePublic Records

Year Built DetailsActual

Interior Features for 174 Water St, Newburyport MA 01950

Approximate Living Area Total3230

Living Area Includes BasementNo

Rooms9

Bedrooms4

Primary En Suite BathroomYes

BasementFull

Cooling1, Split

Fireplaces

AppliancesRange

FlooringTile

Electric220 Volts

Exterior Features for 174 Water St, Newburyport MA 01950

Approximate Lot Size (Acres)0.13

Approximate Lot Size (Square Feet)5530

Total Parking2

Garage Parking0

WaterPublic

SewerPublic Sewer

Lot FeaturesGentle Sloping

Parking Features1

Exterior FeaturesPorch

Foundation Materials

Construction Materials

Road Frontage Type

Patio & PorchCovered

Roof MaterialAsphalt/fiberglass Shingles

Utility Connections110 Volts

Water ViewsYes

Water Views FeaturesBay

Waterfront1

Waterfront FeaturesRiver

Pool Features

Horse Permitted0

Horse AmenitiesRiver

Disclosures for 174 Water St, Newburyport MA 01950

Lead PaintNone

UFFI

Living Area Includes BasementNo

Living Area Disclosure

Building Area SourcePublic Records

Special Listing Conditions

ExclusionsChicken Run

Compensation Based On

Financial Information for 174 Water St, Newburyport MA 01950

Association Fee

Association Fee Frequency

Association Fee Includes

Real Estate Tax19781

Tax Year2026

Assessed Value$2,136,200

Location Information for 174 Water St, Newburyport MA 01950

Elementary SchoolBresnahan

Middle SchoolNock

High SchoolNewburyport

Neighborhood(s)Ipswich

Area AmenitiesWalk/jog Trails

Contact Information for 174 Water St, Newburyport MA 01950

Agent

Name: Melanie Cosgrove

Office

Name: RE/MAX Bentley's

Phone: 978-572-1200

Team Members

Payment Calculator

, Interest

Property Taxes 1648.42

Principal & Interest 14788.04

HOA Dues

Term

Interest

Home Price

Down Payment

Exclusive Listing Agent

RE/MAX Bentley's

Melanie Cosgrove

Agent Phone

Office Phone

(978) 572-1200

Text Agent Call Agent Call Office

Array
(
    [acres] => Approx. 0.13 acres (5,530 SqFt)
    [add_date] => 2026-06-17 12:38:36
    [address] => Water St
    [agent] => Array
        (
            [address] => 
            [city] => 
            [id] => CN207065
            [name] => Melanie Cosgrove
            [national_association] => 452001424
            [office] => AN8279
            [state] => MA
            [zip] => 
        )

[apod_available] => Array
        (
        )

[appliances] => Array
        (
            [0] => Range
        )

[approx_living_area_total] => 3230
    [approx_lot_size_acres] => 0.13
    [approx_lot_size_sqft] => 5530
    [assessed_value] => $2,136,200
    [association] => 
    [association_fee] => Array
        (
        )

[association_fee_frequency] => Array
        (
        )

[association_fee_includes] => Array
        (
        )

[association_required] => Array
        (
        )

[available_date] => 
    [available_now] => 0
    [basement] => Array
        (
            [0] => Full
        )

[bathrooms] => 
    [bedrooms] => 4
    [building_amenities] => Array
        (
        )

[building_area_source] => Array
        (
            [0] => Public Records
        )

[building_management] => Array
        (
        )

[building_debug] => 
    [building_id] => 
    [building_parent] => 0
    [building_name] => 
    [building_name_from_address] => 
    [building_url] => 
    [buyer_agent_compensation] => 
    [buyer_agent_id] => 
    [buyer_office_id] => 
    [c_style] => Array
        (
            [0] => Detached
        )

[c_type] => Array
        (
            [0] => Single Family
        )

[cap_rate] => 
    [city] => Newburyport
    [community_features] => Array
        (
            [0] => Walk/jog Trails
        )

[compensation_based_on] => Array
        (
        )

[complex_complete] => Array
        (
        )

[construction_materials] => Array
        (
        )

[construction_status] => 
    [cooling] => Array
        (
            [0] => 1
            [1] => Split
        )

[cooperating_agent_commission] => Array
        (
        )

[county] => Essex
    [cultivation_acres] => 
    [date_available_note] => 
    [deposit_amount] => Array
        (
        )

[deposit_required] => Array
        (
        )

[deqe] => 
    [description] => 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!
    [disclosures] => 
    [documents_available] => Array
        (
        )

[electric] => Array
        (
            [0] => 220 Volts
        )

[electric_expense] => Array
        (
        )

[elementary_school] => Bresnahan
    [en_suite_bath] => Array
        (
            [0] => Yes
        )

[energy_features] => 
    [entry_level] => Array
        (
        )

[estimated_monthly_payment] => 
    [exclusions] => Array
        (
            [0] => Chicken Run
        )

[exterior_features] => Array
        (
            [0] => Porch
        )

[facilitator_compensation] => 
    [fee_paid_by_tennant] => 
    [financial_data_source] => Array
        (
        )

[fireplaces] => Array
        (
        )

[first_month_required] => Array
        (
        )

[floor_number] => 0
    [flooring] => Array
        (
            [0] => Tile
        )

[for_sale_by_owner] => 
    [foundation_area] => 
    [foundation_materials] => Array
        (
        )

[frontage_length] => 
    [full_baths] => 
    [garage_parking] => 0
    [gas] => Array
        (
        )

[gas_expense] => Array
        (
        )

[gross_income] => Array
        (
        )

[half_baths] => 
    [handicap_access] => 
    [heating] => 
    [heating_expense] => Array
        (
        )

[high_school] => Newburyport
    [horse_features] => Array
        (
            [0] => River
        )

[horse_permitted] => 0
    [hot_water] => Array
        (
        )

[id] => 
    [insurance_expense] => Array
        (
        )

[insurance_required] => Array
        (
        )

[interior_features] => Array
        (
            [0] => French Doors
        )

[last_month_required] => Array
        (
        )

[last_sync_date] => 2026-06-19 08:38:41
    [laundry_features] => Array
        (
            [0] => Archway
        )

[lead_paint] => Array
        (
            [0] => None
        )

[lease_term] => Array
        (
        )

[levels_in_unit] => 
    [living_area] => 
    [living_area_disclosure] => Array
        (
        )

[living_area_includes_basement] => Array
        (
            [0] => No
        )

[lot_features] => Array
        (
            [0] => Gentle Sloping
        )

[management_expense] => Array
        (
        )

[middle_school] => Nock
    [miscellaneuos_expense] => Array
        (
        )

[mls_area] => 
    [mls_id] => 73536972
    [neighborhoods] => Ipswich
    [net_income_calc] => -19781
    [net_operating_income] => Array
        (
        )

[number_of_lots] => Array
        (
        )

[number_of_units] => 
    [office] => Array
        (
            [id] => AN8279
            [name] => RE/MAX Bentley's
            [phone] => 978-572-1200
        )

[operating_expense] => Array
        (
        )

[optional_fee_includes] => Array
        (
        )

[optional_price] => 0
    [outdoor_space_available] => Array
        (
        )

[owner_occupancy_source] => 
    [parking_features] => Array
        (
            [0] => 1
        )

[pasture_area] => 
    [patio_and_porch] => Array
        (
            [0] => Covered
        )

[perc_test] => Array
        (
        )

[perc_test_date] => 
    [pet_policy] => Array
        (
            [0] => Allowed
        )

[phone] => 
    [pool_features] => Array
        (
        )

[price] => 2400000
    [price_per_sqft] => 743.03
    [price_per_unit] => 2400000
    [private_pool] => 
    [property_sub_type] => Array
        (
            [0] => Single Family Residence
        )

[real_estate_tax] => 19781
    [references_required] => Array
        (
        )

[rent_includes] => Array
        (
        )

[repair_maintenance_expense] => Array
        (
        )

[road_frontage_type] => Array
        (
        )

[roof_material] => Array
        (
            [0] => Asphalt/fiberglass Shingles
        )

[rooms] => 9
    [schools] => 
    [senior_community] => 
    [sewer] => Array
        (
            [0] => Public Sewer
        )

[sewer_expense] => Array
        (
        )

[short_sale] => Array
        (
        )

[special_listing_conditions] => Array
        (
        )

[state] => Massachusetts
    [state_code] => MA
    [status] => Array
        (
            [0] => Active Under Contract
        )

[street_number] => 174
    [structure_type] => Array
        (
        )

[style] => Array
        (
            [0] => Colonial
        )

[subagent_compensation] => 
    [tag_accessible_features] => 
    [tag_air_conditioning] => 1
    [tag_association_pool] => 
    [tag_beach_access] => 
    [tag_beach_front] => 
    [tag_elevator] => 
    [tag_equestrian] => 
    [tag_garage_parking] => 
    [tag_generator] => 
    [tag_green_features] => 
    [tag_laundry] => 1
    [tag_lead_paint_free] => 1
    [tag_loft] => 
    [tag_pet_friendly] => 
    [tag_pre_construction] => 
    [tag_private_outdoor_space] => 
    [tag_private_pool] => 
    [tag_professional_management] => 
    [tag_recently_renovated] => 
    [tag_senior_community] => 
    [tag_townhouse] => 
    [tag_waterfront] => 1
    [tag_waterview] => 1
    [tax_year] => 2026
    [team] => CN207065
    [team_agents] => Array
        (
            [CN207065] => Array
                (
                    [agent_mls_id] => CN207065
                    [full_name] => Melanie Cosgrove
                    [address] => 
                    [city] => 
                    [state] => MA
                    [postal_code] => 
                    [national_association_id] => 452001424
                    [office_mls_id] => AN8279
                )

)

[terms] => Array
        (
        )

[timber_acres] => 
    [title_5] => 
    [total_gross_expense] => 19781
    [total_gross_income] => 0
    [total_parking] => 2
    [trash_expense] => Array
        (
        )

[travel_routes] => 
    [uffi] => Array
        (
        )

[unit_1_bathrooms] => 
    [unit_1_bedrooms] => 
    [unit_1_floor] => 
    [unit_1_lease] => Array
        (
        )

[unit_1_levels] => 
    [unit_1_rent] => Array
        (
        )

[unit_2_bathrooms] => 
    [unit_2_bedrooms] => 
    [unit_2_floor] => 
    [unit_2_lease] => Array
        (
        )

[unit_2_levels] => 
    [unit_2_rent] => Array
        (
        )

[unit_3_bathrooms] => 
    [unit_3_bedrooms] => 
    [unit_3_floor] => 
    [unit_3_lease] => Array
        (
        )

[unit_3_levels] => 
    [unit_3_rent] => Array
        (
        )

[unit_4_bathrooms] => 
    [unit_4_bedrooms] => 
    [unit_4_floor] => 
    [unit_4_lease] => Array
        (
        )

[unit_4_levels] => 
    [unit_4_rent] => Array
        (
        )

[unit_level] => 
    [unit_number] => 
    [units_owner_occupied] => 
    [unparsed] => 174 Water St, Newburyport MA 01950
    [utilities] => Array
        (
            [0] => 110 Volts
        )

[view] => Array
        (
        )

[water] => Array
        (
            [0] => Public
        )

[water_expense] => Array
        (
        )

[water_views] => Array
        (
            [0] => Yes
        )

[water_views_features] => Array
        (
            [0] => Bay
        )

[waterfront] => 1
    [waterfront_features] => Array
        (
            [0] => River
        )

[raw] => 
)

EXIT

38 More Photos