Sign up to get new listings emailed daily! JOIN SIGN IN
(781) 223-5813
(781) 223-5813 Email (781) 223-5813
Mary Ellen McDonough
REALTOR®
Facebook Icon LinkedIn Icon Instagram Icon 
  • Main Photo

497 Main Street
Hatfield, MA 01038

$750,000

42 Photos

SCHEDULE A PRIVATE TOUR Call Print Email

Listing Details

  • $750,000
  • MLS# 73563072
  • Type Multi Unit - Multiple
  • Status Active
  • 8
    Bedrooms
  • 3 full 1 partial
    Bathrooms
  • 4,698
    Square Feet
  • 2.603 acres
    Lot Size
  • 1900
    Year Built
MAP LISTING SHARE

Listed By

Agency Name: The Murphys REALTORS, Inc.
Agent Name: Ilene Berezin
Agency Phone: 413-584-5700

agent picture

Shown By

Agent Name: Mary Ellen McDonough
Agent Phone: (781) 223-5813
Agency Title: Donahue Real Estate Co.

IDX logo

Home Value Estimate

Description

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,...read more

Features

  • Oven
  • Dishwasher
  • Microwave
  • Range
  • Refrigerator
  • Washer
  • Dryer
  • None
  • 1 Fireplace
  • Wood
  • Tile
  • Vinyl
  • Varies
  • Baseboard, Natural Gas, Radiant, Wood Stove, Leased Pr
  • 5.0 Stories
  • $8,526 Taxes
  • Public
  • Built in 1900
SUBMIT AN OFFERx

Listed By

Agency Name: The Murphys REALTORS, Inc.
Agent Name: Ilene Berezin
Agency Phone: 413-584-5700

agent picture

Shown By

Agent Name: Mary Ellen McDonough
Agent Phone: (781) 223-5813
Agency Title: Donahue Real Estate Co.

IDX logo

Mary Ellen McDonough
Mary Ellen McDonough Office: (781) 223-5813 Cell: (781) 223-5813 Email Me
LinkedIn IconInstagram Icon
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 09/12/2026. The listing information on this page last changed on 09/12/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Sat 09/12/2026 8:45:50 AM EST) or MLSPIN MLS (last updated Sat 09/12/2026 8:43:24 AM EST) or Cape Cod / Islands MLS (last updated Sat 09/12/2026 8:37:15 AM EST). Real estate listings held by brokerage firms other than Donahue Real Estate Co. may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility
Federal Housing Equal Opportunity Realtor
This site is hosted, designed and copyright © 1994 - 2026 by Delta Media Group, Inc. -- Patent Pending --
  

Login to My Homefinder

Forgot Password

Register