NOT LISTED FOR SALE

Estimated Value: $977,000 - $1,106,693

5 Beds
5 Baths
5,634 Sq Ft
$189/Sq Ft Est. Value

Last Sold August 18, 2020

Last sale price $835,000 $148 Per Sq Ft

Est. 28% increase in value since last sale

Current estimated payment $6,731/month

209 Days on Market

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Clubhouse
  • Fox Hollow Elementary School Rated A-
  • Mountain View
  • Fireplace in Primary Bedroom

About This Home

As of August 2020

Spectacular custom home designed/built by award-winning Wall Custom Homes in the desirable Hillcrest at the Farm. Stylish, 2-story exterior with professional landscaping offers comfortable front and rear outdoor entertaining spaces. Impressive great room with stone fireplace, built-ins and high ceilings with double crown molding is open to the spacious kitchen and nook. Updated features here include a large slab granite center island, stainless steel appliances, a walk-in pantry and plenty of beautiful custom cabinets throughout. Perfectly arranged upper level has master suite, 2 separate large bedrooms with en suite baths and an additional family room, while the stunning lower level is ideal for the big game, wine and beer tastings and your favorite game tables. A great location and neighborhood with amenities and a home that is second to none – don’t miss this opportunity!

Last Agent to Sell the Property

Jeffrey Kloenne

Compass - Denver License #040016343 Listed on: 12/28/2019

Compass - Denver

Last Buyer's Agent

Kyle Foster

Compass - Denver License #100051503

Compass - Denver

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,419

Year Built

  • Built in 2006

Lot Details

  • 10,454 Sq Ft Lot
  • South Facing Home
  • Property is Fully Fenced
  • Landscaped
  • Level Lot
  • Front and Back Yard Sprinklers
  • Private Yard
  • Property is zoned ARPSF

HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Mountain Contemporary Architecture
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Cement Siding
  • Stone Siding

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Built-In Features
  • Ceiling Fan
  • Gas Log Fireplace
  • Double Pane Windows
  • Window Treatments
  • Entrance Foyer
  • Family Room with Fireplace
  • 2 Fireplaces
  • Mountain Views
  • Fire and Smoke Detector

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Double Convection Oven
  • Range Hood
  • Microwave
  • Wine Cooler
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Utility Sink

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet

Finished Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry
  • Basement Cellar

Outdoor Features

  • Covered patio or porch

Schools

  • Fox Hollow Elementary School
  • Liberty Middle School
  • Grandview High School

Utilities

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

Listing and Financial Details

  • Exclusions: Personal Property, Washer/Dryer
  • Assessor Parcel Number 034003177

Community Details

Overview

  • Association fees include ground maintenance, recycling, trash
  • The Farm At Arapahoe County HOA, Phone Number (303) 224-0004
  • Hillcrest At The Farm Pcms Association, Phone Number (303) 224-0004
  • The Farm Subdivision

Amenities

  • Clubhouse

Recreation

  • Community Pool

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,419

Year Built

Built in 2006

Lot Details

0

HOA Fees

$145 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Mountain Contemporary
  • Structure Type: House
  • Levels: Two
  • Year Built: 2006
  • Above Grade Finished Sq Ft: 3859
  • Exclusions: Personal Property, Washer/Dryer
  • Living Area: 5634
  • Directions: From Parker Rd head east on Arapahoe Road, head north on S. Waco St, Turn left on E Peakview Ave, Turn left on S. Telluride St, turn left on to Euclid Pl
  • SubdivisionName: The Farm
  • Ownership: Individual
  • ResoBuildingAreaSource: Appraiser
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 0
  • REC_BelowGradeUnfinishedArea: 44.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 3
  • REC_UpperLevelBedrooms: 3
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.92778
  • Special Features: VirtualTour

Interior Features

  • Appliances: Convection Oven, Double Oven, Microwave, Oven, Range Hood, Refrigerator, Wine Cooler
  • Fireplaces: 2
  • Interior Amenities: Breakfast Nook, Built-in Features, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, Kitchen Island, Primary Suite, Open Floorplan, Pantry, Quartz Counters, Utility Sink, Walk-In Closet(s), Wet Bar
  • Flooring: Carpet, Tile, Wood
  • Fireplace Features: Family Room, Gas, Gas Log, Primary Bedroom
  • Full Bathrooms: 3
  • Basement: Cellar, Finished, Full, Interior Entry
  • Basement: Yes
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1775
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Window Features: Double Pane Windows, Window Coverings

Exterior Features

  • Direction Faces: South
  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Cement Siding, Frame, Stone
  • View: Mountain(s)
  • Exterior Features: Gas Valve, Private Yard
  • Patio and Porch Features: Covered
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Available, Natural Gas Connected, Phone Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air, Natural Gas
  • Water Source: Public
  • Security: Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Maintenance Grounds, Recycling, Trash
  • Association Name: The Farm at Arapahoe County HOA
  • Association Fee Frequency: Monthly
  • Association Amenities: Clubhouse, Pool
  • Association Fee: 45
  • Association #2 Fee: 100
  • Association #2 Fee Frequency: Monthly
  • Association: Hillcrest at The Farm PCMS
  • Phone: 303-224-0004
  • Association Phone #2: 303-224-0004
  • Association: Yes

