$400,000
SOLD OCT 20, 2017

9043 Harlequin Cir Frederick, CO 80504

4 Beds
2.5 Baths
2,166 Sq Ft
7,150 Sq Ft Lot

Recently Sold

$185 Per Sq Ft

2% Below List Price

50 Days on Market

Highlights

  • Open Floorplan
  • No HOA
  • Double Pane Windows
  • Wood Flooring
  • 3 Car Attached Garage
  • Forced Air Heating and Cooling System

About This Home

As of July 2022

Amazing 4bedroom St. Aubyn Home in sought after No Name Creek. With 2,666 finished sqft, w/a 1,156 sqft unfinished basement, granite countertops throughout, huge family room opening to the dining room & kitchen, and an amazing mud room. Upstairs you will find a large master suite equipped with a dual sided fireplace, 3 additional bedrooms, small loft, and a very convenient upstairs laundry. With a 3 car garage that has a dog kennel that opens to a dog run. This home is a must see.

Last Agent to Sell the Property

Tony Thurman

Resident Realty North Metro Listed on: 07/20/2017

Resident Realty North Metro

Co-Listed By

Non-IRES Agent

Non-IRES

Last Buyer's Agent

Luis Gonzalez

Brokers Guild Homes

Brokers Guild Homes

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,723

Year Built

  • Built in 2012

Lot Details

  • 7,150 Sq Ft Lot
  • Sprinkler System

Parking

  • 3 Car Attached Garage

Home Design

  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 3,322 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Gas Fireplace
  • Double Pane Windows
  • Laundry on upper level
  • Unfinished Basement

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Water Rights Not Included

Community Details

  • No Home Owners Association
  • Built by St Aubyn Homes LLC,
  • No Name Creek West Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0737901

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,723

Year Built

Built in 2012

Lot Details

0

Parking

3

Listing Details

  • Year Built: 2012
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.16
  • Co List Office Mls Id: COOP
  • Subdivision Name: No Name Creek West
  • Above Grade Finished Sq Ft: 1010
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3322
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Refrigerator
  • Has Basement: Unfinished
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1156
  • Fireplace Features: Gas
  • Fireplace: Yes
  • Interior Amenities: Open Floorplan
  • Living Area: 2166
  • Window Features: Double Pane Windows
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Living Room Living Room Level: Main
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 130
  • Master Bedroom Master Bedroom Width: 16
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Room Living Room Area: 484
  • Living Room Features: Carpet
  • Room Kitchen Area: 168
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 288
  • Room Dining Room Area: 200
  • Master Bathroom Features: 5 Piece Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Composition
  • Builder Name: St Aubyn Homes LLC,
  • Lot Features: Lawn Sprinkler System, Water Rights Excluded
  • Waterfront: No
  • Construction Type: Wood/Frame
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • IRESDS_Garage Sq Ft: 828
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Heating: Forced Air
  • Utilities: Natural Gas Available
  • Laundry Features: Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water, Public
  • 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: Legacy
  • HighSchool: Frederick
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Coal Ridge

Lot Info

  • Zoning: Residentia
  • Lot Size Sq Ft: 7150
  • Parcel #: R0737901
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2016
  • Tax Annual Amount: 2723

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 1, 2022
Closed on
Jul 29, 2022
Sold by
Webb Audrey M
Bought by
Hambach Mark and Hambach Joerg
Seller's Agent
Marie Roberts
Coldwell Banker Realty-NOCO
Buyer's Agent
Marie Roberts
Coldwell Banker Realty-NOCO
List Price
$599,000
Sold Price
$612,000
Premium/Discount to List
$13,000
2.17%
Current Estimated Value
$684,254

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$72,254
Avg. Annual Appreciation
3.82%
Original Mortgage
$581,400
Outstanding Balance
$558,450
Interest Rate
5.78%
Mortgage Type
New Conventional
Estimated Equity
$125,804

Purchase Details

Closed on
Jun 9, 2020
Sold by
Webb Audrey M and Gippe Audrey M
Bought by
Webb Audrey M and Webb James D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$387,800
Interest Rate
3.1%
Mortgage Type
VA

Purchase Details

Listed on
Jul 20, 2017
Closed on
Oct 20, 2017
Sold by
White Abrham and White Frances T
Bought by
Gippe Audrey M
Seller's Agent
Tony Thurman
Resident Realty North Metro
Buyer's Agent
Luis Gonzalez
Brokers Guild Homes
List Price
$410,000
Sold Price
$400,000
Premium/Discount to List
-$10,000
-2.44%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.17%
Original Mortgage
$400,000
Interest Rate
3.78%
Mortgage Type
New Conventional

