Check Availability
Frederick 80504
9147 Harlequin Cir
$587,000
↓ $17K (2.8%)
● House - For Sale

9147 Harlequin Cir

Frederick, CO 80504
bedrooms
5 Beds
bathrooms
3 Baths
square feet
3,209 Ft²
$3,155
Est. Monthly
5.16%
Cap Rate

About This Property

Peace & privacy welcome you upon entering this semi-custom 5 bed, 3 bath, ranch home. NO HOA or Metro District tax! Top percs: NEW A/C ($12k) 2025, all air ducts & carpets professionally cleaned. NEW Roof 2019 class 4 shingles. Water heater, washer & dryer NEW in 2017. Kitchen is functional & stylish w/stainless appliances, tile counters & backsplash, abundant cabinet/counter space, breakfast bar seating 4-6, & a separate dining room with entrance into the backyard/deck. Soaring vaulted ceilings adorn the open living room with oak floors, backyard views, gas fireplace, & lighted decorative niches. Primary en suite tucked away with private entry to backyard/deck & includes a gorgeous 5-piece bath w/ jetted tub, large tile shower, & walk-in closet. Solar panels installed 2019 & cost $199/month; xadd $23K to offer price for seller-paid solar panels. Fully-fenced backyard is your private oasis with pear, oak, maple, grapes, roses, & irises. Finished basement has large family/rec room, laundry, several storage areas, one lined with shelving. Two additional basement bedrooms, one that functions well as a second primary bedroom with full bath & radiant flooring heat. Oversized 2-car garage with shelving. Total electric, gas, & solar payment for July was only $276. Highly coveted neighborhood has Front Range views & is near great schools, coffee, dining, groceries, & Bella Rosa Golf Course.
Unit Size
3,209 Ft²
Days on Market
-
Land Size
0.16 acres
Price per sqft
$183
Property Type
House
Property Taxes
$273
HOA Dues
-
Year Built
2003

Listed By

Robin Glasener
Sellstate Altitude Property Group

Payment Calculator

Cap Rate Calculator

Last updated: 9 months ago (IRES MLS #1038391)

Price History

Date / Event Date Event Price
Dec 11, 2025 Price Decreased $587,000
↓ $17K (2.8%)
Price Decreased
Sep 30, 2025 Price Decreased $604,000
↓ $5K (0.8%)
Price Decreased
Sep 6, 2025 Price Decreased $609,000
↓ $6K (1%)
Price Decreased
Aug 29, 2025 Price Decreased $615,000
↓ $4K (0.7%)
Price Decreased
Aug 13, 2025 Price Decreased $619,000
↓ $10K (1.6%)
Price Decreased
Show More

Property Highlights

Garage
Air Conditioning
Fireplace
Parking Details
Has Garage
Attached Garage
Parking Features: Garage Door Opener
Garage Spaces: 2
Interior Details
Full Bathrooms: 3
Interior Features: High Speed Internet, Open Floorplan, Pantry, Walk-In Closet(s), Separate Dining Room, Cathedral/Vaulted Ceilings, Stain/Natural Trim, Two Primary Suites, 9ft+ Ceilings, Split Bedroom Floor Plan
Appliances: Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal, Electric Range/Oven
Laundry Features: Washer Hookup, In Basement
Has Fireplace
Fireplace Features: Gas, Living Room
Basement: Full, Partially Finished
Exterior Details
Square Footage: 3209
Square Footage Source: $0
Property Condition: Not New, Previously Owned
Architectural Style: Ranch, Contemporary/Modern
Year Built: 2003
Building Area Total: 1858
Levels: One
Window Features: Window Coverings, Double Pane Windows
Construction Materials: Stucco
Patio and Porch Features: Patio
Lot Features: Curbs, Gutters, Sidewalks, Within City Limits
Lot Size Area: 7000
Lot Size Units: Square Feet
Lot Size Acres: 0.16
Lot Size Square Feet: 7000
Water Source: City Water, Frederick
Financial Details
Tax Annual Amount: $3,272
Utilities Details
Cooling Type: Central Air
Heating Type: Forced Air
Sewer : City Sewer

Building Info

Overview

    General

  • Year Built: 2003
  • Effective Year Built: 2003
  • Building Count: 1
  • Bedroom Count: 5
  • Bathroom Count: 3
  • Full Bathrooms: 3
  • Partial Bathrooms: 3
  • Bathroom Plumbing Fixtures: 15
  • Building Condition: 0
  • Building Quality: 0
  • Construction Type: 6
  • Building Style: 11
  • Exterior Walls Type: 23
  • Interior Walls Type: 3
  • Roof Shape Type: 0
  • Roof Cover Type: 3
  • Floor Count: 100
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 6
  • Basement Area: 1,858
  • Garage Type: 1
  • Garage Square Area: 484
  • Parking Space Count: 2
  • Patio Type: 60
  • Porch Type: 36
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 7,000
  • Total Building Area: 4,200
  • Gross Building Area: 4,200
  • Building Area: 3,209
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 3,209
  • Heating Fuel Type: 0

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: NONAME CREEK WEST
  • Land Acres: 0000000161
  • Standard Land Use Code: 1001
  • County Land Use Code: 1212
  • Legal Description 1: FRE NNCW L9 BLK9 NONAME CREEK WEST

Neighborhood

  • School District Name: St. Vrain Valley School District RE 1J
  • Census Tract: 002018

Geography

  • Assessors Map Reference: MAP 2454
  • Account Number: R0741801
  • Parcel: R0741801
  • Block: 9
  • Lot: 9
  • Meridian: SEC 13 TWN 2N RNG 68W
  • Latitude: 40.1358
  • Longitude: -104.949

    Address

  • Full Address: 9147 Harlequin Cir
  • Address - House Number: 9147
  • Address - Street Name: Harlequin
  • Address - Suffix Type: Cir
  • State: CO
  • City Name: Longmont
  • Carrier Code: R037
  • 4-Digit Zip Code: 9754
  • Zip Code: 80504

Valuation

    Tax

  • Total Area: 3,716
  • Tax Year: 2023
  • Tax Amount: $313,808
  • Initial Tax Delinquent Year: 2021
  • Tax Rate Code Area: 1459

    Appraisal Valuation

  • Standard Deviation: 0.1313
  • Valuation Date: Apr 03, 2024
  • Confidence Score: 85
  • Final Value: 643,301
  • High Value: 727,775
  • Low Value: 558,828

    Market Valuation

  • Market Total Value: $623,943
  • Market Land Value: $135,000
  • Market Improvement Value: $488,943

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $41,810
  • Assessed Land Value: $9,050
  • Assessed Improvements Value: $32,760

    Sales

  • Current Sale Contract Date: Aug 14, 2009
  • Current Sale Recording Date: Aug 17, 2009
  • Current Sale Price:
  • Current Sale Document Type: 71
  • Current Sale Input Document Number: 3643022
  • Previous Sale Recording Date: May 11, 2009
  • Previous Sale Contract Date: Apr 27, 2009
  • Previous Sale Amount: $189,000
  • Previous Sale Document Type: 68

    Financing

  • First Mortgage Financing Type: FIX
Data used for valuation calculations is provided by RealtyHop, and other third party sources

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Frederick


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals



Frequently Asked Questions

When was property at 9147 Harlequin Circle built and last sold?
The property at 9147 Harlequin Circle was built in 2003 and last sold on Aug 14, 2009 for $239,000.
How much is this home worth?
The estimated value of the home located at 9147 Harlequin Circle is $592,870.
What are some comparable homes to 9147 Harlequin Circle?
There are currently no comparable homes to 9147 Harlequin Circle.