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: $250K (3/24)
$1,700,000
9290 W Terrapin Hills Rd, Columbia, MO 65203
5beds
7,229sqft
Est.:
Single Family Residence
Built in 1997
5.45 Acres Lot
$1,597,600 Zestimate®
$235/sqft
$54/mo HOA
What's special
Commercial appliancesRich beautiful hardwood floorsCrown moldingsSpacious pantryBeautiful custom cabinets
- 73 days |
- 957 |
- 28 |
Zillow last checked: 7 hours ago
Listing updated: March 24, 2026 at 01:18pm
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
Tour with a local agent
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: $235/sqft
- Date on market: 1/16/2026
- Road surface type: Paved
Estimated market value
$1,597,600
$1.52M - $1.68M
$5,077/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 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
Public tax history
Tax history is unavailable.BuyAbility℠ payment
Est. payment
$9,985/mo
Principal & interest
$8783
Property taxes
$1148
HOA Fees
$54
More affordability tools
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: PK,9-12Distance: 8.7 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.
Local experts in 65203
- Missouri
- Boone County
- Rocheport
- 65203
- 9290 W Terrapin Hills Rd
Nearby cities
Nearby zip codes
Other Rocheport Topics
