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
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
Foundation Access
Garage: 1
Foundation Material
Poured Concrete: 1
Appliances
Dishwasher: 1
ENERGY STAR Qualified Appliances: 1
Microwave: 1
Cooling
Central Electric: 1
Heating
Forced Air: 1
High Efficiency Furnace: 1
Natural Gas: 1
Roof
Composition: 1
Exterior Finish
Concrete Board/Fiber Cement: 1
Stone Veneer: 1
Arch./Style
Traditional: 1
Exterior Features
Full Sprinklers: 1
Driveway-Paved: 1
Windows-Vinyl: 1
Possession
At Closing: 1
Restriction/Easement
Recorded Plat: 1
Subdiv Restrictions: 1
Water Source
Public: 1
Sewer
Public: 1
Dining
Kit/Din Combo: 1
Utilities
Electric-Boone County Electric: 1
Trash-City: 1
Energy Audit
Energy Audit Completed: Yes
Energy Audit Year Completed: 2025
Community Features
Clubhouse: 1
Lake: 1
Pool: 1
Fireplace
In Living Room: 1
Flooring
Tile: 1
Vinyl: 1
Zoning
R-1 One- Family Dwelling*: 1
Interior/Features
Ceiling/PaddleFan(s): 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
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
Water Source: Public
Sewer: Public
Appliances: Dishwasher; ENERGY STAR Qualified Appliances; Microwave
Porch: Back; Covered
Possession: At Closing
Roof: Composition
Rooms: Full Bathroom
Utilities: Electric-Boone County Electric; Trash-City
Zoning: R-1 One- Family Dwelling*
Room Information
Full Bathroom
Level: Main
Full Bathroom
Level: Main
Full Bathroom
Level: 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.