NOT LISTED FOR SALE

10534 Niagara St Lone Tree, CO 80124

Estimated Value: $5,293,270

7 Beds
9 Baths
11,500 Sq Ft
$460/Sq Ft Est. Value

Last Sold June 23, 2023

Last sale price $5,950,000 $517 Per Sq Ft

Est. 11% decrease in value since last sale

Current estimated payment $30,160/month

3 Days on Market

Highlights

  • Wine Cellar
  • Home Theater
  • Primary Bedroom Suite
  • Wildcat Mountain Elementary School Rated A
  • Outdoor Pool
  • City View

About This Home

As of June 2023

AN ABSOLUTE STUNNER! This truly impeccable, fully furnished, 5.34 acre "Colorado Mountain Contemporary Meets Texas Hill Country Estate" is nestled perfectly up against the gorgeous and protected Wildcat Mountain Reserve - offering some of the most incredible morning/evening scenes you could ever imagine...All. Year. Long! You simply will NOT find a home this close everything you need on a daily basis (Schools, Shopping, Dining, Entertaining, ETC) all while offering one of the most peaceful and private settings in all of Douglas County or even its neighboring counties, for that matter! Pictures/Words cannot even come close to describing the welcoming yet breathtaking feelings you will get when driving up to and stepping foot into this luxurious but still extremely comfortable home. This entertainer's DREAM home: Year round swimming in the outdoor oasis featuring a heated saltwater pool and hot tub - Chip/Pitch/Putt day and night on the lit 2,500+ sq foot artificial putting green - Play a full round of golf in the golf simulator bar - Rock climb, play basketball, even set up a pickleball court ball in the barn (also featuring a FULL guest house) - watch a movie in the 20+ person custom-built movie theater with a sound system that will blow your mind! Did we mention that each section of the home (inside and out) is fully set up with a Sonos system that provides that amazing ambience to whatever genre/party you are feeling! Flip through the pictures and explore the 3D walk through tour...When you decide that this is truly the home of your dreams, give me or your agent a call to set up a private showing of this PURE MASTERPIECE of a home! You will NOT be disappointed as you walk through and learn about the ALL STEEL construction frame and steel geo-peering (home was built by a commercial builder and built as such) - high-speed fiber internet ran over one-mile underground and now you can run 80 devices at full speed without interruption! PLUS, MUCH-MUCH MORE!

Last Agent to Sell the Property

Adam Ferguson

Coldwell Banker Realty 24 Brokerage Phone: 720-557-6360 License #100051012 Listed on: 05/28/2023

Coldwell Banker Realty 24

Last Buyer's Agent

Yu Zhang

Forever Home Real Estate LLC License #100073548

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,169

Year Built

  • Built in 2010 | Remodeled

Lot Details

  • 5.34 Acre Lot
  • Open Space
  • Property is Fully Fenced
  • Meadow
  • Private Yard
  • Garden
  • Property is zoned RR

HOA Fees

  • $6 Monthly HOA Fees

Parking

  • 12 Car Attached Garage
  • Driveway

Property Views

  • City
  • Mountain
  • Meadow

Home Design

  • Frame Construction
  • Spanish Tile Roof
  • Metal Siding
  • Stone Siding
  • Concrete Block And Stucco Construction

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Partially Furnished
  • Home Theater Equipment
  • Sound System
  • Wired For Data
  • Bar Fridge
  • Vaulted Ceiling
  • Ceiling Fan
  • Smart Window Coverings
  • Wine Cellar
  • Family Room with Fireplace
  • 5 Fireplaces
  • Dining Room
  • Home Theater
  • Home Office
  • Game Room
  • Utility Room
  • Home Gym
  • Carbon Monoxide Detectors

Kitchen

  • Eat-In Kitchen
  • Double Self-Cleaning Convection Oven
  • Cooktop with Range Hood
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Solid Surface Countertops
  • Trash Compactor
  • Disposal
  • Fireplace in Kitchen

