Welcome to this stunning new construction walkout ranch in the highly sought-after 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 are set to be top tier
For sale
$579,900
5104 Modesto Dr, Columbia, MO 65203
4beds
2,386sqft
Est.:
Single Family Residence
Built in 2024
6,960 Square Feet Lot
$578,500 Zestimate®
$243/sqft
$42/mo HOA
What's special
Covered porchPrimary suiteWet barTiled showerPrivate toilet closetSpacious walk-in closet
- 21 days
- on Zillow |
- 457 |
- 12 |
Zillow last checked: 7 hours ago
Listing updated: April 12, 2025 at 11:14am
Listed by:
Jay Wilson 573-268-6949,
Weichert, Realtors - First Tier 573-256-8601,
Brooke Sydenstricker McCarty 573-268-4875,
Weichert, Realtors - First Tier
Source: CBORMLS,MLS#: 426165

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: Main
Full bathroom
- Level: Lower
Heating
- High Efficiency Furnace, Forced Air, Electric, Natural Gas
Cooling
- Central Electric
Appliances
- Laundry: Main Level, Washer/Dryer Hookup
Features
- High Speed Internet, Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Ceiling/PaddleFan(s), Kit/Din Combo, Wood Cabinets, Kitchen Island, Quartz Counters
- Flooring: Tile, Vinyl
- Windows: Vinyl Frames
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 2,386
- Total interior livable area: 2,386 sqft
- Finished area below ground: 785
Property
Parking
- Total spaces: 2
- Parking features: Attached, Paved, Garage Door Opener
- Attached garage spaces: 2
Features
- Patio & porch: Deck
- Has private pool: Yes
- Pool features: Community
Lot
- Size: 6,960 Square Feet
- Dimensions: 58 x 120
- Features: Sprinkler-In Ground, Curbs and Gutters
Details
- Parcel number: 1680000120710001
- 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
- Roof: Composition
Condition
- Year built: 2024
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 & HOA
Community
- Features: Clubhouse, Lake
- Security: Smoke Detector(s)
- Subdivision: Legacy Farms
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $243/sqft
- Date on market: 4/4/2025
- Loading
- Loading