Step into this stunning 1.5-story home, where a refreshing open-concept floor plan is beautifully complemented by elegant wood beams and luxurious finishes throughout.. The inviting living area boasts a cozy fireplace, floor-to-ceiling windows flooding the space with natural light and offering serene views of the outdoors.The well-appointed kitchen includes a large pantry perfect for all your storage needs & upgraded cafe appliances with double oven. Upstairs, discover a versatile flex room that can easily transform into a workout area, home office, in-law suite or additional living space—tailored to fit your lifestyle. Nestled in Columbia's brand-new Legacy Farms Subdivision, this home is located across from John Warner Middle School and the soon-to-be-completed SW Elementary School.
For sale
$539,900
5105 Modesto Dr, Columbia, MO 65203
4beds
2,350sqft
Est.:
Single Family Residence
Built in 2024
-- sqft lot
$-- Zestimate®
$230/sqft
$42/mo HOA
What's special
Cozy fireplaceVersatile flex roomAdditional living spaceOpen-concept floor planLuxurious finishesWell-appointed kitchenHome office
- 276 days
- on Zillow |
- 322 |
- 8 |
Zillow last checked: 7 hours ago
Listing updated: June 06, 2025 at 08:04am
Listed by:
Brooke Sydenstricker McCarty 573-268-4875,
Weichert, Realtors - First Tier 573-256-8601,
Jay Wilson 573-268-6949,
Weichert, Realtors - First Tier
Source: CBORMLS,MLS#: 422644

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: Upper
Heating
- High Efficiency Furnace, Forced Air, Natural Gas
Cooling
- Central Electric
Appliances
- Laundry: Washer/Dryer Hookup
Features
- Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Smart Thermostat, Kit/Din Combo, Wood Cabinets, Kitchen Island, Pantry, Quartz Counters
- Flooring: Carpet, Tile, Vinyl
- Has fireplace: Yes
- Fireplace features: Living Room, Gas
Interior area
- Total structure area: 2,350
- Total interior livable area: 2,350 sqft
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Attached, Paved
- Attached garage spaces: 2
Features
- Patio & porch: Concrete, Back, Covered
Lot
- Dimensions: 64.75 × 131.09
- Features: Level, Curbs and Gutters
Details
- Parcel number: 1680000120670001
- Zoning description: R-1 One- Family Dwelling*
- Other equipment: Radon Mit Ready
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter, Slab
- Roof: ArchitecturalShingle
Condition
- Year built: 2024
Details
- Builder name: Warren School Proper
- Warranty included: Yes
Utilities & green energy
- Electric: City
- Gas: Gas-Natural
- Sewer: City
- Water: Public
- Utilities for property: Natural Gas Connected, Trash-City
Community & HOA
Community
- Subdivision: Legacy Farms
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $230/sqft
- Date on market: 9/18/2024
- Road surface type: Paved
- Loading
- Loading