Association/Amenities

  • REC_AssociationFee2Annual: 1200.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 540.00
  • REC_AssociationFeeTotalAnnual: 1740.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 1
  • REC_AssociationURL: ttp://pcms.nete-farm-at-arapahoe-county-hoa/
  • REC_AssociationManagementType2: Professionally Managed
  • REC_AssociationURL2: http://pcms.net/hillcrest-at-the-farm/

Schools

  • Middle Or Junior School: Liberty

Lot Info

  • Parcel Number: 034003177
  • Lot Size Acres: 0.24
  • Fencing: Full
  • Building Area Total: 5678
  • Lot Features: Landscaped, Level, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 10454

Tax Info

  • Tax Year: 2018
  • Tax Annual Amount: 5419

MLS Schools

  • Elementary School: Fox Hollow
  • High School: Grandview

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 28, 2019
Closed on
Aug 18, 2020
Sold by
Wall William
Bought by
Dupont Tyler and Dupont Sarah
Seller's Agent
Jeffrey Kloenne
Compass - Denver
Buyer's Agent
Kyle Foster
Compass - Denver
List Price
$859,000
Sold Price
$835,000
Premium/Discount to List
-$24,000
-2.79%
Total Days on Market
209
Current Estimated Value
$1,065,673

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$230,673
Avg. Annual Appreciation
5.14%
Original Mortgage
$200,000
Outstanding Balance
$180,568
Interest Rate
2.93%
Mortgage Type
New Conventional
Estimated Equity
$883,521

Purchase Details

Closed on
Jan 4, 2017
Sold by
Dividend Llc
Bought by
Wall William

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$373,500
Interest Rate
4.03%
Mortgage Type
Future Advance Clause Open End Mortgage

Purchase Details

Closed on
Jun 16, 2011
Sold by
Wall Custom Homes Llc
Bought by
Dividend Llc

Purchase Details

Closed on
Jan 25, 2006
Sold by
Colonial Bank
Bought by
Wall Custom Homes Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$495,000
Interest Rate
6.19%
Mortgage Type
Construction
Source: Public Records

