Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker PEGGY CARTER TEAM

Property view
Listing view 2
Listing view 3

497 Main Street, 
Hatfield, MA 01038

$799,000


8

Beds


4

Baths


4,698

Sq Ft


Multi-Family

Active

Listed by

Ilene Berezin

The Murphys Realtors®, Inc.

413-584-5700

Last updated:

August 16, 2026, 01:25 AM

MLS#

73563072

Source:

MLSPIN

About This Home

497 Main Street

An unusual offering with possibilities limited only by your imagination! Could this be the dream come to reality—one property where you can live, work, create and generate rental income to help pay the mortgage?Set on 2.6 beautiful, private acres, this distinctive property includes a single-family home, a separate two-family home, and an impressive 28’ x 56’ fully restored barn. Thoughtfully positioned with plenty of privacy between the buildings, the property offers a rare combination of residential, rental and workspaces.The main home features a wonderful addition with a charming tower room that could become your home office, bedroom, studio, reading retreat or meditation space—the choice is yours. The separate two-family home provides excellent potential for rental income, extended family, guests or additional living arrangements.The fully restored barn is a standout feature, offering substantial flexible space for a workshop, studio, home business, creative pursuits, storage or other possibilities. The barn is set up for radiant heat, for you to make it a truly usable year-round space.Modern mechanical systems in both residential buildings add comfort and peace of mind while preserving the property’s unique character. With multiple buildings, generous acreage and an extraordinary blend of living, working and income-producing potential, this is far more than a home—it is an opportunity to create the lifestyle and property you’ve been imagining.Rarely does a property offer this much flexibility, privacy and potential in one package. Come explore the possibilities and decide what your dream looks like here.

Home Facts

Multi-Family

4 Baths

8 Bedrooms

Built in 1900

Price Summary

799,000

$170 per Sq. Ft.

MLS #:

73563072

Last Updated:

August 16, 2026, 01:25 AM


Rooms & Interior

Bedrooms

Total Bedrooms:

8

Bathrooms

Total Bathrooms:

4

Full Bathrooms:

3

Interior

Living Area:

4,698 Sq. Ft.


Structure

Structure

Building Area:

4,698 Sq. Ft.

Year Built:

1900


Lot

Lot Size (Sq. Ft):

113,391


Finances & Disclosures

Finances

Price:

$799,000

Price per Sq. Ft:

$170 per Sq. Ft.

Source:MLSPIN
The property listing data and information, or the Images, set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc. 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. MLS Property Information Network, Inc. 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.

Contact an Agent

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 Contact, 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 a 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.

Contact an Agent

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 Contact, 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 a 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.