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 RealtyListed 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
DateNameOwned ForOwner Type
Jul 2022 - PresentHambach Mark and Hambach Joerg3 Years
Private Individual
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
Jun 2020 - Jul 2022Webb Audrey M and Webb James D2 Years and 1 Month
Private Individual
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
Oct 2017 - Jun 2020Gippe Audrey M2 Years and 8 Months
Private Individual
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
Jul 2012 - Oct 2017White Abraham and White Frances T5 Years and 3 Months
Private Individual
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.
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
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
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
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.
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
Tax AssessmentTax 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.
This home is located at 9043 Harlequin Cir, Frederick, CO 80504 and is currently priced at $281,000, approximately $104 per square foot. This property was built in 2012. 9043 Harlequin Cir is a home located in Weld County with nearby schools including Centennial Elementary School, Coal Ridge Middle School, and Mead High School.
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information deemed reliable but not guaranteed by the MLS.