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

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

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

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.

Leave a Review