$281,000
SOLD JUL 23, 2012

9043 Harlequin Cir Frederick, CO 80504

4 Beds
3.5 Baths
2,690 Sq Ft
7,150 Sq Ft Lot

Recently Sold

$104 Per Sq Ft

176 Days on Market

Highlights

  • Under Construction
  • City View
  • Wood Flooring
  • Green Energy Generation
  • Contemporary Architecture
  • Loft

About This Home

As of July 2022

New construction by Saint Aubyn Homes- this plan just got introduced to the product lineup and features a huge great room off a very open kitchen. It has extensive standard features including granite counter tops, hardwood flooring, 42" uppers, 5 piece master and air conditioning. Seller is paying $5000 towards buyers closing costs. There are no HOA fees or Special Taxing Districts in this subdivision- increasing the buyers purchasing power. Builder contract required.

Last Agent to Sell the Property

Stephen Balliet

Balliet Realty Listed on: 01/01/2012

Last Buyer's Agent

Non-IRES Agent

Non-IRES

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $318

Year Built

  • Built in 2012 | Under Construction

Lot Details

  • 7,150 Sq Ft Lot
  • Sprinkler System

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof

Interior Spaces

  • 3,855 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Dining Room
  • Loft
  • City Views
  • Unfinished Basement
  • Basement Fills Entire Space Under The House
  • Laundry on upper level

Kitchen

  • Electric Oven or Range
  • Dishwasher

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Green Energy Generation

Outdoor Features

  • Patio
  • Exterior Lighting

Schools

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

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number R0737901

Community Details

Overview

  • No Home Owners Association
  • Built by Saint Aubyn Homes
  • Noname Creek West Subdivision

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$318

Year Built

Built in 2012 | Under Construction

Lot Details

0

Parking

3

Listing Details

  • Year Built: 2012
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.16
  • Road Frontage Type: City Street
  • Road Surface Type: Paved
  • Subdivision Name: NoName Creek West
  • Directions: From I25, Go East on Hwy 119 to CR 13 (Colorado Blvd), Go South to CR 20 (Pine Cone Ave), Go West to 3rd Entrance of NoName Creek, Go North to listing
  • Above Grade Finished Sq Ft: 2690
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: Yes
  • Efficiency: HVAC, Energy Rated
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3855
  • Special Features: NewHome
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Dishwasher
  • Has Basement: Full, Unfinished
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1165
  • Interior Amenities: Separate Dining Room, Pantry, Walk-In Closet(s), Loft
  • Living Area: 2690
  • Room Bedroom4 Area: 121
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Upper
  • Room Bedroom3 Area: 132
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 132
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 16
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Room Kitchen Area: 154
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 240
  • Room Dining Room Area: 154
  • Master Bathroom Features: 5 Piece Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Composition
  • Builder Name: Saint Aubyn Homes
  • Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Water Rights Excluded
  • View: City
  • Waterfront: No
  • Construction Type: Wood/Frame
  • Exterior Features: Lighting
  • Patio And Porch Features: Patio
  • Property Condition: Under Construction

Garage/Parking

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

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, United Power
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Frederick
  • Gas Company: Natural Gas, Source Gas

Condo/Co-op/Association

  • Community Features: Park
  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

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

Lot Info

  • Zoning: R-1
  • Lot Size Sq Ft: 7150
  • Parcel #: R0737901
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2011
  • Tax Annual Amount: 318

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 Frederick, CO

  • 7870 Cattail Green Unit 122, Frederick, CO 80530

    $265,000

    • 2 Beds
    • 2 Baths
    • 1,247 Sq Ft
    • 7870 Cattail Green
    • Unit 122
    • Frederick, CO

    Welcome to this meticulously maintained 2-bedroom, 2-bath home nestled in Prairie Greens, one of Frederick’s desired communities. Perfectly situated just minutes from the Carbon Valely Rec Center, restaurants, and the new Soopers Marketplace. With easy access to I-25, this home combines convenience, comfort, and value.Inside, you’ll love the open-concept layout, ideal for both

    Patrick Laurienti Colorado Home Realty

    Section Image
  • 6261 Redcedar St, Frederick, CO 80530

    $289,932

    • 3 Beds
    • 2 Baths
    • 1,508 Sq Ft
    • 6261 Redcedar St
    • Frederick, CO

    New home in Prairie Greens. New home has stainless steel Whirlpool Kitchen appliances, large kitchen island, cabinet lighting in kitchen, gas fireplace in living room, 10'+ ceilings in kitchen, soft close drawers throughout, large master bedroom, large walk in master closet, and home comes with fully landscaped yard, attached 2 car garage, central air, and a 12 month builder warranty

    Jeff Henry Real Estate One Group South Llc

    Section Image
  • 7971 Larkspur Cir Unit 219, Frederick, CO 80530

    $294,900

    • 3 Beds
    • 2 Baths
    • 1,662 Sq Ft
    • 7971 Larkspur Cir
    • Unit 219
    • Frederick, CO

    Wonderful spacious home in Prairie Greens with tons of of great features. This home is so well cared for and offers so many upgrades! Nice open floor plan with lots of natural light. The spacious kitchen has upgraded cabinets, great appliances and ample counter space. There is an eating area in the kitchen as well as a dining room. You will enjoy the extra space the bonus room adds - great space

    Jeff Henry Real Estate One Group South Llc

    Section Image
  • 6150 Bluestem Green, Frederick, CO 80530

    $275,000

    • 3 Beds
    • 2 Baths
    • 1,314 Sq Ft
    • 6150 Bluestem Green
    • Frederick, CO

    This bright and inviting 3-bedroom, 2-bath home offers an open layout filled with natural light, perfect for comfortable living and entertaining. Located in a vibrant community in Frederick with access to a community pool, gym, and just minutes from shopping, dining.

    Joanna Gerdes Keller Williams 1st Realty

    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: 677983

IRES MLS

APN: R0737901