NOT LISTED FOR SALE

9151 W Terrapin Hills Rd Columbia, MO 65203

Estimated Value: $621,000 - $1,082,000

3 Beds
3.5 Baths
4,484 Sq Ft
$204/Sq Ft Est. Value

Last Sold August 31, 2012

Current estimated payment $5,513/month

109 Days on Market

Highlights

  • Heavily Wooded Lot
  • Fireplace in Primary Bedroom
  • Recreation Room
  • Midway Heights Elementary School Rated A-
  • Covered Deck
  • Ranch Style House

About This Home

As of August 2012

Amazing spanish influenced home on the Bluffs of the Missouri River, backing up to the river & KATY Trail. Custom tile, sinks & accessories, light fixtures, stained glass, wrought iron, stone columns and more were imported directly from Mexico. Fantastic river views, 5+ acres, beautiful master suite, open floor plan, 3 car garage, full butlers pantry, excavated garage and more...

Last Agent to Sell the Property

JD Estes

RE/MAX Boone Realty License #2003007481 Listed on: 01/23/2012

RE/MAX Boone Realty

Last Buyer's Agent

JD Estes

RE/MAX Boone Realty License #2003007481 Listed on: 01/23/2012

RE/MAX Boone Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,562

Year Built

  • Built in 2001

Lot Details

  • 5.22 Acre Lot
  • Northeast Facing Home
  • Lot Has A Rolling Slope
  • Heavily Wooded Lot

HOA Fees

  • $32 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Basement Garage
  • Garage Door Opener
  • Dirt Driveway

Home Design

  • Ranch Style House
  • Concrete Foundation
  • Poured Concrete
  • Tile Roof
  • Composition Roof
  • Radon Mitigation System
  • Synthetic Stucco Exterior

Interior Spaces

  • Wet Bar
  • Central Vacuum
  • Ceiling Fan
  • Paddle Fans
  • Screen For Fireplace
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Wood Frame Window
  • Entrance Foyer
  • Living Room with Fireplace
  • Combination Kitchen and Dining Room
  • Home Office
  • Recreation Room
  • First Floor Utility Room
  • Utility Room
  • Home Gym

Kitchen

  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Tile Countertops
  • Built-In or Custom Kitchen Cabinets
  • Utility Sink
  • Trash Compactor
  • Disposal

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Primary bathroom on main floor
  • Hydromassage or Jetted Bathtub
  • Shower Only

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Partially Finished Basement

  • Walk-Out Basement
  • Interior Basement Entry

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Covered Deck
  • Covered Patio or Porch
  • Gazebo

Schools

  • Midway Heights Elementary School
  • Smithton Middle School
  • Hickman High School

Utilities

  • Central Air
  • Heating System Uses Propane
  • Radiant Heating System
  • Baseboard Heating
  • Hot Water Heating System
  • Propane
  • Municipal Utilities District Water
  • Water Softener is Owned
  • Septic Tank
  • High Speed Internet
  • Satellite Dish

Listing and Financial Details

  • Assessor Parcel Number 158003400001.01 01

Community Details

Overview

  • Built by Mastermark
  • Terrapin Hills Subdivision

Security

  • Safe or Vault

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,562

Year Built

Built in 2001

Lot Details

0

HOA Fees

$32 per month

Parking

3

