See Home Value
Frederick 80504
9023 Harlequin Cir
$620,000
● House - Off Market

9023 Harlequin Cir

Longmont, CO 80504
bedrooms
3 Beds
bathrooms
2 Baths, 1 Half Bath
square feet
1,953 Ft²
$3,347
Est. Monthly

About This Property

Sellers are very motivated!!  Welcome to this beautiful 2 story home that sits in a gorgeous established neighborhood! It features a 4 car garage and custom built 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, granite countertops and a pantry. Off of the kitchen there are French doors with built in shades that lead you to the spacious backyard inviting you to a large patio area with plenty of room for barbequing and entertaining . Back inside, the home has high ceilings with fans, upgraded light fixtures and nest thermostat that is tied to the FULLY OWNED solar panels. Upstairs you will find a large loft, currently being used as a home office but could also be used as an additional living or play area. The primary bedroom is huge with lots of natural light, vaulted ceiling and 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 perfect for extra storage or to finish and make it your own. The home also has Ring security system with video doorbell. The home is between 2 beautiful, well cared for parks and 2 golf courses. Nearby you will find a new King Soopers being built at the corner of Highway 52 and Colorado Blvd, several restaurants, urgent care and easy access to I-25. Frederick has a small town feel with city conveniences! Please schedule your showing today! Seller is under contract on their new home and can accommodate a quick close! Seller and listing agent are related.
Unit Size
1,953 Ft²
Days on Market
-
Land Size
0.16 acres
Price per sqft
$320
Property Type
House
Property Taxes
$278
HOA Dues
-
Year Built
2012

Payment Calculator

Cap Rate Calculator

