9018 Harlequin Cir, Frederick, CO 80504 - Photo 1

1/1

$626,000

Sold
Closed
Single Family
4 Beds
2 Full Baths
2 Partial Baths
2,813 Sq. Ft.
4 Car Garage

1/1

Property Description

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

Full Property Details for 9018 Harlequin Cir

General

Sold For: $626,000
Taxes: $3,763 (2024)
Status: Closed
Type: Single Family
Source: IRES
MLS ID: 1042367
Added to Site: 210 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
Parking Features: Attached
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
Permitted 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
Sold by (720) 291-1801

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code optional

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Comment *

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 Submit, 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.

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

Schools

Schools serving 9018 Harlequin Cir

School District:St. Vrain Valley School District Re 1j

Name	Grades	Distance
Centennial Elementary School, Firestone, CO 10290 Neighbors Parkway, Firestone, CO 80504	PK-5	1.3 mi
Coal Ridge Middle School 6201 Booth Drive, Firestone, CO 80504	6-8	1.7 mi
Mead High School 12750 County Road 7, Longmont, CO 80504	9-12	4.2 mi

Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 9018 Harlequin Cir

Date

Details

Price

Change

Source

2/17/2026

Sold

$626,000

0.18%

MLS

8/28/2025

Listed

$624,900

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

7247 Longview Dr, Niwot, CO 80503 - Photo 1

New to Website

$2,195,000

Open House

7247 Longview Dr Niwot, CO 80503

Single Family
Active
Updated 1 day ago

6
Beds
5
Total Baths
6,014
Sq. Ft.
MLS # 1054580

Listed by milehimodern - Boulder

6689 Asher Ct, Niwot, CO 80503 - Photo 1

New to Website

$4,000,000

6689 Asher Ct Niwot, CO 80503

Single Family
Active
Updated 14 hours ago

5
Beds
7
Total Baths
7,566
Sq. Ft.
MLS # 4318158

Listed by Compass Colorado, LLC - Boulder and Compass - Denver

903 Tempted Ways Dr, Longmont, CO 80504 - Photo 1

New to Website

$369,000

903 Tempted Ways Dr Longmont, CO 80504

Lots/Land
Active
Updated 10 hours ago

0.05
Acres
MLS # 1054784

Listed by Joanna Rallo (720) 626-9039

5613 Four Leaf Dr, Longmont, CO 80503 - Photo 1

New to Website

$1,550,000

5613 Four Leaf Dr Longmont, CO 80503

Single Family
Active
Updated 3 days ago

4
Beds
4
Total Baths
4,365
Sq. Ft.
MLS # 1054495

Listed by The Bernardi Group (303) 402-6000

5952 Oxford Rd, Niwot, CO 80503 - Photo 1

Price Reduced

-$250,000 (-5.56%)

$4,250,000

5952 Oxford Rd Niwot, CO 80503

Single Family
Active
Updated 10 hours ago

4
Beds
5
Total Baths
4,376
Sq. Ft.
MLS # 8513432

Listed by Compass - Denver

2391 Whistler Dr, Longmont, CO 80504 - Photo 1

Price Reduced

-$4,500 (-0.9%)

$495,000

2391 Whistler Dr Longmont, CO 80504

Duplex
Active
Updated 1 day ago

3
Beds
3
Total Baths
1,674
Sq. Ft.
MLS # 4564006

Listed by Heidi Martinez (303) 717-1870

15655 Mossrock Dr, Longmont, CO 80503 - Photo 1

Price Reduced

-$50,000 (-6.67%)

$700,000

15655 Mossrock Dr Longmont, CO 80503

Single Family
Active
Updated 11 hours ago

4
Beds
3
Total Baths
3,192
Sq. Ft.
MLS # 1052055

Listed by Vicky Rath (970) 481-4160

1703 Whitehall Dr, Longmont, CO 80504 - Photo 1

Price Reduced

-$5,100 (-1.26%)

$399,900

1703 Whitehall Dr #4A Longmont, CO 80504

Condo
Active
Updated 7 hours ago

2
Beds
2
Total Baths
1,414
Sq. Ft.
MLS # 1052792

Listed by Cindy Montgomery (720) 373-9235

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

9006 Harlequin Cir, Longmont, CO 80504 - Photo 1

Sold

$561,500

9006 Harlequin Cir Longmont, CO 80504

Single Family
Closed

4
Beds
3
Total Baths
3,107
Sq. Ft.
MLS # 9467524

Listed by Elevate Property Group LLC
Sold by Compass - Boulder

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

9145 Harlequin Cir, Frederick, CO 80504 - Photo 1

Sold

$595,000

9145 Harlequin Cir Frederick, CO 80504

Single Family
Closed
Updated 6 days ago

3
Beds
3
Total Baths
2,813
Sq. Ft.
MLS # 6490572

Listed by Farmhouse Realty
Sold by Coldwell Banker Realty-NOCO

9018 Harlequin Cir, Frederick, CO 80504 (MLS# 1042367) is a Single Family property that was sold at $626,000 on February 17, 2026. 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.

9018 Harlequin Cir Frederick, CO 80504