9290 W TERRAPIN HILLS RD RD, COLUMBIA, MO 65203
$1,950,000
Property Type:
Residential
Bedrooms:
5
Baths:
5
Square Footage:
7,229
Lot Size (sq. ft.):
237,402
Status:
Active
Current Price:
$1,950,000
List Date:
1/16/2026
Last Modified:
1/17/2026
Description
This exceptional one-of-a-kind 7200 sq ft custom home rests on 5.45 acres of beautifully private land, perched with breathtaking panoramic views of the river over the bluffs. Here, unmatched privacy meets true serenity—a peaceful oasis away from the everyday world, perfect for creating lasting memories with family and friends.
Inside, discover 5 generously sized bedrooms, a dedicated study ideal for focused work, reading, or quiet reflection, and a gracious formal dining room perfect for hosting memorable meals and celebrations. Rich, beautiful hardwood floors, crown moldings and a plethora of windows grace the main living areas and flow seamlessly throughout, lending timeless warmth, elegance, and durability to every step.
The family chef will love the beautiful custom cabinets,
Supplements: 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.
More Information MLS# 431699
General Property Description
# of Bedrooms Above Grade: 4
Attached/Detached: Detached
# of Baths-Half: 1
Primary Style: 2 Story
Garage Capacity: 2
Sq Ft Source: Appraiser
# of Acres: 5.45
Uncovered Parking: Parking Spaces
Age Description: 21-30 Yrs
Appx Fin Sq Ft Main #: 2357
Appx Fin Sq Ft Lower #: 2375
Appx Fin Sq Ft Upper #: 2497
Appx Fin Other Sq Ft #: 0
Basement: Yes
Appx UnFin Sq Ft Main #: 0
Appx UnFin Sq Ft Lower #: 0
Appx UnFin Sq Ft Upper #: 0
Appx UnFin Other Sq Ft #: 0
Appx UnFin Sq Ft Total #: 0
Builder Name: Smarr
Type: Single Family Residence
# of Bedrooms: 5
Baths Full: 4
Total Bathrooms: 5
Appx Fin Sq Ft Total #: 7229
Year Built: 1997
Location Tax & Legal
Zoning: Single Family Res
School District: Columbia
Elementary Sch: Midway Heights
Middle/Jr High Sch: Smithton
Senior Sch: Hickman
HOA/Condo: Yes
HOA/Condo $: 650
HOA/Condo Descrip: Annual
HOA/Condo Init: No
Condo Ext Maint: None
Legal Description: PT NW
TR 39A (SUR 1158-410)
& TR A (SUR 1303-533)
Auction: No
Land Lease: No
Land Lease Descrip: N/A
Located within City of Columbia: No
Remarks & Misc
Directions: Rt 0 South to Terrapin Hills. Go all the way back to the end of the road and the house is at the end. Overlooking the bluff
Status Change Info
List Price/Sqft: 269.75
Status: Active
Status Change Date: 2026-01-15
Licensee Per/Int Dis
Not Applicable: 1
Rooms
Full Bathroom: 1
Full Bathroom Level: Upper
Half Bathroom: 1
Half Bathroom Level: Main
Property Disclosure
Property Disclosure To Be Provided: No
Foundation Type
Full Bsmt Full Fin: 1
Walkout Basement: 1
Appliances
Built-In Gas Range: 1
Dishwasher: 1
Disposal: 1
Exhaust Fan: 1
Microwave: 1
Refrigerator: 1
Trash Compactor: 1
Interior/Features
Ceiling/PaddleFan(s): 1
Dryer: 1
Elevator: 1
Garage Dr Opener(s): 1
Generator: 1
Handicap Modified: 1
Programmable Thermostat(s): 1
Security System: 1
Smoke Detector(s): 1
Stand AloneShwr/MBR: 1
Tub/Built In Jetted: 1
Tub/Shower: 1
Walk in Closet(s): 1
Washer: 1
WindowTreatmnts Some: 1
Wired for Sec Sys: 1
Cooling
Central Electric: 1
Accessibility Features
Accessible Elevator Installed: 1
Exterior Finish
Stone Veneer: 1
Synthetic Stucco: 1
Community Features
Trail(s): 1
Road Responsibility
Public Maintained Road: 1
Road Surface Type
Paved: 1
Other Structures
Additional Living Quarters: 1
Foundation Access
Walkout: 1
Possession
At Closing: 1
Heating
Forced Air: 1
Propane: 1
Foundation Material
Poured Concrete: 1
Additional Acreage
1 - 5 Acres: 1
Restriction/Easement
Recorded Plat: 1
Subdiv Restrictions: 1
Arch./Style
Traditional: 1
Deck
Back: 1
Covered: 1
Screened: 1
Side: 1
Wood: 1
Dining
Eat-In Kitchen: 1
Formal Dining: 1
Lot Features
Near Trail(s): 1
Wooded: 1
Exterior Features
Balcony: 1
Windows-Wood: 1
Roof
ArchitecturalShingle: 1
Utilities
Electric-Boone County Electric: 1
Trash-Private: 1
Fireplace
Gas: 1
In Family Room: 1
Zoning
R-S Single Family Residential: 1
Flooring
Carpet: 1
Tile: 1
Wood: 1
Kitchen/Features
Cabinets-Custom Blt: 1
Cabinets-Wood: 1
Counter-SolidSurface: 1
Pantry: 1
Walk-in Pantry: 1
Porch
Back: 1
Covered: 1
Screened: 1
Contract Information
Current Price: $1,950,000
List Date: 2026-01-16
List Price: $1,950,000
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
Property Features
Foundation Type: Full Bsmt Full Fin; Walkout Basement
Accessibility Features: Accessible Elevator Installed
Additional Acreage: 1 - 5 Acres
Cooling: Central Electric
Road Responsibility: Public Maintained Road
Road Surface Type: Paved
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 Access: Walkout
Foundation Material: Poured Concrete
Heating: Forced Air; Propane
Appliances: Built-In Gas Range; Dishwasher; Disposal; Exhaust Fan; Microwave; Refrigerator; Trash Compactor
Other Structures: Additional Living Quarters
Porch: Back; Covered; Screened
Possession: At Closing
Roof: ArchitecturalShingle
Lot Features: Near Trail(s); Wooded
Rooms: Full Bathroom; Half Bathroom
Utilities: Electric-Boone County Electric; Trash-Private
Zoning: R-S Single Family Residential
Room Information
Full Bathroom
Level: Upper
Full Bathroom
Level: Upper
Full Bathroom
Level: Lower
Full Bathroom
Level: Upper
Half Bathroom
Level: Main
Listing Office:
573 Realty, LLC
Listing Agent:
Jen McCallister
Co Listing Agent: Erin Hendershott
Last Updated: January - 17 - 2026
Information deemed reliable but not guaranteed.