Skip main navigation
For sale
  • $539,900

    5105 Modesto Dr, Columbia, MO 65203

    4beds
    2,350sqft
    : 
    Single Family Residence
    Built in 2024
    -- sqft lot
    $-- Zestimate®
    $230/sqft
    $42/mo HOA

    What's special

    Cozy fireplaceVersatile flex roomAdditional living spaceOpen-concept floor planLuxurious finishesWell-appointed kitchenHome office
    Step into this stunning 1.5-story home, where a refreshing open-concept floor plan is beautifully complemented by elegant wood beams and luxurious finishes throughout.. The inviting living area boasts a cozy fireplace, floor-to-ceiling windows flooding the space with natural light and offering serene views of the outdoors.The well-appointed kitchen includes a large pantry perfect for all your storage needs & upgraded cafe appliances with double oven. Upstairs, discover a versatile flex room that can easily transform into a workout area, home office, in-law suite or additional living space—tailored to fit your lifestyle. Nestled in Columbia's brand-new Legacy Farms Subdivision, this home is located across from John Warner Middle School and the soon-to-be-completed SW Elementary School.
    276 days
    on Zillow
    |
    322
    |
    8
    |

    Zillow last checked: 7 hours ago

    Listing updated: June 06, 2025 at 08:04am

    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#: 422644MLS Logo
    Travel times

    Tour with a buyer’s agent

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

    Next available tour time:Today at 11am

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 3
    • Full bathrooms: 3
    Full bathroom
    • Level: Main
    Full bathroom
    • Level: Main
    Full bathroom
    • Level: Upper
    Heating
    • High Efficiency Furnace, Forced Air, Natural Gas
    Cooling
    • Central Electric
    Appliances
    • Laundry: Washer/Dryer Hookup
    Features
    • Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Smart Thermostat, Kit/Din Combo, Wood Cabinets, Kitchen Island, Pantry, Quartz Counters
    • Flooring: Carpet, Tile, Vinyl
    • Has fireplace: Yes
    • Fireplace features: Living Room, Gas
    Interior area
    • Total structure area: 2,350
    • Total interior livable area: 2,350 sqft
    • Finished area below ground: 0

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached, Paved
    • Attached garage spaces: 2
    Features
    • Patio & porch: Concrete, Back, Covered
    Lot
    • Dimensions: 64.75 × 131.09
    • Features: Level, Curbs and Gutters
    Details
    • Parcel number: 1680000120670001
    • Zoning description: R-1 One- Family Dwelling*
    • Other equipment: Radon Mit Ready

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Concrete Perimeter, Slab
    • Roof: ArchitecturalShingle
    Condition
    • Year built: 2024
    Details
    • Builder name: Warren School Proper
    • Warranty included: Yes

    Utilities & green energy

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

    Community & HOA

    Community
    • Subdivision: Legacy Farms
    HOA
    • Has HOA: Yes
    • HOA fee: $500 annually
    Location
    • Region: Columbia

    Financial & listing details

    • Price per square foot: $230/sqft
    • Date on market: 9/18/2024
    • Road surface type: Paved
    • Loading
    • Loading