Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$624,900

  • For Sale
  • Under Contract
  • Single Family
  • 4 Beds
  • 2 Full Baths
  • 2 Partial Baths
  • 2,813 Sq. Ft.
  • 4 Car Garage
See This Home
Save This Home
See This Home
Save This Home
CHARMING 4 BDRM/4 BATH WITH FINISHED BSMT & HUGE 4 CAR GARAGE w/built-in workbench in tandem bay. Abundant hardwoods & new carpeting welcome you into the heart of the home. Newer roof, sprinkler system (front/back), water heater & 2025 HVAC (top of the line!) Main level offers spacious great rm w/stone fireplace surrounded by built-in cabinetry, sunny kitchen w/abundant counter space, stainless appliances & bfast bar island, beautiful formal dining room & convenient powder bath. Upstairs features loft/office space, 3 bdrms including primary w/cozy fireplace & 5 piece bath ensuite and laundry rm w/custom barn door. Bsmt features kitchenette & rec rm (w/beautiful leather theater chairs included) & bdrm suite perfect for guests or multi-generational living. Step into low maintenance BKYD OASIS for relaxing, gardening, entertaining. Huge garage w/space for vehicles, toys & projects w/pass through garage door to lg concrete pad in back. NO HOA

Full Property Details for 9018 Harlequin Cir

General

  • Price: $624,900
  • Taxes: $3,763 (2024)
  • Status: Under Contract
  • Type: Single Family
  • Source: IRES
  • MLS ID: 1042367
  • Updated: 12/17/2025
  • Added to Site: 144 day(s) ago

Interior

  • Interior Features: Eat-In Kitchen, Separate Dining Room, Cathedral Ceiling(s), Pantry, Washer/Dryer Hookup, Kitchen Island
  • Fireplace: Yes
  • Fireplace(s): Two or More, Electric
  • Appliances: Electric Range, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave
  • Flooring: Wood

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 2
  • 3/4 Bathrooms: 1
  • Half Bathrooms: 1

Bedrooms

  • Total Bedrooms: 4

Exterior

  • Exterior Features: Sprinkler System, Oversized Garage, Tandem Garage, Drive Through Garage
  • Porch/Patio/Deck: Patio

Parking

  • Garage: Yes
  • Attached garage: Yes
  • Garage Spaces: 4
  • Garage Description: Attached

Location

  • Area: Frederick
  • County: Weld
  • Subdivision: NoName Creek

School Information

  • School District: ST Vrain Dist RE 1J
  • Elementary School: Centennial
  • Middle School: Coal Ridge
  • High School: Frederick

Heating & Cooling

  • Cooling Type: Central Air, Ceiling Fan(s)
  • Heating Type: Forced Air

Utilities

  • Gas: Yes
  • Sewer: Public Sewer
  • Water: City
  • Utility Description: Natural Gas Available, Electricity Available, Cable Available, Satellite Available

Structural Information

  • Architectural Style: Contemporary
  • Construction: Frame, Stone
  • Exterior Const.: Frame, Stone
  • Basement: Yes
  • Basement Desc.: Partially Finished
  • Roof: Composition
  • Windows: Window Coverings
  • Square Feet: 2,813
  • Sq. Ft. Source: Assessor
  • Living Area: 2,813 Sq. Ft.
  • Year Built: 2012

Lot Features

  • Lot Size (Acres): 0.16
  • Lot Size (Sq. Ft.): 7,000
  • Fence: Yes
  • Lot Features: Deciduous Trees, Level
  • Potential Use: Single-Family
  • Zoning: RES
  • Fencing (Description): Wood

Financial Considerations

  • Tax Amount: $3,763
  • Tax Year: 2024
  • Terms: Cash, Conventional, FHA, VA

Disclosures and Reports

  • Special Conditions: Private Owner
  • Exclusions: Seller's personal property
  • Property ID: R0739301

Listed by Charter Realty (720) 291-1801

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 9018 Harlequin Cir —

  • Charter Realty

    720-291-1801

7202911801

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 9018 Harlequin Cir

School District:St. Vrain Valley School District Re 1j
NameGradesDistance
Centennial Elementary School, Firestone, CO
10290 Neighbors Parkway, Firestone, CO 80504
PK-51.3 mi
Coal Ridge Middle School
6201 Booth Drive, Firestone, CO 80504
6-81.7 mi
Mead High School
12750 County Road 7, Longmont, CO 80504
9-124.2 mi
Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 9018 Harlequin Cir Get Price Alerts and Save Property

Date
Details
Price
Change
Source
8/28/2025
Listed
$624,900
31.84%
MLS
8/24/2020
Sold
$474,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 9018 Harlequin Cir

Year
Property Taxes
Change
Tax Assessment
Change
2024
$3,763
4%
$39,830
-1%
2023
$3,609
17%
$40,210
33%
2021
$3,095
1%
$30,220
3%
2022
$3,066
—
$29,380
-3%
2020
$3,068
-1%
$30,200
—
2019
$3,113
26%
$30,200
22%
2018
$2,465
-2%
$24,820
—
2017
$2,520
10%
$24,820
12%
2016
$2,294
3%
$22,230
—
2015
$2,224
23%
$22,230
23%
2014
$1,810
-1%
$18,110
—
2013
$1,828
—
$18,110
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 9018 Harlequin Cir

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Charter Realty (720) 291-1801

Similar Properties near 9018 Harlequin Cir

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

2144 Santa Fe Dr, Longmont, CO 80504 - Photo 1
$619,000

2144 Santa Fe Dr  Longmont, CO 80504

  • Single Family
  • Active
  • Updated 11 days ago
  • 4
    Beds
  • 4
    Total Baths
  • 2,551
    Sq. Ft.
  • MLS # 1049176
