Skip main navigation
For sale
  • $419,900

    5029 Modesto Dr, Columbia, MO 65203

    3beds
    1,634sqft
    : 
    Single Family Residence
    Built in 2025
    6,737.26 Square Feet Lot
    $419,200 Zestimate®
    $257/sqft
    $42/mo HOA

    What's special

    Cozy fireplaceHigh-end finishesPrimary suiteTiled walk-in showerGorgeous wood beamsPlenty of natural lightThoughtful design
    Discover modern elegance in this stunning new construction home, located in Columbia's sought-after Legacy Farms Subdivision. Perfectly positioned across from John Warner Middle School and the upcoming SW Elementary School, this home offers both convenience and charm. Step inside to find luxury vinyl plank flooring throughout, providing a sleek and low-maintenance finish. The open-concept living area is designed for effortless entertaining, featuring gorgeous wood beams, a cozy fireplace, and plenty of natural light. Unwind in the primary suite, complete with a tiled walk-in shower and an expansive walk-in closet. With high-end finishes and thoughtful design, this home is truly a must-see. Don't miss your chance to be part of this vibrant new community!
    24 days
    on Zillow
    |
    439
    |
    15
    |

    Zillow last checked: 7 hours ago

    Listing updated: April 18, 2025 at 11:30pm

    Listed by:

    Brooke Sydenstricker McCarty 573-268-4875,

    Weichert, Realtors - First Tier 573-256-8601,

    Jay Wilson 573-268-6949,

    Weichert, Realtors - First Tier

    Source: CBORMLS,MLS#: 426062MLS Logo
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 5029 Modesto Dr.

    Next available tour time:Today at 5:30pm

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 2
    Full bathroom
    • Level: Main
    Full bathroom
    • Level: Main
    Heating
    • Forced Air, Electric, Natural Gas
    Cooling
    • Central Electric
    Appliances
    • Laundry: Main Level, Washer/Dryer Hookup
    Features
    • High Speed Internet, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Ceiling/PaddleFan(s), Kit/Din Combo, Wood Cabinets, Kitchen Island, Quartz Counters
    • Flooring: Tile, Vinyl
    • Windows: Vinyl Frames
    • Has fireplace: Yes
    • Fireplace features: Living Room
    Interior area
    • Total structure area: 1,634
    • Total interior livable area: 1,634 sqft
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached, Garage Door Opener
    • Attached garage spaces: 2
    Features
    • Patio & porch: Concrete, Back, Deck
    • Has private pool: Yes
    • Pool features: Community
    Lot
    • Size: 6,737.26 Square Feet
    • Dimensions: 64.80 x 103.97
    • Features: Cleared, Sprinkler-In Ground, Curbs and Gutters
    Details
    • Parcel number: 1680000120630001
    • Zoning description: R-1 One- Family Dwelling*
    • Other equipment: Radon Mit Ready

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Concrete Perimeter, Slab
    • Roof: ArchitecturalShingle
    Condition
    • Year built: 2025
    Details
    • Builder name: Timber Ridge
    • Warranty included: Yes

    Utilities & green energy

    • Electric: County
    • Gas: Gas-Natural
    • Sewer: City
    • Water: Public
    • Utilities for property: Natural Gas Connected, Trash-City

    Community & HOA

    Community
    • Features: Clubhouse
    • Security: Smoke Detector(s)
    • Subdivision: Legacy Farms
    HOA
    • Has HOA: Yes
    • HOA fee: $500 annually
    Location
    • Region: Columbia

    Financial & listing details

    • Price per square foot: $257/sqft
    • Tax assessed value: $50,000
    • Annual tax amount: $641
    • Date on market: 4/2/2025
    • Loading
    • Loading