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