Skip main navigation
For sale
  • $5,498,000

    497 Old, Concord, MA 01742

    5beds
    10,200sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 2000
    8.5 Acres Lot
    $5,232,100 Zestimate®
    $539/sqft
    $-- HOA

    What's special

    In-ground poolBackyard oasisMarble foyerHome gymRetail quality walk-in closetSpacious ensuite bathMedia room
    SPECTACULARLY ONE-OF-A-KIND HOME! This JAW DROPPING home is a MASTERPIECE OF CUSTOM DESIGN ON 8.5 ACRES! A backyard oasis offers a VACATION AT HOME LIFESTYLE! The STYLE & DESIGN throughout is reminiscent of the best homes available in NANTUCKET, THE HAMPTONS OR PALM BEACH! The oversized wood pivot front door opens to a MARBLE FOYER with SKY HIGH CEILINGS & A DRAMATIC DOUBLE STAIRCASE. The EXPANSIVE DINING ROOM SEATS 18! A DESIGNER KITCHEN offers stone countertops & A SEPARATE STONE DINING ISLAND, views of the backyard, SS appliances & FLOOR TO CEILING CABINETRY! A 1ST FLOOR PRIMARY SUITE stuns with a RETAIL QUALITY WALK-IN CLOSET & a spacious ensuite bath. The 2nd floor showcases 4 additional bedrooms including a 2ND FLOOR BEDROOM SUITE & a 2nd laundry room! WALK OUT FINISHED LOWER LEVEL FEELS LIKE A 1ST FLOOR & features a full MEDIA ROOM, home gym, full bath SAUNA & add'l guest space. ENJOY THE IN-GROUND POOL, 2 hot tubs, KITCHEN CABANA with a FULL WET BAR & GAZEBO! 4 CAR GARAGE!
    287 days
    |
    652
    |
    29
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    The Zur Attias Team 978-621-0734,

    The Attias Group, LLC 978-371-1234,

    The Zur Attias Team 978-621-0734

    Source: MLS PIN,MLS#: 73432257

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 6
      • Full bathrooms: 5
      • 1/2 bathrooms: 1
      Primary bedroom
      • Features: Bathroom - Full, Walk-In Closet(s), Flooring - Wood
      • Level: First
      • Area: 456
      • Dimensions: 24 x 19
      Bedroom 2
      • Features: Ceiling Fan(s), Flooring - Wood, Recessed Lighting, Closet - Double
      • Level: Second
      • Area: 330
      • Dimensions: 22 x 15
      Bedroom 3
      • Features: Flooring - Wood, Balcony / Deck, Recessed Lighting, Closet - Double
      • Level: Second
      • Area: 561
      • Dimensions: 33 x 17
      Bedroom 4
      • Features: Walk-In Closet(s), Flooring - Wood, Recessed Lighting
      • Level: Second
      • Area: 228
      • Dimensions: 19 x 12
      Bedroom 5
      • Features: Bathroom - Full, Walk-In Closet(s), Flooring - Wood
      • Level: Second
      • Area: 420
      • Dimensions: 28 x 15
      Primary bathroom
      • Features: Yes
      Bathroom 1
      • Features: Bathroom - Half, Flooring - Wood, Double Vanity, Lighting - Pendant
      • Level: First
      • Area: 72
      • Dimensions: 9 x 8
      Bathroom 2
      • Features: Bathroom - Full, Bathroom - Tiled With Shower Stall, Flooring - Stone/Ceramic Tile, Double Vanity
      • Level: First
      • Area: 285
      • Dimensions: 19 x 15
      Bathroom 3
      • Features: Bathroom - Full, Bathroom - Tiled With Shower Stall, Flooring - Stone/Ceramic Tile, Recessed Lighting
      • Level: Second
      • Area: 80
      • Dimensions: 10 x 8
      Dining room
      • Features: Flooring - Wood, Lighting - Pendant
      • Level: First
      • Area: 450
      • Dimensions: 30 x 15
      Family room
      • Features: Flooring - Wood, Exterior Access
      • Level: First
      • Area: 459
      • Dimensions: 27 x 17
      Kitchen
      • Features: Flooring - Wood, Kitchen Island, Stainless Steel Appliances
      • Level: First
      • Area: 552
      • Dimensions: 24 x 23
      Living room
      • Features: Flooring - Wood, Recessed Lighting
      • Level: First
      • Area: 255
      • Dimensions: 17 x 15
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Water Heater, Range, Dishwasher, Refrigerator
      • Laundry: Closet/Cabinets - Custom Built, Flooring - Stone/Ceramic Tile, First Floor, Electric Dryer Hookup
      Features
      • Lighting - Pendant, Bathroom - Full, Bathroom - Tiled With Shower Stall, Recessed Lighting, Entrance Foyer, Bathroom, Game Room, Media Room, Sauna/Steam/Hot Tub
      • Flooring: Wood, Tile, Vinyl / VCT, Marble, Flooring - Stone/Ceramic Tile, Flooring - Engineered Hardwood, Flooring - Wall to Wall Carpet
      • Basement: Full,Finished,Walk-Out Access
      • Number of fireplaces: 2
      • Fireplace features: Family Room
      Interior area
      • Total structure area: 10,200
      • Total interior livable area: 10,200 sqft
      • Finished area above ground: 8,036
      • Finished area below ground: 2,164

      Property

      Parking
      • Total spaces: 20
      • Parking features: Attached, Paved Drive, Off Street, Paved
      • Attached garage spaces: 4
      • Uncovered spaces: 16
      Features
      • Patio & porch: Porch, Patio
      • Exterior features: Porch, Patio, Pool - Inground, Cabana, Rain Gutters, Gazebo, Stone Wall
      • Has private pool: Yes
      • Pool features: In Ground
      Lot
      • Size: 8.5 Acres
      Details
      • Additional structures: Cabana, Gazebo
      • Parcel number: M:11F B:3644 L:2
      • Zoning: Z

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial,Contemporary
      • Property subtype: Single Family Residence
      Materials
      • Frame, Stone
      • Foundation: Concrete Perimeter
      • Roof: Shingle
      Condition
      • Year built: 2000

      Utilities & green energy

      • Electric: Circuit Breakers
      • Sewer: Private Sewer
      • Water: Public
      • Utilities for property: for Gas Range, for Electric Dryer
      Green energy
      • Energy efficient items: Thermostat

      Community & HOA

      Community
      • Features: Walk/Jog Trails, Conservation Area
      • Subdivision: ORNAC
      HOA
      • Has HOA: No
      Location
      • Region: Concord

      Financial & listing details

      • Price per square foot: $539/sqft
      • Tax assessed value: $4,883,200
      • Annual tax amount: $64,662
      • Date on market: 9/17/2025

        Estimated market value

        $5,232,100

        $4.97M - $5.49M

        $7,840/mo

        Price history

        DateEventPrice
        9/17/2025Listed for sale$5,498,000+83.3%$539/sqft
        Source: MLS PIN #73432257 Report a problem
        10/15/2021Sold$3,000,000-4.8%$294/sqft
        Source: MLS PIN #72776460 Report a problem
        8/25/2021Pending sale$3,150,000$309/sqft
        Source: MLS PIN #72776460 Report a problem
        8/11/2021Contingent$3,150,000$309/sqft
        Source: MLS PIN #72776460 Report a problem
        8/5/2021Listed for sale$3,150,000-6%$309/sqft
        Source: MLS PIN #72776460 Report a problem
        7/12/2021Listing removed--
        Source: MLS PIN #72776460 Report a problem
        7/8/2021Price change$3,350,000-10.7%$328/sqft
        Source: MLS PIN #72776460 Report a problem
        5/16/2021Price change$3,750,000-5.1%$368/sqft
        Source: MLS PIN #72776460 Report a problem
        1/19/2021Listed for sale$3,950,000+618.2%$387/sqft
        Source: MLS PIN #72776460 Report a problem
        1/13/2000Sold$550,000+9.5%$54/sqft
        Source: Public Record Report a problem
        1/27/1997Sold$502,500$49/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$57,551 +1%$4,340,200
        2024$56,987 +21%$4,340,200 +19.5%
        2023$47,084 +0.6%$3,633,000 +14.6%
        2022$46,792 -0.6%$3,170,200 -0.9%
        2021$47,075 +0.7%$3,198,000 -2.6%
        2020$46,743 +2.3%$3,284,800 +2%
        2019$45,697 +2.3%$3,220,400 +3%
        2018$44,681 -0.7%$3,126,700 -2.3%
        2017$45,016 -3.9%$3,199,400 -4.9%
        2016$46,845 $3,365,300

        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 01742

        Getting around

        8 / 100
        Car-Dependent
        7 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Willard
        • Middle: Cms
        • High: Cchs

        Source: MLS PIN. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel