Skip to main content
Liriano Realty

For Sale · Multi-Family

497 Main Street

Hatfield, MA 01038

$799,000

$170 per sq ft

8
beds
3.5
baths
4,698
sq ft

Est. payment: $4,901/mo Estimated. Taxes and insurance included.

Lot (sq ft)
113,391
Year Built
1900
Type
Multi-Family
Status
For Sale
Property taxes (2026)
$8,526
Assessed value
$581,200
Days on Market
4

About this home

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.

Facts & features

Interior

Total rooms
15
Appliances
Oven, Dishwasher, Microwave, Range, Refrigerator, Washer, Dryer
Flooring
Wood, Tile, Vinyl, Varies
Fireplaces
1
Laundry
Gas Dryer Hookup, Washer Hookup
Basement
Full, Bulkhead, Sump Pump, Concrete
Interior features
Living Room, Dining Room, Kitchen, Laundry Room

Systems & utilities

Heating
Baseboard, Natural Gas, Radiant, Wood Stove, Leased Propane Tank, Individual
Cooling
None
Water
Public
Sewer
Private Sewer
Electric
100 Amp Service, 200+ Amp Service, Individually Metered, Varies per Unit
Utilities
for Gas Range, for Electric Range, for Gas Dryer, Washer Hookup, Varies per Unit

Exterior & parking

Parking
Off Street, Unpaved
Garage spaces
3
Total parking
23
Exterior features
Varies per Unit, Garden
Patio & porch
Porch

Construction

Construction materials
Frame
Foundation
Stone, Brick/Mortar
Roof
Shingle
Year built
1900

Flood risk

Location

Map

Courtesy of The Murphys REALTORS®, Inc.

MLS #: 73563072 · Updated: August 17, 2026

Listing data is provided in part by MLS PIN and PrimeMLS/NEREN and is for consumers' personal, non-commercial use. Information is deemed reliable but not guaranteed.