9290 W Terrapin Hills Rd, Columbia, MO, 65203
About This Home
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.
Getting Around
Car-Dependent
Very Limited Transit
Somewhat BikeableSchools
Construction
Condition
- Year built: 1997
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Other
- Builder name: Smarr
Type & Style
- Home type: SingleFamily
- Property subType: Single Family Residence
Interior
Appliances
- Appliances included: Trash Compactor,Refrigerator,Microwave,Disposal,Dishwasher
Basement
- Has basement: Yes
- Basement: Walk-Out Access
Bedrooms & Bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Features
- Tub/Shower,Stand AloneShwr/MBR,Walk-In Closet(s),Elevator,Smart Thermostat,Eat-in Kitchen,Formal Dining,Cabinets-Custom Blt,Solid Surface Counters,Wood Cabinets,Pantry
- Window features: Some Window Treatments
- Flooring: Wood,Carpet,Tile
- Fireplace features: Gas,Family Room
- Fireplace: Yes
- Finished area below ground: 2,375
Full Bathroom
- Level: Upper
Full Bathroom
- Level: Upper
Full Bathroom
- Level: Lower
Full Bathroom
- Level: Upper
Half Bathroom
- Level: Main
Heating & Cooling
- Heating features: Forced Air,Natural Gas,Propane
- Cooling features: Central Electric
Interior Area
- Total structure area: 7,229
- Total interior livable area: 7,229 sqft
Property
Accessibility
- Accessibility features: Accessible Elevator Installed,Handicap Modified
Details
- Parcel number: 159003500004.06 01
- Zoning description: R-S Single Family Residential
Features
- Patio & porch: Screened,Covered,Deck,Rear Porch
- Exterior features: Balcony
- Has spa: Yes
- Spa features: Tub/Built In Jetted
Lot
- Lot size: 5.45 Acres
- Features: Wooded,Near Trail(s)
Parking
- Total spaces: 2
- Parking features: Attached
- Has garage: Yes
- Attached garage spaces: 2
- Covered spaces: 2
- Has uncovered spaces: Yes
Climate Risk is Financial Risk
Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.
Biggest Threats for This Home
- Lightning
- Tornado
- Winter Weather
- Cold Wave
- Heat Wave
- Inland Flooding
- Ice Storm
- Strong Wind
How This Home’s Risks Compare
FEMA Declared Disasters Across Missouri Counties
Understanding the Costs
Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.
Estimated Costs Today
| Monthly | Annual | |
|---|---|---|
| Mortgage | $7,534 | $90,408 |
| Home Insurance * | $823 | $9,876 |
| Property Taxes | $1,018 | $12,216 |
| Electricity | $552 | $6,624 |
| Total | $9,927 | $119,124 |
Income You'd Need if You Spent...
Missouri FAIR Plan Programs
How Costs Could Change Over Time
Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.
Comparing Against the Market
Price Per Sq Ft
vs Other Active Listings
Avg $/sqft
vs Homes Sold Last Month
Median $/sqft
Current Market Trends
Median Price Per Square Foot
The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.
Historicals for This Listing
Zestimate History ($/sqft)
Price History
| Date | Event | Price |
|---|---|---|
| 2026-05-08 | Price change | $1,490,000 |
| 2026-03-24 | Price change | $1,700,000 |
| 2026-01-16 | Listed for sale | $1,950,000 |
View on Zillow