Address
9290 W Terrapin Hills Rd Rd, COLUMBIA, MO
Price
$ 1,490,000
Property Attributes
- MLS#431699
- TypeSingle Family
- Listing Status Active
- CountyBoone
- CityCOLUMBIA
- NeighborhoodTERRAPIN HILLS
- Zip65203
- StyleTraditional
- Year Built1997
- Price$ 1,490,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage7229
- Lot Size5.45 Acres
Data Source:
Columbia MO MLS (CBORMLS)
Property 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, 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.
| Elementary School | Middle School | High School |
|---|---|---|
| Midway Heights Elementary School | Smithton Middle School | Hickman High School |
| Price History | |
|---|---|
| 1/16/2026 | Listed $1,950,000 |
| 3/24/2026 | 13$1,700,000 |
| 5/8/2026 | 12$1,490,000 |
General Features
| Attached Detached | Detached |
|---|---|
| Heating | Forced Air,Natural Gas,Propane |
| Cooling | Central Electric,Ceiling/PaddleFan(s) |
| Utilities | Water-City,Electric-County,Trash-Private |
| Roof | ArchitecturalShingle |
| Appliances | Trash Compactor,Refrigerator,Microwave,Exhaust Fan,Disposal,Dishwasher,Dryer,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 |
| 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 |
Interior Features
| Interior 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 |
Exterior Features
| Exterior 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 |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 65203
Price
Year Built
These Properties are provided courtesy of Broker Reciprocity/IDX Lake Of The Ozarks Board of REALTORS® and Bagnell Dam Association of REALTORS® MLS, Inc. Multiple Listing Service. This information is copyrighted by The Lake Of The Ozarks Board of REALTORS® and The Bagnell Dam Association of REALTORS® MLS, Inc. Multiple Listing Service. Information is being provided for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties
The territorial jurisdiction of the Jefferson City Area Board of REALTORS®, Inc. includes Cole, Callaway, Moniteau, and Osage Counties. This representation is based in whole or part on data supplied by the Multiple Listing Service of the Jefferson City Area Board of REALTORS®, Inc. Neither the Board nor its MLS guarantees or is any way responsible for its accuracy. Data maintained by the Board or its MLS may not reflect all real estate activity in the market.
Heart Of Missouri Board Of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
