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
- Bedrooms8
- Mls StatusActive
- Bathroom4
- Lot Features Cleared, Gentle Sloping, Level
- Parcel Number 3624861
- Road Frontage DescriptionPaved
Tax Information
- Tax Assessed Value $581,200
- Tax Year 2026
- Taxes$8,526
Parking
- Parking Spaces18
- Covered Spaces 6
- Garage YN Yes
- Parking Features
- Barn
- Detached
- Off Street
- Oversized
- Stone/Gravel
- Storage
- Workshop in Garage
Rooms
- Bathrooms Total Decimal 3.5
- Full Bath3
- Half Baths1
Basic Information
- List Price$699,000
- MLS Number73563071
- Modification Date10/05/2026
- Property SubTypeSingle Family Residence
Location
- Address497 Main Street
- Building Number497
- CountyHampshire
- StateMA
- StreetMain Street
- TownHatfield
- Zip01038
Building
- BasementFull, Sump Pump, Concrete
- Building Area Units Square Feet
- Construction Materials Frame
- FireplaceYes
- Fireplaces Total 1
- FoundationStone, Brick/Mortar
- Garage Spaces6
- Patio And Porch Features Porch
- Property StyleFarmhouse
- Rooms15
- Utilities
- For Electric Dryer
- For Electric Range
- For Gas Dryer
- For Gas Range
- Generator Connection
- Washer Hookup
- Year Built1900
- Year Built Details Approximate
- Year Built Source Public Records
Property
- Acreage2.6
- Frontage Length 178
Interior
- Flooring Wood, Tile, Vinyl
- Interior Features Internet Available - Broadband
Exterior
- Exterior Features Porch
- RoofShingle
Utilities
- Electric Circuit Breakers,100 Amp Service,200+ Amp Service, Generator Connection
- Heat SystemYes
- Heating Central, Baseboard, Radiant, Natural Gas, Propane
- Sewer Private Sewer
- Water Source Public
Property Information
- Square Feet4,698
- Building Area Source Public Records
- Living Area 4,698
- Lot Size Square Feet 113,391
- Lot Size Units Acres
- Road Responsibility Public Maintained Road
Amenities
- AmenitiesConservation Area, Highway Access, Private School, Public School, University
- Appliances IncludedWater Heater, Range, Oven, Dishwasher, Microwave, Washer, Dryer
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: