NOT LISTED FOR SALE

9100 Harlequin Cir Frederick, CO 80504

Estimated Value: $703,000 - $760,000

5 Beds
4.5 Baths
3,788 Sq Ft
$192/Sq Ft Est. Value

Last Sold February 29, 2024

Last sale price $695,000 $183 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $4,400/month

14 Days on Market

Highlights

  • Outdoor Pool
  • Open Floorplan
  • Deck
  • Primary Bedroom Suite
  • Fireplace in Primary Bedroom
  • Contemporary Architecture

About This Home

As of February 2024

This Gorgeous Home features five bedrooms, three full bathrooms (upper level), one 3/4 bathroom (basement), and a half bath (main Level). The open floor plan provides for easy entertaining. The Kitchen has ample cabinet space, stainless steel appliances, and granite countertops with a breakfast bar. There's plenty of room for formal dining. You will relax and enjoy the large living room next to the fireplace. The Primary Bedroom also features a two-sided fireplace when you want to enjoy those quiet moments with your significant other or enjoy a bath under the warmth of your fireplace. The basement has been professionally finished and features a custom wet bar, media room, large bedroom, and 3/4 bath. The third stall of the 3-car garage has been converted into a work studio with a separate entrance for those who prefer to work from home. The lot is over 18,000 square feet (almost a half acre) and features a fenced garden area and an above-ground swimming pool. No HOA fees to deal with!

Last Agent to Sell the Property

Paul Aragon

Aragon Realty Group Brokerage Email: Paul@TheAragonGroup.net,303-525-8915 License #001312797 Listed on: 01/04/2024

Last Buyer's Agent

Katherine McCaslin

Real Broker, LLC DBA Real License #100072124

Real Broker, LLC DBA Real

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,849

Year Built

  • Built in 2012 | Remodeled

Lot Details

  • 0.42 Acre Lot
  • Cul-De-Sac
  • Northwest Facing Home
  • Partially Fenced Property
  • Landscaped
  • Level Lot
  • Front and Back Yard Sprinklers
  • Irrigation
  • Garden
  • Grass Covered Lot

Parking

  • 3 Car Attached Garage
  • Exterior Access Door

Home Design

  • Contemporary Architecture
  • Frame Construction
  • Composition Roof
  • Cement Siding
  • Stone Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • High Ceiling
  • Ceiling Fan
  • Gas Log Fireplace
  • Double Pane Windows
  • Entrance Foyer
  • Living Room with Fireplace
  • 2 Fireplaces

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Self-Cleaning Oven
  • Range
  • Microwave
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite

Finished Basement

  • Basement Fills Entire Space Under The House
  • Interior Basement Entry
  • 1 Bedroom in Basement

Eco-Friendly Details

  • Smoke Free Home

Outdoor Features

  • Outdoor Pool
  • Balcony
  • Deck

Schools

  • Legacy Elementary School
  • Coal Ridge Middle School
  • Frederick High School

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts
  • 110 Volts
  • Natural Gas Connected
  • Gas Water Heater
  • Cable TV Available

Community Details

  • No Home Owners Association
  • No Name Creek Subdivision

Listing and Financial Details

  • Exclusions: Washer/Dryer Garage Fridge, Bar Fridge, Garage freezer, Hot tub, All TV’s, Outdoor Speakers, outdoor Cameras, Stereo receiver in basement
  • Assessor Parcel Number R0742601

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,849

Year Built

Built in 2012 | Remodeled

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Contemporary
  • Structure Type: House
  • Levels: Two
  • Year Built: 2012
  • Above Grade Finished Sq Ft: 2680
  • Exclusions: Washer/Dryer Garage Fridge, Bar Fridge, Garage freezer, Hot tub, All TV’s, Outdoor Speakers, outdoor Cameras, Stereo receiver in basement
  • Living Area: 3788
  • Pets Allowed: Yes
  • Property Condition: Updated/Remodeled
  • SubdivisionName: No Name Creek
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 1
  • REC_BelowGradeUnfinishedArea: 48.00
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 3
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.95205
  • Attribution Contact: Paul@TheAragonGroup.net,303-525-8915
  • Special Features: None

Interior Features

  • Appliances: Dishwasher, Disposal, Gas Water Heater, Microwave, Oven, Range, Refrigerator, Self Cleaning Oven
  • Fireplaces: 2
  • Interior Amenities: Breakfast Nook, Ceiling Fan(s), Eat-in Kitchen, Entrance Foyer, Five Piece Bath, Granite Counters, High Ceilings, Open Floorplan, Pantry, Primary Suite, Smoke Free
  • Flooring: Carpet, Laminate, Tile, Wood
  • Fireplace Features: Gas Log, Living Room, Primary Bedroom
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Basement: Finished, Full, Interior Entry
  • Basement: Yes
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1108
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: Northwest
  • Foundation Details: Concrete Perimeter
  • Roof: Composition
  • Construction Materials: Cement Siding, Frame, Stone
  • Exterior Features: Balcony, Garden
  • Patio and Porch Features: Deck
  • Pool Features: Outdoor Pool
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete, Exterior Access Door, Finished
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Electric: 110V, 220 Volts

