970.222.1020
 | 
Login Account
 | 
Sign Up
Home » Real Estate » CO » Longmont » 80504 » 9023 Harlequin Cir, Longmont, CO, 80504
$647,000

9023 Harlequin Cir, Longmont, CO, 80504

3 Beds
3 Baths
2,813 Square Feet
NO HOA!! This beautiful 2 story home sits in a gorgeous established neighborhood! It features a 4 car garage and an additional shed in the large backyard with privacy fencing and mature beautiful landscaping in the front and back. As you walk inside you are greeted by the gorgeous staircase and all hard floors! It features a large formal dining room, gorgeous kitchen with stainless steel appliances and granite countertops, French doors to the back yard with built in shades. It also has high ceilings with ceiling fans, upgraded light fixtures and nest thermostat. Upstairs you will find a large loft currently being used as a home office but could also be used as an additional living room. The primary bedroom is huge with lots of natural light, vaulted ceiling and ceiling fan. It leads into the 5 piece bathroom with large bath tub, shower and huge walk in closet. The 2 additional bedrooms have a full bathroom in between with a separate linen closet in the hallway. The unfinished basement with 4 egress windows is the perfect space for extra storage or to finish for even more living space. The home also has solar already installed that is fully paid off and Ring security system with video doorbell. The city of Frederick is getting a King Soopers (not sure on completion date) at the corner of Highway 52 and Colorado Blvd, Frederick is small town living with big city amenities! This home won't last long so schedule your showing today! Seller and listing agent are related. Please contact Agent for showings and questions.
Offered By
Scott Smith 7202527037, You 1st Realty Infinity

Property Details

Property Type Residential
Status Active
Bedrooms 3
Bathrooms (Full) 2
Property Sub Type Residential-Detached
Square Feet 2,813
MLS # 1016804
Bathrooms (Half) 1

Market Trends

New Properties On Market
82
58% Increase In New Listings
Average Asking Price
$634,828
$133,441 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$230
$38 Decrease In List Price/Sq. Ft.
Average Days On Market
20
15 Day Decrease In Days On Market
Data as of Nov 16, 2024. Remaining statistics above are calculated on activity within the period from Sep 01, 2024 to Oct 31, 2024.

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

2105 Springs Pl, Longmont, CO 80504 Listing Photo  1
$739,900
2105 Springs Pl
Longmont, CO
4 Beds
|
4 Baths
|
3,488 Square Feet
Offered By Mary Romano RE/MAX Alliance-Boulder
2105 Springs Pl, Longmont, CO 80504 Listing Photo  1
$739,900
2105 Springs Pl
Longmont, CO
4 Beds
|
4 Baths
|
3,488 Square Feet
Offered By Boulder Home Source RE/MAX ALLIANCE
836 Windflower Dr, Longmont, CO 80504 Listing Photo  1
$738,000
836 Windflower Dr
Longmont, CO
2 Beds
|
3 Baths
|
3,032 Square Feet
Offered By Josh Hunter St Vrain Realty LLC
2116 Springs Pl, Longmont, CO 80504 Listing Photo  1
$729,900
2116 Springs Pl
Longmont, CO
5 Beds
|
4 Baths
|
2,825 Square Feet
Offered By Mary Romano RE/MAX Alliance-Boulder
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. © 2024 IRES. Property data was last updated on 11/15/2024 at 8:28 pm