Best priced house in the neighborhood! Spacious 4-Bedroom Home with Oversized 3-Car Garage
Built in 2012, this beautiful 2,195 sq. ft. home offers a thoughtful layout with all four bedrooms conveniently located upstairs along with the laundry room. The primary suite features a luxurious 5-piece en-suite bath, while an additional full bath serves the other bedrooms.
On the main level, enjoy an open and inviting floor plan complete with a half bath for guests. The oversized three-car garage provides plenty of space for vehicles, storage, or a workshop.
The home also includes a 912 sq. ft. unfinished basement—perfect for storage or future expansion to suit your needs.
This property combines comfort, functionality, and room to grow, making it an excellent choice for your next home.
Sold for $561,500
$561,500
9006 Harlequin Circle, Longmont, CO 80504
4beds
3,107sqft
Single Family Residence
Built in 2012
6,969 Square Feet Lot
$564,400 Zestimate®
$181/sqft
$3,038 Estimated rent
Home value
$564,400
$536,000 - $593,000
$3,038/mo
Zestimate® history
Owner options
List your home for rent
$3,038/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,038/mo
Rent Zestimate®
Refinance and save
$3,347/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,347/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Thoughtful layoutHalf bath for guests
Zillow last checked:
Listing updated:
Listed by:
Jeremy Banks 720-261-7295 Jeremy@TheBanksHomeTeam.com,
Elevate Property Group LLC
Bought with:
Alex Jacobson, 100074226
Compass - Boulder
Source: REcolorado as distributed by MLS GRID,MLS#: 9467524
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bedroom
- Level: Upper
Bathroom
- Level: Upper
Bathroom
- Level: Main
Other
- Level: Upper
Other
- Level: Upper
Family room
- Level: Main
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Microwave, Oven, Range, Refrigerator
Features
- Basement: Unfinished
Interior area
- Total structure area: 3,107
- Total interior livable area: 3,107 sqft
- Finished area above ground: 2,195
- Finished area below ground: 0
Property
Parking
- Total spaces: 3
- Parking features: Garage - Attached
- Attached garage spaces: 3
Features
- Levels: Two
- Stories: 2
Lot
- Size: 6,969 Square Feet
Details
- Parcel number: R0738701
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame
- Roof: Composition
Condition
- Year built: 2012
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: Noname Creek
HOA
- Has HOA: No
Location
- Region: Frederick
Financial & listing details
- Price per square foot: $181/sqft
- Tax assessed value: $576,354
- Annual tax amount: $3,617
- Date on market: 8/17/2025
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: Sellers Personal Property
- Ownership: Individual
Price history
| Date | Event | Price |
|---|---|---|
| 1/26/2026 | Sold | $561,500-3%$181/sqft |
Source:  REcolorado as distributed by MLS GRID #9467524 Report a problem | ||
| 12/22/2025 | Pending sale | $579,000$186/sqft |
Source: REcolorado as distributed by MLS GRID #9467524 Report a problem | ||
| 12/3/2025 | Price change | $579,000-1.7%$186/sqft |
Source: REcolorado as distributed by MLS GRID #9467524 Report a problem | ||
| 11/5/2025 | Price change | $589,000-1.7%$190/sqft |
Source: REcolorado as distributed by MLS GRID #9467524 Report a problem | ||
| 9/30/2025 | Price change | $599,000-1%$193/sqft |
Source: REcolorado as distributed by MLS GRID #9467524 Report a problem | ||
| 8/18/2025 | Listed for sale | $605,000+141.3%$195/sqft |
Source: REcolorado as distributed by MLS GRID #9467524 Report a problem | ||
| 12/21/2012 | Sold | $250,750$81/sqft |
Source:  IRES as distributed by MLS GRID #692494 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $4,033 +11.5% | $35,270 -2.1% |
| 2025 | $3,617 +4.3% | $36,020 -6.2% |
| 2024 | $3,469 +17.2% | $38,420 -0.9% |
| 2023 | $2,961 -0.9% | $38,780 +36.7% |
| 2022 | $2,989 +0.5% | $28,370 -2.8% |
| 2021 | $2,973 | $29,180 -0.3% |
| 2020 | $2,973 +15.6% | $29,260 |
| 2019 | $2,571 -14.8% | $29,260 +13.1% |
| 2018 | $3,017 +17.3% | $25,880 |
| 2017 | $2,571 -2.2% | $25,880 +11.6% |
| 2016 | $2,628 +13.2% | $23,200 |
| 2015 | $2,321 +22.4% | $23,200 +22.2% |
| 2014 | $1,897 | $18,980 |
| 2013 | -- | $18,980 +528.5% |
| 2012 | -- | $3,020 |
| 2011 | -- | $3,020 +762.9% |
| 2010 | -- | $350 |
| 2009 | -- | $350 |
| 2008 | -- | $350 |
| 2007 | -- | $350 |
| 2006 | -- | $350 |
| 2005 | -- | $350 |
| 2004 | -- | $350 |
Find assessor info on the county website
Neighborhood: 80504
Nearby homes
- $580,0003 bd3 ba2.8k sqft9004 Harlequin Cir, Frederick, CO 80504Sold
- $683,7005 bd4 ba3.2k sqft9008 Harlequin Cr, Frederick, CO 80504Off Market
- $569,7005 bd3 ba1.6k sqft9105 Harlequin Cir, Frederick, CO 80504Off Market
- $491,7003 bd3 ba1.6k sqft9103 Harlequin Cir, Frederick, CO 80504Off Market
- $615,0004 bd3 ba3.5k sqft9107 Harlequin Cir, Frederick, CO 80504Sold
- $635,0005 bd4 ba3.4k sqft9007 Harlequin Cir, Frederick, CO 80504Sold
- $590,2003 bd3 ba3.4k sqft9007 Harlequin Dr, Frederick, CO 80504Off Market
- $541,0003 bd3 ba2.8k sqft9010 Harlequin Cir, Frederick, CO 80504Off Market
Nearby schools
GreatSchools rating
- 4/10Centennial Elementary SchoolGrades: PK-5Distance: 1.3 mi
- 6/10Coal Ridge Middle SchoolGrades: 6-8Distance: 1.8 mi
- 7/10Mead High SchoolGrades: 9-12Distance: 4.2 mi
Schools provided by the listing agent
- Elementary: Centennial
- Middle: Coal Ridge
- High: Mead
- District: St. Vrain Valley RE-1J
Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$564,400
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$564,400
- Colorado
- Weld County
- Frederick
- 80504
- 9006 Harlequin Circle
Nearby cities
Nearby zip codes
Other Frederick Topics
