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: 1/06/2026

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.

More Information MLS# 426156

General Property Description

Attached/Detached: Detached # of Baths-Half: 0 Primary Style: Ranch Garage Capacity: 2 Sq Ft Source: Builders Plans Age Description: Under Construction ExpDate/Complete(NC): 2025-04-11 Lot Dimensions: 58 x 120 Appx Fin Sq Ft Main #: 1600 Appx Fin Sq Ft Lower #: 957 Appx Fin Sq Ft Upper #: 0 Appx Fin Other Sq Ft #: 0 Basement: No 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 Builder Name: Timber Ridge House Faces: W Type: Single Family Residence # of Bedrooms: 4 Baths Full: 3 Total Bathrooms: 3 Appx Fin Sq Ft Total #: 2557 Year Built: 2024

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

Status Change Info

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

Licensee Per/Int Dis

Not Applicable: 1

Columbia Pub Schools

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

Rooms

Full Bathroom: 1 Full Bathroom Level: Main

Property Disclosure

Property Disclosure To Be Provided: No

Foundation Type

Slab: 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

Recorded Plat: 1 Subdiv Restrictions: 1

Arch./Style

Traditional: 1

Dining

Kit/Din Combo: 1

Energy Audit

Energy Audit Completed: Yes Energy Audit Year Completed: 2025

Exterior Features

Clubhouse-Community: 1 Driveway-Paved: 1 Pool-Community: 1 Full Sprinklers: 1 Windows-Vinyl: 1

Roof

Composition: 1

Utilities

Electric-Boone County Electric: 1 Gas-Natural: 1 Sewage-City: 1 Trash-City: 1 Water-City: 1

Fireplace

In Living Room: 1

Zoning

R-1 One- Family Dwelling*: 1

Flooring

Tile: 1 Vinyl: 1

Interior/Features

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

Kitchen/Features

Cabinets-Wood: 1 Counter-Quartz: 1 Island: 1

Porch

Back: 1 Covered: 1

Contract Information

Current Price: $585,000 List Date: 2025-04-03 List Price: $585,000

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

Property Features

Foundation Type: Slab Cooling: Central Electric Dining: Kit/Din Combo Exterior Features: Clubhouse-Community; Driveway-Paved; Pool-Community; Windows-Vinyl Exterior Finish: Concrete Board/Fiber Cement; Stone Veneer Fireplace: In Living Room Flooring: Tile; Vinyl Foundation Access: Garage Foundation Material: Poured Concrete Porch: Back; Covered Possession: At Closing Roof: Composition Rooms: Full Bathroom Utilities: Electric-Boone County Electric; Gas-Natural; Sewage-City; Trash-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 - First Tier
Listing Agent: Jay Wilson
Co Listing Agent: Brooke McCarty
Last Updated: January - 06 - 2026
Information deemed reliable but not guaranteed.