NOT LISTED FOR SALE

5029 Modesto Dr Columbia, MO 65203

Columbia Area

Estimated Value: $415,000

3 Beds
2 Baths
1,634 Sq Ft
$254/Sq Ft Est. Value

Sale Details

Date Sold: November 14, 2025

201 Days on Market

Highlights

  • Clubhouse
  • Covered Deck
  • Quartz Countertops
  • Mill Creek Elementary School Rated A
  • Ranch Style House
  • Community Pool

About This Home

As of November 2025

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!

Last Agent to Sell the Property

Brooke McCarty

Weichert, Realtors - House of Brokers License #2003015126 Listed on: 04/02/2025

Co-Listed By

Jay Wilson

Weichert, Realtors - House of Brokers License #1999101567

Last Buyer's Agent

Ryan Lidholm

Weichert, Realtors - House of Brokers License #2016032760

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2025

Lot Details

  • Lot Dimensions are 64.80 x 103.97
  • East Facing Home
  • Sprinkler System
  • Cleared Lot

HOA Fees

  • $42 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Ranch Style House
  • Traditional Architecture
  • Concrete Foundation
  • Slab Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Radon Mitigation System
  • Stone Veneer

Interior Spaces

  • 1,634 Sq Ft Home
  • Paddle Fans
  • Electric Fireplace
  • Vinyl Clad Windows
  • Living Room with Fireplace
  • Combination Kitchen and Dining Room
  • Fire and Smoke Detector

Kitchen

  • Microwave
  • Dishwasher
  • ENERGY STAR Qualified Appliances
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Bathroom on Main Level
  • 2 Full Bathrooms
  • Bathtub with Shower
  • Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Outdoor Features

  • Covered Deck
  • Patio
  • Rear Porch

Schools

  • Mill Creek Elementary School
  • John Warner Middle School
  • Rock Bridge High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 1680000120630001

Community Details

Overview

  • $1,000 Initiation Fee
  • Built by Timber Ridge
  • Legacy Farms Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Year Built

Built in 2025

Lot Details

0 Sq Ft Lot

HOA Fees

$42 per month

Parking

2

Listing Details

  • Directions: Nifong to South on Sinclair to Havana to right on Darlington to right on Modesto.
  • Lot Size: 64.80 X 103.97
  • Prop. Type: Residential
  • Full Bathroom Level: Main
  • Year Built: 2025
  • BathsFull34MainLevel: 2
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Public Maintained, Curbs and Gutters
  • Subdivision Name: LEGACY FARMS
  • Above Grade Finished Sq Ft: 1634.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Exterior Finish:Concrete BoardFiber Cement: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • Deck:Covered: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Electric-County: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Exterior Finish:Stone Veneer: Yes
  • Dining:KitDin Combo: Yes
  • TopoLot Description:Cleared: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Vinyl3: Yes
  • Patio:Concrete2: Yes
  • Foundation Type:Slab: Yes
  • Special Features: NewHome

Interior Features

  • Flooring: Tile, Vinyl
  • Interior Amenities: High Spd Int Access, Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Radon Mit Ready, Home Warranty, Kit/Din Combo, Cabinets-Wood, Kitchen Island, Counter-Quartz
  • Basement YN: No
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: In Living Room
  • Fireplace: Yes
  • Living Area: 1634.0
  • Window Features: Windows-Vinyl
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Split Bedroom Design: Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:ENERGY STAR Qualified Appliances: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:Home Warranty: Yes
  • InteriorFeatures:Radon Mit Ready: Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • Fireplace:Electric3: Yes

Exterior Features

  • Builder Name: Timber Ridge
  • Roof: ArchitecturalShingle
  • Lot Features: Sprinkler-In Ground, Cleared
  • Pool Features: Pool-Community
  • Direction Faces: East
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Concrete, Back, Deck
  • Exterior Features:Sprinkler-In Ground: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Clubhouse-Community: Yes
  • Exterior Features:Pool-Community: Yes

Garage/Parking

  • Garage Spaces: 2.0
  • Parking Features: Garage Dr Opener(s), Attached
  • General Property Description:Garage Capacity: 2
  • InteriorFeatures:Garage Dr Opener(s): Yes
  • Foundation Access:Garage: Yes

Utilities

  • Utilities: Water-City, Electric-County, Gas-Natural, Sewage-City, Trash-City
  • Cooling: Central Electric, Ceiling/PaddleFan(s)
  • Heating: Forced Air, Electric, Natural Gas
  • Laundry Features: Laundry-Main Floor
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Community Features: Clubhouse-Community
  • Association #2 Fee: 1000.0
  • Association Fee: 500.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: Mill Creek
  • Junior High Dist: Columbia
  • High School: Rock Bridge
  • Middle Or Junior School: John Warner

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1680000120630001
  • Zoning Description: R-1 One- Family Dwelling*

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
11/14/2025 11/14/25 Sold -- -- --
10/20/2025 10/20/25 Pending -- -- --
09/26/2025 09/26/25 Price Changed $415,000 -1.2% $254 / Sq Ft
04/02/2025 04/02/25 For Sale $419,900 -- $257 / Sq Ft
Source: Columbia Board of REALTORS®

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 426062

Columbia Board of REALTORS®
Your Personal Tour Guide

Ask me questions while you tour the home.