Home » Real Estate » CO » Frederick » 80504 »
$624,900
9018 Harlequin Cir, Frederick, CO, 80504
4
Beds
4
Baths
2,813
Square Feet
Open House
July 5 2:00 pm - 4:00 pm
LOVELY 4 BDRM/4 BATH W/FINISHED BSMT & 4 CAR GARAGE! Abundant hardwoods & brand new carpeting welcome you into this charming space. Main level offers inviting great rm w/fireplace & custom cabinetry, sunny kitchen w/granite counters, stainless & bfast bar island, formal dining & 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. Step into HUGE GARAGE w/space for vehicles & projects w/custom garage door opening to lg concrete pad in back. Newer roof, sprinkler system (front & back) and water heater. Upgraded HVAC installed earlier this year. NO HOA
Offered By
Robin Zwisler 7202911801, Charter Realty
Property Details
Property Type
Residential
Status
Active
Bedrooms
4
Bathrooms (Full)
2
Property Sub Type
Residential-Detached
Square Feet
2,813
MLS #
1034399
Bathrooms (¾)
1
Bathrooms (Half)
1
Flooring
Wood Floors
Appliances
Electric Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave
LAUNDRY FEATURES
Washer/Dryer Hookups, Upper Level
FIREPLACE FEATURES
Gas
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available, Cable Available
WATER SOURCE
City Water, City
Year Built
2012
Basement
Partially Finished
FINISHED BASEMENT SIZE
860.0
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
Parking Features
Oversized, Tandem, Drive Through
Fence
Fenced
Lot Features
Lawn Sprinkler System, Level
Garage spaces
4
Other Structures
Workshop
CITY
Frederick
SUBDIVISION
Noname Creek
COUNTY
Weld
AREA
Greeley/Weld
STATE
CO
SENIOR COMMUNITY
No
TAX AMOUNT
3763.0
LATEST UPDATE
2025-07-04T17:10:06.533Z
DAYS ON MARKET
43
PRICE CHANGE(S)
$639,900 May 22, 2025
$624,900 Jul 3, 2025
CUMULATIVE DAYS ON MARKET
43
Property Details
Property Type
Residential
Status
Active
Bedrooms
4
Bathrooms (Full)
2
Property Sub Type
Residential-Detached
Square Feet
2,813
MLS #
1034399
Bathrooms (¾)
1
Bathrooms (Half)
1
Open House
July 5 2:00 pm - 4:00 pm
New Properties On Market
147
88%
Increase In New Listings
Average Asking Price
$713,560
$17,639 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$239
$2 Decrease In List Price/Sq. Ft.
Average Days On Market
9
26 Day
Decrease In Days On Market
Data as of Jul 04, 2025.
Remaining statistics above are calculated on activity within the period from May 01, 2025 to Jun 30, 2025.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.
Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance
Similar Listings
$694,000
5520 Morgan Way
Frederick, CO
4
Beds
| 3
Baths
| 4,158
Square Feet
Offered By Eric Morris Fathom Realty Colorado LLC
$694,000
5520 Morgan Way
Frederick, CO
4
Beds
| 3
Baths
| 3,893
Square Feet
Offered By Eric Morris Fathom Realty Colorado LLC
$690,000
8010 Raspberry Dr
Frederick, CO
4
Beds
| 4
Baths
| 4,068
Square Feet
Offered By Whitney Kloss Insight Realty Team LLC
$690,000
5483 Gunnison Dr
Frederick, CO
3
Beds
| 4
Baths
| 3,393
Square Feet
Offered By Betsy Moser MB Moser Real Estate Group
Information deemed reliable but not guaranteed by the MLS.
Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Data Source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules. © 2025 IRES.
Property data was last updated on 7/4/2025 at 10:04 pm