NOT LISTED FOR SALE

5012 Modesto Dr Columbia, MO 65203

Estimated Value: $580,000

4 Beds
3 Baths
2,504 Sq Ft
$232/Sq Ft Est. Value

Sale Details

Date Sold: August 18, 2025

61 Days on Market

Highlights

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

About This Home

As of August 2025

Welcome to 5012 Modesto in Legacy Farms! This stunning 4-bed, 3-bath home boasts 2,504 finished sqft, plus 1,156 sqft of unfinished space for ample storage. Enjoy quartz countertops, modern finishes, a walkout basement, Fireplace in the living room, and a covered back deck—all in the desirable Legacy Farms community, directly adjacent to John Warner Middle School with tons of planned amenities. This is your chance to own a beautiful home in one of the area's most sought-after neighborhoods.

Last Agent to Sell the Property

Tyler Hill

Weichert, Realtors - First Tier License #2021003481 Listed on: 05/16/2025

Co-Listed By

Jay Wilson

Weichert, Realtors - First Tier License #1999101567

Last Buyer's Agent

Angie Olsen

Berkshire Hathaway Select License #2019037224

Berkshire Hathaway Select

Home Details

Home Type

  • Single Family

Lot Details

  • Lot Dimensions are 58x120
  • Sprinkler System
  • Cleared Lot

HOA Fees

  • $42 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway

Home Design

  • Ranch Style House
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Stone Veneer

Interior Spaces

  • Wet Bar
  • Bar
  • Paddle Fans
  • Electric Fireplace
  • Living Room with Fireplace
  • Fire and Smoke Detector
  • Laundry on main level
  • Partially Finished Basement

Kitchen

  • Gas Range
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

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

Outdoor Features

  • Balcony
  • Covered Deck
  • 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 Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 16-800-00-12-078.00 01

Community Details

Overview

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

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Lot Details

0 Sq Ft Lot

HOA Fees

$42 per month

Parking

2

Listing Details

  • Directions: South on Sinclair right on Needle Rush Left on Modesto
  • Lot Size: 58X120
  • Prop. Type: Residential
  • Full Bathroom Level: Main
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 2
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters
  • Subdivision Name: LEGACY FARMS
  • Above Grade Finished Sq Ft: 1616.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Exterior Finish:Concrete BoardFiber Cement: Yes
  • Foundation Material:Poured Concrete: Yes
  • Deck:Back: Yes
  • Deck:Covered: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Electric-County: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Carpet: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Exterior Finish:Stone Veneer: Yes
  • TopoLot Description:Cleared: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Vinyl3: Yes
  • Patio:Covered3: Yes
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Vinyl
  • Interior Amenities: High Spd Int Access, Split Bedroom Design, Walk in Closet(s), Main Lvl Master Bdrm, Bar, Bar-Wet Bar, Cabinets-Custom Blt, Cabinets-Wood, Kitchen Island, Counter-Quartz
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 888.0
  • Fireplace Features: In Living Room
  • Fireplace: Yes
  • Living Area: 2504.0
  • InteriorFeatures:Cable Ready: Yes
  • 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
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Range-Gas: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • InteriorFeatures:Bar: Yes
  • Fireplace:Electric3: Yes

Exterior Features

  • Builder Name: Timber Ridge
  • Exterior Features: Balcony, Driveway-Paved
  • Roof: ArchitecturalShingle
  • Fencing: None
  • Lot Features: Sprinkler-In Ground, Cleared
  • Pool Features: Pool-Community
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Back, Covered, Deck
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Sprinkler-In Ground: Yes
  • Exterior Features:Community Lake: Yes
  • Exterior Features:Clubhouse-Community: Yes
  • Exterior Features:Pool-Community: Yes
  • Exterior Features:Balcony: 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, Cable Ready, Electric-County, Gas-Natural, Sewage-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, Community Lake
  • 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 #: 16-800-00-12-078.00 01
  • 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

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
08/18/2025 08/18/25 Sold -- -- --
07/16/2025 07/16/25 Pending -- -- --
05/16/2025 05/16/25 For Sale $580,000 -- $232 / Sq Ft
Source: Columbia Board of REALTORS®

Agents Affiliated with this Home

  • T

    Seller's Agent in 2025

    Tyler Hill

    Weichert, Realtors - First Tier

  • J

    Seller Co-Listing Agent in 2025

    Jay Wilson

    Weichert, Realtors - First Tier

  • Angie Olsen

    Buyer's Agent in 2025

    Angie Olsen

    Berkshire Hathaway Select

    (636) 459-4737

    52 Total Sales

    Angie Olsen
    Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 427167

Columbia Board of REALTORS®
Missouri Boone County Columbia 65203

5012 Modesto Dr, Columbia, MO

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.