2509 NEEDLE RUSH DR, COLUMBIA, MO 65203
$725,000
Property Type:
Residential
Bedrooms:
5
Baths:
3
Square Footage:
3,439
Status:
Closed
Current Price:
$725,000
List Date:
11/23/2024
Last Modified:
7/02/2025
Overview
Description
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!
Listing Details MLS# 423923
Location, Tax & Legal
- Area
- Southwest
- Street No #
- 2509
- Street
- NEEDLE RUSH
- Street Suffix
- DR
- County
- Boone
- State/Province
- MO
- Zip Code
- 65203
- Subdivision
- LEGACY FARMS
- Mapping ID #
- 1680000120340001
General Property Description
- Type
- Single Family Residence
- Attached/Detached
- Detached
- Primary Style
- Ranch
- # of Bedrooms
- 5
- Baths Full
- 3
- Total Bathrooms
- 3
- Garage Capacity
- 3
- Age Description
- Under Construction
- ExpDate/Complete(NC)
- 2025-05-31
- Lot Dimensions
- 130x83.87
- Sq Ft Source
- Listing Agent
- Appx Fin Sq Ft Main #
- 1883
- Appx Fin Sq Ft Lower #
- 1556
- Appx Fin Sq Ft Total #
- 3439
- Appx UnFin Sq Ft Lower #
- 415
- Appx UnFin Sq Ft Total #
- 415
- Builder Name
- River Oak Homes
- Year Built
- 2024
- # of Baths-Half
- 0
- Appx Fin Sq Ft Upper #
- 0
- Appx Fin Other Sq Ft #
- 0
- Basement
- Yes
- Appx UnFin Sq Ft Main #
- 0
- Appx UnFin Sq Ft Upper #
- 0
- Appx UnFin Other Sq Ft #
- 0
Status Change Info
- List Price/Sqft
- 210.82
- Sold Date
- 2025-05-23
- Under Contract Date
- 2025-04-21
- Status Change Date
- 2025-05-26
Property Disclosure
- Property Disclosure To Be Provided
- No
Columbia Pub Schools
- Elementary School 2025/2026
- Mill Creek
- Middle School 2025/2026
- John Warner
More Information
Rooms
- Full Bathroom Level
- Lower
- Full Bathroom
- Yes
Location Tax & Legal
- Zoning
- Single Family Res
- Actual Taxes $
- 0
- School District
- Columbia
- Elementary Sch
- Mill Creek
- Middle/Jr High Sch
- John Warner
- Senior Sch
- Rock Bridge
- HOA/Condo
- Yes
- HOA/Condo $
- 500
- HOA/Condo Descrip
- Annual
- HOA/Condo Init
- Yes
- HOA/Condo Init $
- 1000
- Condo Ext Maint
- None
- Legal Description
- LEGACY FARMS PLAT NO. 1 LOT 1004
- Auction
- No
- Land Lease
- No
- Land Lease Descrip
- N/A
- Located within City of Columbia
- Yes
Remarks & Misc
- Directions
- Sinclair to Needle Rush
Licensee Per/Int Dis
- Not Applicable
- Yes
Foundation Type
- Full Bsmt Part Fin
- Yes
Foundation Access
- Walkout
- Yes
Foundation Material
- Poured Concrete
- Yes
Appliances
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Range
- Yes
- Instant Hot Water
- Yes
- Tankless Water Heater
- Yes
Cooling
- Central Electric
- Yes
Heating
- Forced Air
- Yes
- Natural Gas
- Yes
Roof
- ArchitecturalShingle
- Yes
Exterior Finish
- Concrete Board/Fiber Cement
- Yes
- Stone Veneer
- Yes
Arch./Style
- Traditional
- Yes
Topo/Lot Description
- Level
- Yes
- Rolling
- Yes
Exterior Features
- Driveway-Paved
- Yes
- Windows-Vinyl
- Yes
Road Responsibility
- Public Maintained Road
- Yes
Road Surface Type
- Paved
- Yes
Possession
- At Closing
- Yes
Restriction/Easement
- Easements/RightofWay
- Yes
- Subdiv Restrictions
- Yes
- Unknown (Verify)
- Yes
Deck
- Back
- Yes
- Covered
- Yes
Dining
- Kit/Din Combo
- Yes
Community Features
- Lake
- Yes
Fireplace
- Electric
- Yes
- In Living Room
- Yes
Flooring
- Carpet
- Yes
- Laminate
- Yes
- Tile
- Yes
Zoning
- R-1 One- Family Dwelling*
- Yes
Interior/Features
- Bar
- Yes
- Bar-Wet Bar
- Yes
- Ceiling/PaddleFan(s)
- Yes
- Garage Dr Opener(s)
- Yes
- Laundry-Main Floor
- Yes
- Main Lvl Master Bdrm
- Yes
- Radon Mit Ready
- Yes
- Smoke Detector(s)
- Yes
- Tub/Shower
- Yes
- Walk in Closet(s)
- Yes
- Washer/DryerConnectn
- Yes
Kitchen/Features
- Counter-Quartz
- Yes
- Island
- Yes
- Pantry
- Yes
Patio
- Back
- Yes
- Covered
- Yes
Porch
- Covered
- Yes
- Front
- Yes
Baths Full-3/4
- Lower Level
- Yes
- Main Level
- 2
Property Features
Foundation Type:
Full Bsmt Part Fin
Cooling:
Central Electric
Deck:
Back; Covered
Dining:
Kit/Din Combo
Community Features:
Lake
Exterior Features:
Driveway-Paved; Windows-Vinyl
Exterior Finish:
Concrete Board/Fiber Cement; Stone Veneer
Fireplace:
Electric; In Living Room
Flooring:
Carpet; Laminate; Tile
Foundation Access:
Walkout
Foundation Material:
Poured Concrete
Heating:
Forced Air; Natural Gas
Appliances:
Dishwasher; Disposal; Gas Range; Instant Hot Water; Tankless Water Heater
Patio:
Back; Covered
Porch:
Covered; Front
Possession:
At Closing
Roof:
ArchitecturalShingle
Road Responsibility:
Public Maintained Road
Road Surface Type:
Paved
Rooms:
Full Bathroom
Zoning:
R-1 One- Family Dwelling*
Room Information
Full Bathroom
Level: Lower
Full Bathroom
Level: Main
Full Bathroom
Level: Main
Listing Office:
Weichert, Realtors - First Tier
Listing Agent:
Ryan Lidholm
Co Listing Agent: Travis Kempf
Last Updated: July - 02 - 2025
Information deemed reliable but not guaranteed.