Purchase Details

Listed on
Jan 1, 2012
Closed on
Jul 10, 2012
Sold by
Saint Aubyn Homes Llc
Bought by
White Abraham and White Frances T
Seller's Agent
Stephen Balliet
Balliet Realty
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$280,250
Sold Price
$281,000
Premium/Discount to List
$750
0.27%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.96%
Original Mortgage
$252,900
Interest Rate
3.68%
Mortgage Type
New Conventional
Source: Public Records

Similar Homes in the area

  • 7433 Ellingwood Cir, Frederick, CO 80504

    $500,000

    • 3 Beds
    • 2 Baths
    • 1,743 Sq Ft
    • 7433 Ellingwood Cir
    • Frederick, CO

    Charming One-Story Home with Open Floor Plan and Modern UpgradesWelcome to this beautifully maintained one-story home offering comfort, style, and functionality all in one. Featuring an open floor plan with 3 spacious bedrooms and 2 full bathrooms, this residence is perfect for families, professionals, or anyone seeking single-level living.The heart of the home is the kitchen,

    Felipe Figueroa Remax inMotion

    Section Image
  • 114 Berwick Ave, Firestone, CO 80520

    $399,000

    • 3 Beds
    • 1 Bath
    • 1,323 Sq Ft
    • 114 Berwick Ave
    • Firestone, CO

    If you've been looking for an ideal starter home, a smart investment, or a cozy space to downsize into-this sweet home in downtown Firestone offers comfort, updates, and room to grow. With 3 bedrooms, 1 bathroom, and 1,323 square feet, this home blends functionality with small-town charm and a location that makes everyday living easy. Step inside and enjoy durable, updated flooring throughout the

    Amy Neb Dwellings Colorado Real Estate

    Section Image
  • 441 Johnson St, Frederick, CO 80530

    $369,900

    • 3 Beds
    • 2 Baths
    • 1,351 Sq Ft
    • 441 Johnson St
    • Frederick, CO

    BACK ON MARKET BUYERS FINANCES FELL THROUGH Unincorporated Weld County- Frederick is a very desirable area to live and play also you will notice the surrounding areas is growing and expanding as well. Come and check out this cute 3 bedroom 2-bathroom home that has a newer roof, new water and sewer lines installed in 2024. This home also has a lot of storage space and a workshop for all your home

    Lisa Yoshimura Resident Realty Colorado

    Section Image
  • 542 Hawthorn Cir, Frederick, CO 80530

    $481,000

    • 3 Beds
    • 2 Baths
    • 1,154 Sq Ft
    • 542 Hawthorn Cir
    • Frederick, CO

    Seller may consider buyer concessions if made in an offer. Check out this stunner! This home has Fresh Interior Paint, New flooring throughout the home. Discover a bright interior tied together with a neutral color palette. Head to the spacious primary suite with good layout and closet included. The primary bathroom features plenty of under sink storage waiting for your home organization needs.

    Tara Jones Opendoor Brokerage LLC

    Section Image
  • 332 Maple Dr, Frederick, CO 80530

    $455,000

    • 2 Beds
    • 2 Baths
    • 960 Sq Ft
    • 332 Maple Dr
    • Frederick, CO

    Remodeled 2-bedroom, 2-bathroom home in Parkview Estates in Frederick! This ranch-style home offers updates throughout, including new windows on the main floor, a newer roof, central air, interior paint, and a two-car attached garage. The spacious and updated kitchen features quartz countertops, white shaker cabinets, laminate flooring, and a new sliding door leading out to the wood deck. The

    Samantha Mortensen-Judkins Key Team Real Estate Corp.

    Section Image
  • 10420 Butte Dr, Longmont, CO 80504

    $425,000

    • 3 Beds
    • 2 Baths
    • 1,470 Sq Ft
    • 10420 Butte Dr
    • Longmont, CO

    Discover comfort, convenience & walk to the park in this adorable 3-bedroom, 2-bathroom two-story home located in a Idaho Creek neighborhood. Spacious 3 bedrooms and 2 full baths with Large living room and kitchen with eat in dining and large pantry and island. Upstairs the primary bedroom is big with walk in large closets and full bath. There are 2 additional bedrooms, full bath and laundry room

    Abby Renner RE/MAX Nexus

    Section Image
  • 247 Tipple Pkwy, Frederick, CO 80530

    $495,000

    • 3 Beds
    • 1 Bath
    • 1,296 Sq Ft
    • 247 Tipple Pkwy
    • Frederick, CO

    Welcome to 247 Tipple Pkwy in Frederick, CO. Recently completely remodeled and ready to move in home! Wonderful historic property in Old Town Frederick on a MASSIVE 15,600 SF lot with alley access for parking up to 4 vehicles!!!! Several mature, beautiful trees as well as 8 newer trees and lots of perennials for seasonal color. Ranch floor plan with total square footage all on one level. Newer

    Jace Thorpe Neuhaus Real Estate Inc

    Section Image
  • 10413 Durango Place, Longmont, CO 80504

    $439,900

    • 3 Beds
    • 2.5 Baths
    • 1,558 Sq Ft
    • 10413 Durango Place
    • Longmont, CO

    Fabulous 3 Bed, 2.5 Bath home in Idaho Creek! Enjoy the over 30 acres of community open space with expansive mountain views, pond and trails at the Idaho Creek Open Space Park just steps out of your front door. The inviting main level features an open-concept floor plan creating the perfect space for both entertaining and relaxing with updated flooring and a convenient powder bath. The kitchen

    Paul Andrews Resident Realty

    Section Image
  • 257 2nd St, Frederick, CO 80530

    $420,000

    • 4 Beds
    • 2.5 Baths
    • 1,486 Sq Ft
    • 257 2nd St
    • Frederick, CO

    Welcome to this pottery barn perfect, small-town, 4-bedroom, 3-bath home, brimming with warmth, character, and tasteful updates! Built just ten years after the turn of the 20th century makes this gorgeous home one of Fredericks original homesteads.Nestled on a spacious corner lot in the heart of Old Town, this historic gem blends timeless charm with today’s comforts.The home’s rich

    Sascha Brand Reagency Realty LLC

    Section Image

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

