$624,900

9018 Harlequin Cir Longmont, CO 80504

Estimated payment $3,713/month

Total Views 6,245
4 Beds
3.5 Baths
2,813 Sq Ft
$222 Price per Sq Ft

Highlights

  • Contemporary Architecture
  • Cathedral Ceiling
  • Loft
  • Multiple Fireplaces
  • Wood Flooring
  • No HOA

About This Home

CHARMING 4 BDRM/4 BATH WITH FINISHED BSMT & HUGE GARAGE W/WORKBENCH Abundant hardwoods & new carpeting welcome you into the heart of the home. Main level offers spacious great rm w/stone fireplace surrounded by built-in cabinetry, sunny kitchen w/abundant counter space, stainless appliances & bfast bar island, beautiful formal dining room & convenient 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. 4 CAR GARAGE w/space for vehicles, toys & projects w/pass through garage door to lg concrete pad in back. Newer roof, sprinkler system (front/back) & water heater. Upgraded HVAC installed earlier this year. NO HOA

Listing Agent

Robin Zwisler

Charter Realty Listed on: 08/28/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,763

Year Built

  • Built in 2012

Lot Details

  • 7,000 Sq Ft Lot
  • Wood Fence
  • Level Lot
  • Sprinkler System
  • Landscaped with Trees

Parking

  • 4 Car Attached Garage
  • Tandem Parking
  • Drive Through

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Stone

Interior Spaces

  • 2,813 Sq Ft Home
  • 2-Story Property
  • Bar Fridge
  • Cathedral Ceiling
  • Ceiling Fan
  • Multiple Fireplaces
  • Electric Fireplace
  • Window Treatments
  • Dining Room
  • Home Office
  • Loft
  • Wood Flooring

Kitchen

  • Eat-In Kitchen
  • Electric Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Outdoor Features

  • Patio

Schools

  • Centennial Elementary School
  • Coal Ridge Middle School
  • Frederick High School

Utilities

  • Forced Air Heating and Cooling System
  • Satellite Dish
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Noname Creek Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0739301

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,763

Year Built

Built in 2012

Lot Details

0

Parking

4

Listing Details

  • Inclusions: Window Coverings,Electric Range/Oven,Dishwasher,Refrigerator,Bar Refrigerator,Clothes Washer,Clothes Dryer,Microwave
  • Year Built: 2012
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.16
  • Subdivision Name: NoName Creek
  • Above Grade Finished Sq Ft: 1953
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 2813
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave
  • Has Basement: Partially Finished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 860
  • Fireplace Features: 2+ Fireplaces, Electric
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Satellite Avail, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Pantry, Loft, Kitchen Island
  • Living Area: 2813
  • Main Level Bathrooms: 1
  • Window Features: Window Coverings
  • Room Bedroom3 Features: Wood Floor
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Basement
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 14
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Wood Floor
  • Master Bedroom Features: Wood Floor
  • Room Kitchen Features: Wood Floor
  • Room Kitchen Area: 144
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 196
  • Master Bathroom Features: 5 Piece Primary Bath

Exterior Features

  • Roof: Composition
  • Fencing: Wood
  • Lot Features: Lawn Sprinkler System, Level
  • View: No
  • Waterfront: No
  • Disclosures: Seller's Property Disclosure
  • Home Warranty: No
  • Construction Type: Wood/Frame, Stone
  • Patio And Porch Features: Patio
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Parking Features: Oversized, Tandem, Drive Through
  • IRESDS_Garage Sq Ft: 840
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: City Sewer
  • Water Source: City Water, City
  • Gas Company: Natural Gas

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

  • Elementary School: Centennial,Legacy
  • HighSchool: Frederick
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Coal Ridge

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 7000
  • Parcel #: R0739301
  • Irrigation Water Rights: No

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 3763

Multi Family

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $3,763 $37,050 $7,190 $29,860
2024 $3,763 $37,050 $7,190 $29,860
2023 $3,609 $40,210 $9,130 $31,080
2022 $3,066 $29,380 $5,910 $23,470
2021 $3,095 $30,220 $6,080 $24,140
2020 $3,068 $30,200 $4,220 $25,980
2019 $3,113 $30,200 $4,220 $25,980
2018 $2,465 $24,820 $3,740 $21,080
2017 $2,520 $24,820 $3,740 $21,080
2016 $2,294 $22,230 $3,180 $19,050
2015 $2,224 $22,230 $3,180 $19,050
2014 $1,810 $18,110 $2,390 $15,720
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/28/2025 08/28/25 For Sale $624,900 +31.8% $222 / Sq Ft
11/23/2020 11/23/20 Off Market $474,000 -- --
08/24/2020 08/24/20 Sold $474,000 -1.0% $169 / Sq Ft
07/09/2020 07/09/20 For Sale $479,000 -- $170 / Sq Ft
Source: IRES MLS

Purchase History

Date Type Sale Price Title Company
Quit Claim Deed -- None Listed On Document
Special Warranty Deed $474,000 Land Title Guarantee Co
Warranty Deed $375,000 Land Title Guarantee Co
Special Warranty Deed $243,250 Heritage Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $140,000 New Conventional
Previous Owner $371,450 New Conventional
Previous Owner $328,000 New Conventional
Previous Owner $35,500 Credit Line Revolving
Previous Owner $248,214 New Conventional
Source: Public Records

