5104 MODESTO DR, COLUMBIA, MO 65203 (MLS# 433839)

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

Overview

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

Tomorrow, 1:00 pm - 2:30 pm

Listing Details MLS# 433839

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

General Property Description

Type: Single Family Residence
Attached/Detached: Detached
Primary Style: Ranch
# of Bedrooms: 4
# of Bedrooms Above Grade: 3
Baths Full: 3
Total Bathrooms: 3
Garage Capacity: 2
Age Description: 1 Dy-5 Yrs
Lot Dimensions: 58 x 120
Sq Ft Source: Builders Plans
Appx Fin Sq Ft Main #: 1601
Appx Fin Sq Ft Lower #: 785
Appx Fin Sq Ft Total #: 2386
Appx UnFin Sq Ft Lower #: 816
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
Basement: Yes
Appx UnFin Sq Ft Main #: 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: 261.94
Status Change Date: 2026-04-13

Property Disclosure

Property Disclosure To Be Provided: No

Energy Audit

Energy Audit Completed: Yes
Energy Audit Year Completed: 2025

More Information

Rooms

Full Bathroom Level: Main
Full Bathroom: Yes

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

Licensee Per/Int Dis

Not Applicable: Yes

Foundation Type

Full Bsmt Part Fin: Yes

Foundation Access

Walkout: Yes

Foundation Material

Poured Concrete: Yes

Appliances

Dishwasher: Yes
Disposal: Yes
ENERGY STAR Qualified Appliances: Yes
Exhaust Fan: Yes
Gas Range: Yes
Microwave: Yes

Cooling

Central Electric: Yes

Heating

Forced Air: Yes
High Efficiency Furnace: Yes
Natural Gas: Yes

Exterior Finish

Concrete Board/Fiber Cement: Yes
Stone Veneer: Yes

Arch./Style

Traditional: Yes

Lot Features

Full Sprinklers: Yes

Possession

At Closing: Yes

Restriction/Easement

Recorded Plat: Yes
Subdiv Restrictions: Yes

Deck

Back: Yes
Covered: Yes

Water Source

Public: Yes

Sewer

Public: Yes

Dining

Kit/Din Combo: Yes

Utilities

Electric-Boone County Electric: Yes
Gas - Natural: Yes
Trash-City: Yes

Road Responsibility

Public Maintained Road: Yes

Community Features

Clubhouse: Yes
Lake: Yes
Pool: Yes

Road Surface Type

Paved: Yes

Exterior Features

Driveway-Paved: Yes
Windows-Vinyl: Yes

Fireplace

Electric: Yes
In Living Room: Yes

Flooring

Tile: Yes
Vinyl: Yes

Zoning

R-1 One- Family Dwelling*: Yes

Interior/Features

Bar-Wet Bar: Yes
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

Patio

Back: Yes
Concrete: Yes

Porch

Covered: Yes
Front: Yes

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

Room Name	Level
Full Bathroom	Main
Full Bathroom	Main
Full Bathroom	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.

Property Info