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
Documents
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.