5012 MODESTO DR, COLUMBIA, MO 65203 (MLS# 427167)

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

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

Property Features

Basement: Exterior Entry; Full; Partially Finished Cooling: Central Electric Crops: None Deck: Back; Covered Community Features: Clubhouse; Lake; Pool Exterior Features: Balcony Exterior Finish: Concrete Board/Fiber Cement; Stone Veneer Fireplace: Electric; In Living Room Flooring: Carpet; Vinyl Foundation Details: Poured Concrete Heating: Forced Air; Natural Gas Appliances: Dishwasher; Disposal; Gas Range Patio: Back; Covered Possession: At Closing Roof: Architectural Shingle Road Responsibility: Public Maintained Road Road Surface Type: Paved Lot Features: Full Sprinklers Rooms: Full Bathroom Water Source: Public Sewer: Public Utilities: Electric-Boone County Electric; Gas - Natural Parking Features: Driveway; Paved Zoning: R-1 One- Family Dwelling*

Room Information

Room Name Level
Full Bathroom Main
Full Bathroom Main
Full Bathroom 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.

Leave a Review