Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

9290 W Terrapin Hills Rd, Columbia, MO, 65203

5beds
5baths
7,229sqft
$1,490,000
$206price/sqft
$9,927/moest. monthly cost
$397,080/yrincome needed

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

0
WalkingCar-Dependent
0
TransitVery Limited Transit
19
BikeSomewhat Bikeable

Schools

5/10
Smithton Middle SchoolGrades 6-85.9 mi
7/10
David H. Hickman High SchoolGrades PK,9-128.7 mi

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