Skip main navigation
Sold on 05/20/25
  • Price Unknown

    5112 Modesto Dr, Columbia, MO 65203

    5beds
    3,422sqft
    Single Family Residence
    Built in 2024
    8,638.8 Square Feet Lot
    $777,200 Zestimate®
    $--/sqft
    $-- Estimated rent

    Owner options

    List your home for rent

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    Refinance and save

    $500/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $500/mo

    Est. payment

    What's special

    Welcome to LEGACY FARMS!!!!! This brand new ANDERSON HOME features all of the custom finishes so many buyers have enjoyed for years. The open concept floorplan offers a custom kitchen w beautiful cabinets, quartz top, oversized island and a HUGE walk in pantry. Buyers will love the 5 spacious bedrooms and enjoy evenings on the covered concrete deck. With 3 levels of living there is plenty of room to spread out. Walking distant to John Warner and the new Elementary coming soon. Future amenities of Legacy include a pool, basketball courts, fishing pond and pickelball courts!! Come see what Legacy Farms is all about.

    Zillow last checked: 8 hours ago

    Listing updated: May 21, 2025 at 06:10am

    Listed by:

    Jen McCallister 573-999-3983,

    573 Realty, LLC 573-355-7159,

    Katie Wagner 573-355-7159,

    573 Realty, LLC

    Bought with:

    Erin Hendershott, 2016045114

    573 Realty, LLC

    Source: CBORMLS,MLS#: 422215MLS Logo

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Full bathroom
    • Level: Upper
    Full bathroom
    • Level: Upper
    Full bathroom
    • Level: Main
    Half bathroom
    • Level: Lower
    Heating
    • Forced Air, Natural Gas
    Cooling
    • Central Electric
    Appliances
    • Laundry: Washer/Dryer Hookup
    Features
    • Tub/Shower, Stand AloneShwr/MBR, Walk-In Closet(s), Bar, Wet Bar, Smart Thermostat, Eat-in Kitchen, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Pantry, Quartz Counters
    • Flooring: Wood, Carpet, Tile
    • Basement: Walk-Out Access
    • Has fireplace: Yes
    • Fireplace features: Family Room
    Interior area
    • Total structure area: 3,422
    • Total interior livable area: 3,422 sqft
    • Finished area below ground: 905

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached, Paved
    • Attached garage spaces: 2
    Features
    • Levels: 2 Story
    • Patio & porch: Concrete, Back, Covered, Deck, Front Porch
    Lot
    • Size: 8,638 sqft
    • Dimensions: 120 x 71.99
    • Features: Curbs and Gutters
    Details
    • Parcel number: 1680000120690001
    • Zoning description: R-S Single Family Residential

    Construction

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

    Utilities & green energy

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

    Community & neighborhood

    Location
    • Region: Columbia
    • Subdivision: Legacy Farms

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $500 annually

    Other

    Other facts
    • Road surface type: Paved