Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

$647,000

Listing Price

3beds

2baths

1,953sqft

7,000sqft lot

9023 Harlequin Cir, Longmont, CO 80504

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

For Sale

Off Market

Single Family

Home type

323.54

Price / sqft

2012

Year built

Home Details

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 con

Interior Details

Square Feet
  • 1953

Bedrooms
  • 3

Bathrooms
  • 2

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Central

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    Central

Fuel
  • Has Fuel:

    No

  • Fuel Type:

    N/A

Basement
  • Has Basement:

    No

  • Basement Type:

    Basement (unspecified)

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 7000

Water
  • No

Sewer
  • No

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    3

Deck
  • No

Patio
  • No

Fence
  • No

Pool
  • No

Porch
  • No

Stoop
  • No

Breezeway
  • No

Construction Details

Number of Stories
  • 2

Style
  • Bi-level

Exterior
  • Frame Hardboard

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • Composition Shingle

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

2019

$2,908

$4,220

$23,990

--%

$28,210

2019

$2,908

$4,220

$23,990

--%

$28,210

2018

$2,465

$3,740

$21,080

--%

$24,820

2017

$2,520

$3,740

$21,080

--%

$24,820

2016

$2,294

$3,180

$19,050

--%

$22,230

2014

$2,122

$2,390

$15,720

--%

$18,110

2013

$1,827

$2,390

$15,720

--%

$18,110

2012

$303

$3,020

$0

--%

$3,020

percent-home-icon

Average Home Price in 80504

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

CO

$615,468

$615,468

3 Beds

3 Baths

1,953 Sqft

8,044 Lot (sqft)

Sold 09/01/2026

$556,530

4 Beds

3 Baths

2,099 Sqft

7,000 Lot (sqft)

Sold 09/01/2026

$564,430

3 Beds

2 Baths

1,901 Sqft

6,600 Lot (sqft)

Sold 08/19/2026

$642,817

3 Beds

2 Baths

1,967 Sqft

12,000 Lot (sqft)

Sold 10/13/2026

$608,055

4 Beds

3 Baths

2,195 Sqft

10,175 Lot (sqft)

Sold 10/13/2026

$625,476

4 Beds

3 Baths

2,195 Sqft

7,810 Lot (sqft)

Sold 10/18/2026

$647,000

3 Beds

2 Baths

1,953 Sqft

7,000 Lot (sqft)

Sold 11/15/2025

$597,583

4 Beds

3 Baths

2,195 Sqft

7,000 Lot (sqft)

Sold 10/13/2026

$600,457

4 Beds

3 Baths

2,195 Sqft

7,810 Lot (sqft)

Sold 10/13/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
647,000
$
Down payment
129,400
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
3,882
$
HOA (Monthly)
0
$
PMI
0
$
$4,188
Your Payment
Total Monthly Payment:$4,188
Percent of Income:72%
Affordable:No

Details for 9023 HARLEQUIN CIR

Property Debt

Foreclosure Contact Details