NOT LISTED FOR SALE

1604 Dunhill Way Columbia, MO 65203

Estimated Value: $752,000 - $870,000

5 Beds
4.5 Baths
4,809 Sq Ft
$166/Sq Ft Est. Value

Last Sold June 12, 2018

Current estimated payment $4,833/month

39 Days on Market

Highlights

  • Deck
  • Traditional Architecture
  • Main Floor Primary Bedroom
  • Mill Creek Elementary School Rated A-
  • Wood Flooring
  • Hydromassage or Jetted Bathtub

About This Home

As of June 2018

Luxury and classic sophistication perfectly balanced at this exquisite home located in the beautiful Heritage Estates. This gorgeous home has an open airy feel and an abundance of natural light. There is a HUGE list of amazing and unique features that make this the PERFECT family home. Wood floors. Granite. Stainless. Wolf range. Custom island w/butcher block & wine rack. Trash compactor. Plantation shutters. Formal dining room. Office. INDOOR TURF ROOM. Lower level custom bar w/fridge,dishwasher,microwave. HOT TUB. NEW composite deck. Security system. Newer paint & flooring. Allovino wine fridges. NEW water heater. 2 hvac units. Butler's pantry w/wine storage. Oversized garage with workshop area. Glass french doors. The list goes on. More photos available! Don't wait! Set up a tour!

Last Agent to Sell the Property

Erin Hendershott

Century 21 Community License #2016045114 Listed on: 01/26/2018

Co-Listed By

Katie Wagner

Century 21 Community License #2015010198

Last Buyer's Agent

Jennifer Zhang

Weichert, Realtors - House of Brokers License #2016035211

Weichert, Realtors - House of Brokers

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,923

Year Built

  • Built in 2004

Lot Details

  • Lot Dimensions are 101.07 x 138.42
  • Sprinkler System
  • Cleared Lot

Parking

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

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Concrete Foundation
  • Poured Concrete
  • Architectural Shingle Roof
  • Vinyl Construction Material

Interior Spaces

  • 1.5-Story Property
  • Wet Bar
  • Wired For Sound
  • Bar
  • Ceiling Fan
  • Paddle Fans
  • Gas Fireplace
  • Vinyl Clad Windows
  • Window Treatments
  • Living Room with Fireplace
  • Formal Dining Room
  • Finished Basement
  • Walk-Out Basement
  • Laundry on main level

Kitchen

  • Eat-In Kitchen
  • Built-In Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Built-In or Custom Kitchen Cabinets
  • Trash Compactor
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Walk-In Closet
  • Hydromassage or Jetted Bathtub
  • Shower Only

Home Security

  • Home Security System
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Covered Patio or Porch

Schools

  • Mill Creek Elementary School
  • John Warner Middle School
  • Rock Bridge High School

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Water Softener is Owned
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Built by Pate-Jones
  • Heritage Est Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1680000050240001

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,923

Year Built

Built in 2004

Lot Details

0

Parking

3

Listing Details

  • Directions: Forum to west on Southampton. Left on Royal Heritage to right on Brookfield Manor. Becomes Dunhill Way. First house on left on Dunhill Way.
  • Lot Size: 101.07 x 138.42
  • Prop. Type: Residential
  • Year Built: 2004
  • BathsFull34LowerLevel: 1
  • BathsFull34MainLevel: 1
  • BathsFull34Total: 4
  • BathsFull34UpperLevel: 2
  • Property Sub Type: Single Family Residence
  • Road Surface Type: Paved, Public Maintained, Curbs and Gutters
  • Co List Office Mls Id: 510001403
  • Co List Office Phone: 573-777-5555
  • Subdivision Name: HERITAGE EST
  • Above Grade Finished Sq Ft: 3459.0
  • Architectural Style: 1.5 Story
  • Foundation Type:Walkout Basement: Yes
  • Garage Type Attached: Yes
  • Cooling:Central Electric: Yes
  • Foundation Access:Walkout: Yes
  • Foundation Material:Poured Concrete: Yes
  • ArchStyle:Traditional: Yes
  • Deck:Back: Yes
  • Roof:ArchitecturalShingle: Yes
  • Utilities:Gas-Natural: Yes
  • Flooring:Carpet: Yes
  • Flooring:Tile: Yes
  • Heat Fuel:Natural Gas: Yes
  • Heat Type:Forced Air: Yes
  • Patio:Back3: Yes
  • Baths-Half:Main Level2: 1
  • Baths-Half:Total2: 1
  • Dining:Eat-In Kitchen: Yes
  • Dining:Formal Dining: Yes
  • TopoLot Description:Cleared: Yes
  • Utilities:Electric-City: Yes
  • Utilities:Sewage-City: Yes
  • Utilities:Water-City: Yes
  • Flooring:Wood2: Yes
  • Patio:Concrete2: Yes
  • Exterior Finish:Vinyl2: Yes
  • Porch:Covered2: Yes
  • Porch:Front2: Yes
  • Exterior Finish:Brick Veneer: Yes
  • Foundation Type:Part Bsmt Full Fin: Yes
  • Special Features: None

