Active
Listing Tools
Success!
While you wait to hear back from us:
Hi there! How can we help you?
Contact us using the form below or give us a call.
Success!
While you wait to hear back from us:
Send to a friend
Forward this listing to a friend
Send A Message:
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.
More Info
Basic Information
- Lot Features Wooded, Cleared, Gentle Sloping, Level
- Mls StatusActive
- Parcel Number 3624861
- Road Frontage DescriptionPaved
Tax Information
- Tax Assessed Value $581,200
- Tax Year 2026
- Taxes$8,526
Parking
- Covered Spaces 3
- Garage YN Yes
- Open Parking YN Yes
- Parking Features Off Street, Unpaved
- Parking Spaces23
Rooms
- Bathroom4
- Bathrooms Total Decimal 3.5
- Bedrooms8
- Full Bath3
- Half Baths1
Basic Information
- List Price$699,000
- MLS Number73563072
- Modification Date10/05/2026
- Property SubType3 Family
Location
- Address497 Main Street
- Building Number497
- CountyHampshire
- StateMA
- StreetMain Street
- TownHatfield
- Zip01038
Building
- BasementFull, Bulkhead, Sump Pump, Concrete
- Building Area Units Square Feet
- Construction Materials Frame
- FireplaceYes
- Fireplaces Total 1
- FoundationStone, Brick/Mortar
- Garage Spaces3
- Levels 5
- Patio And Porch Features Porch
- Rooms15
- Stories5
- Units3
- Utilities For Gas Range, For Electric Range, For Gas Dryer, Washer Hookup, Varies Per Unit
- Year Built1900
- Year Built Details Approximate
- Year Built Source Public Records
Property
- Acreage2.6
- Frontage Length 178
- Other Structures Barn/Stable
Interior
- Flooring Wood, Tile, Vinyl, Varies
- Interior Features Living Room, Dining Room, Kitchen, Laundry Room
Exterior
- Exterior Features Varies per Unit, Garden
- RoofShingle
Utilities
- Electric 100 Amp Service,200+ Amp Service, Individually Metered, Varies per Unit
- Heat SystemYes
- Heating
- Baseboard
- Individual
- Leased Propane Tank
- Natural Gas
- Radiant
- Wood Stove
- Sewer Private Sewer
- Water Source Public
Property Information
- Building Area Source Public Records
- Living Area 4,698
- Lot Size Square Feet 113,391
- Lot Size Units Acres
- Road Responsibility Public Maintained Road
- Square Feet4,698
Amenities
- Amenities
- Highway Access
- House of Worship
- Medical Facility
- Private School
- T-Station
- University
- Appliances IncludedOven, Dishwasher, Microwave, Range, Refrigerator, Washer, Dryer
- Other AmenitiesBasement, Fireplace, Garden
Legal
- ZoningRUR
Other
- Date Listed08/13/2026
- Farm Land Area Units Square Feet
- View Count2
Map Location
Listed by Ilene Berezin of The Murphys REALTORS®,Inc.
Success!
While you wait to hear back from us:
Hi there! How can we help you?
Contact us using the form below or give us a call.
Send Us A Message:
Success!
While you wait to hear back from us:
Hi there! How can we help you?
Contact us using the form below or give us a call.
Send Us A Message:
Success!
While you wait to hear back from us:
Hi there! How can we help you?
Contact us using the form below or give us a call.
Send Us A Message: