$610,000
$25K PRICE DROP

5037 Modesto Dr Columbia, MO 65203

Estimated payment $4,062/month

Total Views 6,532
5 Beds
2.5 Baths
2,966 Sq Ft
$206 Price per Sq Ft

Highlights

  • Quartz Countertops
  • Covered patio or porch
  • Walk-In Closet
  • Mill Creek Elementary School Rated A-
  • 2 Car Attached Garage
  • Bathtub with Shower

About This Home

This home is located at 5037 Modesto Dr, Columbia, MO 65203 and is currently priced at $610,000, approximately $205 per square foot. This property was built in 2024. 5037 Modesto Dr is a home located in Boone County with nearby schools including Mill Creek Elementary School, Ann Hawkins Gentry Middle School, and Rock Bridge High School.

Listing Agent

Jessica Spillman

Century 21 Community License #2016043997 Listed on: 03/22/2025

Century 21 Community

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2024

HOA Fees

  • $83 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Home Design

  • Concrete Foundation
  • Slab Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Stucco

Interior Spaces

  • 2,966 Sq Ft Home
  • 2-Story Property
  • Electric Fireplace
  • Living Room with Fireplace
  • Fire and Smoke Detector

Kitchen

  • Electric Cooktop
  • Quartz Countertops
  • Built-In or Custom Kitchen Cabinets
  • Disposal

Flooring

  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Bathroom on Main Level
  • Bathtub with Shower
  • Shower Only
  • Garden Bath

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
  • Municipal Utilities District Water

Community Details

  • $1,000 Initiation Fee
  • Built by Studio Spillman
  • Legacy Farms Subdivision

Listing and Financial Details

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

Home Details

Home Type

Single Family

Year Built

Built in 2024

Lot Details

0

HOA Fees

$83 per month

Parking

2

Listing Details

  • Directions: Take Sinclair road to Needle Rush, left on Modesto.
  • Lot Size: 64.77 × 131.60
  • Prop. Type: Residential
  • Full Bathroom Level: Upper
  • Half Bathroom Level: Main
  • Year Built: 2024
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Public Maintained
  • Subdivision Name: LEGACY FARMS
  • Above Grade Finished Sq Ft: 2966.0
  • Architectural Style: 2 Story
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Exterior Finish:Stucco: Yes
  • Foundation Material:Poured Concrete: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Electric-County: Yes
  • Utilities:Gas-Natural: Yes
  • Water District: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Flooring:Vinyl3: Yes
  • Patio:Covered3: Yes
  • Foundation Type:Slab: Yes
  • Special Features: NewHome

Interior Features

  • Flooring: Carpet, Tile, Vinyl
  • Interior Amenities: Tub/Shower, Stand AloneShwr/MBR, Tub-Garden, Walk in Closet(s), Home Warranty, Cabinets-Custom Blt, Counter-Quartz
  • Basement YN: No
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: In Living Room
  • Fireplace: Yes
  • Living Area: 2966.0
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Tub-Garden: Yes
  • InteriorFeatures:TubShower: Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • KitchenFeatures:Refrigerator: Yes
  • InteriorFeatures:Home Warranty: Yes
  • KitchenFeatures:Counter-Quartz: Yes
  • KitchenFeatures:Vent Fan: Yes
  • KitchenFeatures:Cooktop-Electric: Yes
  • Fireplace:Electric3: Yes

Exterior Features

  • Builder Name: Studio Spillman
  • Roof: ArchitecturalShingle
  • Foundation Details: Poured Concrete, Slab
  • Patio And Porch Features: Back, Covered

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

Utilities

  • Utilities: Water-District, Electric-County, Gas-Natural, Trash-Private
  • Cooling: Central Electric
  • Heating: Forced Air, Electric, Natural Gas
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association #2 Fee: 1000.0
  • Association Fee: 1000.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: Annual
  • Land Lease: No
  • Parcel #: 1680000120650001
  • Zoning Description: R-1 One- Family Dwelling*

Map

Range of Values:

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 Change Sq Ft Price
06/30/2025 06/30/25 Price Changed $610,000 -0.8% $206 / Sq Ft
06/02/2025 06/02/25 Price Changed $615,000 -1.6% $207 / Sq Ft
05/05/2025 05/05/25 Price Changed $625,000 -1.6% $211 / Sq Ft
03/22/2025 03/22/25 For Sale $635,000 -- $214 / Sq Ft
Source: Columbia Board of REALTORS®

