NOT LISTED FOR SALE

1604 Dunhill Way Columbia, MO 65203

Estimated Value: $762,826 - $823,000

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

Last Sold June 12, 2018

Current estimated payment $4,999/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

House of Brokers Realty, Inc. License #2016035211

House of Brokers Realty, Inc.

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
House of Brokers Realty, Inc.
List Price
$539,900
Sold Price
$528,000
Premium/Discount to List
-$11,900
-2.2%
Total Days on Market
39
Current Estimated Value
$784,457

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$256,457
Avg. Annual Appreciation
5.43%
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

Similar Homes in Columbia, MO

  • 1713 Worcester Ln, Columbia, MO 65203

    $775,000

    • 5 Beds
    • 4 Baths
    • 5,752 Sq Ft
    • 1713 Worcester Ln
    • Columbia, MO

    European flair meets modern elegance in this custom-built home. Exquisite millwork trims the arched doorways and complements the extensive crown molding and beautiful hardwood floors throughout the main level. High ceilings and delightful chandeliers add to the homes' charm. An open foyer adjoins hallway to oversized owner suite and office/ bedroom at the other end of the hall. Home offers a

    Jane Boles RE/MAX Boone Realty

    Section Image
  • 4820 Whisper Ct, Columbia, MO 65203

    $795,000

    • 5 Beds
    • 4 Baths
    • 3,628 Sq Ft
    • 4820 Whisper Ct
    • Columbia, MO

    Welcome to 4820 Whisper Ct, a stunning 5-bedroom, 4-bathroom home in Legacy Farms, built by J Jones Homes. This two-story walkout home features a spacious living area with a 3-car tandem garage, quartz countertops, and a large screened-in patio that backs to serene trees for ultimate privacy. Enjoy two versatile flex spaces—perfect for a home office or workout room. Located in the desirable

    Tyler Hill Weichert, Realtors - First Tier

    Section Image
  • 3381 S Country Woods Rd, Columbia, MO 65203

    $699,000

    • 4 Beds
    • 4 Baths
    • 3,763 Sq Ft
    • 3381 S Country Woods Rd
    • Columbia, MO

    Situated on over an acre in the sought-after Country Woods, with direct access to the MKT Trail, this beautifully remodeled home blends classic charm with modern elegance. Surrounded by mature trees and peaceful roads, it offers a sense of privacy and serenity not within city limits, while still being just minutes from the heart of Columbia. Inside, you'll find high-end finishes, hardwood floors,

    Megan Walters EXP Realty LLC

    Section Image
  • 4210 Granite Springs Dr, Columbia, MO 65203

    $754,000

    • 4 Beds
    • 4.5 Baths
    • 3,780 Sq Ft
    • 4210 Granite Springs Dr
    • Columbia, MO

    Welcome to 4210 Granite Springs in the sought after development of Copperstone! This spacious home offers 4 en-suite bedrooms-3 on the main level, including a serene master with wooded back yard views, an ADA-friendly suite, and a private guest retreat with its own living space, laundry, fridge hookup, and backyard access. Upstairs, discover a cozy suite with a huge den and walk-in closet. The

    Erin Hendershott 573 Realty, LLC

    Section Image
  • 2416 Cimarron Dr, Columbia, MO 65203

    $800,000

    • 5 Beds
    • 5.5 Baths
    • 5,827 Sq Ft
    • 2416 Cimarron Dr
    • Columbia, MO

    Unbelievable View, overlooking the Hinkson Creek! You will never see another like this. Huge back deck overlooks woods, Hinkson creek. and Mizzou Arena. Wonderful home featuring an amazing 5 Bed 5 Bath well designed living space. Completely remodeled in 2014 for an updated style in an exquisite home. Tons of windows and natural light, massive chef kitchen featuring an oversized island and an

    Brent Gardner Berkshire Hathaway HomeServices | Vision Real Estate

    Section Image
  • 5409 Bell Flower Ct, Columbia, MO 65203

    $939,000

    • 6 Beds
    • 4.5 Baths
    • 4,317 Sq Ft
    • 5409 Bell Flower Ct
    • Columbia, MO

    Experience lakeside luxury in this stunning 6 bed, 4.5 bath home in the prestigious Thornbrook Community. Step into elegance with a grand curved staircase and enjoy the gourmet chef's kitchen featuring granite countertops and chef's appliances. Relax by the cozy gas fireplace or entertain in the lower level's full movie theatre, billiards parlor, wet bar, and John Deere Room with shop. A secure

    Jeff Cramer House of Brokers Realty, Inc.

    Section Image
  • 4609 Sawgrass Dr, Columbia, MO 65203

    $769,000

    • 5 Beds
    • 4 Baths
    • 3,951 Sq Ft
    • 4609 Sawgrass Dr
    • Columbia, MO

    Welcome to your new 1 1/2 story home on a walkout basement. Lovely open living room with fireplace inside a focal stone chimney. Kitchen with gas stove and lovely island makes entertaining a breeze. Full wall of cabinets for all of your storage needs in breakfast area. Formal dining room has amazing trim. 2nd bedroom on main floor in addition to primary suite. Primary bedroom offers its own

    Denise Payne Weichert Realtors-First Tier

    Section Image
  • 7312 Sella Ct, Columbia, MO 65203

    $852,000

    • 6 Beds
    • 5 Baths
    • 4,396 Sq Ft
    • 7312 Sella Ct
    • Columbia, MO

    Nestled on a peaceful cul-de-sac, this exceptional 2-story home boasts a spacious layout perfect for modern living. With 6 bedrooms and a 3-car garage, you'll have all the space you need for comfort and convenience. Step inside to find a grand living room featuring vaulted ceilings and a striking gas stone fireplace with built-ins, creating an inviting focal point. French doors lead to a stunning

    Shannon Drewing House of Brokers Realty, Inc.

    Section Image
  • 4902 Cochero Ct, Columbia, MO 65203

    $889,500

    • 5 Beds
    • 6 Baths
    • 5,229 Sq Ft
    • 4902 Cochero Ct
    • Columbia, MO

    Tucked in a private setting backing to the woods, this home with European charm features impeccable attention to details with beautiful hardwood floors, extensive trim, crown molding and gorgeous windows.The living room includes a gas fireplace that can also be enjoyed from the hearth/breakfast area and the open kitchen. The gourmet kitchen offers sleek granite, gas cooktop along with a dining

    Jane Boles RE/MAX Boone Realty

    Section Image

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 $300,000
Closed Guo Yicheng $430,000
Previous Owner Colbert Stephen Hubbard $296,700
Previous Owner Colbert Stephen Hubbard $314,000
Previous Owner Colbert Stephen Hubbard $330,000
Previous Owner Colbert Stephen Hubbard $108,500
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
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