Similar Homes in the area

  • 5426 S Jasper Way, Centennial, CO 80015

    $899,000

    • 5 Beds
    • 5 Baths
    • 4,595 Sq Ft
    • 5426 S Jasper Way
    • Centennial, CO

    Welcome to this meticulously maintained & elegantly updated 5bd/5bth home in the prestigious Piney Creek community. Nestled w/in the highly sought after & award-winning Cherry Creek ISD, this spacious executive residence offers a perfect blend of luxury, comfort, and modern upgrades. Recent enhancements include interior & exterior paint, Class 4 impact-resistant roof, insulated garage doors, new

    Jim Loveridge Real Broker, LLC DBA Real

    Section Image
  • 5416 S Hannibal Ct, Centennial, CO 80015

    $825,000

    • 4 Beds
    • 4 Baths
    • 3,061 Sq Ft
    • 5416 S Hannibal Ct
    • Centennial, CO

    Welcome to this spacious 4-bed, 4-bath home in the sought-after Summit at Piney Creek, set on a quiet cul-de-sac and backing to a greenbelt for privacy and serenity. Gorgeous paved driveway and patio, sets this home apart. With nearly 3,100 sq ft above grade, this home features a sun-filled 2-story foyer, a formal livingroom vaulted ceiling, bay window and plantation shutters. The large dining

    Joni Jagger Coldwell Banker Realty 24

    Section Image
  • 6368 S Walden Way, Aurora, CO 80016

    $975,000

    • 5 Beds
    • 4.5 Baths
    • 4,212 Sq Ft
    • 6368 S Walden Way
    • Aurora, CO

    This well-kept home is the beauty you’ve been looking in The Farm! The property is ideally located on a quiet street and adjacent to open space and the trail head into the Piney Creek Trail System! The back yard and deck are amplified with spectacular western views and the perfect setting to optimize the outdoor kitchen (entertainer's paradise) while enjoying lots of space and vistas. This is a

    Michael Phelps Red Dragon Realty Inc

    Section Image
  • 19052 E Briarwood Dr, Centennial, CO 80016

    $1,249,000

    • 5 Beds
    • 4.5 Baths
    • 4,895 Sq Ft
    • 19052 E Briarwood Dr
    • Centennial, CO

    Welcome to this impeccably maintained single-family home in the highly sought-after Chapparal neighborhood! With nearly 5,000 square feet of finished living space, this stunning two-story home offers 5 bedrooms, 5 bathrooms, and a dedicated office. Situated on 1.28 acres, it boasts a garden-level basement and a wealth of luxurious features.The spacious kitchen opens to a heated sunroom, perfect

    Deborah Syke LIV Sotheby's International Realty

    Section Image
  • 5795 S Pagosa Way, Centennial, CO 80015

    $860,000

    • 6 Beds
    • 5 Baths
    • 4,476 Sq Ft
    • 5795 S Pagosa Way
    • Centennial, CO

    Welcome home to your modern farmhouse in a picture perfect neighborhood. This beautifully maintained home now features a newly renovated master bathroom and an upgraded laundry and mudroom with custom cabinetry. A brand new roof will be installed prior to closing, and all-new Anlin energy-efficient windows will be fully paid for at closing and professionally installed after the sale—offering the

    Nathan Crumb Keller Williams DTC

    Section Image
  • 5745 S Andes St, Aurora, CO 80015

    $825,000

    • 6 Beds
    • 4.5 Baths
    • 4,751 Sq Ft
    • 5745 S Andes St
    • Aurora, CO

    This stunning home is the culmination of a perfect floorplan, the ideal location, & extreme pride of ownership with tons of updates throughout. The interior is warm, bright, & welcoming with open concept living, high ceilings, neutral paint & an impressive double-sided staircase. On the main floor, you’ll love the formal living room featuring a cozy gas fireplace, a large formal dining room with

    The Awaka Group Keller Williams Trilogy

    Section Image
  • 15857 E Aberdeen Ave, Centennial, CO 80016

    $1,200,000

    • 5 Beds
    • 4.5 Baths
    • 6,264 Sq Ft
    • 15857 E Aberdeen Ave
    • Centennial, CO

    This semi-custom 5-bedroom home has all of the classic amenities including a grand entryway, living room and dining room but also boasts an exceptionally large, recently refinished, open floor plan perfect for get togethers or parties. It is decoratively fitted with a gas fireplace, art niches and luxury finishes with an archway leading to an elegant bar/hors d'oeuvre section with imported

    Jerry Glass Realty One Group Elevations, LLC

    Section Image
  • 16416 E Powers Place, Centennial, CO 80015

    $1,195,000

    • 4 Beds
    • 6 Baths
    • 6,036 Sq Ft
    • 16416 E Powers Place
    • Centennial, CO

    Welcome to your dream home! – An Unmatched Sanctuary of Style and Serenity located in the Cherry Creek school district with close proximity to Regis High School. This exquisite, fully renovated residence is thoughtfully upgraded with over $250,000 in high-end renovations. Designed for both luxurious living and effortless entertaining, this home is a true masterpiece, offering luxury, comfort, and

    Paula Pantaleo RE/MAX Leaders

    Section Image
  • 15723 E Orchard Place, Aurora, CO 80016

    $1,200,000

    • 5 Beds
    • 4.5 Baths
    • 4,463 Sq Ft
    • 15723 E Orchard Place
    • Aurora, CO

    Welcome to the Home of Your Dreams – Prime Lot, and Award-Winning Design. Located in Piney Creek Village community, this stunning 5-bedroom, 5-bath home is offering unparalleled privacy and natural beauty, bordered by open space on one side and a scenic walking trail along Piney Creek . Step into a grand entryway that leads to a formal living room featuring soaring ceilings and a massive

    Reem Saidi RE/MAX Leaders

    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
Dupont Tyler $835,000 Guardian Title
Wall William $547,000 Land Title Guarantee Co
Dividend Llc $417,000 Fidelity National Title Insu
Wall Custom Homes Llc $190,000 Stewart Title Of Denver
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Dupont Tyler $200,000
Open Dupont Tyler $510,400
Closed Dupont Tyler $200,000
Previous Owner Wall William $373,500
Previous Owner Wall Custom Homes Llc $300,000
Previous Owner Wall Custom Homes Llc $495,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/18/2020 08/18/20 Sold $835,000 -2.8% $148 / Sq Ft
07/23/2020 07/23/20 Pending -- -- --
06/01/2020 06/01/20 Price Changed $859,000 0.0% $152 / Sq Ft
06/01/2020 06/01/20 For Sale $859,000 +2.9% $152 / Sq Ft
05/31/2020 05/31/20 Off Market $835,000 -- --
04/30/2020 04/30/20 Price Changed $869,000 0.0% $154 / Sq Ft
04/30/2020 04/30/20 For Sale $869,000 +4.1% $154 / Sq Ft
04/09/2020 04/09/20 Off Market $835,000 -- --
03/05/2020 03/05/20 Price Changed $879,000 -2.3% $156 / Sq Ft
12/27/2019 12/27/19 For Sale $900,000 -- $160 / Sq Ft
Source: REcolorado®

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,582 $70,109 -- --
2023 $7,582 $70,109 $0 $0
2022 $5,332 $45,835 $0 $0
2021 $5,370 $45,835 $0 $0
2020 $5,773 $0 $0 $0
2019 $5,751 $49,564 $0 $0
2018 $5,419 $44,633 $0 $0
2017 $5,336 $44,633 $0 $0
2016 $5,954 $45,308 $0 $0
2015 $5,741 $45,308 $0 $0
2014 $5,598 $40,102 $0 $0
2013 -- $38,960 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 2998501

REcolorado®

APN: 2073-21-4-23-008