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.
Sold for $820,000
$820,000
497 S Main St, Andover, MA 01810
6beds
3,322sqft
Single Family Residence
Built in 1908
1.2 Acres Lot
$825,800 Zestimate®
$247/sqft
$5,702 Estimated rent
Home value
$825,800
$760,000 - $900,000
$5,702/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: November 10, 2025 at 09:44am
Listed by:
The Carroll Group 978-475-2100,
RE/MAX Partners 978-475-2100,
Thomas Carroll 978-502-8347
Bought with:
Joe Pinto
Pinto Realty Group Inc.
Source: MLS PIN,MLS#: 73386926
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 4
- Full bathrooms: 4
Primary bedroom
- Features: Flooring - Hardwood
- Level: Second
- Area: 204
- Dimensions: 17 x 12
Bedroom 2
- Features: Ceiling Fan(s), Flooring - Hardwood
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom 3
- Features: Ceiling Fan(s), Flooring - Hardwood
- Level: Second
- Area: 176
- Dimensions: 16 x 11
Bedroom 4
- Features: Ceiling Fan(s), Flooring - Hardwood
- Level: Second
- Area: 120
- Dimensions: 12 x 10
Bedroom 5
- Features: Ceiling Fan(s), Flooring - Hardwood
- Level: Second
- Area: 108
- Dimensions: 12 x 9
Primary bathroom
- Features: No
Bathroom 1
- Features: Bathroom - Full, Closet - Linen, Flooring - Stone/Ceramic Tile
- Level: First
- Area: 54
- Dimensions: 9 x 6
Bathroom 2
- Features: Bathroom - Full, Closet - Linen, Flooring - Stone/Ceramic Tile
- Level: Second
- Area: 72
- Dimensions: 9 x 8
Bathroom 3
- Features: Bathroom - Full, Closet - Linen, Flooring - Stone/Ceramic Tile
- Level: Second
- Area: 56
- Dimensions: 7 x 8
Dining room
- Features: Ceiling Fan(s), Flooring - Hardwood
- Level: First
- Area: 192
- Dimensions: 12 x 16
Family room
- Features: Ceiling Fan(s), Flooring - Hardwood, Window(s) - Bay/Bow/Box
- Level: First
- Area: 416
- Dimensions: 16 x 26
Kitchen
- Features: Skylight, Flooring - Hardwood, Dining Area, French Doors, Deck - Exterior, Recessed Lighting
- Level: First
- Area: 228
- Dimensions: 19 x 12
Heating
- Central, Forced Air, Baseboard, Oil, Hydro Air
Cooling
- Central Air, Dual
Appliances
- Included: Electric Water Heater, Water Heater, Range, Dishwasher, Microwave, Refrigerator, Washer, Dryer
- Laundry: In Basement, Electric Dryer Hookup
Features
- Bathroom - Full, Closet - Linen, Play Room, Game Room, Kitchen, Bathroom, Bedroom, Central Vacuum
- Flooring: Tile, Hardwood, Flooring - Hardwood, Flooring - Stone/Ceramic Tile
- Doors: Storm Door(s)
- Windows: Insulated Windows
- Basement: Partial,Partially Finished,Walk-Out Access,Concrete
- Number of fireplaces: 1
- Fireplace features: Family Room
Interior area
- Total structure area: 3,322
- Total interior livable area: 3,322 sqft
- Finished area above ground: 3,322
Property
Parking
- Total spaces: 7
- Parking features: Under, Paved Drive
- Attached garage spaces: 1
- Uncovered spaces: 6
Features
- Patio & porch: Deck
- Exterior features: Deck, Pool - Inground, Rain Gutters, Storage, Sprinkler System, Fenced Yard
- Has private pool: Yes
- Pool features: In Ground
- Fencing: Fenced
Lot
- Size: 1.20 Acres
- Features: Wooded
Details
- Parcel number: M:00102 B:00001 L:00000,1841888
- Zoning: SRC
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Frame
- Foundation: Stone
- Roof: Shingle
Condition
- Year built: 1908
Utilities & green energy
- Electric: 220 Volts, Circuit Breakers, 200+ Amp Service
- Sewer: Public Sewer
- Water: Public
- Utilities for property: for Electric Range, for Electric Oven, for Electric Dryer
Community & neighborhood
Community
- Community features: Public Transportation, Shopping, Park, Golf
Location
- Region: Andover
Other
Other facts
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 11/10/2025 | Sold | $820,000-8.9%$247/sqft |
Source: MLS PIN #73386926 Report a problem | ||
| 9/11/2025 | Contingent | $899,900$271/sqft |
Source: MLS PIN #73386926 Report a problem | ||
| 8/6/2025 | Price change | $899,900-10%$271/sqft |
Source: MLS PIN #73386926 Report a problem | ||
| 6/6/2025 | Listed for sale | $999,900+54.8%$301/sqft |
Source: MLS PIN #73386926 Report a problem | ||
| 4/28/2017 | Sold | $646,000-2.8%$194/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $10,120 | $785,700 |
| 2024 | $10,120 +3.1% | $785,700 +9.3% |
| 2023 | $9,819 | $718,800 |
Find assessor info on the county website
Neighborhood: 01810
Nearby schools
GreatSchools rating
- 9/10South Elementary SchoolGrades: K-5Distance: 1.7 mi
- 8/10Andover West Middle SchoolGrades: 6-8Distance: 3.7 mi
- 10/10Andover High SchoolGrades: 9-12Distance: 3.7 mi
Schools provided by the listing agent
- Elementary: South
- Middle: Doherty
- High: Ahs
Source: MLS PIN. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value$825,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$825,800