Home » Real Estate » CO » Frederick » 80504 »
$725,000
9048 Harlequin Cir, Frederick, CO, 80504
3
Beds
3
Baths
1,937
Square Feet
New Construction home with a huge FOUR car garage, in sought after Noname Creek subdivision which has NO HOA and NO metro district tax!!! Welcome, this truly show stopping kitchen with an open living space invites you in to enjoy the beauty and comfort in all things this model has to offer. Your eye is instantly drawn to the expansive kitchen island that is the heart of this home, but don't miss the details this builder incorporates. From soft close cabinets, designer tile and lighting, to tankless water heater and fully landscaped yards with a fence - the elevated feel of this builder is something to be experienced. Our Mount Evans model features 3 generous sized bedroom, a full unfinished basement with 9-foot ceilings. We are a semi customizable builder, come to us with ideas - we strive to say yes before anything else!
Offered By
Tatum Roper, Better Blueprint Realty
Property Details
Property Type
Residential
Status
Active
Bedrooms
3
Bathrooms (Full)
2
Property Sub Type
Single Family Residence
Square Feet
1,937
MLS #
1043569
Bathrooms (Half)
1
Appliances
Gas Range, Dishwasher, Refrigerator, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Gas, Living Room
Heating
Forced Air
Cooling
Central Air
Utility Features
Natural Gas Available, Electricity Available
SEWER
Public Sewer
WATER SOURCE
City
Year Built
2026
Builder Name
Alliance Development
Basement
Unfinished
FINISHED BASEMENT SIZE
1890.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
Roof
Composition
EXTERIOR FEATURES
Sprinkler System, Oversized Garage
Parking Features
Attached
Fence
Fenced, Wood
Garage spaces
3
CITY
Frederick
SUBDIVISION
Noname Creek West B4 Rplt 2
COUNTY
Weld
AREA
Greeley/Weld
STATE
CO
HOA
1
TAX AMOUNT
23.96
LATEST UPDATE
2026-03-02T22:17:04.494Z
DAYS ON MARKET
172
PRICE CHANGE(S)
$725,000 Oct 30, 2025
Property Details
Property Type
Residential
Status
Active
Bedrooms
3
Bathrooms (Full)
2
Property Sub Type
Single Family Residence
Square Feet
1,937
MLS #
1043569
Bathrooms (Half)
1
New Properties On Market
102
117%
Increase In New Listings
Average Asking Price
$650,302
$66,586 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$240
$49 Decrease In List Price/Sq. Ft.
Average Days On Market
13
25 Day
Decrease In Days On Market
Data as of Mar 14, 2026.
Remaining statistics above are calculated on activity within the period from Jan 01, 2026 to Feb 28, 2026.
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
$725,000
8001 Raspberry Dr
Frederick, CO
3
Beds
| 2
Baths
| 3,508
Square Feet
Offered By Vincent Pallone MB Pallone & Associates
$685,000
9046 Harlequin Dr
Frederick, CO
3
Beds
| 3
Baths
| 2,464
Square Feet
Offered By Tatum Jablonski Better Blueprint Realty
$640,000
4901 Wren Ct
Frederick, CO
4
Beds
| 3
Baths
| 3,979
Square Feet
Offered By Laura MacDonald West and Main Homes