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.
For sale
Price cut: $100K (8/6)
$899,900
497 S Main St, Andover, MA 01810
6beds
3,322sqft
Est.:
Single Family Residence
Built in 1908
1.2 Acres Lot
$907,600 Zestimate®
$271/sqft
$-- HOA
What's special
Character-filled homePrivate acre-plus lotFlexible floor planFive spacious bedrooms
- 76 days
- on Zillow |
- 4,539 |
- 123 |
Zillow last checked: 7 hours ago
Listing updated: August 10, 2025 at 01:08am
Listed by:
The Carroll Group,
RE/MAX Partners,
Thomas Carroll
Source: MLS PIN,MLS#: 73386926
Travel times
Tour with a buyer's agent
Tour with a buyer's agent
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
- 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
Video & virtual tour
Property
Parking
- Total spaces: 6
- Parking features: Under, Paved Drive
- Attached garage spaces: 1
- Has uncovered spaces: Yes
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.2 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 & HOA
Community
- Features: Public Transportation, Shopping, Park, Golf
HOA
- Has HOA: No
Location
- Region: Andover
Financial & listing details
- Price per square foot: $271/sqft
- Tax assessed value: $785,700
- Annual tax amount: $10,120
- Date on market: 6/6/2025
- Road surface type: Paved
- Loading
- Loading