9290 W TERRAPIN HILLS RD RD, Columbia, MO 65203

• 5 beds |
• 5 baths |
• 7,229 sqft

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.

Listing Status:

Active

Date Added:

January 16, 2026

Data Last Updated:

April 5, 2026 at 5:40AM

Listing Office:

573 Realty, LLC : 573-355-7159

Listing Agent:

Jen McCallister : 573-999-3983

MLS ID:

431699

Interior

• General: Eat-in KitchenFormal DiningElevatorHandicap ModifiedSmoke Detector(s)Stand AloneShwr/MBRTub/Built In JettedWindowTreatmnts SomeTub/ShowerSmart ThermostatCabinets-Custom BltCabinets-WoodPantryCounter-SolidSurfaceWalk-in Pantry
• Rooms: Full BathroomHalf Bathroom
• Appliances: Water Softener OwnedDishwasherDisposalMicrowaveRefrigeratorTrash CompactorExhaust FanBuilt-In Gas Range
• Basement: Full Bsmt Full FinWalk-Out Access
• Flooring: CarpetTileWood
• A/C: Central ElectricCeiling/PaddleFan(s)
• Heating: Forced AirNatural GasPropane
• Fireplace: GasFamily RoomFireplace
• Disability Feature: Accessible Elevator Installed

Exterior

• General: BalconyAdditional Living Quarters
• Style: Traditional
• Other Structures: Additional Living QuartersWoodDeckRear PorchScreenedCovered
• Parking: Side EntryGarage Dr Opener(s)

Construction

• Windows: Windows-Wood
• General: Poured Concrete

Location

• HOA Amenities: 650.0Annually
• Golf: Trail(s)
• Originating MLS: Columbia Board of REALTORS®
• School District: Columbia
• County: Boone

Lot

• Zoning: Single Family ResPT NW TR 39A (SUR 1158-410) & TR A (SUR 1303-533)15-900-35-00-004.06 01

Utilities

• Utilities: Electric-Boone County ElectricTrash-Private

Financial

• Source: Columbia Board of REALTORS®