Nestled across from John Warner Middle School and the SW Elementary School, this beautifully crafted home offers the perfect blend of modern luxury and classic charm.Step inside to luxury vinyl plank flooring throughout, combining elegance with durability. The open-concept living space is highlighted by gorgeous wood beams and a cozy fireplace, creating a warm and inviting atmosphere. The kitchen and living areas flow seamlessly into a covered back patio. The primary suite is a true retreat, featuring a tiled walk-in shower and a spacious walk-in closet. Every detail of this home has been thoughtfully designed for both style and functionality. Clubhouse, pool, pickleball, tennis, basketball courts & soccer fields will all be available for your use soon.
For sale
$419,900
5033 Modesto Dr, Columbia, MO 65203
3beds
1,713sqft
Est.:
Single Family Residence
Built in 2025
8,525.05 Square Feet Lot
$419,300 Zestimate®
$245/sqft
$42/mo HOA
What's special
Cozy fireplaceOpen-concept living spacePrimary suiteTiled walk-in showerGorgeous wood beamsCovered back patioSpacious walk-in closet
- 23 days
- on Zillow |
- 735 |
- 28 |
Zillow last checked: 7 hours ago
Listing updated: April 18, 2025 at 11:31pm
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#: 426099

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Heating
- Forced Air, Natural Gas
Cooling
- Central Electric
Appliances
- Laundry: Main Level, Washer/Dryer Hookup
Features
- High Speed Internet, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Kit/Din Combo, Wood Cabinets, Quartz Counters
- Flooring: Tile, Vinyl
- Windows: Vinyl Frames
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 1,713
- Total interior livable area: 1,713 sqft
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage Door Opener
- Attached garage spaces: 2
Features
- Patio & porch: Concrete, Back, Rear Porch
- Has private pool: Yes
- Pool features: Community
Lot
- Size: 8,525.05 Square Feet
- Dimensions: 64.78 x 131.60
- Features: Cleared, Curbs and Gutters
Details
- Parcel number: 1680000120640001
- 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 & HOA
Community
- Features: Clubhouse
- 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: $245/sqft
- Tax assessed value: $50,000
- Annual tax amount: $641
- Date on market: 4/3/2025
- Loading
- Loading