5104 MODESTO DR, COLUMBIA, MO 65203
New Listing
$625,000
Property Type:
Residential
Bedrooms:
4
Baths:
3
Square Footage:
2,386
Status:
Active
Current Price:
$625,000
List Date:
4/13/2026
Last Modified:
4/16/2026
Description
Welcome to this stunning better than new construction walkout ranch in the Legacy Farms community! This home offers unbeatable value as the lowest-priced walkouts 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. Legacy Farms amenities: pool, clubhouse, basketball courts!
Open Houses
Sunday, April 19, 1:00 pm - 2:30 pm
More Information MLS# 433839
General Property Description
# of Bedrooms Above Grade: 3
Attached/Detached: Detached
# of Baths-Half: 0
Primary Style: Ranch
Garage Capacity: 2
Sq Ft Source: Builders Plans
Age Description: 1 Dy-5 Yrs
Lot Dimensions: 58 x 120
Appx Fin Sq Ft Main #: 1601
Appx Fin Sq Ft Lower #: 785
Appx Fin Sq Ft Upper #: 0
Appx Fin Other Sq Ft #: 0
Basement: Yes
Appx UnFin Sq Ft Main #: 0
Appx UnFin Sq Ft Lower #: 816
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 #: 2386
Year Built: 2024
Location Tax & Legal
Zoning: Single Family Res
Actual Taxes $: 5664.82
Tax Yr: 2025
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: No
HOA/Condo Init $: 1000
Other Fees: NO
Condo Ext Maint: None
Legal Description: LEGACY FARMS PLAT NO. 1 LOT 1189
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: 261.94
Status: Active
Status Change Date: 2026-04-13
Licensee Per/Int Dis
Not Applicable: 1
Rooms
Full Bathroom: 1
Full Bathroom Level: Main
Property Disclosure
Property Disclosure To Be Provided: No
Foundation Type
Full Bsmt Part Fin: 1
Foundation Access
Walkout: 1
Foundation Material
Poured Concrete: 1
Appliances
Dishwasher: 1
Disposal: 1
ENERGY STAR Qualified Appliances: 1
Exhaust Fan: 1
Gas Range: 1
Microwave: 1
Cooling
Central Electric: 1
Heating
Forced Air: 1
High Efficiency Furnace: 1
Natural Gas: 1
Exterior Finish
Concrete Board/Fiber Cement: 1
Stone Veneer: 1
Arch./Style
Traditional: 1
Lot Features
Full Sprinklers: 1
Possession
At Closing: 1
Restriction/Easement
Recorded Plat: 1
Subdiv Restrictions: 1
Deck
Back: 1
Covered: 1
Water Source
Public: 1
Sewer
Public: 1
Dining
Kit/Din Combo: 1
Utilities
Electric-Boone County Electric: 1
Gas - Natural: 1
Trash-City: 1
Energy Audit
Energy Audit Completed: Yes
Energy Audit Year Completed: 2025
Road Responsibility
Public Maintained Road: 1
Community Features
Clubhouse: 1
Lake: 1
Pool: 1
Road Surface Type
Paved: 1
Exterior Features
Driveway-Paved: 1
Windows-Vinyl: 1
Fireplace
Electric: 1
In Living Room: 1
Flooring
Tile: 1
Vinyl: 1
Zoning
R-1 One- Family Dwelling*: 1
Interior/Features
Bar-Wet Bar: 1
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
Patio
Back: 1
Concrete: 1
Porch
Covered: 1
Front: 1
Contract Information
Current Price: $625,000
List Date: 2026-04-13
List Price: $625,000
Location, Tax & Legal
Area: Southwest
Street No #: 5104
Street: MODESTO
Street Suffix: DR
County: Boone
State/Province: MO
Zip Code: 65203
Subdivision: LEGACY FARMS
Mapping ID #: 1680000120710001
Property Features
Foundation Type: Full Bsmt Part Fin
Cooling: Central Electric
Deck: Back; Covered
Dining: Kit/Din Combo
Community Features: Clubhouse; Lake; Pool
Exterior Features: Driveway-Paved; Windows-Vinyl
Exterior Finish: Concrete Board/Fiber Cement; Stone Veneer
Fireplace: Electric; In Living Room
Flooring: Tile; Vinyl
Foundation Access: Walkout
Foundation Material: Poured Concrete
Heating: Forced Air; High Efficiency Furnace; Natural Gas
Appliances: Dishwasher; Disposal; ENERGY STAR Qualified Appliances; Exhaust Fan; Gas Range; Microwave
Patio: Back; Concrete
Porch: Covered; Front
Possession: At Closing
Road Responsibility: Public Maintained Road
Road Surface Type: Paved
Lot Features: Full Sprinklers
Rooms: Full Bathroom
Water Source: Public
Sewer: Public
Utilities: Electric-Boone County Electric; Gas - Natural; 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 - House of Brokers
Listing Agent:
Jay Wilson
Co Listing Agent: Brooke McCarty
Last Updated: April - 16 - 2026
Information deemed reliable but not guaranteed.