Discover modern elegance in this stunning new construction home, located in Columbia's sought-after Legacy Farms Subdivision. Perfectly positioned across from John Warner Middle School and the upcoming SW Elementary School, this home offers both convenience and charm. Step inside to find luxury vinyl plank flooring throughout, providing a sleek and low-maintenance finish. The open-concept living area is designed for effortless entertaining, featuring gorgeous wood beams, a cozy fireplace, and plenty of natural light. Unwind in the primary suite, complete with a tiled walk-in shower and an expansive walk-in closet. With high-end finishes and thoughtful design, this home is truly a must-see. Don't miss your chance to be part of this vibrant new community!
Sold on 11/14/25
Price Unknown
5029 Modesto Dr, Columbia, MO 65203
3beds
1,634sqft
Single Family Residence
Built in 2025
6,737.26 Square Feet Lot
$400,100 Zestimate®
$--/sqft
$-- Estimated rent
Owner options
What's special
Zillow last checked: 8 hours ago
Listing updated: November 14, 2025 at 12:14pm
Listed by:
Brooke Sydenstricker McCarty 573-268-4875,
Weichert, Realtors - House of Brokers 573-446-6767,
Jay Wilson 573-268-6949,
Weichert, Realtors - House of Brokers
Bought with:
Ryan Lidholm, 2016032760
Weichert, Realtors - House of Brokers
Source: CBORMLS,MLS#: 426062
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Heating
- Forced Air, Electric, Natural Gas
Cooling
- Central Electric
Appliances
- Laundry: Washer/Dryer Hookup
Features
- High Speed Internet, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Kit/Din Combo, Wood Cabinets, Kitchen Island, Quartz Counters
- Flooring: Tile, Vinyl
- Has basement: No
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 1,634
- Total interior livable area: 1,634 sqft
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Features
- Patio & porch: Concrete, Back, Deck
Lot
- Size: 6,737 sqft
- Dimensions: 64.80 x 103.97
- Features: Cleared, Curbs and Gutters
Details
- Parcel number: 1680000120630001
- Zoning description: R-1 One- Family Dwelling*
- Other equipment: Radon Mit Ready
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter, Slab
- Roof: ArchitecturalShingle
Condition
- Year built: 2025
Details
- Builder name: Timber Ridge
- Warranty included: Yes
Utilities & green energy
- Electric: County
- Gas: Gas-Natural
- Sewer: City
- Water: Public
- Utilities for property: Natural Gas Connected, Trash-City
Community & neighborhood
Location
- Region: Columbia
- Subdivision: Legacy Farms
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $500 annually