Listing Details

  • Directions: Scott Blvd, to Gillespie Bridge Rd, left on Hwy UU, then left on Hwy O, to right on Terrapin Hills Rd.
  • Prop. Type: Residential
  • Bedroom 2 Level: Lower
  • Dining Room Level: Main
  • Kitchen Level: Main
  • Living Room Level: Main
  • Master Bathroom Level: Main
  • Primary Bedroom Level: Main
  • Year Built: 2001
  • BathsFull34MainLevel: 1
  • Property Sub Type: Single Family Residence
  • Lot Size Acres: 5.22
  • Road Surface Type: Paved, Private Maintained
  • Subdivision Name: TERRAPIN HILLS
  • Above Grade Finished Sq Ft: 2604.0
  • Architectural Style: Ranch
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • Deck:Back: Yes
  • Deck:Covered: Yes
  • Utilities:Electric-County: Yes
  • Water District: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Patio:Back3: Yes
  • Baths-Half:Main Level2: 1
  • Rooms:Dining Room: Yes
  • Rooms:Exercise Room: Yes
  • Rooms:Foyer: Yes
  • Rooms:Living Room: Yes
  • Rooms:Office: Yes
  • Rooms:Recreation Room2: Yes
  • Foundation Type:Full Bsmt Part Fin: Yes
  • Exterior Finish:Synthetic Stucco: Yes
  • Foundation Access:Inside Entrance: Yes
  • Dining:KitDin Combo: Yes
  • TopoLot Description:Heavily Wooded: Yes
  • Patio:Concrete2: Yes
  • Patio:Covered3: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Heat Fuel:Propane: Yes
  • Utilities:Gas-PropaneTankOwned: Yes
  • Roof:Composition: Yes
  • Utilities:Sewage-Septic Tank: Yes
  • Heat Type:Baseboard: Yes
  • Outbuildings:Gazebo: Yes
  • Heat Type:Radiant: Yes
  • Heat Fuel:Hot WaterSteam: Yes
  • Roof:Tile2: Yes
  • Special Features: None

Interior Features

  • Has Basement: Excavated Garage
  • Bedroom 3 Level: Lower
  • Exercise Room Level: Lower
  • Foyer Level: Main
  • Office Level: Upper
  • Bedrooms Other Level: Main
  • Utility Room Level: Main
  • Flooring: Carpet, Tile
  • Interior Amenities: High Spd Int Access, Utility Sink, Stand AloneShwr/MBR, Tub-2+Person, Tub/Built In Jetted, Laundry-Main Floor, Satellite Receiver, WindowTreatmnts Some, Water Softener Owned, Walk in Closet(s), Washer/DryerConnectn, Main Lvl Master Bdrm, Built-In Safe, Radon Mit System, Bar-Wet Bar, Ceiling/PaddleFan(s), Central Vacuum, Security System, Smoke Detector(s), Garage Dr Opener(s), FireplaceScreenDr(s), Kit/Din Combo, Cabinets-Custom Blt, Cabinets-Wood, Kitchen Island, Pantry, Tile Counters
  • Basement YN: Yes
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Below Grade Sq Ft: 1880.0
  • Fireplace Features: In Master Bedroom, In Living Room, Gas
  • Fireplace: Yes
  • Living Area: 4484.0
  • Fireplace:Gas: Yes
  • InteriorFeatures:CeilingPaddleFan(s): Yes
  • InteriorFeatures:High Spd Int Access: Yes
  • InteriorFeatures:Laundry-Main Floor: Yes
  • InteriorFeatures:Main Lvl Master Bdrm: Yes
  • InteriorFeatures:Smoke Detector(s): Yes
  • InteriorFeatures:Walk in Closet(s): Yes
  • InteriorFeatures:WasherDryerConnectn: Yes
  • KitchenFeatures:Cabinets-Custom Blt: Yes
  • KitchenFeatures:Cabinets-Wood: Yes
  • KitchenFeatures:Dishwasher-Built In: Yes
  • KitchenFeatures:Garbage Disposal: Yes
  • KitchenFeatures:Island: Yes
  • KitchenFeatures:Microwave Oven: Yes
  • Kitchen Features Pantry: Yes
  • KitchenFeatures:Range-Gas: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Central Vacuum: Yes
  • InteriorFeatures:Radon Mit System: Yes
  • InteriorFeatures:Security System: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:TubBuilt In Jetted: Yes
  • InteriorFeatures:Utility Sink: Yes
  • KitchenFeatures:Cooktop-Gas: Yes
  • KitchenFeatures:Refrigerator: Yes
  • InteriorFeatures:Water Softener Owned: Yes
  • KitchenFeatures:Range-Electric: Yes
  • InteriorFeatures:FireplaceScreenDr(s): Yes
  • KitchenFeatures:Vent Fan: Yes
  • KitchenFeatures:Cooktop-Electric: Yes
  • InteriorFeatures:WindowTreatmnts Some: Yes
  • InteriorFeatures:Tub-2Person: Yes
  • Fireplace:In Master Bedroom: Yes
  • KitchenFeatures:Counter-Tile: Yes
  • KitchenFeatures:Trash Compactor: Yes
  • InteriorFeatures:Built-In Safe: Yes

