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 fireplace surround. The large primary suite and bath are the perfect place to unwind after a long day!! Enjoy the covered patio and all of the amenities that Legacy Farms provides. Schools include Mill Creek, JW and RBHS. Take a look today.
For sale
$495,000
5109 Modesto Dr, Columbia, MO 65203
3beds
1,898sqft
Est.:
Single Family Residence
Built in 2024
10,101.22 Square Feet Lot
$494,900 Zestimate®
$261/sqft
$42/mo HOA
What's special
- 15 days
- on Zillow |
- 337 |
- 16 |
Zillow last checked: 7 hours ago
Listing updated: April 13, 2025 at 07:27am
Listed by:
Jen McCallister 573-999-3983,
573 Realty, LLC 573-355-7159,
Katie Wagner 573-355-7159,
573 Realty, LLC
Source: CBORMLS,MLS#: 426312

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Heating
- Forced Air
Cooling
- Central Electric
Appliances
- Laundry: Main Level, Washer/Dryer Hookup
Features
- Tub/Shower, Stand AloneShwr/MBR, Split Bedroom Design, Walk-In Closet(s), Ceiling/PaddleFan(s), Smart Thermostat, Eat-in Kitchen, Cabinets-Custom Blt, Wood Cabinets, Kitchen Island, Pantry, Quartz Counters
- Flooring: Wood, Carpet, Tile
- Windows: Vinyl Frames
- Has fireplace: Yes
- Fireplace features: Family Room
Interior area
- Total structure area: 1,898
- Total interior livable area: 1,898 sqft
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Attached, Garage Faces Side, Paved, Garage Door Opener
- Attached garage spaces: 2
Features
- Patio & porch: Concrete, Back, Covered, Front Porch
Lot
- Size: 10,101.22 Square Feet
- Dimensions: 78.45 x 128.76
- Features: Sprinkler-In Ground, Curbs and Gutters
Details
- Parcel number: 1680000120680001
- Zoning description: R-S Single Family Residential
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter, Slab
- 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, Cable Connected
Community & HOA
Community
- Security: Smoke Detector(s)
- Subdivision: Legacy Farms
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $261/sqft
- Date on market: 4/10/2025
- Road surface type: Paved
- Loading
- Loading