Skip main navigation
Off market
    • $590,500

    218 Madison Ave W, Holyoke, MA 01040

    5beds
    3,414sqft
    SingleFamily
    Built in 1900
    0.25 Acres Lot
    $590,500 Zestimate®
    $173/sqft
    $3,339 Estimated rent

    Home value

    $590,500

    $549,000 - $638,000

    $3,339/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,339/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,339/mo

    Rent Zestimate®

    Refinance and save

    $3,849/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,849/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Your waiting is over! Come see this stately yet family friendly gem in sought-after Highlands. Much original charm left intact such as 4 fireplaces + hardwood floors on all 3 levels. Enter into a grand hall with a show-stopping curved staircase. You will be the envy of your friends + family with the new gourmet kitchen complete with gas range, new cabinets + granite counters. The fresh walk in pantry will hold an abundance of the extras. The large formal dining room features a fireplace. The back to back family + living room has a fireplace on 1 side + a gas stove on the other side! The 1st floor bath is thoughtfully updated. The 2nd floor master bedroom features a window seat, fireplace + large ensuite bath. Check out the walk in shower, double vanity, luxurious soaking tub + laundry. The 2nd floor has 2 more bedrooms + full bath with double vanity. The 3rd floor has an option for an inlaw apt, including 2 more bedrooms + full bath. Also new roof + windows, new electric + plumbing

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Other, Electric, Gas
    Cooling
    • None
    Appliances
    • Included: Dishwasher, Microwave, Range / Oven, Refrigerator
    Features
    • Cable Available
    • Flooring: Tile, Concrete, Hardwood, Laminate
    • Basement: Unfinished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 3,414 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Wood
    Lot
    • Size: 0.25 Acres
    Details
    • Parcel number: HOLYM0132B0000L12

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Colonial
    Materials
    • Frame
    • Roof: Asphalt
    Condition
    • Year built: 1900

    Community & neighborhood

    Location
    • Region: Holyoke

    Other

    Other facts
    • Amenities: Public Transportation, Shopping, Medical Facility, Highway Access, Park, Walk/Jog Trails
    • Construction: Frame
    • Electric Feature: Circuit Breakers, 100 Amps
    • Energy Features: Insulated Windows
    • Flooring: Wood, Tile, Hardwood, Laminate
    • Master Bath: Yes
    • Roof Material: Asphalt/Fiberglass Shingles
    • Utility Connections: For Electric Dryer, Washer Hookup, For Gas Range
    • Year Round: Yes
    • Exterior: Wood
    • Hot Water: Natural Gas
    • Terms Feature: Contract For Deed
    • Appliances: Dishwasher, Microwave, Refrigerator, Refrigerator - Energy Star, Dishwasher - Energy Star, Range - Energy Star, Countertop Range
    • Bed2 Dscrp: Flooring - Hardwood, Closet
    • Bed2 Level: Second Floor
    • Bed3 Level: Second Floor
    • Bth1 Level: First Floor
    • Interior Features: Cable Available
    • Kit Dscrp: Pantry, Dining Area, Flooring - Hardwood, Countertops - Stone/Granite/Solid, Stainless Steel Appliances, Walk-In Storage
    • Kit Level: First Floor
    • Mbr Dscrp: Flooring - Hardwood, Bathroom - Full, Closet, Window(s) - Bay/Bow/Box, Fireplace
    • Mbr Level: Second Floor
    • Heating: Gas, Electric, Hot Water Radiators
    • Garage Parking: Attached
    • Bed3 Dscrp: Closet, Flooring - Hardwood
    • Din Level: First Floor
    • Bth2 Level: Second Floor
    • Style: Colonial, Victorian
    • Bth1 Dscrp: Flooring - Stone/Ceramic Tile, Bathroom - Half
    • Bth2 Dscrp: Bathroom - Full, Double Vanity, Bathroom - Tiled With Tub & Shower, Remodeled, Dryer Hookup - Electric, Washer Hookup
    • Fam Dscrp: Flooring - Hardwood, Fireplace
    • Fam Level: First Floor
    • Insulation Feature: Unknown
    • Bed4 Dscrp: Closet, Flooring - Hardwood
    • Bed5 Dscrp: Closet, Flooring - Hardwood
    • Bth3 Level: Second Floor
    • Din Dscrp: Flooring - Hardwood, Fireplace
    • Bth3 Dscrp: Bathroom - Full, Double Vanity, Bathroom - Tiled With Tub & Shower
    • Bed4 Level: Third Floor
    • Bed5 Level: Third Floor
    • Basement Feature: Full, Concrete Floor
    • Lead Paint: Unknown
    • Exterior Features: Porch, Deck - Wood, Gutters, Fenced Yard, Storage Shed
    • Laundry Level: Second Floor
    • Liv Dscrp: Fireplace, Flooring - Hardwood
    • Road Type: Public, Paved, Publicly Maint.
    • Liv Level: First Floor
    • Lot Description: Paved Drive, Cleared, Level
    • Sf Type: Detached
    • Foundation: Brick
    • CONTINGENCY_TYPE: Inspection

    Price history

    DateEventPrice
    11/15/2019Sold$377,000-2.1%$110/sqft
    Source: Agent Provided Report a problem
    9/27/2019Pending sale$384,987$113/sqft
    Source: Hampden Realty Center, LLC #72536173 Report a problem
    8/22/2019Price change$384,987-2.5%$113/sqft
    Source: Hampden Realty Center, LLC #72536173 Report a problem
    7/18/2019Listed for sale$394,987+121.9%$116/sqft
    Source: Hampden Realty Center, LLC #72536173 Report a problem
    10/10/2018Sold$178,000-8.9%$52/sqft
    Source: Public Record Report a problem
    5/16/2017Listing removed$195,490$57/sqft
    Source: Agnelli Real Estate #72130573 Report a problem
    5/2/2017Price change$195,490-5%$57/sqft
    Source: Agnelli Real Estate #72130573 Report a problem
    5/2/2017Pending sale$205,770$60/sqft
    Source: Agnelli Real Estate #72130573 Report a problem
    3/14/2017Price change$205,770-5%$60/sqft
    Source: Agnelli Real Estate #72130573 Report a problem
    2/14/2017Price change$216,600+0.3%$63/sqft
    Source: Agnelli Real Estate #72100917 Report a problem
    2/10/2017Price change$216,000-5.3%$63/sqft
    Source: Agnelli Real Estate #72100917 Report a problem
    1/11/2017Price change$228,000-5%$67/sqft
    Source: Agnelli Real Estate #72100917 Report a problem
    12/12/2016Listed for sale$240,000-19.1%$70/sqft
    Source: Agnelli Real Estate #72100917 Report a problem
    10/24/2016Sold$296,556+29.5%$87/sqft
    Source: Public Record Report a problem
    9/2/2012Listing removed$229,000$67/sqft
    Source: The Murphys REALTORS�, Inc. #71353071 Report a problem
    7/14/2012Price change$229,000-6.5%$67/sqft
    Source: The Murphys REALTORS�, Inc. #71353071 Report a problem
    6/20/2012Price change$245,000-2%$72/sqft
    Source: The Murphys REALTORS�, Inc. #71353071 Report a problem
    5/30/2012Price change$250,000-16.4%$73/sqft
    Source: The Murphys REALTORS�, Inc. #71353071 Report a problem
    5/2/2012Price change$299,000-3.5%$88/sqft
    Source: The Murphys REALTORS�, Inc. #71353071 Report a problem
    4/20/2012Price change$310,000-3.1%$91/sqft
    Source: The Murphys REALTORS�, Inc. #71353071 Report a problem
    3/18/2012Listed for sale$320,000-10.4%$94/sqft
    Source: The Murphys REALTORS�, Inc. #71353071 Report a problem
    2/7/2006Sold$357,000+1.4%$105/sqft
    Source: Public Record Report a problem
    4/20/2004Sold$352,000+127.2%$103/sqft
    Source: Public Record Report a problem
    4/10/1987Sold$154,900$45/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$8,959 +6.5%$513,100 +15.6%
    2024$8,410 +4.9%$443,800 +3.8%
    2023$8,020 +4.6%$427,500 +7.4%
    2022$7,667 +4.5%$398,100 +4.5%
    2021$7,338 -1.1%$380,800 -2.4%
    2020$7,419 +1.7%$390,200 +3.2%
    2019$7,295 +5.2%$378,200 +4.4%
    2018$6,933 -0.2%$362,400
    2017$6,947 +1.9%$362,400 +1.6%
    2016$6,820 +0.4%$356,700
    2015$6,792 +0%$356,700 -6.7%
    2014$6,792 -3.5%$382,300 -0.3%
    2013$7,037 +6.3%$383,500 -2.4%
    2012$6,619 +6.8%$392,800
    2011$6,198 +5.3%$392,800
    2010$5,884 -2.3%$392,800 -7.1%
    2009$6,022 +3.6%$422,900
    2008$5,815 +6.2%$422,900
    2007$5,477 +21.1%$422,900 +18.7%
    2006$4,524 +41.6%$356,200 +51%
    2005$3,194 +2.5%$235,900 +8.4%
    2004$3,116 -2.5%$217,600 +15.4%
    2003$3,197 +12%$188,600 +6%
    2001$2,854 $177,900

    Find assessor info on the county website

    Neighborhood: 01040

    Nearby homes

    Skip to the end of the carouselSkip to the beginning of the carousel

    Nearby schools

    GreatSchools rating
    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
    $590,500
    2% more
    +$11,810
    With Zillow Showcase(estimated)
    $602,310

    Nearby cities

    Nearby zip codes

    Other Holyoke Topics

      Search
      Updates
      Favorites
      Plan
      Inbox