Welcome to LEGACY FARMS!!!!! This brand new ANDERSON HOME features all of the custom finishes so many buyers have enjoyed for years. The open concept floorplan offers a custom kitchen w beautiful cabinets, quartz top, oversized island and a HUGE walk in pantry. Buyers will love the 5 spacious bedrooms and enjoy evenings on the covered concrete deck. With 3 levels of living there is plenty of room to spread out. Walking distant to John Warner and the new Elementary coming soon. Future amenities of Legacy include a pool, basketball courts, fishing pond and pickelball courts!! Come see what Legacy Farms is all about.
Sold
Price Unknown
5112 Modesto Dr, Columbia, MO 65203
5beds
3,422sqft
Single Family Residence
Built in 2024
8,638 Square Feet Lot
$779,600 Zestimate®
$--/sqft
$3,778 Estimated rent
Home value
$779,600
$717,000 - $850,000
$3,778/mo
Zestimate® history
Owner options
List your home for rent
$3,778/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,778/mo
Rent Zestimate®
Refinance and save
$500/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$500/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Fishing pondQuartz topBasketball courtsCustom kitchenHuge walk in pantryOversized islandBeautiful cabinets
Zillow last checked:
Listing updated:
Listed by:
Jen McCallister 573-999-3983,
573 Realty, LLC 573-355-7159,
Katie Wagner 573-355-7159,
573 Realty, LLC
Bought with:
Erin Hendershott, 2016045114
573 Realty, LLC
Source: MMBOR,MLS#: 422215
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Full bathroom
- Level: Upper
Full bathroom
- Level: Upper
Full bathroom
- Level: Main
Half bathroom
- Level: Lower
Heating
- Forced Air, Natural Gas
Cooling
- Central Electric
Appliances
- Laundry: Washer/Dryer Hookup
Features
- Tub/Shower, Stand AloneShwr/MBR, Walk-In Closet(s), Bar, Wet Bar, Smart Thermostat, Eat-in Kitchen, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Pantry, Quartz Counters
- Flooring: Wood, Carpet, Tile
- Basement: Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Family Room
Interior area
- Total structure area: 3,422
- Total interior livable area: 3,422 sqft
- Finished area below ground: 905
Property
Parking
- Total spaces: 2
- Parking features: Attached, Paved
- Attached garage spaces: 2
Features
- Levels: 2 Story
- Patio & porch: Concrete, Back, Covered, Deck, Front Porch
Lot
- Size: 8,638 Square Feet
- Dimensions: 120 x 71.99
- Features: Curbs and Gutters
Details
- Parcel number: 1680000120690001
- Zoning description: R-S Single Family Residential
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Condition
- Year built: 2024
Details
- Builder name: Anderson
- Warranty included: Yes
Utilities & green energy
- Electric: City
- Gas: Gas-Natural
- Sewer: City
- Water: Public
- Utilities for property: Natural Gas Connected, Trash-City
Community & HOA
Community
- Subdivision: Legacy Farms
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Location
- Region: Columbia
Financial & listing details
- Date on market: 8/27/2024
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 5/20/2025 | Sold | -- |
Source:  MMBOR #422215 Report a problem | ||
| 4/5/2025 | Pending sale | $765,000$224/sqft |
Source: MMBOR #422215 Report a problem | ||
| 8/27/2024 | Listed for sale | $765,000$224/sqft |
Source: MMBOR #422215 Report a problem | ||
Public tax history
Tax history is unavailable.
Neighborhood: 65203
Nearby homes
- $--5 bd4 ba3.6k sqft4800 Whisper Ct, Columbia, MO 65203Sold
- $--5 bd5 ba3.4k sqft4812 Whisper Ct, Columbia, MO 65203Sold
- $--5 bd3 ba3.3k sqft4808 Whisper Ct, Columbia, MO 65203Sold
- $835,0004 bd3 ba3.1k sqft4801 Whisper Ct, Columbia, MO 65203For Sale
- $609,5003 bd3 ba2.1k sqft4805 Whisper Ct, Columbia, MO 65203For Sale
- $536,0003 bd2 ba3.2k sqft2620 W Mill Creek Ct, Columbia, MO 65203Off Market
- $28,500-- sqftMuirfield Dr, Columbia, MO 65203Off Market
- $--3 bd3 ba1.8k sqft2013 Muirfield Dr, Columbia, MO 65203Sold
Nearby schools
GreatSchools rating
- 10/10Mill Creek Elementary SchoolGrades: PK-5Distance: 0.5 mi
- 10/10JOHN WARNER MIDDLE SCHOOLGrades: 6-8Distance: 0.8 mi
- 9/10Rock Bridge Senior High SchoolGrades: 9-12Distance: 2 mi
Schools provided by the listing agent
- Elementary: Mill Creek
- Middle: John Warner
- High: Rock Bridge
Source: MMBOR. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$779,600
2% more
+$15,592
With Zillow Showcase(estimated)
$795,192
Sell for more on Zillow
Get a Zillow Showcase℠ listing at no additional cost and you could sell for .
$779,600
2% more
+$15,592
With Zillow Showcase(estimated)
$795,192
- Missouri
- Boone County
- Columbia
- 65203
- 5112 Modesto Dr