Flooring

  • Wood
  • Carpet
  • Concrete
  • Tile

Bedrooms and Bathrooms

  • 7 Bedrooms | 4 Main Level Bedrooms
  • Fireplace in Bedroom
  • Primary Bedroom Suite
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Basement Fills Entire Space Under The House
  • Fireplace in Basement
  • Bedroom in Basement
  • 3 Bedrooms in Basement

Eco-Friendly Details

  • Smoke Free Home

Pool

  • Outdoor Pool
  • Spa
  • Pool Alarm

Outdoor Features

  • Balcony
  • Covered Patio or Porch
  • Outdoor Fireplace
  • Fire Pit
  • Exterior Lighting
  • Outdoor Gas Grill
  • Playground
  • Rain Gutters

Schools

  • Wildcat Mountain Elementary School
  • Rocky Heights Middle School
  • Rock Canyon High School

Utilities

  • Mini Split Air Conditioners
  • Humidifier
  • Forced Air Heating System
  • 220 Volts in Garage
  • Well
  • Tankless Water Heater
  • Water Softener
  • Septic Tank
  • High Speed Internet

Listing and Financial Details

  • Exclusions: To be determined.
  • Assessor Parcel Number R0475602

Community Details

Overview

  • Mcarthur Ranch HOA, Phone Number (303) 814-8006
  • Mcarthur Ranch Subdivision

Amenities

  • Laundry Facilities

Recreation

  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,169

Year Built

Built in 2010 | Remodeled

Lot Details

0

HOA Fees

$6 per month

Parking

12

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: One
  • Year Built: 2010
  • Above Grade Finished Sq Ft: 6030
  • Below Grade Sq Ft: 359
  • Exclusions: To be determined.
  • Living Area: 11500
  • Pets Allowed: Yes
  • Property Condition: Updated/Remodeled
  • SubdivisionName: McArthur Ranch
  • Ownership: Individual
  • Property Attached Yn: No
  • REC_BasementLevelBathrooms: 4
  • REC_BasementLevelBedrooms: 3
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00000
  • Attribution Contact: 720-557-6360
  • Special Features: VirtualTour

Interior Features

  • Appliances: Bar Fridge, Convection Oven, Cooktop, Dishwasher, Disposal, Double Oven, Dryer, Humidifier, Microwave, Oven, Range, Range Hood, Refrigerator, Self Cleaning Oven, Tankless Water Heater, Trash Compactor, Washer, Water Softener, Wine Cooler
  • Fireplaces: 5
  • Interior Amenities: Audio/Video Controls, Breakfast Bar, Ceiling Fan(s), Eat-in Kitchen, Five Piece Bath, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Smart Window Coverings, Smoke Free, Solid Surface Counters, Sound System, Hot Tub, Synthetic Counters, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar, Wired for Data
  • Flooring: Carpet, Concrete, Tile, Wood
  • Fireplace Features: Basement, Bedroom, Family Room, Kitchen, Outside
  • Full Bathrooms: 7
  • Half Bathrooms: 2
  • Basement: Finished, Full
  • Basement: Yes
  • Total Bedrooms: 7
  • Below Grade Sq Ft: 5470
  • Main Level Bathrooms: 5
  • Main Level Bedrooms: 4
  • Other Equipment: Home Theater

Exterior Features

  • Roof: Spanish Tile
  • Construction Materials: Block, Concrete, Frame, Metal Siding, Stone, Stucco
  • View: City, Meadow, Mountain(s)
  • Exterior Features: Balcony, Barbecue, Fire Pit, Garden, Gas Grill, Gas Valve, Lighting, Playground, Private Yard, Rain Gutters, Spa/Hot Tub
  • Patio and Porch Features: Covered, Front Porch, Patio
  • Pool Features: Outdoor Pool, Private

Garage/Parking

  • Parking Features: 220 Volts, Asphalt, Concrete
  • Attached Garage: Yes
  • Garage Spaces: 12
  • Total Parking Spaces: 12
  • REC_ParkingCount: 2