Last updated: 11 months ago (REcolorado MLS #5812088)

Price History

Date / Event Date Event Price
Mar 4, 2025 Sold
Sold
Jan 23, 2025 In contract -
In contract
Dec 13, 2024 Listed by HomeSmart $624,900
Listed by HomeSmart
Sellers are very motivated!! Welcome to this beautiful 2 story home that sits in a gorgeous established neighborhood! It features a 4 car garage and custom built 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, granite countertops and a pantry. Off of the kitchen there are French doors with built in shades that lead you to the spacious backyard inviting you to a large patio area with plenty of room for barbequing and entertaining . Back inside, the home has high ceilings with fans, upgraded light fixtures and nest thermostat that is tied to the FULLY OWNED solar panels. Upstairs you will find a large loft, currently being used as a home office but could also be used as an additional living or play area. The primary bedroom is huge with lots of natural light, vaulted ceiling and 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 perfect for extra storage or to finish and make it your own. The home also has Ring security system with video doorbell. The home is between 2 beautiful, well cared for parks and 2 golf courses. Nearby you will find a new King Soopers being built at the corner of Highway 52 and Colorado Blvd, several restaurants, urgent care and easy access to I-25. Frederick has a small town feel with city conveniences! Please schedule your showing today! Seller is under contract on their new home and can accommodate a quick close! Seller and listing agent are related.
Dec 8, 2024 Price Decreased $624,900
↓ $15K (2.3%)
Price Decreased
Nov 26, 2024 Listed by Strategic Real Estate and Development Services $639,900
Listed by Strategic Real Estate and Development Services
Sellers are very motivated!! Welcome to this beautiful 2 story home that sits in a gorgeous established neighborhood! It features a 4 car garage and custom built 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, granite countertops and a pantry. Off of the kitchen there are French doors with built in shades that lead you to the spacious backyard inviting you to a large patio area with plenty of room for barbequing and entertaining . Back inside, the home has high ceilings with fans, upgraded light fixtures and nest thermostat that is tied to the FULLY OWNED solar panels. Upstairs you will find a large loft, currently being used as a home office but could also be used as an additional living or play area. The primary bedroom is huge with lots of natural light, vaulted ceiling and 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 perfect for extra storage or to finish and make it your own. The home also has Ring security system with video doorbell. The home is between 2 beautiful, well cared for parks and 2 golf courses. Nearby you will find a new King Soopers being built at the corner of Highway 52 and Colorado Blvd, several restaurants, urgent care and easy access to I-25. Frederick has a small town feel with city conveniences! Please schedule your showing today! Seller is under contract on their new home and can accommodate a quick close! Seller and listing agent are related.
Show More

Property Highlights

Garage
Air Conditioning

Building Info

Overview

    General

  • Year Built: 2012
  • Effective Year Built: 2012
  • Building Count: 1
  • Bedroom Count: 3
  • Bathroom Count: 3
  • Full Bathrooms: 3
  • Partial Bathrooms: 3
  • Bathroom Plumbing Fixtures: 13
  • Building Condition: 0
  • Building Quality: 0
  • Construction Type: 17
  • Building Style: 40
  • Exterior Walls Type: 17
  • Interior Walls Type: 3
  • Roof Shape Type: 0
  • Roof Cover Type: 3
  • Floor Count: 200
  • Living Units: 1
  • Floor Cover: 0
  • Basement Type: 9
  • Basement Area: 860
  • Garage Type: 1
  • Garage Square Area: 840
  • Parking Space Count: 3
  • Patio Type: 0
  • Porch Type: 36
  • Pool Type: 0

    Dimensions

  • Lot Size Square Feet: 7,000
  • Total Building Area: 3,653
  • Gross Building Area: 3,653
  • Building Area: 1,953
  • Building Area Measurement: L

    Heating and Cooling

  • Air Conditioning: 1
  • Heating: 3
  • Heated Square Feet: 1,953
  • Heating Fuel Type: 0

    Utilities

  • Sewer System: 0
  • Water Service: 0

Building

  • Building Type: 0
  • Property Class: R
  • Subdivision: NONAME CREEK WEST
  • Land Acres: 0000000161
  • Standard Land Use Code: 1001
  • County Land Use Code: 1212
  • Legal Description 1: FRE NNCW L16 BLK6 NONAME CREEK WEST

Neighborhood

  • School District Name: St. Vrain Valley School District RE 1J
  • Census Tract: 002018

Geography

  • Assessors Map Reference: MAP 2454
  • Account Number: R0733901
  • Parcel: R0733901
  • Block: 6
  • Lot: 16
  • Meridian: SEC 13 TWN 2N RNG 68W
  • Latitude: 40.1337
  • Longitude: -104.95

    Address

  • Full Address: 9023 Harlequin Cir
  • Address - House Number: 9023
  • Address - Street Name: Harlequin
  • Address - Suffix Type: Cir
  • State: CO
  • City Name: Longmont
  • Carrier Code: R037
  • 4-Digit Zip Code: 9755
  • Zip Code: 80504

Valuation

    Tax

  • Tax Year: 2023
  • Tax Amount: $333,982
  • Tax Rate Code Area: 1459

    Appraisal Valuation

  • Standard Deviation: 0.1344
  • Valuation Date: Apr 03, 2024
  • Confidence Score: 84
  • Final Value: 566,734
  • High Value: 642,926
  • Low Value: 490,541

    Market Valuation

  • Market Total Value: $554,063
  • Market Land Value: $135,000
  • Market Improvement Value: $419,063

    Assessments Valuation

  • Assessed Year: 2023
  • Assessed Total Value: $37,130
  • Assessed Land Value: $9,050
  • Assessed Improvements Value: $28,080

    Sales

  • Current Sale Contract Date: Jan 12, 2022
  • Current Sale Recording Date: Jan 14, 2022
  • Current Sale Price:
  • Current Sale Document Type: 68
  • Current Sale Input Document Number: 4794094
  • Previous Sale Recording Date: Jul 26, 2017
  • Previous Sale Contract Date: Jul 25, 2017
  • Previous Sale Amount: $400,000
  • Previous Sale Document Type: 71
Data used for valuation calculations is provided by RealtyHop, and other third party sources

Comparables

Unit
Status
Type
Beds
Baths
ft²
Price/ft²
Asking Price
Listed On
Closing Price
Sold On
HOA + Taxes

About Frederick


Similar Homes for Sale

Currently no similar homes around

Nearby Rentals



Frequently Asked Questions

When was property at 9023 Harlequin Circle built and last sold?
The property at 9023 Harlequin Circle was built in 2012 and last sold on Jan 12, 2022 for $555,000.
How much is this home worth?
The estimated value of the home located at 9023 Harlequin Circle is $0.
What are some comparable homes to 9023 Harlequin Circle?
There are currently no comparable homes to 9023 Harlequin Circle.