Skip main navigation
For sale
  • $585,000

    5100 Modesto Dr, Columbia, MO 65203

    4beds
    2,557sqft
    : 
    Single Family Residence
    Built in 2024
    6,960 Square Feet Lot
    $583,800 Zestimate®
    $229/sqft
    $42/mo HOA

    What's special

    Covered porchPrimary suiteLush green spaceWet barTiled showerPrivate toilet closetSpacious walk-in closet
    Welcome to this stunning new construction walkout ranch in the highly sought-after Legacy Farms community! This home offers unbeatable value as one of the lowest-priced walkout in the entire subdivision—without compromising on quality or style. Step inside to find luxury vinyl plank flooring throughout, creating a seamless and modern look. The inviting living room fireplace adds warmth and charm, while the covered porch offers the perfect spot to relax and enjoy the peaceful views of the lush green space behind the home. Designed for both comfort and entertainment, the lower level features a wet bar, ideal for hosting guests. The primary suite is a private retreat, complete with a tiled shower, private toilet closet, and spacious walk-in closet.
    22 days
    on Zillow
    |
    425
    |
    26
    |

    Zillow last checked: 7 hours ago

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

    Listed by:

    Jay Wilson 573-268-6949,

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

    Brooke Sydenstricker McCarty 573-268-4875,

    Weichert, Realtors - First Tier

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

    Tour with a buyer’s agent

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

    Next available tour time:Today at 5:30pm

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 3
    Full bathroom
    • Level: Main
    Full bathroom
    • Level: Main
    Full bathroom
    • Level: Lower
    Heating
    • High Efficiency Furnace, Forced Air, Natural Gas
    Cooling
    • Central Electric
    Appliances
    • Laundry: Main Level, Washer/Dryer Hookup
    Features
    • High Speed Internet, 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: 2,557
    • Total interior livable area: 2,557 sqft
    • Finished area below ground: 957

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached, Paved, Garage Door Opener
    • Attached garage spaces: 2
    Features
    • Patio & porch: Rear Porch
    • Has private pool: Yes
    • Pool features: Community
    Lot
    • Size: 6,960 Square Feet
    • Dimensions: 58 x 120
    • Features: Sprinkler-In Ground
    Details
    • Parcel number: 1680000120710001
    • 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: Composition
    Condition
    • Year built: 2024
    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, Lake
    • 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: $229/sqft
    • Date on market: 4/4/2025
    • Loading
    • Loading