9290 W TERRAPIN HILLS RD RD
Columbia, MO, 65203 $ 1,950,000
Bedrooms5 Baths4.1 Sq 7,229 Monthly Estimate*
$ 12,006
for $1,950,000 with 5 bedrooms and 4 full baths, 1 half bath. This 7,229 square foot home was built in 1997 on a lot size of 5.45.
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, 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.
See more
FeaturesGeneralAttached Detached Detached
Heating Forced Air Propane
Cooling Central Electric Ceiling/PaddleFan(s)
Utilities Water-District Electric-County Gas-Natural Sewage-District Trash-Private
Roof ArchitecturalShingle
Appliances Built-In Gas Range Water Softener Owned
Zoning Single Family Res
HOA Fee 650
Garage Spaces 2
Patio/Porch Features Screened Covered Wood Deck Rear Porch
Architectural Style Traditional 2 Story
Security Features Wired for Sec Sys Security System Smoke Detector(s)
Year Built 1997
Property Subtype Single Family Residence
Assoc Fee Paid Per Annual
County Boone
Property Type Residential
HOA true
Subdivision Name TERRAPIN HILLS
Garage Y/N true
Other Structures Additional Living Quarters
Total Rooms 5
Full Baths 4
Status Active
High School Hickman
City COLUMBIA
High School District Columbia
Lot Size Units Acres
Lot Size Square Feet 237402
Elementary School Midway Heights
Middle/Junior High School Smithton
Builder Name Smarr
See more
InteriorInterior Amenities Walk-in Pantry Handicap Modified Tub/Shower Stand AloneShwr/MBR Tub/Built In Jetted WindowTreatmnts Some Walk in Closet(s) Elevator Smart Thermostat Eat-in Kitchen Formal Dining Cabinets-Custom Blt Counter-SolidSurface Cabinets-Wood Pantry
Flooring Wood Carpet Tile
Air Conditioning Y/N true
Heating Y/N true
Window Features Windows-Wood
Fireplace Y/N true
Half Baths 1
Total Bedrooms 5
Total Baths 5
See more
ExteriorExterior Amenities Balcony
Parking Features Garage Dr Opener(s) Attached
Lot Features Wooded Near Trail(s)
Lot Size Area 5.45
Building Area Total 7229
Lot Size Acres 5.45
Other Equipment Generator
See more
* Excluded FeaturesList ByJen McCallisterListing Agent
Affordability Calculator
- Monthly Principal & Interest
- $12,006
- Monthly Property Taxes
- --
- Monthly Home Insurance
- --
Default based on a 30-year fixed rate of 6.25% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save NearbySingle family listings in Columbia, MO
Average List Price $522,310
Percent of Sale Price 73%
About Columbia, MO 120,921 Population
32% Since 2002
$ 47,243 Median Income
30.47 Median Age
24% Households with Children
Trends Information provided by ATTOM Data Solutions.
4821349 Elementary School
4821348 Middle School
Hickman High School High School
Pricing History| Date | Price | Price Change | Description |
|---|
| 1/16/2026 | $1,950,000 | | Listed Price |