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.
For sale
Price cut: $210K (5/8)
$1,490,000
9290 W Terrapin Hills Rd, Columbia, MO 65203
5beds
7,229sqft
Single Family Residence
Built in 1997
5.45 Acres Lot
$1,406,500 Zestimate®
$206/sqft
$54/mo HOA
What's special
Commercial appliancesRich beautiful hardwood floorsCrown moldingsSpacious pantryBeautiful custom cabinets
- 162 days |
- 397 |
- 11 |
Zillow last checked:
Listing updated:
Listed by:
Jen McCallister 573-999-3983,
573 Realty, LLC 573-355-7159,
Katie Wagner 573-355-7159,
573 Realty, LLC
Source: CBORMLS,MLS#: 431699
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Full bathroom
- Level: Upper
Full bathroom
- Level: Upper
Full bathroom
- Level: Lower
Full bathroom
- Level: Upper
Half bathroom
- Level: Main
Heating
- Forced Air, Natural Gas, Propane
Cooling
- Central Electric
Appliances
- Included: Trash Compactor, Refrigerator, Microwave, Disposal, Dishwasher
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
- Flooring: Wood, Carpet, Tile
- Windows: Some Window Treatments
- Basement: Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Gas, Family Room
Interior area
- Total structure area: 7,229
- Total interior livable area: 7,229 sqft
- Finished area below ground: 2,375
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Accessibility
- Accessibility features: Accessible Elevator Installed, Handicap Modified
Features
- Patio & porch: Screened, Covered, Deck, Rear Porch
- Exterior features: Balcony
- Has spa: Yes
- Spa features: Tub/Built In Jetted
Lot
- Size: 5.45 Acres
- Features: Wooded, Near Trail(s)
Details
- Additional structures: Additional Living Quarters
- Parcel number: 159003500004.06 01
- Zoning description: R-S Single Family Residential
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Foundation: Concrete Perimeter
- Roof: ArchitecturalShingle
Condition
- Year built: 1997
Details
- Builder name: Smarr
Utilities & green energy
- Utilities for property: Trash-Private
Community & HOA
Community
- Subdivision: Terrapin Hills
HOA
- Has HOA: Yes
- HOA fee: $650 annually
Location
- Region: Columbia
Financial & listing details
- Price per square foot: $206/sqft
- Date on market: 1/16/2026
- Road surface type: Paved
Estimated market value
$1,406,500
$1.34M - $1.48M
$5,209/mo
Price history
| Date | Event | Price |
|---|---|---|
| 5/8/2026 | Price change | $1,490,000-12.4%$206/sqft |
Source:  CBORMLS #431699 Report a problem | ||
| 3/24/2026 | Price change | $1,700,000-12.8%$235/sqft |
Source: CBORMLS #431699 Report a problem | ||
| 1/16/2026 | Listed for sale | $1,950,000$270/sqft |
Source: CBORMLS #431699 Report a problem | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 65203
Nearby schools
GreatSchools rating
- 9/10Midway Heights Elementary SchoolGrades: PK-5Distance: 4.8 mi
- 5/10Smithton Middle SchoolGrades: 6-8Distance: 5.9 mi
- 7/10David H. Hickman High SchoolGrades: 9-12Distance: 8.8 mi
Schools provided by the listing agent
- Elementary: Midway Heights
- Middle: Smithton
- High: Hickman
Source: CBORMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
A local lender can help you make sure your offer is ready when you are.
- Missouri
- Boone County
- Rocheport
- 65203
- 9290 W Terrapin Hills Rd
Nearby cities
Nearby zip codes
Other Rocheport Topics
