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.
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
$768,800 Zestimate®
$--/sqft
$-- Estimated rent
What's special
Zillow last checked: 7 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#: 422215

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Full bathroom
- Level: Upper
Full bathroom
- Level: Main
Half bathroom
- Level: Lower
Full bathroom
- Level: Upper
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