$580,000
UNDER CONTRACT $10K PRICE DROP

9004 Harlequin Cir Frederick, CO 80504

Estimated payment $3,337/month

Total Views 1,951
3 Beds
2.5 Baths
2,813 Sq Ft
$206 Price per Sq Ft

Highlights

  • Solar Power System
  • Deck
  • Vaulted Ceiling
  • Open Floorplan
  • Contemporary Architecture
  • Wood Flooring

About This Home

This stunning home beckons you in from the beautiful landscaping to the refreshed interior. As you enter, you are greeted by clean lines, gleaming hardwood floors, an open floor plan yet with defined spaces for living. The open kitchen is made for creating delicious meals and hosting gatherings. The gourmet kitchen is a chef's dream, complete with upgraded stainless steel appliances, granite counters, a spacious kitchen island and streaming sunlight. The generous living room boasts new hardwood floors, a cozy fireplace and space for lingering. The formal dining area enhances the open floor plan. Upstairs you will find a spacious primary suite with vaulted ceilings, a 5-piece bath and walk in closet with well thought-out built-in shelving. You will also find 2 additional bedrooms, loft, full bath and laundry upstairs. The bonus enclosed loft area could be an office or potential 4th bedroom. Linger in the truly impressive yard that is a dream oasis made for relaxing with extensive patios, room to barbecue, a gazebo, gorgeous gardens and play space too. The yard will take you away. There is plenty of space for storage and expanding with a sunlight filled basement, storage shed and oversized 4 car garage. With easy access to local parks and recreational areas, this home offers the perfect balance of tranquility and convenience.

Listing Agent

Andrea Medaugh

Bold Realty Listed on: 10/10/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,545

Year Built

  • Built in 2012

Lot Details

  • 7,300 Sq Ft Lot
  • West Facing Home
  • Wood Fence
  • Level Lot
  • Sprinkler System
  • Landscaped with Trees

Parking

  • 4 Car Attached Garage
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Stone

Interior Spaces

  • 2,813 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Vaulted Ceiling
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Great Room with Fireplace
  • Dining Room
  • Home Office
  • Loft
  • Unfinished Basement
  • Basement Fills Entire Space Under The House
  • Fire and Smoke Detector

Kitchen

  • Double Self-Cleaning Oven
  • Electric Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Eco-Friendly Details

  • Energy-Efficient Thermostat
  • Solar Power System

Outdoor Features

  • Deck
  • Patio
  • Outdoor Storage

Schools

  • Centennial Elementary School
  • Coal Ridge Middle School
  • Mead High School

Utilities

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

Community Details

  • No Home Owners Association
  • Noname Creek West Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0738601

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,545

Year Built

Built in 2012

Lot Details

0

Parking

4

Listing Details

  • Inclusions: Window Coverings,Electric Range/Oven,Self-Cleaning Oven,Double Oven,Dishwasher,Refrigerator,Clothes Washer,Clothes Dryer,Microwave,Garage Door Opener,Disposal,Smoke Alarm(s)
  • Year Built: 2012
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.17
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Noname Creek West
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Efficiency: Thermostat
  • Green Power: Solar PV Leased
  • Building Stories: 2
  • Power Production Type: Photovoltaics
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 2813
  • Special Features: 4224
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
  • Accessibility Features: Level Lot
  • Has Basement: Full, Unfinished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace Features: Gas, Great Room
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, High Speed Internet, Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Loft, Kitchen Island
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Hardwood
  • IRESDS_HasFamilyRoom: No
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Hardwood
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: 5 Piece Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Wood
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Level
  • View: No
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame, Stone
  • Direction Faces: West
  • Other Structures: Storage
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Parking Features: Garage Door Opener, Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: City Sewer
  • Water Source: City Water, City of Frederick
  • Gas Company: Natural Gas

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

  • Elementary School: Centennial
  • HighSchool: Mead
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Coal Ridge

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 7300
  • Parcel #: R0738601
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 3545

Multi Family

Map

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

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 $3,545 $35,230 $7,190 $28,040
2024 $3,545 $35,230 $7,190 $28,040
2023 $3,400 $38,090 $9,130 $28,960
2022 $2,891 $27,700 $5,910 $21,790
2021 $2,919 $28,500 $6,080 $22,420
2020 $2,909 $28,630 $4,220 $24,410
2019 $2,952 $28,630 $4,220 $24,410
2018 $2,509 $25,260 $3,740 $21,520
2017 $2,565 $25,260 $3,740 $21,520
2016 $2,351 $22,780 $3,180 $19,600
2015 $2,279 $22,780 $3,180 $19,600
2014 $1,859 $18,600 $2,390 $16,210
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/24/2025 10/24/25 Price Changed $580,000 -1.7% $206 / Sq Ft
10/10/2025 10/10/25 For Sale $590,000 +137.4% $210 / Sq Ft
01/28/2019 01/28/19 Off Market $248,550 -- --
01/17/2013 01/17/13 Sold $248,550 +0.1% $91 / Sq Ft View Prior Sale
12/18/2012 12/18/12 Pending -- -- --
11/15/2012 11/15/12 For Sale $248,300 -- $91 / Sq Ft
Source: IRES MLS

Purchase History

Date Type Sale Price Title Company
Special Warranty Deed $248,550 Heritage Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $223,695 New Conventional
Source: Public Records

Source: IRES MLS

MLS Number: 1045482

IRES MLS

APN: R0738601