Skip main navigation
For sale
  • $580,000

    5012 Modesto Dr, Columbia, MO 65203

    4beds
    2,504sqft
    : 
    Single Family Residence
    Built in ----
    6,960 Square Feet Lot
    $569,200 Zestimate®
    $232/sqft
    $42/mo HOA

    What's special

    Welcome to 5012 Modesto in Legacy Farms! This stunning 4-bed, 3-bath home boasts 2,504 finished sqft, plus 1,156 sqft of unfinished space for ample storage. Enjoy quartz countertops, modern finishes, a walkout basement, Fireplace in the living room, and a covered back deck—all in the desirable Legacy Farms community, directly adjacent to John Warner Middle School with tons of planned amenities. This is your chance to own a beautiful home in one of the area's most sought-after neighborhoods.
    32 days
    on Zillow
    |
    509
    |
    11
    |

    Zillow last checked: 7 hours ago

    Listing updated: June 01, 2025 at 11:32pm

    Listed by:

    Tyler Hill 573-256-8601,

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

    Jay Wilson 573-268-6949,

    Weichert, Realtors - First Tier

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

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 5012 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: Lower
    Full bathroom
    • Level: Main
    Heating
    • Forced Air, Electric, Natural Gas
    Cooling
    • Central Electric
    Features
    • High Speed Internet, Split Bedroom Design, Walk-In Closet(s), Bar, Wet Bar, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Quartz Counters
    • Flooring: Carpet, Vinyl
    • Has fireplace: Yes
    • Fireplace features: Living Room
    Interior area
    • Total structure area: 2,504
    • Total interior livable area: 2,504 sqft
    • Finished area below ground: 888
    Video & virtual tour

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached, Paved
    • Attached garage spaces: 2
    Features
    • Patio & porch: Back, Covered, Deck
    • Exterior features: Balcony
    • Fencing: None
    Lot
    • Size: 6,960 Square Feet
    • Dimensions: 58 x 120
    • Features: Cleared, Curbs and Gutters
    Details
    • Parcel number: 168000012078.00 01
    • Zoning description: R-1 One- Family Dwelling*

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Ranch
    • Property subtype: Single Family Residence
    Materials
    • Foundation: Concrete Perimeter
    • Roof: ArchitecturalShingle
    Details
    • Builder name: Timber Ridge

    Utilities & green energy

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

    Community & HOA

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

    Financial & listing details

    • Price per square foot: $232/sqft
    • Date on market: 5/16/2025
    • Road surface type: Paved
    • Loading
    • Loading