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 5-bedroom, 3-bathroom walkout basement home boasts modern elegance and comfort. Step inside to find beautiful laminate flooring throughout, complemented by sleek quartz countertops and soft close doors/drawers in the kitchen. The cozy stone fireplace adds warmth and charm, while under-cabinet lighting in the kitchen and the fireplace shelves enhances the homes functionality and style. Outdoors, enjoy a luxurious covered deck perfect for entertaining with serene privacy backing to trees. This home is the perfect blend of luxury with so many upgrades including a tankless hot water heater and irrigation system!
Sold on 05/23/25
Price Unknown
2509 Needle Rush Dr, Columbia, MO 65203
5beds
3,439sqft
Single Family Residence
Built in 2024
0.25 Acres Lot
$728,000 Zestimate®
$--/sqft
$-- Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: July 02, 2025 at 07:23am
Listed by:
Ryan Lidholm 573-673-2842,
Weichert, Realtors - First Tier 573-256-8601,
Travis Kempf 573-424-2556,
Weichert, Realtors - First Tier
Bought with:
Ryan Lidholm, 2016032760
Weichert, Realtors - First Tier
Source: CBORMLS,MLS#: 423923

Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
- Full bathrooms: 3
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, Walk-In Closet(s), Bar, Wet Bar, Kit/Din Combo, Kitchen Island, Pantry, Quartz Counters
- Flooring: Carpet, Laminate, Tile
- Has fireplace: Yes
- Fireplace features: Living Room
Interior area
- Total structure area: 3,439
- Total interior livable area: 3,439 sqft
- Finished area below ground: 1,556
Property
Parking
- Total spaces: 3
- Parking features: Attached, Paved
- Attached garage spaces: 3
Features
- Patio & porch: Back, Covered, Deck, Front Porch
Lot
- Size: 0.25 Acres
- Dimensions: 130 x 83.87
- Features: Level, Rolling Slope, Curbs and Gutters
Details
- Parcel number: 1680000120340001
- 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: 2024
Details
- Builder name: River Oak Homes
Community & neighborhood
Location
- Region: Columbia
- Subdivision: Legacy Farms
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $500 annually
Other
Other facts
- Road surface type: Paved