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.
Sold on 08/18/25
Price Unknown
5012 Modesto Dr, Columbia, MO 65203
4beds
2,504sqft
Single Family Residence
Built in ----
6,960 Square Feet Lot
$565,600 Zestimate®
$--/sqft
$-- Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: August 18, 2025 at 01:24pm
Listed by:
Tyler Hill 573-356-9257,
Weichert, Realtors - House of Brokers 573-446-6767,
Jay Wilson 573-268-6949,
Weichert, Realtors - House of Brokers
Bought with:
Angie Olsen, 2019037224
Berkshire Hathaway Select
Source: CBORMLS,MLS#: 427167
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
- 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 basement: Yes
- 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
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 sqft
- 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 & neighborhood
Location
- Region: Columbia
- Subdivision: Legacy Farms
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Other
Other facts
- Road surface type: Paved