Skip main navigation
Sold for $820,000 on 11/10/25
  • $820,000

    497 S Main St, Andover, MA 01810

    6beds
    3,322sqft
    Single Family Residence
    Built in 1908
    1.2 Acres Lot
    $864,100 Zestimate®
    $247/sqft
    $5,735 Estimated rent

    Owner options

    List your home for rent

    $5,735/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,735/mo

    Rent Zestimate®

    Refinance and save

    $4,984/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $4,984/mo

    Est. payment

    What's special

    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.

    Zillow last checked: 8 hours ago

    Listing updated: November 10, 2025 at 09:44am

    Listed by:

    The Carroll Group,

    RE/MAX Partners,

    Thomas Carroll

    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
    • 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: 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.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
    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
    $864,100