Similar Homes in Longmont, CO

  • 11729 Elmer Linn Dr, Longmont, CO 80504

    $675,000

    • 3 Beds
    • 2.5 Baths
    • 2,556 Sq Ft
    • 11729 Elmer Linn Dr
    • Longmont, CO

    Discounted rate options and no lender fee future refinancing may be available for qualified buyers of this home.Welcome to your dream home in the highly sought-after neighborhood of The Elms at Meadow Vale in Weld county, wherethe taxes are significantly lower than both the national median of 0.99% and the Colorado state median of 0.55%. Thislovely 3-bedroom, 2.5-bath home is

    Tiffany Osborn Orchard Brokerage LLC

    Section Image
  • 227 Cattail Ct, Longmont, CO 80501

    $535,000

    • 3 Beds
    • 2.5 Baths
    • 1,496 Sq Ft
    • 227 Cattail Ct
    • Longmont, CO

    Step into a light-filled home featuring a beautifully remodeled kitchen with, sleek countertops, stainless steel appliances, and an open layout perfect for both cooking and entertaining. The living and dining areas flow seamlessly with warm finishes and functional design. Upstairs, you’ll find three generously sized bedrooms, including a spacious primary suite with vaulted ceilings, a soaking

    Adam Mayfield eXp Realty, LLC

    Section Image
  • 502 Peregrine Cir, Longmont, CO 80504

    $739,000

    • 5 Beds
    • 5 Baths
    • 4,569 Sq Ft
    • 502 Peregrine Cir
    • Longmont, CO

    Located on a quiet corner and overlooking open green space, this home offers a beautiful balance of character and comfort, where classic charm meets modern ease. Located in one of Longmont's most tranquil neighborhoods and just steps from the brand-new Fox Meadows Park, Fox Hill Country Club, and Union Reservoir it's an ideal setting for those who value both community and calm. Step inside to a

    Heather McChesney Keller Williams 1st Realty

    Section Image
  • 1005 E 5th Ave, Longmont, CO 80504

    $675,000

    • 4 Beds
    • 2.5 Baths
    • 3,136 Sq Ft
    • 1005 E 5th Ave
    • Longmont, CO

    Exceptionally unique Fox Hill gem! This distinctive 4-level home sits on a desirable corner lot with fantastic views and gorgeous mature trees providing shade and privacy. Inside, you'll find 4 spacious bedrooms and 3 baths, plus fresh new paint and carpet throughout. The kitchen features brand-new stainless-steel appliances and an inviting eat-in area. A separate dining room adjoins which is

    Janet Leap RE/MAX of Boulder, Inc

    Section Image
  • 747 Elliott St, Longmont, CO 80504

    $530,000

    • 6 Beds
    • 3 Baths
    • 2,464 Sq Ft
    • 747 Elliott St
    • Longmont, CO

    **Welcome to this Original Owner, Custom Ranch with Walk-Out Basement in Sun Valley**This thoughtfully designed ranch-style home, built and lovingly maintained by the original owner, offers both space and versatility. Featuring five bedrooms plus an additional office or rec room, the layout provides surprising flexibility-ideal for multi-generational living or potential rental opportunities with

    Jenny Hart Keller Williams 1st Realty

    Section Image
  • 2344 Flagstaff Dr, Longmont, CO 80504

    $599,000

    • 4 Beds
    • 3.5 Baths
    • 3,422 Sq Ft
    • 2344 Flagstaff Dr
    • Longmont, CO

    Hard to find beautifully updated ranch style home with 3-car garage in popular Pleasant Valley. Open floor plan. 2000+sf on main floor with 3 bedrooms. Great for entertaining. Vaulted ceilings. Hardwood floors throughout. Refurbished cabinets and granite counters highlight bright and fresh kitchen/eat-in area with access to wrap around patio. Family room off kitchen features cozy gas fireplace.

    Mark Webber Equity Colorado-Front Range

    Section Image
  • 1157 Gay St, Longmont, CO 80501

    $485,000

    • 3 Beds
    • 1.5 Baths
    • 1,296 Sq Ft
    • 1157 Gay St
    • Longmont, CO

    Charming Bungalow in the Heart of Old Town Longmont!This cozy 3-bedroom, 1.5-bath home sits on a spacious corner lot surrounded by mature landscaping and beautiful shade trees that help keep the home cool during summer months. Freshly painted throughout with newly refinished hardwood floors, this home offers a warm and inviting feel from the moment you step inside. The updated kitchen flows into

    Cecilia De Villiers Shasta Realty Inc

    Section Image
  • 1313 Garden Cir, Longmont, CO 80501

    $595,000

    • 4 Beds
    • 3 Baths
    • 2,616 Sq Ft
    • 1313 Garden Cir
    • Longmont, CO

    Welcome to your private backyard retreat—this Longmont home is built for entertaining and relaxing. The standout feature is the beautifully landscaped yard with a covered outdoor living space, raised garden beds, spacious patios, fire pit, and plenty of grassy space to play or unwind. 2 large sheds offering extra storage in addition to the oversized 2 car garage. A masterfully planned irrigation

    Jeremy Kane eXp Realty, LLC

    Section Image
  • 1630 Lincoln Ct, Longmont, CO 80501

    $525,000

    • 2 Beds
    • 2.5 Baths
    • 2,318 Sq Ft
    • 1630 Lincoln Ct
    • Longmont, CO

    Tucked away in a peaceful cul-de-sac in desirable Twin Peaks Estate, this rarely available full-brick ranch offers easy living with no HOA or metro district taxes. The well-designed main level features an open-concept living, dining, and kitchen area, plus a cozy second living room with a gas fireplace-perfect for gatherings or relaxing evenings. The primary suite includes a private 3/4 bath and

    Jenny Hart Keller Williams 1st Realty

    Section Image

Source: IRES MLS

MLS Number: 1042367

IRES MLS

APN: R0739301