$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

Sale Details

Date Sold: June 5, 2025

$229 Per Sq Ft

34 Days on Market

Highlights

  • Community Lake
  • Traditional Architecture
  • Quartz Countertops
  • Mill Creek Elementary School Rated A
  • Main Floor Primary Bedroom
  • Covered Patio or Porch

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

  • 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
  • Kitchen Island
  • Quartz Countertops

Flooring

  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • 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

Community Details

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

Listing and Financial Details

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

Home Details

Home Type

Single Family

Year Built

Built in 2024

Lot Details

0 Sq Ft Lot

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: Traditional
  • Garage Yn: Yes
  • 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
  • Flooring:Tile: Yes
  • Exterior Finish:Stone Veneer: Yes
  • Dining:KitDin Combo: Yes
  • Flooring:Vinyl3: 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
  • Appliances: Microwave, Dishwasher, ENERGY STAR Qualified Appliances
  • 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:Island: Yes
  • Fireplace:In Living Room: 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
  • Direction Faces: West
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Covered, Rear Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Sprinkler-In Ground: Yes
  • Exterior Features:Windows-Vinyl: 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, 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: Pool, Clubhouse, 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

  • Zoning: Single Family Res
  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1680000120710001
  • Zoning Description: R-1 One- Family Dwelling*
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

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®

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

    179 Total Sales

    Brooke McCarty
    Section Image

  • E

    Buyer's Agent in 2025

    Erin Hendershott

    573 Realty, LLC

    (573) 355-4804

    198 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
Your Personal Tour Guide

Ask me questions while you tour the home.