9290 W TERRAPIN HILLS RD RD, COLUMBIA, MO 65203
$1,490,000
Property Type:
Residential
Bedrooms:
5
Baths:
5
Square Footage:
7,229
Lot Size (sq. ft.):
237,402
Status:
Active
Current Price:
$1,490,000
List Date:
1/16/2026
Last Modified:
7/22/2026
Overview
Description
Supplements: ... (Read more) commercial appliances and spacious pantry. This home is also equipped with a custom elevator to promote accessibility of all levels of the home for all guests. For added versatility and comfort, the property includes a fully separate guest apartment with its own private entrance, kitchenette, living area, bedroom, and full bath ideal for extended family visits, overnight guests, or multi-generational living. A rare and luxurious retreat that masterfully blends sophisticated living, abundant space, and the calming embrace of nature's beauty. Don't miss this extraordinary opportunity to own a home made for cherished moments with loved ones.
Listing Details MLS# 431699
Location, Tax & Legal
- Street No #
- 9290
- Street Direction
- W
- Street
- TERRAPIN HILLS RD
- Street Suffix
- RD
- County
- Boone
- State/Province
- MO
- Zip Code
- 65203
- Subdivision
- TERRAPIN HILLS
- Mapping ID #
- 15-900-35-00-004.06 01
General Property Description
- Type
- Single Family Residence
- Attached/Detached
- Detached
- Primary Style
- 2 Story
- # of Bedrooms
- 5
- # of Bedrooms Above Grade
- 4
- Baths Full
- 4
- # of Baths-Half
- Yes
- Total Bathrooms
- 5
- Garage Capacity
- 2
- Uncovered Parking
- Parking Spaces
- Age Description
- 21-30 Yrs
- # of Acres
- 5.45
- Sq Ft Source
- Appraiser
- Appx Fin Sq Ft Main #
- 2357
- Appx Fin Sq Ft Lower #
- 2375
- Appx Fin Sq Ft Upper #
- 2497
- Appx Fin Sq Ft Total #
- 7229
- Builder Name
- Smarr
- Year Built
- 1997
Status Change Info
- List Price/Sqft
- 206.11
- Status Change Date
- 2026-01-15
Property Disclosure
- Property Disclosure To Be Provided
- No
Columbia Pub Schools
- Elementary School 2025/2026
- Midway Heights
- Middle School 2025/2026
- Smithton
- High School 2025/2026
- Hickman
More Information
Rooms
- Full Bathroom Level
- Upper
- Half Bathroom Level
- Main
Property Features
Basement:
Finished; Full; Walk-Out Access
Accessibility Features:
Accessible Elevator Installed
Additional Acreage:
1 - 5 Acres
Cooling:
Central Electric
Deck:
Back; Covered; Screened; Side; Wood
Dining:
Eat-In Kitchen; Formal Dining
Community Features:
Trail(s)
Exterior Features:
Balcony; Windows-Wood
Exterior Finish:
Stone Veneer; Synthetic Stucco
Fireplace:
Gas; In Family Room
Flooring:
Carpet; Tile; Wood
Foundation Details:
Poured Concrete
Heating:
Forced Air; Natural Gas; Propane
Appliances:
Built-In Gas Range; Dishwasher; Disposal; Dryer; Exhaust Fan; Microwave; Refrigerator; Trash Compactor; Washer; Water Softener Owned
Other Structures:
Additional Living Quarters
Porch:
Back; Covered; Screened
Possession:
At Closing
Roof:
Architectural Shingle
Road Responsibility:
Public Maintained Road
Road Surface Type:
Paved
Lot Features:
Near Trail(s); Wooded
Rooms:
Full Bathroom; Half Bathroom
Water Source:
Public
Sewer:
Public
Utilities:
Electric-Boone County Electric; Gas - Natural; Trash-Private
Zoning:
R-S Single Family Residential
Room Information
| Room Name | Level |
|---|---|
| Full Bathroom | Upper |
| Full Bathroom | Upper |
| Full Bathroom | Lower |
| Full Bathroom | Upper |
| Half Bathroom | Main |
Listing Office:
573 Realty, LLC
Listing Agent:
Jen McCallister
Co Listing Agent: Katie Wagner
Last Updated: July - 22 - 2026
Information deemed reliable but not guaranteed.