Exterior Features

  • Builder Name: Mastermark
  • Exterior Features: Driveway-Dirt/Gravel, Driveway-Paved, Satellite Dish, Windows-Wood, Windows-Vinyl
  • Roof: Composition, Tile
  • Lot Features: Rolling Slope
  • Direction Faces: Northeast
  • Foundation Details: Poured Concrete
  • Other Structures: Gazebo
  • Patio And Porch Features: Concrete, Back, Covered, Deck, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Windows-Vinyl: Yes
  • Exterior Features:Windows-Wood: Yes
  • Exterior Features:Driveway-DirtGravel: Yes
  • Exterior Features:Satellite Dish: Yes

Garage/Parking

  • Garage Spaces: 3.0
  • Parking Features: Attached
  • General Property Description:Garage Capacity: 3
  • InteriorFeatures:Garage Dr Opener(s): Yes
  • Foundation Type:Excavated Garage: Yes

Utilities

  • Utilities: Water-District, Electric-County, Gas-PropaneTankOwned, Trash-Private, Sewage-Septic Tank
  • Cooling: Central Electric
  • Heating: Radiant, Baseboard, Propane
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association Fee: 380.0
  • Association Fee Frequency: Annual
  • Association: Yes

Schools

  • Elementary School: Midway Heights
  • Junior High Dist: Columbia
  • High School: Hickman
  • Middle Or Junior School: Smithton

Lot Info

  • Land Lease Amount Frequency: Annual
  • Land Lease: No
  • Lot Size Sq Ft: 227383.2
  • Parcel #: 158003400001.01 01
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 31, 2023
Sold by
Leuenberger Robert Arthur and Leuenberger Robert A
Bought by
Leuenberger Robert A and Leuenberger Brenda K
Current Estimated Value
$914,157

Purchase Details

Listed on
Jan 23, 2012
Closed on
Aug 31, 2012
Sold by
Estes James R and Estes Sara S
Bought by
Lwuenberger Robert Arthur and Leuenberger Brenda K
Seller's Agent
JD Estes
RE/MAX Boone Realty
Buyer's Agent
JD Estes
RE/MAX Boone Realty
List Price
$625,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.07%
Original Mortgage
$273,300
Interest Rate
3.59%
Mortgage Type
New Conventional
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Leuenberger Robert A -- None Listed On Document
Lwuenberger Robert Arthur -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Lwuenberger Robert Arthur $273,300
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/31/2012 08/31/12 Sold -- -- --
05/12/2012 05/12/12 Pending -- -- --
01/23/2012 01/23/12 For Sale $625,000 -- $139 / Sq Ft
Source: Columbia Board of REALTORS®

Tax History Compared to Growth

Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $7,562 $115,026 $5,700 $109,326
2024 $7,562 $104,576 $5,700 $98,876
2023 $7,498 $104,576 $5,700 $98,876
2022 $6,937 $96,824 $5,700 $91,124
2021 $6,948 $96,824 $5,700 $91,124
2020 $7,078 $93,100 $5,700 $87,400
2019 $8,086 $106,354 $5,491 $100,863
2018 $7,534 $0 $0 $0
2017 $7,448 $98,477 $5,491 $92,986
2016 $7,436 $98,477 $5,491 $92,986
2015 $6,867 $98,477 $5,491 $92,986
2014 -- $98,477 $5,491 $92,986
Source: Public Records

Agents Affiliated with this Home

  • JD Estes

    Seller's Agent in 2012

    JD Estes

    RE/MAX

    (573) 256-3198

    106 Total Sales

    JD Estes
    Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 337560

Columbia Board of REALTORS®

APN: 15-800-34-00-001-01-01

Missouri Boone County Columbia 65203

9151 W Terrapin Hills Rd, Columbia, MO

This home is located at 9151 W Terrapin Hills Rd, Columbia, MO 65203 since 23 January 2012 and is currently estimated at $914,157, approximately $203 per square foot. This property was built in 2001. 9151 W Terrapin Hills Rd is a home located in Boone County with nearby schools including Midway Heights Elementary School, Ann Hawkins Gentry Middle School, and Rock Bridge High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Columbia Board of REALTORS® IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes