9290 W TERRAPIN HILLS RD RD, COLUMBIA, MO 65203 (MLS# 431699)

9290 W TERRAPIN HILLS RD RD, COLUMBIA, MO 65203

$1,700,000

Property Type: Residential Bedrooms: 5 Baths: 5 Square Footage: 7,229 Lot Size (sq. ft.): 237,402 Status: Active

Current Price: $1,700,000 List Date: 1/16/2026 Last Modified: 3/24/2026

Overview

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 extende ... (Read more)

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
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

Status Change Info

List Price/Sqft: 235.16
Status Change Date: 2026-01-15

Property Disclosure

Property Disclosure To Be Provided: No

Rooms

Full Bathroom Level: Upper
Half Bathroom Level: Main
Full Bathroom: Yes
Half Bathroom: Yes

More Information

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

Licensee Per/Int Dis

Not Applicable: Yes

Foundation Type

Full Bsmt Full Fin: Yes
Walkout Basement: Yes

Foundation Access

Walkout: Yes

Foundation Material

Poured Concrete: Yes

Appliances

Built-In Gas Range: Yes
Dishwasher: Yes
Disposal: Yes
Dryer: Yes
Exhaust Fan: Yes
Microwave: Yes
Refrigerator: Yes
Trash Compactor: Yes
Washer: Yes
Water Softener Owned: Yes

Cooling

Central Electric: Yes

Heating

Forced Air: Yes
Natural Gas: Yes
Propane: Yes

Accessibility Features

Accessible Elevator Installed: Yes

Roof

ArchitecturalShingle: Yes

Additional Acreage

1 - 5 Acres: Yes

Exterior Finish

Stone Veneer: Yes
Synthetic Stucco: Yes

Arch./Style

Traditional: Yes

Lot Features

Near Trail(s): Yes
Wooded: Yes

Other Structures

Additional Living Quarters: Yes

Possession

At Closing: Yes

Restriction/Easement

Recorded Plat: Yes
Subdiv Restrictions: Yes

Deck

Back: Yes
Covered: Yes
Screened: Yes
Side: Yes
Wood: Yes

Water Source

Public: Yes

Sewer

Public: Yes

Dining

Eat-In Kitchen: Yes
Formal Dining: Yes

Utilities

Electric-Boone County Electric: Yes
Trash-Private: Yes

Road Responsibility

Public Maintained Road: Yes

Community Features

Trail(s): Yes

Road Surface Type

Paved: Yes

Exterior Features

Balcony: Yes
Windows-Wood: Yes

Fireplace

Gas: Yes
In Family Room: Yes

Flooring

Carpet: Yes
Tile: Yes
Wood: Yes

Zoning

R-S Single Family Residential: Yes

Interior/Features

Ceiling/PaddleFan(s): Yes
Elevator: Yes
Garage Dr Opener(s): Yes
Generator: Yes
Handicap Modified: Yes
Programmable Thermostat(s): Yes
Security System: Yes
Smoke Detector(s): Yes
Stand AloneShwr/MBR: Yes
Tub/Built In Jetted: Yes
Tub/Shower: Yes
Walk in Closet(s): Yes
WindowTreatmnts Some: Yes
Wired for Sec Sys: Yes

Kitchen/Features

Cabinets-Custom Blt: Yes
Cabinets-Wood: Yes
Counter-SolidSurface: Yes
Pantry: Yes
Walk-in Pantry: Yes

Porch

Back: Yes
Covered: Yes
Screened: Yes

Property Features

Foundation Type: Full Bsmt Full Fin; Walkout Basement 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 Access: Walkout Foundation Material: Poured Concrete Heating: Forced Air; Natural Gas; Propane Appliances: Built-In Gas Range; Dishwasher; Disposal; Dryer; Dryer; Exhaust Fan; Microwave; Refrigerator; Trash Compactor; Washer; Water Softener Owned Other Structures: Additional Living Quarters Porch: Back; Covered; Screened Possession: At Closing Roof: ArchitecturalShingle 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; 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: March - 24 - 2026

Information deemed reliable but not guaranteed.

Property Info