Interior Features

  • Has Basement: Walk-Out Access, Excavated Garage
  • Flooring: Wood, Carpet, Tile
  • Interior Amenities: High Spd Int Access, Stand AloneShwr/MBR, Tub/Built In Jetted, Laundry-Main Floor, Wired for Audio, Wired for Sec Sys, WindowTreatmnts Some, Water Softener Owned, Walk in Closet(s), Main Lvl Master Bdrm, Remodeled, Bar, Bar-Wet Bar, Ceiling/PaddleFan(s), Cable Ready, Security System, Smoke Detector(s), Garage Dr Opener(s), Eat-in Kitchen, Formal Dining, Cabinets-Custom Blt, Granite Counters, Cabinets-Wood, Kitchen Island
  • Basement YN: Yes
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1350.0
  • Fireplace Features: In Living Room, Gas
  • Fireplace: Yes
  • Living Area: 4809.0
  • Fireplace:Gas: Yes
  • InteriorFeatures:Cable Ready: 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
  • 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
  • KitchenFeatures:Range-Gas: Yes
  • Fireplace:In Living Room: Yes
  • InteriorFeatures:Bar-Wet Bar: Yes
  • InteriorFeatures:Remodeled: Yes
  • InteriorFeatures:Security System: Yes
  • InteriorFeatures:Stand AloneShwrMBR: Yes
  • InteriorFeatures:TubBuilt In Jetted: Yes
  • InteriorFeatures:Wired for Audio: Yes
  • KitchenFeatures:Counter-Granite: Yes
  • KitchenFeatures:Refrigerator: Yes
  • InteriorFeatures:Water Softener Owned: Yes
  • KitchenFeatures:Wall Oven(s): Yes
  • InteriorFeatures:WindowTreatmnts Some: Yes
  • InteriorFeatures:Bar: Yes
  • InteriorFeatures:Wired for Sec Sys: Yes
  • KitchenFeatures:Vent-Down Draft: Yes
  • KitchenFeatures:Trash Compactor: Yes

Exterior Features

  • Builder Name: Pate-Jones
  • Exterior Features: Driveway-Paved, Windows-Vinyl, Sprinkler-In Ground
  • Roof: ArchitecturalShingle
  • Lot Features: Cleared
  • Foundation Details: Poured Concrete
  • Patio And Porch Features: Concrete, Back, Deck, Front Porch
  • Exterior Features:Driveway-Paved: Yes
  • Exterior Features:Sprinkler-In Ground: Yes
  • Exterior Features:Windows-Vinyl: 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-City, Gas-Natural, Sewage-City, Electric-City, Trash-City
  • Cooling: Central Electric
  • Heating: Forced Air, Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes

Condo/Co-op/Association

  • Association: No

Schools

  • Elementary School: Mill Creek
  • Junior High Dist: Columbia
  • High School: Rock Bridge
  • Middle Or Junior School: John Warner

Lot Info

  • Land Lease Amount Frequency: N/A
  • Land Lease: No
  • Parcel #: 1680000050240001
  • Zoning Description: R-1 One- Family Dwelling*

Tax Info

  • Tax Annual Amount: 6923.21
  • Tax Year: 2017

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 26, 2018
Closed on
Jun 12, 2018
Sold by
Colbert Stephen Hubbard and Colbert Cary Dee
Bought by
Guo Yicheng and Zhang Yutieng
Seller's Agent
Erin Hendershott
Century 21 Community
Buyer's Agent
Jennifer Zhang
Weichert, Realtors - House of Brokers
List Price
$539,900
Current Estimated Value
$799,235

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.84%
Original Mortgage
$430,000
Interest Rate
4.5%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 25, 2013
Sold by
Colbert Stephen Hubbard and Colbert Cary Dee
Bought by
Colbert Stephen Hubbard and Colbert Cary Dee

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$296,700
Interest Rate
3.43%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 19, 2005
Sold by
Rms Properties Llc
Bought by
Colbert Stephen Hubbard and Fitzgerald Cary Dee

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$350,000
Interest Rate
5.92%
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
Guo Yicheng -- Boone Central Title Co
Colbert Stephen Hubbard -- None Available
Colbert Stephen Hubbard -- Boone Central Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Guo Yicheng $430,000
Previous Owner Colbert Stephen Hubbard $296,700
Previous Owner Colbert Stephen Hubbard $350,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/12/2018 06/12/18 Sold -- -- --
03/07/2018 03/07/18 Pending -- -- --
01/26/2018 01/26/18 For Sale $539,900 -- $112 / 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,138 $121,163 $8,208 $112,955
2024 $7,138 $105,811 $8,208 $97,603
2023 $7,079 $105,811 $8,208 $97,603
2022 $6,800 $101,745 $8,208 $93,537
2021 $6,813 $101,745 $8,208 $93,537
2020 $7,251 $101,745 $8,208 $93,537
2019 $7,251 $101,745 $8,208 $93,537
2018 $7,021 $0 $0 $0
2017 $6,935 $97,831 $8,208 $89,623
2016 $6,923 $97,831 $8,208 $89,623
2015 $6,358 $97,831 $8,208 $89,623
2014 -- $97,831 $8,208 $89,623
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Columbia Board of REALTORS®

MLS Number: 375450

Columbia Board of REALTORS®

APN: 16-800-00-05-024-00-01