Welcome to this stunning new construction home, perfectly designed for modern living & entertaining in Legacy Farms subdivision. This spacious residence features 5 bedrooms and 3 full baths, offering ample space for family & guests. The beautiful wooded backyard provides a serene retreat, complete w/ screened-in deck perfect for outdoor gatherings.
The heart of the home is the expansive kitchen, which boasts modern appliances, elegant countertops, and a generous pantry for all your culinary needs. The luxurious master suite is a true sanctuary, featuring a grand master bedroom and a spa-like master bath for ultimate relaxation.
The finished basement is a standout feature, complete with a large bar ideal for hosting, and two spacious bedrooms.
For sale
Price cut: $2K (8/5)
$817,000
2829 Misty Flower Dr, Columbia, MO 65203
5beds
3,699sqft
Est.:
Single Family Residence
Built in 2025
-- sqft lot
$810,800 Zestimate®
$221/sqft
$42/mo HOA
What's special
Finished basementBeautiful wooded backyardScreened-in deckModern appliancesLuxurious master suiteGrand master bedroomSpa-like master bath
- 22 days
- on Zillow |
- 407 |
- 20 |
Likely to sell faster than
Zillow last checked: 7 hours ago
Listing updated: August 24, 2025 at 11:31pm
Listed by:
Piper Graves 573-999-4392,
Weichert, Realtors - House of Brokers 573-446-6767
Source: CBORMLS,MLS#: 428991

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Level: Main
Bedroom 2
- Level: Main
Bedroom 3
- Level: Main
Bedroom 4
- Level: Lower
Bedroom 5
- Level: Lower
Full bathroom
- Level: Lower
Full bathroom
- Level: Main
Full bathroom
- Level: Main
Heating
- Forced Air, Electric, Natural Gas
Cooling
- Central Electric
Appliances
- Laundry: Washer/Dryer Hookup
Features
- Tub/Shower, Stand AloneShwr/MBR, Tub-2+Person, Walk-In Closet(s), Bar, Wet Bar, Wired for Data, Smart Thermostat, Kit/Din Combo, Cabinets-Custom Blt, Wood Cabinets, Pantry, Quartz Counters
- Flooring: Carpet, Tile, Vinyl
- Has basement: Yes
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 3,699
- Total interior livable area: 3,699 sqft
- Finished area below ground: 1,521
Property
Parking
- Total spaces: 3
- Parking features: Attached, Paved
- Attached garage spaces: 3
Features
- Patio & porch: Concrete, Back, Covered, Deck
Lot
- Dimensions: 104.44 × 223.62
- Features: Curbs and Gutters
- Residential vegetation: Partially Wooded
Details
- Parcel number: 2020000200230001
- Zoning description: R-1 One- Family Dwelling*
- Other equipment: Radon Mit Ready
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Condition
- Year built: 2025
Details
- Builder name: John Jones
- Warranty included: Yes
Utilities & green energy
- Electric: County
- 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
- Price per square foot: $221/sqft
- Annual tax amount: $640
- Date on market: 8/5/2025
- Road surface type: Paved
- Loading
- Loading