$585,000
SOLD JUN 5, 2025
Last list price

5100 Modesto Dr Columbia, MO 65203

4 Beds
3 Baths
2,557 Sq Ft
2024 Built

Recently Sold

$229 Per Sq Ft

34 Days on Market

Highlights

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

About This Home

As of June 2025

Welcome to this stunning new construction walkout ranch in the highly sought-after Legacy Farms community! This home offers unbeatable value as one of the lowest-priced walkout 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.

Last Agent to Sell the Property

Jay Wilson

Weichert, Realtors - First Tier License #1999101567 Listed on: 04/04/2025

Co-Listed By

Brooke McCarty

Weichert, Realtors - House of Brokers License #2003015126

Last Buyer's Agent

Erin Hendershott

573 Realty, LLC License #2016045114

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2024

Lot Details

  • Lot Dimensions are 58 x 120
  • West Facing Home
  • Sprinkler System

HOA Fees

  • $42 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

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

Interior Spaces

  • Paddle Fans
  • 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

Flooring

  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Bathroom on Main Level
  • 3 Full Bathrooms
  • Shower Only

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Outdoor Features

  • Covered Patio or 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-Efficiency Furnace
  • High Speed Internet

Listing and Financial Details

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

Community Details

Overview

  • $100 Initiation Fee
  • Built by Timber Ridge
  • Legacy Farms Subdivision
  • Community Lake

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Year Built

Built in 2024

Lot Details

0

HOA Fees

$42 per month

Parking

2

Listing Details

  • Directions: West on Nifong, south on Sinclair, Right on Needle Rush Left on Modesto
  • Lot Size: 58 x 120
  • Prop. Type: Residential
  • Full Bathroom Level: Main
  • Year Built: 2024
  • Property Sub Type: Single Family Residence
  • Co List Office Phone: 573-256-8601
  • Subdivision Name: LEGACY FARMS
  • Above Grade Finished Sq Ft: 1600.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
  • Utilities:Electric-County: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Exterior Finish:Stone Veneer: Yes
  • Dining:KitDin Combo: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Vinyl3: Yes
  • Heat Type:High Efficiency Furnace: Yes
  • Porch:Covered2: Yes
  • Foundation Type:Slab: Yes
  • Porch:Back2: Yes
  • Roof:Composition: Yes
  • Special Features: NewHome

Interior Features

  • Flooring: Tile, Vinyl
  • Interior Amenities: High Spd Int Access, 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: 3
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 957.0
  • Fireplace Features: In Living Room
  • Fireplace: Yes
  • Living Area: 2557.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:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: 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

Exterior Features

  • Builder Name: Timber Ridge
  • Exterior Features: Driveway-Paved
  • Roof: Composition
  • Lot Features: Sprinkler-In Ground
  • Pool Features: Pool-Community
  • Direction Faces: West
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Rear Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Sprinkler-In Ground: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Community Lake: 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: High Efficiency Furnace, Forced Air, 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, Community Lake
  • Association #2 Fee: 100.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 #: 1680000120710001
  • Zoning Description: R-1 One- Family Dwelling*

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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 Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/05/2025 06/05/25 Sold -- -- --
05/08/2025 05/08/25 Pending -- -- --
04/04/2025 04/04/25 Price Changed $585,000 +0.9% $229 / Sq Ft
04/04/2025 04/04/25 For Sale $579,900 -- $227 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History Compared to Growth

Source: Public Records

Agents Affiliated with this Home

  • J

    Seller's Agent in 2025

    Jay Wilson

    Weichert, Realtors - First Tier

  • Brooke McCarty

    Seller Co-Listing Agent in 2025

    Brooke McCarty

    Weichert, Realtors - House of Brokers

    (573) 256-8601

    174 Total Sales

    Brooke McCarty
    Section Image

  • E

    Buyer's Agent in 2025

    Erin Hendershott

    573 Realty, LLC

    (573) 355-4804

    194 Total Sales

    Erin Hendershott
    Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 426156

Columbia Board of REALTORS®
Missouri Boone County Columbia 65203

5100 Modesto Dr, Columbia, MO

Sold

Detached

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Columbia Board of REALTORS® IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes