Discover the charm and versatility of this unique property set on a private acre-plus lot abutting the scenic Goldsmith Reservation woodlands and trails. This character-filled home offers a flexible floor plan perfect for today’s multi-functional living. The first floor, formerly a licensed day care, provides ideal space for a home business or creative studio. Upstairs, the second floor features five spacious bedrooms, while the walk-out lower level includes a private guest suite—perfect for extended family or guests. Enjoy the outdoors year-round in the enclosed screen porch with fireplace and built-in grill, or unwind by the in-ground pool surrounded by nature. With easy access to downtown, top schools, and major commuting routes, this one-of-a-kind home is both a private retreat and a practical lifestyle opportunity.
Listed by Thomas Carroll
·
RE/MAX Partners
·
978-502-8347
Listed by The Carroll Group
·
RE/MAX Partners
Last updated August 10, 2025
·
Source: MLSPin #73386926
Listing Facts
TypeSingle-family
NeighborhoodAndover
Bedrooms6
Bathrooms4
Days on Prevu95
Taxes$10,120/year
Size3,322 sqft
Price per sqft$271
Amenities
Dishwasher
Private Outdoor Space
Washer/Dryer
Air Conditioning
Parking
Swimming Pool
Location
Mortgage Calculator
Listing History
08/06/2025
Price Decreased
$899,900
06/06/2025
Listed by RE/MAX Partners
$999,900
Property Details for 497 S Main St
Association
Amenities
Community Features: Public Transportation, Shopping, Park, Golf
Electric: 220 Volts, Circuit Breakers, 200+ Amp Service
Heating: Central, Forced Air, Baseboard, Oil, Hydro Air
Has Heating: Yes
Laundry Features: In Basement, Electric Dryer Hookup
Sewer: Public Sewer
Utilities: For Electric Range, For Electric Oven, For Electric Dryer
Water Source: Public
The property listing data and information, or the Images, set forth herein were provided
to MLS Property Information Network, Inc. from third party sources, including sellers,
lessors, landlords and public records, and were compiled by MLS Property Information
Network, Inc. The property listing data and information, and the Images, are for the
personal, non commercial use of consumers having a good faith interest in purchasing,
leasing or renting listed properties of the type displayed to them and may not be used
for any purpose other than to identify prospective properties which such consumers may
have a good faith interest in purchasing, leasing or renting. MLS Property Information
Network, Inc. and its subscribers disclaim any and all representations and warranties
as to the accuracy of the property listing data and information, or as to the accuracy
of any of the Images, set forth herein.
Rebate estimate is indicative only and based on listing price and estimated buyer's agent commission paid by owner, if applicable. Final rebates are subject to Terms of Use and may vary due to final negotiated transaction terms.