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.
Sold for $580,000
$580,000
9004 Harlequin Cir, Longmont, CO 80504
3beds
2,813sqft
Single Family Residence
Built in 2012
7,300 Square Feet Lot
$583,700 Zestimate®
$206/sqft
$3,010 Estimated rent
Home value
$583,700
$555,000 - $613,000
$3,010/mo
Zestimate® history
Owner options
List your home for rent
$3,010/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,010/mo
Rent Zestimate®
Refinance and save
$2,728/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$2,728/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
Zillow last checked:
Listing updated:
Listed by:
Andrea Medaugh 720-971-3519,
Bold Realty
Bought with:
Carin Nguyen Team
Real Broker, LLC DBA Real
Source: IRES as distributed by MLS GRID,MLS#: 1045482
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Rooms
- Room types: Loft
Primary bedroom
- Description: Carpet
- Features: 5 Piece Primary Bath
- Level: Upper
- Area: 224 Square Feet
- Dimensions: 16 x 14
Bedroom 2
- Description: Carpet
- Level: Upper
- Area: 121 Square Feet
- Dimensions: 11 x 11
Bedroom 3
- Description: Carpet
- Level: Upper
- Area: 110 Square Feet
- Dimensions: 10 x 11
Dining room
- Description: Hardwood
- Level: Main
- Area: 165 Square Feet
- Dimensions: 15 x 11
Great room
- Description: Hardwood
- Level: Main
- Area: 315 Square Feet
- Dimensions: 15 x 21
Kitchen
- Description: Hardwood
- Level: Main
- Area: 105 Square Feet
- Dimensions: 15 x 7
Laundry
- Description: Tile
- Level: Upper
Study
- Description: Carpet
- Level: Upper
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Electric Range, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Disposal
- Laundry: Washer/Dryer Hookup
Features
- Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island
- Flooring: Wood
- Windows: Window Coverings
- Basement: Full,Unfinished
- Has fireplace: Yes
- Fireplace features: Gas, Great Room
Interior area
- Total structure area: 1,953
- Total interior livable area: 2,813 sqft
- Finished area above ground: 1,953
Property
Parking
- Total spaces: 4
- Parking features: Garage Door Opener, Oversized
- Attached garage spaces: 4
- Details: Attached
Accessibility
- Accessibility features: Level Lot
Features
- Levels: Two
- Stories: 2
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Fencing: Fenced,Wood
Lot
- Size: 7,300 Square Feet
- Features: Deciduous Trees, Level, Paved, Curbs, Gutters, Sidewalks
Details
- Additional structures: Storage
- Parcel number: R0738601
- Zoning: RES
- Special conditions: Private Owner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Frame, Stone
- Roof: Composition
Condition
- New construction: No
- Year built: 2012
Utilities & green energy
- Electric: Photovoltaics Third-Party Owned
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, High Speed Avail
Green energy
- Energy efficient items: Windows, Thermostat
Community & HOA
Community
- Security: Fire Alarm
- Subdivision: Noname Creek West
HOA
- Has HOA: No
Location
- Region: Frederick
Financial & listing details
- Price per square foot: $206/sqft
- Tax assessed value: $563,665
- Annual tax amount: $3,545
- Date on market: 10/10/2025
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: Sellers' personal property, curtains in bedrooms, gas firepit, ceramic pots on patios, refrigerator in garage, wine refrigerator and beer kegerator
- Electric utility on property: Yes
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 12/12/2025 | Sold | $580,000$206/sqft |
Source:  IRES as distributed by MLS GRID #1045482 Report a problem | ||
| 10/28/2025 | Pending sale | $580,000$206/sqft |
Source:  REcolorado as distributed by MLS GRID #IR1045482 Report a problem | ||
| 10/24/2025 | Price change | $580,000-1.7%$206/sqft |
Source: IRES as distributed by MLS GRID #1045482 Report a problem | ||
| 10/10/2025 | Listed for sale | $590,000+137.4%$210/sqft |
Source: IRES as distributed by MLS GRID #1045482 Report a problem | ||
| 1/17/2013 | Sold | $248,550$88/sqft |
Source: IRES as distributed by MLS GRID #695045 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $3,944 +11.3% | $34,500 -2.1% |
| 2025 | $3,545 +4.3% | $35,230 -6.6% |
| 2024 | $3,400 +17.6% | $37,730 -0.9% |
| 2023 | $2,891 -1% | $38,090 +37.5% |
| 2022 | $2,919 +0.3% | $27,700 -2.8% |
| 2021 | $2,909 | $28,500 -0.5% |
| 2020 | $2,909 +15.9% | $28,630 |
| 2019 | $2,509 -15% | $28,630 +13.3% |
| 2018 | $2,952 +17.6% | $25,260 |
| 2017 | $2,509 -2.2% | $25,260 +10.9% |
| 2016 | $2,565 +12.5% | $22,780 |
| 2015 | $2,279 +22.6% | $22,780 +22.5% |
| 2014 | $1,859 | $18,600 |
| 2013 | -- | $18,600 +515.9% |
| 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
- $561,5004 bd3 ba3.1k sqft9006 Harlequin Cir, Frederick, CO 80504Sold
- $595,3005 bd4 ba2k sqft9002 Harlequin Cir, Frederick, CO 80504Off Market
- $491,7003 bd3 ba1.6k sqft9103 Harlequin Cir, Frederick, CO 80504Off Market
- $602,0005 bd4 ba2.1k sqft9101 Harlequin Cir, Frederick, CO 80504Off Market
- $569,7005 bd3 ba1.6k sqft9105 Harlequin Cir, Frederick, CO 80504Off Market
- $683,7005 bd4 ba3.2k sqft9008 Harlequin Cr, Frederick, CO 80504Off Market
- $523,4003 bd3 ba2.7k sqft9003 Harlequin Cir, Frederick, CO 80504Off Market
- $665,2005 bd4 ba2.6k sqft9005 Harlequin Cir, Frederick, CO 80504Off Market
Nearby schools
GreatSchools rating
- 4/10Centennial Elementary SchoolGrades: PK-5Distance: 1.4 mi
- 6/10Coal Ridge Middle SchoolGrades: 6-8Distance: 1.8 mi
- 7/10Mead High SchoolGrades: 9-12Distance: 4.3 mi
Schools provided by the listing agent
- Elementary: Centennial
- Middle: Coal Ridge
- High: Mead
Source: IRES 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
$583,700
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
$583,700
- Colorado
- Weld County
- Frederick
- 80504
- 9004 Harlequin Cir
Nearby cities
Nearby zip codes
Other Frederick Topics
