5112 MODESTO DR, COLUMBIA, MO 65203 (MLS# 422215)

5112 MODESTO DR, COLUMBIA, MO 65203

$765,000
Property Type: Residential Bedrooms: 5 Baths: 4 Square Footage: 3,422 Status: Closed
Current Price: $765,000 List Date: 8/27/2024 Last Modified: 5/21/2025

Overview

Description

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.

Listing Details MLS# 422215

Location, Tax & Legal

Area
Southwest
Street No #
5112
Street
MODESTO
Street Suffix
DR
County
Boone
State/Province
MO
Zip Code
65203
Subdivision
LEGACY FARMS
Mapping ID #
1680000120690001

General Property Description

Type
Single Family Residence
Attached/Detached
Detached
Primary Style
2 Story
# of Bedrooms
5
Baths Full
3
# of Baths-Half
Yes
Total Bathrooms
4
Garage Capacity
2
Age Description
New-Never Occupied
ExpDate/Complete(NC)
2024-06-01
Lot Dimensions
120 x 71.99
Sq Ft Source
Builders Plans
Appx Fin Sq Ft Main #
1292
Appx Fin Sq Ft Lower #
905
Appx Fin Sq Ft Upper #
1225
Appx Fin Sq Ft Total #
3422
Appx UnFin Sq Ft Lower #
500
Appx UnFin Sq Ft Total #
500
Builder Name
Anderson
Year Built
2024
Appx Fin Other Sq Ft #
0
Basement
Yes
Appx UnFin Sq Ft Main #
0
Appx UnFin Sq Ft Upper #
0
Appx UnFin Other Sq Ft #
0

Status Change Info

List Price/Sqft
223.55
Sold Date
2025-05-20
Under Contract Date
2025-04-04
Status Change Date
2025-05-21

Property Disclosure

Property Disclosure To Be Provided
No

Columbia Pub Schools

Elementary School 2025/2026
Mill Creek
Middle School 2025/2026
John Warner

More Information

Rooms

Full Bathroom Level
Upper
Half Bathroom Level
Lower
Full Bathroom
Yes
Half Bathroom
Yes

Baths-Half

Lower Level
Yes
Total
Yes

Location Tax & Legal

Zoning
Single Family Res
Actual Taxes $
0
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 1186
Auction
No
Land Lease
No
Land Lease Descrip
N/A
Located within City of Columbia
Yes

Remarks & Misc

Directions
Nifong to Sinclair to Needle Rush to Modesto Drive (do not use GPS) *THERE ARE NO STREET SIGNS*

Licensee Per/Int Dis

Not Applicable
Yes

Foundation Type

Full Bsmt Full Fin
Yes
Walkout Basement
Yes

Foundation Access

Walkout
Yes

Foundation Material

Poured Concrete
Yes

Appliances

Dishwasher
Yes
Disposal
Yes
ENERGY STAR Qualified Appliances
Yes
Microwave
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
Wood
Yes

Arch./Style

Traditional
Yes

Exterior Features

Driveway-Paved
Yes
Windows-Vinyl
Yes

Road Responsibility

Public Maintained Road
Yes

Road Surface Type

Paved
Yes

Possession

At Closing
Yes

Restriction/Easement

Recorded Plat
Yes
Subdiv Restrictions
Yes

Deck

Back
Yes
Covered
Yes

Water Source

Public
Yes

Sewer

Public
Yes

Dining

Eat-In Kitchen
Yes

Utilities

Electric-City of Columbia
Yes
Trash-City
Yes

Fireplace

In Family Room
Yes

Flooring

Carpet
Yes
Tile
Yes
Wood
Yes

Zoning

R-S Single Family Residential
Yes

Interior/Features

Bar
Yes
Bar-Wet Bar
Yes
Cable Ready
Yes
Ceiling/PaddleFan(s)
Yes
Garage Dr Opener(s)
Yes
Home Warranty
Yes
Laundry-Main Floor
Yes
Programmable Thermostat(s)
Yes
Smoke Detector(s)
Yes
Stand AloneShwr/MBR
Yes
Tub/Shower
Yes
Walk in Closet(s)
Yes
Washer/DryerConnectn
Yes

Kitchen/Features

Cabinets-Custom Blt
Yes
Cabinets-Wood
Yes
Counter-Quartz
Yes
Island
Yes
Pantry
Yes

Patio

Back
Yes
Concrete
Yes
Covered
Yes

Porch

Covered
Yes
Front
Yes

Baths Full-3/4

Main Level
Yes
Upper Level
2
Total
3

Property Features

Foundation Type: Full Bsmt Full Fin; Walkout Basement Cooling: Central Electric Deck: Back; Covered Dining: Eat-In Kitchen Exterior Features: Driveway-Paved; Windows-Vinyl Exterior Finish: Concrete Board/Fiber Cement; Stone Veneer; Wood Fireplace: In Family Room Flooring: Carpet; Tile; Wood Foundation Access: Walkout Foundation Material: Poured Concrete Heating: Forced Air; Natural Gas Appliances: Dishwasher; Disposal; ENERGY STAR Qualified Appliances; Microwave Patio: Back; Concrete; Covered Porch: Covered; Front Possession: At Closing Roof: ArchitecturalShingle Road Responsibility: Public Maintained Road Road Surface Type: Paved Rooms: Full Bathroom; Half Bathroom Water Source: Public Sewer: Public Utilities: Electric-City of Columbia; Trash-City Zoning: R-S Single Family Residential

Room Information

Full Bathroom Level: Upper Full Bathroom Level: Upper Full Bathroom Level: Main Half Bathroom Level: Lower
Listing Office: 573 Realty, LLC
Listing Agent: Jen McCallister
Co Listing Agent: Katie Wagner
Last Updated: May - 21 - 2025
Information deemed reliable but not guaranteed.

Leave a Review