See Home Value
Frederick 80504
9004 Harlequin Cir
$580,000
● House - Off Market

9004 Harlequin Cir

Longmont, CO 80504
bedrooms
3 Beds
bathrooms
2 Baths, 1 Half Bath
square feet
1,953 Ft²
$3,144
Est. Monthly

About This Property

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.
Unit Size
1,953 Ft²
Days on Market
-
Land Size
0.17 acres
Price per sqft
$297
Property Type
House
Property Taxes
$295
HOA Dues
-
Year Built
2012

Payment Calculator

Cap Rate Calculator

Last updated: 10 months ago (IRES MLS #1045482)

Price History

Date / Event Date Event Price
Dec 12, 2025 Sold
Sold
Oct 26, 2025 Price Decreased $580,000
↓ $10K (1.7%)
Price Decreased
Oct 10, 2025 Listed by Bold Realty $590,000
Listed by Bold Realty
Jan 18, 2013 Sold
Sold
Nov 15, 2012 Listed by Bold Realty $248,300
Listed by Bold Realty

Property Highlights

Garage
Air Conditioning
Fireplace

Building Info

Overview

    General

  • Year Built: 2012
  • Effective Year Built: 2012
  • Building Count: 1
  • Bedroom Count: 3
  • Bathroom Count: 3
  • Full Bathrooms: 3
  • Partial Bathrooms: 3
  • Bathroom Plumbing Fixtures: 13
  • Building Condition: 0
  • Building Quality: 0
  • Construction Type: 17
  • Building Style: 40
  • Exterior Walls Type: 17
  • Interior Walls Type: 3
  • Roof Shape Type: 0
  • Roof Cover Type: 3
  • Floor Count: 200
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 9
  • Basement Area: 860
  • Garage Type: 1
  • Garage Square Area: 840
  • Parking Space Count: 3
  • Patio Type: 0
  • Porch Type: 36
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 7,300
  • Total Building Area: 3,653
  • Gross Building Area: 3,653
  • Building Area: 1,953
  • Building Area Measurement: L

    Heating and Cooling

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

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: NONAME CREEK WEST
  • Land Acres: 0000000168
  • Standard Land Use Code: 1001
  • County Land Use Code: 1212
  • Legal Description 1: FRE NNCW L2 BLK8 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: R0738601
  • Parcel: R0738601
  • Block: 8
  • Lot: 2
  • Meridian: SEC 13 TWN 2N RNG 68W
  • Latitude: 40.132
  • Longitude: -104.95

    Address

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

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $339,976
  • Tax Rate Code Area: 1459

    Appraisal Valuation

  • Standard Deviation: 0.1196
  • Valuation Date: Apr 03, 2024
  • Confidence Score: 87
  • Final Value: 588,833
  • High Value: 659,305
  • Low Value: 518,361

    Market Valuation

  • Market Total Value: $563,037
  • Market Land Value: $135,000
  • Market Improvement Value: $428,037

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $37,730
  • Assessed Land Value: $9,050
  • Assessed Improvements Value: $28,680

    Sales

  • Current Sale Contract Date: Jan 09, 2013
  • Current Sale Recording Date: Jan 18, 2013
  • Current Sale Price:
  • Current Sale Document Type: 68
  • Current Sale Input Document Number: 3904080
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 9004 Harlequin Circle built and last sold?
The property at 9004 Harlequin Circle was built in 2012 and last sold on Jan 9, 2013 for $248,550.
How much is this home worth?
The estimated value of the home located at 9004 Harlequin Circle is $557,893.
What are some comparable homes to 9004 Harlequin Circle?
There are currently no comparable homes to 9004 Harlequin Circle.