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
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.
More Information MLS# 427167
General Property Description
Attached/Detached: Detached
# of Baths-Half: 0
Primary Style: Ranch
Garage Capacity: 2
Sq Ft Source: Appraiser
Age Description: New-Never Occupied
Lot Dimensions: 58X120
Appx Fin Sq Ft Main #: 1616
Appx Fin Sq Ft Lower #: 888
Appx Fin Sq Ft Upper #: 0
Appx Fin Other Sq Ft #: 0
Basement: Yes
Appx UnFin Sq Ft Main #: 434
Appx UnFin Sq Ft Lower #: 722
Appx UnFin Sq Ft Upper #: 0
Appx UnFin Other Sq Ft #: 0
Appx UnFin Sq Ft Total #: 1156
Builder Name: Timber Ridge
Type: Single Family Residence
# of Bedrooms: 4
Baths Full: 3
Total Bathrooms: 3
Appx Fin Sq Ft Total #: 2504
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
Remarks & Misc
Directions: South on Sinclair right on Needle Rush Left on Modesto
Status Change Info
List Price/Sqft: 231.63
Status: Closed
Sold Date: 2025-08-18
Under Contract Date: 2025-07-16
Status Change Date: 2025-08-18
Licensee Per/Int Dis
Not Applicable: 1
Columbia Pub Schools
Elementary School 2025/2026: Mill Creek
Middle School 2025/2026: John Warner
High School 2025/2026: Rock Bridge
Rooms
Full Bathroom: 1
Full Bathroom Level: Main
Property Disclosure
Property Disclosure To Be Provided: No
Foundation Type
Full Bsmt Part Fin: 1
Crops
None: 1
Cooling
Central Electric: 1
Exterior Finish
Concrete Board/Fiber Cement: 1
Stone Veneer: 1
Foundation Access
Garage: 1
Possession
At Closing: 1
Foundation Material
Poured Concrete: 1
Restriction/Easement
Easements/RightofWay: 1
Recorded Plat: 1
Subdiv Restrictions: 1
Deck
Back: 1
Covered: 1
Topo/Lot Description
Cleared: 1
Energy Audit
Energy Audit Completed: No
Exterior Features
Balcony: 1
Clubhouse-Community: 1
Driveway-Paved: 1
Pool-Community: 1
Full Sprinklers: 1
Roof
ArchitecturalShingle: 1
Utilities
Electric-Boone County Electric: 1
Gas-Natural: 1
Sewage-City: 1
Water-City: 1
Fireplace
Electric: 1
In Living Room: 1
Zoning
R-1 One- Family Dwelling*: 1
Flooring
Carpet: 1
Vinyl: 1
Interior/Features
Bar: 1
Bar-Wet Bar: 1
Cable Ready: 1
Ceiling/PaddleFan(s): 1
Garage Dr Opener(s): 1
High Spd Int Access: 1
Laundry-Main Floor: 1
Main Lvl Master Bdrm: 1
Smoke Detector(s): 1
Split Bedroom Design: 1
Walk in Closet(s): 1
Kitchen/Features
Cabinets-Custom Blt: 1
Cabinets-Wood: 1
Counter-Quartz: 1
Island: 1
Patio
Back: 1
Covered: 1
Baths Full-3/4
Lower Level: 1
Main Level: 2
Contract Information
Current Price: $580,000
List Date: 2025-05-16
List Price: $580,000
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
Property Features
Foundation Type: Full Bsmt Part Fin
Cooling: Central Electric
Crops: None
Deck: Back; Covered
Exterior Features: Balcony; Clubhouse-Community; Driveway-Paved; Pool-Community
Exterior Finish: Concrete Board/Fiber Cement; Stone Veneer
Fireplace: Electric; In Living Room
Flooring: Carpet; Vinyl
Foundation Access: Garage
Foundation Material: Poured Concrete
Patio: Back; Covered
Possession: At Closing
Roof: ArchitecturalShingle
Rooms: Full Bathroom
Utilities: Electric-Boone County Electric; Gas-Natural; Sewage-City; Water-City
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.