Similar Homes in Columbia, MO

  • 613 Red Feather Ct, Columbia, MO 65203

    $650,000

    • 4 Beds
    • 2.5 Baths
    • 2,693 Sq Ft
    • 613 Red Feather Ct
    • Columbia, MO

    Impeccably maintained 1.5-story smart home in sought-after Breckenridge Park. The open layout, abundant natural light, custom solid walnut floating staircase, and wood floors create a grand, inviting feel. A chef's kitchen features a solid walnut island, custom cabinetry, upgraded appliances, and a large butler's pantry with versatile storage, prep space and ample outlets. Enjoy sunsets from the

    Beth Steele RE/MAX Boone Realty

    Section Image
  • 5109 Modesto Dr, Columbia, MO 65203

    $495,000

    • 3 Beds
    • 2 Baths
    • 1,898 Sq Ft
    • 5109 Modesto Dr
    • Columbia, MO

    Welcome to LEGACY FARMS!!!! This Anderson Homes beauty is sure to check so many boxes for every buyer. The open floor concept and the array of windows allows sunlight to come in from all directions. The designer kitchen comes w a HUGE island, custom cabinets, a HUGE pantry, a custom designed hood, quartz tops and premiere lighting finishes. Buyers will love the tall ceilings and custom

    Jen McCallister 573 Realty, LLC

    Section Image
  • 5105 Whisper Dr, Columbia, MO 65203

    $499,900

    • 3 Beds
    • 2 Baths
    • 1,888 Sq Ft
    • 5105 Whisper Dr
    • Columbia, MO

    Welcome to your dream home in Legacy Farms with a planned clubhouse, resort style pool, pickleball courts, basketball courts, pocket parks and more! This stunning 3-bedroom, 2-bathroom new construction home boasts modern elegance and comfort. Step inside to find beautiful laminate flooring throughout, complemented by sleek granite countertops and soft close doors/drawers in the kitchen. The cozy

    Ryan Lidholm Weichert, Realtors - House of Brokers

    Section Image
  • 5009 Whisper Dr, Columbia, MO 65202

    $600,000

    • 5 Beds
    • 3 Baths
    • 2,963 Sq Ft
    • 5009 Whisper Dr
    • Columbia, MO

    Welcome to 5009 Whisper Dr, a stunning new construction by Spillman Homes in Legacy Farms. Featuring 5 bedrooms, 3 baths, and a main-level office, this home offers a flexible layout with modern finishes and a private backyard.Enjoy fresh new exterior paint, and exciting neighborhood updates — a community pool is set to be completed this summer, and the clubhouse foundation is already

    Kaili Li Century 21 Community

    Section Image
  • 5101 Modesto Dr, Columbia, MO 65203

    $475,000

    • 3 Beds
    • 2 Baths
    • 1,912 Sq Ft
    • 5101 Modesto Dr
    • Columbia, MO

    Step into this stunning 3-bedroom, 2-bathroom home featuring a spacious 2-car garage and striking modern design elements throughout. With soaring 15-foot ceilings and an open layout, the home feels grand and inviting from the moment you enter.The primary suite offers a unique and stylish bathroom design—a tub within the shower, combining function and elegance in one sleek space. Every

    Kaili Li Century 21 Community

    Section Image
  • 2705 Misty Flower Dr, Columbia, MO 65203

    $509,900

    • 3 Beds
    • 2 Baths
    • 1,850 Sq Ft
    • 2705 Misty Flower Dr
    • Columbia, MO

    Experience elevated living in this beautifully crafted 2024-built home by River Oak Homes, located in the sought-after Legacy Farms subdivision. This 3-bedroom, 2-bathroom residence offers a perfect blend of modern luxury and timeless design. Step inside to find quartz countertops throughout, engineered hardwood laminate flooring, and plush carpeting in the bedrooms for added comfort. The

    Samuel Crane Berkshire Hathaway HomeServices | Vision Real Estate

    Section Image
  • 2016 Devonshire Dr, Columbia, MO 65203

    $660,000

    • 3 Beds
    • 2 Baths
    • 2,030 Sq Ft
    • 2016 Devonshire Dr
    • Columbia, MO

    This stunning home in Heritage Woods offers an idyllic retreat nestled on a serene cul-de-sac. Featuring 3 bedrooms on the main, and the potential to nearly double the finished square footage size, this home has everything you are searching for. The lower walk out level is framed, with a John Deere work room finished with additional washer/dryer and dog wash connections. Find refuge on your

    Claire Taylor Iron Gate Real Estate

    Section Image
  • 2905 Cromford Mill Dr, Columbia, MO 65203

    $548,900

    • 3 Beds
    • 2 Baths
    • 1,900 Sq Ft
    • 2905 Cromford Mill Dr
    • Columbia, MO

    Pool and clubhouse construction is underway—Legacy Farms is booming! This stunning home on a premier wooded lot offers luxury and comfort with an upgraded trim package, cozy fireplace, and laminate plank flooring. The gourmet kitchen boasts quartz countertops, an island, stainless steel appliances, and a gas range. Each bedroom features a walk-in closet, plus a 3rd car garage for extra storage.

    Travis Kempf Weichert, Realtors - House of Brokers

    Section Image
  • 3107 Crape Myrtle Dr, Columbia, MO 65203

    $549,900

    • 5 Beds
    • 3 Baths
    • 2,844 Sq Ft
    • 3107 Crape Myrtle Dr
    • Columbia, MO

    Take a look at this beautiful home in the desired Magnolia Falls subdivision.. This five bedroom, three bathroom has spacious floorplan spanning over 2800 square feet that includes a large yard, three car garage, screened in porch, and more. With the neighborhood pool and park a short walk away, this home is ready for you and your family to create precious memories. Schedule your tour today!

    Jordan Sayre Iron Gate Real Estate

    Section Image

Source: Columbia Board of REALTORS®

MLS Number: 425843

Columbia Board of REALTORS®