Skip main navigation
Off market
  • $923,100

    8645 W Terrapin Hills Rd #R, Columbia, MO 65203

    4beds
    5,002sqft
    SingleFamily
    Built in 2018
    5.11 Acres Lot
    $923,100 Zestimate®
    $185/sqft
    $4,143 Estimated rent

    Home value

    $923,100

    $831,000 - $1.02M

    $4,143/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $4,143/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $4,143/mo

    Rent Zestimate®

    Refinance and save

    $5,436/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $5,436/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Custom built home on 5.11 acres with beautiful hardwood floors throughout main floor, chefs kitchen with convention oven and convection microwave, warming drawer, ice maker, beverage refrigerator (all JENN-AIR) and 3 gas fireplaces throughout the home. Enjoy the spectacular views from the 4 seasons room that has floor to ceiling windows over looking a large wooded lot. Entertain your guests in the large lower level with wet bar and pool table and plenty of outdoor entertaining space on the deck and patios. Oversized master bedroom that walks out to the deck and has an ensuite with heated floors, jetted tub and custom multi head shower. Lower level is excavated under garage for extra storage or shop. 4th Bedroom is Nonconforming with no closet but easy to add Hot tub on back deck accessible from master bedroom and sunroom

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 4
    • Full bathrooms: 3
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Heat pump, Electric, Gas, Propane / Butane
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Garbage disposal, Microwave, Refrigerator
    Features
    • Flooring: Carpet
    • Basement: Unfinished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 5,002 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stone, Vinyl, Wood, Brick
    • Has spa: Yes
    Lot
    • Size: 5.11 Acres
    Details
    • Parcel number: 1590026000070001
    • Zoning: Single Family Res

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • masonry
    • Foundation: Other
    Condition
    • Year built: 2018

    Utilities & green energy

    • Utilities for property: Electric-County, Sewage-Septic Tank, Trash-Private, Water-District, GasPropaneTankRented

    Community & neighborhood

    Location
    • Region: Columbia

    Other

    Other facts
    • Interior/Features: Bar-Wet Bar, Cable Ready, FireplaceScreenDr(s), Garage Dr Opener(s), Laundry-Main Floor, Smoke Detector(s), Stand AloneShwr/MBR, Tub/Built In Jetted, Utility Sink, Walk in Closet(s), Ceiling/PaddleFan(s), High Spd Int Access, Security System, Tub/Shower, Water Softener Owned, Bar, Data Wiring, Window Treatmnts All, Cable Available, Tub-2+Person, Wired for Audio, Dual Zone Control HVAC, Humidifier, Main Lvl Master Bdrm, Split Bedroom Design, Radon Mit Ready, ENERGY STAR Qualified Appliances
    • Cooling: Central Electric, Heat Pump(s), Mini-Split
    • Fireplace: In Family Room, In Living Room, Gas, Air Circulating, In Basement
    • Dining: Formal Dining, Kit/Din Combo
    • Flooring: Carpet, Tile, Wood
    • Kitchen/Features: Cabinets-Custom Blt, Cooktop-Gas, Dishwasher-Built In, Garbage Disposal, Island, Refrigerator, Vent Fan, Cabinets-Wood, Pantry, Counter-Granite, Microwave - Convection, Wall Oven(s), Convection Oven, Stand-alone Ice Maker Unit
    • Exterior Features: Driveway-Paved, Windows-Vinyl, Sprinkler-In Ground, Exterior Audio Wiring, Security Cameras
    • Restriction/Easement: Subdiv Restrictions
    • Roof: ArchitecturalShingle
    • Street/Roads: Paved
    • Topo/Lot Description: Partially Wooded, Level
    • Utilities: Electric-County, Sewage-Septic Tank, Trash-Private, Water-District, GasPropaneTankRented
    • Foundation Material: Poured Concrete
    • Foundation Type: Full Bsmt Part Fin, Excavated Garage, Walkout Basement
    • Foundation Access: Walkout
    • Deck: Back
    • Porch: Front, Covered
    • Heat Type: Forced Air, Mini-Split, Heat Pump(s)
    • Rooms: Dining Room, Family Room, Kitchen, Living Room, Recreation Room, Bedroom 2, Bedroom 3, Other, Master Bathroom
    • Primary Style: Ranch
    • Zoning: Single Family Res
    • School District: Columbia
    • Basement: Yes
    • Fence: Backyard, Partial
    • Exterior Finish: Wood Product, Brick Veneer, Stone Veneer
    • Patio: Back, Covered
    • Fence Material: Chain Link, Metal
    • Arch./Style: Traditional
    • Heat Fuel: Propane, Electricity
    • Senior Sch: Hickman
    • Sq Ft Source: Builders Plans
    • Licensee Per/Int Dis: Not Applicable
    • Additional Acreage: 1 - 5 Acres
    • Type: Single Family Residence
    • Rooms: Master Bath Level: Main
    • Rooms: Kitchen Level: Main
    • Rooms: Dining Room Level: Main
    • Rooms: Living Room Level: Main
    • Rooms: Bedroom 2 Level: Main
    • Rooms: Recreation Room Level: Lower
    • Rooms: Other Room Level: Main
    • Rooms: Bedroom 3 Level: Lower
    • Rooms: Family Room Level: Lower
    • Legal Description: PT S 1/2 S 1/2 TR 1A SUR 1103-233

    Price history

    DateEventPrice
    8/18/2020Listing removed$790,000$158/sqft
    Source: Vision Real Estate #391573
    4/15/2020Price change$790,000-1.3%$158/sqft
    Source: Berkshire Hathaway HomeServices ; Vision Real Estate #391573
    3/24/2020Listed for sale$800,000$160/sqft
    Source: Berkshire Hathaway HomeServices ; Vision Real Estate #391573

    Public tax history

    YearProperty taxesTax assessment
    2024$7,051 +0.9%$97,508
    2023$6,991 +8.1%$97,508 +8%
    2022$6,469 -0.2%$90,288

    Find assessor info on the county website

    Neighborhood: 65203

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Midway Heights
    • Middle: Smithton
    • High: Hickman
    • District: Columbia

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.