Listed by RE/MAX of Boulder, Inc
613 Rider Ridge Dr, Longmont, CO 80504 - Photo 1
$642,500

613 Rider Ridge Dr  Longmont, CO 80504

  • Single Family
  • Active
  • 4
    Beds
  • 4
    Total Baths
  • 3,439
    Sq. Ft.
  • MLS # 1047418
Listed by Spiro Realty Group
1551 Vivian St, Longmont, CO 80501 - Photo 1
$625,000

1551 Vivian St  Longmont, CO 80501

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 3,176
    Sq. Ft.
  • MLS # 1047985
Listed by St Vrain Realty LLC
618 Silver Star Ct, Longmont, CO 80504 - Photo 1
$629,900

618 Silver Star Ct  Longmont, CO 80504

  • Single Family
  • Active
  • Updated 7 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 3,683
    Sq. Ft.
  • MLS # 1042172
Listed by Legacy Real Estate Group

Just Listed near 9018 Harlequin Cir

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

8009 James Ct, Niwot, CO 80503 - Photo 1 New to Website
$1,190,000
Open House

8009 James Ct  Niwot, CO 80503

  • Single Family
  • Active
  • Updated 4 hours ago
  • 4
    Beds
  • 3
    Total Baths
  • 2,856
    Sq. Ft.
  • MLS # 1049663
Listed by Compass - Boulder
3600 Quail Rd, Longmont, CO 80503 - Photo 1 New to Website
$635,000

3600 Quail Rd  Longmont, CO 80503

  • Single Family
  • Active
  • Updated 6 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,913
    Sq. Ft.
  • MLS # 1049439
Listed by eXp Realty LLC
2093 Boise Ct, Longmont, CO 80504 - Photo 1 New to Website
$625,000

2093 Boise Ct  Longmont, CO 80504

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,445
    Sq. Ft.
  • MLS # 1049535
Listed by RE/MAX Alliance-Longmont
2807 Bear Springs Circle, Longmont, CO 80503 - Photo 1 New to Website
$449,990

2807 Bear Springs Circle  Longmont, CO 80503

  • Townhouse
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 1,375
    Sq. Ft.
  • MLS # 1049548
Listed by DFH Colorado Realty LLC

Price Reduced near 9018 Harlequin Cir

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

8050 Niwot Rd, Niwot, CO 80503 - Photo 1 Price Reduced
-$30,000 (-9.38%)
$290,000

8050 Niwot Rd  #40  Niwot, CO 80503

  • Condo
  • Active
  • Updated 4 days ago
  • 2
    Beds
  • 1
    Total Bath
  • 882
    Sq. Ft.
  • MLS # 3441742
Listed by Kimberly Henry
2858 Bear Springs Circle, Longmont, CO 80503 - Photo 1 Price Reduced
-$100 (-0.02%)
$539,890

2858 Bear Springs Circle  Longmont, CO 80503

  • Townhouse
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 3
    Total Baths
  • 2,031
    Sq. Ft.
  • MLS # 1047817
Listed by DFH Colorado Realty LLC
2062 Ridgeview Dr, Longmont, CO 80504 - Photo 1 Price Reduced
-$1,000 (-0.11%)
$949,000

2062 Ridgeview Dr  Longmont, CO 80504

  • Single Family
  • Active
  • Updated 5 days ago
  • 6
    Beds
  • 4
    Total Baths
  • 3,870
    Sq. Ft.
  • MLS # 1046658
Listed by RE/MAX Alliance-Longmont
3340 Longview Blvd, Longmont, CO 80504 - Photo 1 Price Reduced
-$4,100 (-3.18%)
$124,900

3340 Longview Blvd  Longmont, CO 80504

  • Mobile Home
  • Active
  • Updated 3 days ago
  • 2
    Beds
  • 2
    Total Baths
  • 1,232
    Sq. Ft.
  • MLS # 4676125
Listed by RE/MAX Nexus

Recent Sales near 9018 Harlequin Cir

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

9016 Harlequin Cir, Frederick, CO 80504 - Photo 1 Sold
$639,900

9016 Harlequin Cir  Frederick, CO 80504

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
  • 3,588
    Sq. Ft.
  • MLS # 1047046
Listed and Sold by Charter Realty
9004 Harlequin Cir, Longmont, CO 80504 - Photo 1 Sold
$580,000

9004 Harlequin Cir  Longmont, CO 80504

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 2,813
    Sq. Ft.
  • MLS # 1045482
Listed by Bold Realty
9046 Sandpiper Dr, Frederick, CO 80504 - Photo 1 Sold
$599,000

9046 Sandpiper Dr  Frederick, CO 80504

  • Single Family
  • Closed
  • 3
    Beds
  • 3
    Total Baths
  • 3,419
    Sq. Ft.
  • MLS # 5812151
Listed by Berkshire Hathaway Home Services, Rocky Mountain Realtors
Sold by 8z Real Estate
9000 Eldorado Ave, Longmont, CO 80504 - Photo 1 Sold
$645,000

9000 Eldorado Ave  Longmont, CO 80504

  • Single Family
  • Closed
  • Updated 3 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 3,670
    Sq. Ft.
  • MLS # 1040514
Listed by WK Real Estate Longmont

9018 Harlequin Cir, Frederick, CO 80504 (MLS# 1042367) is a Single Family property with 4 bedrooms, 2 full bathrooms and 2 partial bathrooms. 9018 Harlequin Cir is currently listed for $624,900 and was received on August 28, 2025. Want to learn more about 9018 Harlequin Cir? Do you have questions about finding other Single Family real estate for sale in Frederick? You can browse all Frederick real estate or contact a Coldwell Banker agent to request more information.

Tour this property