5100 MODESTO DR, COLUMBIA, MO 65203 (MLS# 426156)

5100 MODESTO DR, COLUMBIA, MO 65203

$585,000

Property Type: Residential Bedrooms: 4 Baths: 3 Square Footage: 2,557 Status: Closed

Current Price: $585,000 List Date: 4/04/2025 Last Modified: 2/24/2026

Overview

Description

Welcome to this stunning new construction walkout ranch in the highly sought-after Legacy Farms community! This home offers unbeatable value as one of the lowest-priced walkout in the entire subdivision—without compromising on quality or style. Step inside to find luxury vinyl plank flooring throughout, creating a seamless and modern look. The inviting living room fireplace adds warmth and charm, while the covered porch offers the perfect spot to relax and enjoy the peaceful views of the lush green space behind the home. Designed for both comfort and entertainment, the lower level features a wet bar, ideal for hosting guests. The primary suite is a private retreat, complete with a tiled shower, private toilet closet, and spacious walk-in closet.

Listing Details MLS# 426156

Location, Tax & Legal

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

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: Under Construction
ExpDate/Complete(NC): 2025-04-11
Lot Dimensions: 58 x 120
Sq Ft Source: Builders Plans
Appx Fin Sq Ft Main #: 1600
Appx Fin Sq Ft Lower #: 957
Appx Fin Sq Ft Total #: 2557
Basement: No
Builder Name: Timber Ridge
Year Built: 2024
House Faces: W
# of Baths-Half: 0
Appx Fin Sq Ft Upper #: 0
Appx Fin Other Sq Ft #: 0
Appx UnFin Sq Ft Main #: 0
Appx UnFin Sq Ft Lower #: 0
Appx UnFin Sq Ft Upper #: 0
Appx UnFin Other Sq Ft #: 0
Appx UnFin Sq Ft Total #: 0

Status Change Info

List Price/Sqft: 228.78
Sold Date: 2025-06-05
Under Contract Date: 2025-05-08
Status Change Date: 2025-06-06

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

Energy Audit

Energy Audit Completed: Yes
Energy Audit Year Completed: 2025

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 $: 100
Other Fees: NO
Condo Ext Maint: None
Legal Description: LEGACY FARMS PLAT NO. 1 LOT 1188
Auction: No
Land Lease: No
Land Lease Descrip: N/A
Located within City of Columbia: Yes

Remarks & Misc

Directions: West on Nifong, south on Sinclair, Right on Needle Rush Left on Modesto

Licensee Per/Int Dis

Not Applicable: Yes

Foundation Type

Slab: Yes

Foundation Access

Garage: Yes

Foundation Material

Poured Concrete: Yes

Appliances

Dishwasher: Yes
ENERGY STAR Qualified Appliances: Yes
Microwave: Yes

Cooling

Central Electric: Yes

Heating

Forced Air: Yes
High Efficiency Furnace: Yes
Natural Gas: Yes

Roof

Composition: Yes

Exterior Finish

Concrete Board/Fiber Cement: Yes
Stone Veneer: Yes

Arch./Style

Traditional: Yes

Exterior Features

Driveway-Paved: Yes
Windows-Vinyl: Yes

Possession

At Closing: Yes

Restriction/Easement

Recorded Plat: Yes
Subdiv Restrictions: Yes

Water Source

Public: Yes

Sewer

Public: Yes

Dining

Kit/Din Combo: Yes

Utilities

Electric-Boone County Electric: Yes
Trash-City: Yes

Community Features

Clubhouse: Yes
Lake: Yes
Pool: Yes

Fireplace

In Living Room: Yes

Flooring

Tile: Yes
Vinyl: Yes

Zoning

R-1 One- Family Dwelling*: Yes

Interior/Features

Ceiling/PaddleFan(s): Yes
Garage Dr Opener(s): Yes
High Spd Int Access: Yes
Home Warranty: Yes
Laundry-Main Floor: Yes
Main Lvl Master Bdrm: Yes
Radon Mit Ready: Yes
Smoke Detector(s): Yes
Split Bedroom Design: Yes
Stand AloneShwr/MBR: Yes
Walk in Closet(s): Yes
Washer/DryerConnectn: Yes

Kitchen/Features

Cabinets-Wood: Yes
Counter-Quartz: Yes
Island: Yes

Porch

Back: Yes
Covered: Yes

Property Features

Foundation Type: Slab Cooling: Central Electric Dining: Kit/Din Combo Community Features: Clubhouse; Lake; Pool Exterior Features: Driveway-Paved; Windows-Vinyl Exterior Finish: Concrete Board/Fiber Cement; Stone Veneer Fireplace: In Living Room Flooring: Tile; Vinyl Foundation Access: Garage Foundation Material: Poured Concrete Heating: Forced Air; High Efficiency Furnace; Natural Gas Appliances: Dishwasher; ENERGY STAR Qualified Appliances; Microwave Porch: Back; Covered Possession: At Closing Roof: Composition Rooms: Full Bathroom Water Source: Public Sewer: Public Utilities: Electric-Boone County Electric; Trash-City Zoning: R-1 One- Family Dwelling*

Room Information

Room Name	Level
Full Bathroom	Main
Full Bathroom	Main
Full Bathroom	Lower

Documents

Occupancy Disclosure ›

Listing Office: Weichert, Realtors - First Tier

Listing Agent: Jay Wilson

Co Listing Agent: Brooke McCarty

Last Updated: February - 24 - 2026

Information deemed reliable but not guaranteed.

5100 MODESTO DR, COLUMBIA, MO 65203 (MLS# 426156)