Purchase History

Date Type Sale Price Title Company
Warranty Deed $612,000 None Listed On Document
Interfamily Deed Transfer -- None Available
Warranty Deed $400,000 Land Title Guarantee Co
Special Warranty Deed $281,000 Heritage Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $581,400 New Conventional
Previous Owner $94,500 Construction
Previous Owner $456,000 VA
Previous Owner $387,800 VA
Previous Owner $400,000 New Conventional
Previous Owner $252,900 New Conventional
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/29/2022 07/29/22 Sold $612,000 +2.2% $210 / Sq Ft
07/08/2022 07/08/22 Pending -- -- --
07/06/2022 07/06/22 For Sale $599,000 -2.1% $205 / Sq Ft
07/06/2022 07/06/22 Off Market $612,000 -- --
06/27/2022 06/27/22 Price Changed $599,000 -2.6% $205 / Sq Ft
06/21/2022 06/21/22 Price Changed $615,000 -5.4% $211 / Sq Ft
06/15/2022 06/15/22 Price Changed $650,000 -2.3% $223 / Sq Ft
06/01/2022 06/01/22 For Sale $665,000 +66.3% $228 / Sq Ft
01/28/2019 01/28/19 Off Market $400,000 -- --
01/28/2019 01/28/19 Off Market $281,000 -- --
10/20/2017 10/20/17 Sold $400,000 -2.4% $185 / Sq Ft
09/08/2017 09/08/17 Pending -- -- --
07/20/2017 07/20/17 For Sale $410,000 +45.9% $189 / Sq Ft
07/23/2012 07/23/12 Sold $281,000 +0.3% $104 / Sq Ft
06/23/2012 06/23/12 Pending -- -- --
01/01/2012 01/01/12 For Sale $280,250 -- $104 / Sq Ft
Source: IRES MLS

Tax History Compared to Growth

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 $5,042 $43,920 $7,190 $36,730
2024 $5,042 $43,920 $7,190 $36,730
2023 $4,547 $46,310 $9,130 $37,180
2022 $2,580 $31,670 $5,910 $25,760
2021 $2,604 $32,580 $6,080 $26,500
2020 $2,599 $32,730 $4,220 $28,510
2019 $2,637 $32,730 $4,220 $28,510
2018 $2,179 $29,130 $3,740 $25,390
2017 $2,958 $29,130 $3,740 $25,390
2016 $2,723 $26,380 $3,180 $23,200
2015 $2,639 $26,380 $3,180 $23,200
2014 $2,196 $21,970 $2,390 $19,580
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 827195

IRES MLS

APN: R0737901