Welcome to 5012 Modesto in Legacy Farms! This stunning 4-bed, 3-bath home boasts 2,504 finished sqft, plus 1,156 sqft of unfinished space for ample storage. Enjoy quartz countertops, modern finishes, a walkout basement, Fireplace in the living room, and a covered back deck—all in the desirable Legacy Farms community, directly adjacent to John Warner Middle School with tons of planned amenities. This is your chance to own a beautiful home in one of the area's most sought-after neighborhoods.
For sale
$580,000
5012 Modesto Dr, Columbia, MO 65203
4beds
2,504sqft
Est.:
Single Family Residence
Built in ----
6,960 Square Feet Lot
$569,200 Zestimate®
$232/sqft
$42/mo HOA
What's special
- 32 days
- on Zillow |
- 509 |
- 11 |
Zillow last checked: 7 hours ago
Listing updated: June 01, 2025 at 11:32pm
Listed by:
Tyler Hill 573-256-8601,
Weichert, Realtors - First Tier 573-256-8601,
Jay Wilson 573-268-6949,
Weichert, Realtors - First Tier
Source: CBORMLS,MLS#: 427167

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Full bathroom
- Level: Main
Full bathroom
- Level: Lower
Full bathroom
- Level: Main
Heating
- Forced Air, Electric, Natural Gas
Cooling
- Central Electric
Features
- High Speed Internet, Split Bedroom Design, Walk-In Closet(s), Bar, Wet Bar, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Quartz Counters
- Flooring: Carpet, Vinyl
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 2,504
- Total interior livable area: 2,504 sqft
- Finished area below ground: 888
Video & virtual tour
Property
Parking
- Total spaces: 2
- Parking features: Attached, Paved
- Attached garage spaces: 2
Features
- Patio & porch: Back, Covered, Deck
- Exterior features: Balcony
- Fencing: None
Lot
- Size: 6,960 Square Feet
- Dimensions: 58 x 120
- Features: Cleared, Curbs and Gutters
Details
- Parcel number: 168000012078.00 01
- Zoning description: R-1 One- Family Dwelling*
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Details
- Builder name: Timber Ridge
Utilities & green energy
- Electric: County
- Gas: Gas-Natural
- Sewer: City
- Water: Public
- Utilities for property: Natural Gas Connected
Community & HOA
Community
- Subdivision: Legacy Farms
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $232/sqft
- Date on market: 5/16/2025
- Road surface type: Paved
- Loading
- Loading