Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
8 Beds
4 Baths
4,698 sqft

$699,000

497 Main Street, Hatfield MA, 01038

Price per sqft$148.79
Built in1900
Property size4,698 sqft
Property typeMulti-family

Overview

Active

Listed Aug 13, 2026

Updated 2 days ago

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.

$4,650/mo

Est. mortgage payment based on a $699,000 home price.

All estimates are provided by Luxury Presence for informational purposes only. Actual amounts may vary.

Additional information

MLS® ID
73563072

Interior Features

Bedrooms
8
Bathrooms
4
Fireplace
Yes
Heating
Yes
Basement
Yes

Exterior Features

Lot Size
2.6 Acres

Other Property Details

Taxes
$8,526
Tax Frequency
Annually
Garage
Yes
55+/Senior Community
No

This listing is provided by Ilene Berezin with The Murphys REALTORS®, Inc.

The property listing data and images displayed herein were provided to MLS Property Information Network, Inc. from third-party sources, including sellers, lessors, and public records, and compiled by MLS Property Information Network, Inc. This information is intended solely for the personal, non-commercial use of consumers who have a genuine interest in purchasing or leasing listed properties. It may not be used for any purpose other than to identify prospective properties of interest.

MLS Property Information Network, Inc. and its subscribers make no representations or warranties regarding the accuracy of the listing data or images presented.

©2026 MLS Property Information Network, Inc. All rights reserved.

Data last updated 3:17 AM UTC, 10/6/2026

Powered by Luxury Presence