Utilities

  • Sewer: Septic Tank
  • Cooling: Air Conditioning-Room
  • Heating: Forced Air
  • Water Source: Well
  • Laundry Features: Sink, Common Area
  • Security: Carbon Monoxide Detector(s), Pool Alarm

Condo/Co-op/Association

  • Association Name: McArthur Ranch HOA
  • Association Fee Frequency: Annually
  • Association Amenities: Trail(s)
  • Association Fee: 75
  • Phone: 303-814-8006
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 75.00
  • REC_AssociationFeeTotalAnnual: 75.00
  • REC_AssociationManagementType: Voluntary
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationURL: www.mcarthurranch.org

Schools

  • Middle Or Junior School: Rocky Heights

Lot Info

  • Parcel Number: R0475602
  • Lot Size Acres: 5.34
  • Fencing: Full
  • Building Area Total: 11859
  • Lot Features: Meadow, Open Space
  • Lot Size Sq Ft: 232610.4

Rental Info

  • Furnished: Partially

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 11169

MLS Schools

  • Elementary School: Wildcat Mountain
  • High School: Rock Canyon

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 28, 2023
Closed on
Jun 23, 2023
Sold by
Garrett Eric
Bought by
Liu Chongyu and Yang Shuo
Seller's Agent
Adam Ferguson
Coldwell Banker Realty 24
Buyer's Agent
Yu Zhang
Forever Home Real Estate LLC
List Price
$5,950,000
Sold Price
$5,950,000
Total Days on Market
3
Views
99
Current Estimated Value
$5,293,270

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$656,730
Avg. Annual Appreciation
-3.41%

Purchase Details

Closed on
Aug 3, 2020
Sold by
Miller Cregg C and Miller Daphanie P
Bought by
Garrett Eric and Garrett Rhonda

Purchase Details

Closed on
Sep 19, 2008
Sold by
Elfstrom Evelyn M
Bought by
Miller Gregg C and Miller Daphanie P

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
6.5%
Mortgage Type
Unknown

Purchase Details

Closed on
Apr 18, 2008
Sold by
Elfstrom Evelyn Mae
Bought by
Elfstrom Evelyn M

Purchase Details

Closed on
Aug 18, 2006
Sold by
The John Douglas Elfstrom Trust
Bought by
Elfstrom John D and Elfstrom Evelyn M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$260,300
Interest Rate
6.75%
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
Liu Chongyu -- None Listed On Document
Liu Chongyu $5,950,000 Land Title
Garrett Eric $2,700,000 Land Title Guarantee Co
Miller Gregg C $670,000 Land Title Guarantee Company
Elfstrom Evelyn M -- None Available
Elfstrom John D -- Security Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Miller Gregg C $397,700
Previous Owner Miller Gregg C $230,397
Previous Owner Miller Gregg C $196,761
Previous Owner Miller Gregg C $417,000
Previous Owner Elfstrom John D $260,300
Previous Owner The John Douglas Elfstrom Trust $112,600
Previous Owner Elfstrom John D $122,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/23/2023 06/23/23 Sold $5,950,000 0.0% $517 / Sq Ft
05/31/2023 05/31/23 Pending -- -- --
05/28/2023 05/28/23 For Sale $5,950,000 -- $517 / 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 $16,412 $194,310 $56,950 $137,360
2023 $16,589 $194,310 $56,950 $137,360
2022 $11,169 $134,230 $26,370 $107,860
2021 $11,628 $134,230 $26,370 $107,860
2020 $10,941 $129,340 $25,820 $103,520
2019 $10,986 $129,340 $25,820 $103,520
2018 $9,648 $111,720 $21,670 $90,050
2017 $8,954 $111,720 $21,670 $90,050
2016 $10,212 $124,870 $23,880 $100,990
2015 $10,459 $124,870 $23,880 $100,990
2014 $11,286 $125,880 $23,880 $102,000
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 3174488

REcolorado®

APN: 2231-201-03-001