5012 MODESTO DR, COLUMBIA, MO 65203
$580,000
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
2,504
Status:
Closed
Current Price:
$580,000
List Date:
5/16/2025
Last Modified:
8/20/2025
Overview
Description
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.
Listing Details MLS# 427167
Location, Tax & Legal
- Area
- Southwest
- Street No #
- 5012
- Street
- MODESTO
- Street Suffix
- DR
- County
- Boone
- State/Province
- MO
- Zip Code
- 65203
- Subdivision
- LEGACY FARMS
- Mapping ID #
- 16-800-00-12-078.00 01
General Property Description
- Type
- Single Family Residence
- Attached/Detached
- Detached
- Primary Style
- Ranch
- # of Bedrooms
- 4
- Baths Full
- 3
- Total Bathrooms
- 3
- Garage Capacity
- 2
- Age Description
- New-Never Occupied
- Lot Dimensions
- 58X120
- Sq Ft Source
- Appraiser
- Appx Fin Sq Ft Main #
- 1616
- Appx Fin Sq Ft Lower #
- 888
- Appx Fin Sq Ft Total #
- 2504
- Appx UnFin Sq Ft Main #
- 434
- Appx UnFin Sq Ft Lower #
- 722
- Appx UnFin Sq Ft Total #
- 1156
- Builder Name
- Timber Ridge
- # of Baths-Half
- 0
- Appx Fin Sq Ft Upper #
- 0
- Appx Fin Other Sq Ft #
- 0
- Basement
- Yes
- Appx UnFin Sq Ft Upper #
- 0
- Appx UnFin Other Sq Ft #
- 0
Status Change Info
- List Price/Sqft
- 231.63
- Sold Date
- 2025-08-18
- Under Contract Date
- 2025-07-16
- Status Change Date
- 2025-08-18
Property Disclosure
- Property Disclosure To Be Provided
- No
Columbia Pub Schools
- Elementary School 2025/2026
- Mill Creek
- Middle School 2025/2026
- John Warner
- High School 2025/2026
- Rock Bridge
More Information
Energy Audit
- Energy Audit Completed
- No
Rooms
- Full Bathroom Level
- Main
- Full Bathroom
- Yes
Location Tax & Legal
- Zoning
- Single Family Res
- School District
- Columbia
- Elementary Sch
- Mill Creek
- Middle/Jr High Sch
- John Warner
- Senior Sch
- Rock Bridge
- HOA/Condo
- Yes
- HOA/Condo $
- 500
- HOA/Condo Descrip
- Annual
- HOA/Condo Init
- Yes
- HOA/Condo Init $
- 1000
- Condo Ext Maint
- None
- Legal Description
- LEGACY FARMS PLAT NO. 1 LOT 1195
- Auction
- No
- Land Lease
- No
- Land Lease Descrip
- N/A
- Located within City of Columbia
- Yes
Remarks & Misc
- Directions
- South on Sinclair right on Needle Rush Left on Modesto
Licensee Per/Int Dis
- Not Applicable
- Yes
Foundation Type
- Full Bsmt Part Fin
- Yes
Foundation Access
- Garage
- Yes
Crops
- None
- Yes
Foundation Material
- Poured Concrete
- Yes
Appliances
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Range
- Yes
Cooling
- Central Electric
- Yes
Heating
- Forced Air
- Yes
- Natural Gas
- Yes
Roof
- ArchitecturalShingle
- Yes
Exterior Finish
- Concrete Board/Fiber Cement
- Yes
- Stone Veneer
- Yes
Topo/Lot Description
- Cleared
- Yes
Exterior Features
- Balcony
- Yes
- Driveway-Paved
- Yes
Road Responsibility
- Public Maintained Road
- Yes
Road Surface Type
- Paved
- Yes
Possession
- At Closing
- Yes
Restriction/Easement
- Easements/RightofWay
- Yes
- Recorded Plat
- Yes
- Subdiv Restrictions
- Yes
Deck
- Back
- Yes
- Covered
- Yes
Water Source
- Public
- Yes
Sewer
- Public
- Yes
Utilities
- Electric-Boone County Electric
- Yes
Community Features
- Clubhouse
- Yes
- Lake
- Yes
- Pool
- Yes
Fireplace
- Electric
- Yes
- In Living Room
- Yes
Flooring
- Carpet
- Yes
- Vinyl
- Yes
Zoning
- R-1 One- Family Dwelling*
- Yes
Interior/Features
- Bar
- Yes
- Bar-Wet Bar
- Yes
- Cable Ready
- Yes
- Ceiling/PaddleFan(s)
- Yes
- Garage Dr Opener(s)
- Yes
- High Spd Int Access
- Yes
- Laundry-Main Floor
- Yes
- Main Lvl Master Bdrm
- Yes
- Smoke Detector(s)
- Yes
- Split Bedroom Design
- Yes
- Walk in Closet(s)
- Yes
Kitchen/Features
- Cabinets-Custom Blt
- Yes
- Cabinets-Wood
- Yes
- Counter-Quartz
- Yes
- Island
- Yes
Patio
- Back
- Yes
- Covered
- Yes
Baths Full-3/4
- Lower Level
- Yes
- Main Level
- 2
Property Features
Foundation Type:
Full Bsmt Part Fin
Cooling:
Central Electric
Crops:
None
Deck:
Back; Covered
Community Features:
Clubhouse; Lake; Pool
Exterior Features:
Balcony; Driveway-Paved
Exterior Finish:
Concrete Board/Fiber Cement; Stone Veneer
Fireplace:
Electric; In Living Room
Flooring:
Carpet; Vinyl
Foundation Access:
Garage
Foundation Material:
Poured Concrete
Heating:
Forced Air; Natural Gas
Appliances:
Dishwasher; Disposal; Gas Range
Patio:
Back; Covered
Possession:
At Closing
Roof:
ArchitecturalShingle
Road Responsibility:
Public Maintained Road
Road Surface Type:
Paved
Rooms:
Full Bathroom
Water Source:
Public
Sewer:
Public
Utilities:
Electric-Boone County Electric
Zoning:
R-1 One- Family Dwelling*
Room Information
Full Bathroom
Level: Main
Full Bathroom
Level: Main
Full Bathroom
Level: Lower
Listing Office:
Weichert, Realtors - House of Brokers
Listing Agent:
Tyler Hill
Co Listing Agent: Jay Wilson
Last Updated: August - 20 - 2025
Information deemed reliable but not guaranteed.