Condo/Co-op/Association

  • Association: No
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 0.00
  • REC_AssociationFeeTotalAnnual: 0.00
  • REC_MultipleAssociationsYN: 0

Schools

  • Middle Or Junior School: Coal Ridge

Lot Info

  • Parcel Number: R0742601
  • Lot Size Acres: 0.42
  • Fencing: Partial
  • Building Area Total: 3836
  • Lot Features: Cul-De-Sac, Irrigated, Landscaped, Level, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 18341
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 3849

MLS Schools

  • Elementary School: Legacy
  • High School: Frederick

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 4, 2024
Closed on
Feb 29, 2024
Sold by
Willis Lindsay Rae and Willis Gwen
Bought by
Hanson Dustin Jon
Seller's Agent
Paul Aragon
Aragon Realty Group
Buyer's Agent
Katherine McCaslin
Real Broker, LLC DBA Real
List Price
$730,000
Sold Price
$695,000
Premium/Discount to List
-$35,000
-4.79%
Views
51
Current Estimated Value
$726,690

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$31,690
Avg. Annual Appreciation
4.17%
Original Mortgage
$625,500
Outstanding Balance
$616,251
Interest Rate
6.6%
Mortgage Type
New Conventional
Estimated Equity
$119,644

Purchase Details

Closed on
Mar 29, 2019
Sold by
Arriaga Julio and Mestas Lillian
Bought by
Willis Lindsay Rae and Willis Rudolph

Home Financials for this Owner

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

Purchase Details

Listed on
Jul 27, 2018
Closed on
Aug 31, 2018
Sold by
Kruchten Joshua P and Kruchten Emily M
Bought by
Arriaga Julio and Mestas Lillian
Seller's Agent
Michelle Bodin
LIV Sotheby's Intl Realty
Buyer's Agent
Lacey Valdez
Rockwell Realty
List Price
$445,000
Sold Price
$450,000
Premium/Discount to List
$5,000
1.12%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.39%
Original Mortgage
$365,079
Interest Rate
4.5%
Mortgage Type
FHA

Purchase Details

Closed on
Dec 28, 2012
Sold by
Saint Aubyn Homes Llc
Bought by
Kruchten Joshua P and Kruchten Emily M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$289,275
Interest Rate
3.35%
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
Hanson Dustin Jon $695,000 Land Title Guarantee
Willis Lindsay Rae $480,000 8Z Title
Arriaga Julio $450,000 Heritage Title Co
Kruchten Joshua P $304,500 Heritage Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hanson Dustin Jon $625,500
Previous Owner Willis Lindsay Rae $467,500
Previous Owner Willis Willis Lindsay Rae Lindsay Rae $456,000
Previous Owner Arriaga Julio $365,079
Previous Owner Kruchten Joshua P $289,275
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/29/2024 02/29/24 Sold $695,000 0.0% $183 / Sq Ft
01/19/2024 01/19/24 Pending -- -- --
01/16/2024 01/16/24 Price Changed $695,000 -4.8% $183 / Sq Ft
01/04/2024 01/04/24 For Sale $730,000 +62.2% $193 / Sq Ft
11/29/2019 11/29/19 Off Market $450,000 -- --
08/31/2018 08/31/18 Sold $450,000 +1.1% $169 / Sq Ft
08/01/2018 08/01/18 Pending -- -- --
07/27/2018 07/27/18 For Sale $445,000 -- $167 / 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
2025 $4,494 $46,360 $7,190 $39,170
2024 $4,494 $46,360 $7,190 $39,170
2023 $4,431 $47,300 $9,130 $38,170
2022 $3,849 $32,220 $5,910 $26,310
2021 $3,514 $33,140 $6,080 $27,060
2020 $3,500 $33,270 $4,220 $29,050
2019 $3,550 $33,270 $4,220 $29,050
2018 $2,984 $30,040 $3,740 $26,300
2017 $3,050 $30,040 $3,740 $26,300
2016 $2,791 $27,040 $3,180 $23,860
2015 $2,705 $27,040 $3,180 $23,860
2014 $2,226 $22,270 $2,390 $19,880
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 4514104

REcolorado®

APN: R0742601