9043 Harlequin Circle

Frederick, CO 80504

$612,000
Last Sold Price
4
Beds
4
Baths
3,822 Sq. Ft.
$160 / Sq. Ft.
3,822
Sq. Ft.
$160
per Sq. Ft.

Description

This unique 4 bedroom St. Aubyn Home is in the highly sought-after No Name Creek subdivision walking distance to the Bella Rosa Golf Course and NO HOA. The beautiful kitchen overlooks the dining room, with granite countertops and black stainless steel appliances. Large family room with a gas fireplace for those chilly Colorado days. Plenty of natural sunlight throughout the home. Fantastic mudroom with storage under the bench. New stain-resistant carpet throughout. Upstairs you will find the primary...This unique 4 bedroom St. Aubyn Home is in the highly sought-after No Name Creek subdivision walking distance to the Bella Rosa Golf Course and NO HOA. The beautiful kitchen overlooks the dining room, with granite countertops and black stainless steel appliances. Large family room with a gas fireplace for those chilly Colorado days. Plenty of natural sunlight throughout the home. Fantastic mudroom with storage under the bench. New stain-resistant carpet throughout. Upstairs you will find the primary en-suite with a 5-piece bathroom and dual-sided fireplace situated perfectly for a relaxing getaway in your own bathroom, a separate shower, double sink vanity with granite top, and a walk-in closet. Junior Suite and 2 more additional bedrooms, a small loft, and a very convenient upstairs laundry. An oversized 3-car garage with built-in overhead storage, 220v for welders, air compressors, and or car charging. The driveway is OVERSIZED. The basement has been framed out and has high-grade epoxy flooring with a lifetime warranty through Ninja Flooring. Radon Mitigation Installed

Roof -2018, Blue Ribbon Home Warranty (Gold Plan) paid through May 26, 2023/ This covers all appliances in the home, AC, Furnace, and Water heater. The home has ADT at the cost of $39.99/month and is transferrable to the new homeowner if they would like. Other inclusions: Kitchen bar stools, Bar Mirror, glasses, and stools in the basement, refrigerator in the basement,
  1. Listed by Marie Warren • Coldwell Banker Realty - LoveLand

Property Details for 9043 Harlequin Circle

Structure Type
House
Architectural Style
A-Frame
Levels
Two
Stories
2
Subdivision Name
No Name Creek
Association
No
Basement
Yes

Location

Listing Courtesy of Coldwell Banker Realty - LoveLand, Marie Warren

Sold By Vestra Realty Group, Mitchell Mahaffey

Add your commute
LISTING UPDATED: 07/29/2022 03:03 PM

Property Details for 9043 Harlequin Circle

StatusClosed
MLS #8241927
Days on Compass37
Taxes$2,604 / year
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential-Detached
Year Built2012
Lot Size0.16 AC / 7,150 SF
CountyWeld County

Location

Listing Courtesy of Coldwell Banker Realty - LoveLand, Marie Warren

Sold By Vestra Realty Group, Mitchell Mahaffey

Add your commute

Building Information for 9043 Harlequin Circle

Stories-Year Built2012Building Size-Lot Size0.16 AC / 7,150 SF

Payment Calculator

$3,557 per month

30 year fixed, 7.25% Interest

Principal and Interest

$3,340

Property Taxes

$217

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 9043 Harlequin Circle

Interior Area & SqFt
Interior Area & SqFt
  • Building Area Total (SqFt Total): 3822
  • Sqft Total: 3822
  • Living Area (SqFt Finished): 2915
  • Above Grade Finished Area: 2666
  • Living SqFt: 2666
  • Sq Ft Apx: 249
  • Below Grade Unfinished Area: 907
  • Area Source: Public Records
  • PSF Total: 160
  • PSF Above Grade: 230
  • PSF Finished: 210
  • Master on Main: No
  • Direction Faces: East
  • Room and Floor: Kitchen-Main-1, Family Room-Main-1, Dining Room-Main-1, Bathroom (Full)-Upper-1, Bathroom (Full)-Upper-2, Laundry-Upper-1, Bedroom-Upper-1, Bedroom-Upper-2, Bedroom-Upper-3, Primary Bedroom-Upper-1, Primary Bathroom (Full)-Upper-1, Mud Room-Main-1, Loft-Upper-1, Bathroom (1/2)-Main-1
  • Room Count: 14
  • Basement: Partial, Unfinished
  • Foundation Details: Slab
  • Fireplaces Total: 2
  • Fireplace Features: Bedroom, Family Room
  • Heating: Forced Air, Natural Gas
  • Cooling: Central Air
  • HVAC Description: Central Air Conditioning
  • Interior Features: Eat-in Kitchen, Five Piece Bath, Granite Counters, High Ceilings, Radon Mitigation System, Walk-In Closet(s), Wet Bar
  • Security Features: Carbon Monoxide Detector(s), Radon Detector, Security System, Smart Locks, Smoke Detector(s)
  • Flooring: Carpet, Laminate
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Oven, Range Hood, Refrigerator, Self Cleaning Oven, Washer
  • Laundry Features: In Unit
  • Virtual Tour URL Unbranded: https://show.tours/e/yPMh9st
Bed & Bath Summary
Bedrooms
  • Bedrooms Total: 4
  • Upper Level Bedrooms: 4
  • Main Level Bedrooms: 0
  • Lower Level Bedrooms: 0
  • Basement Level Bedrooms: 0
Bathrooms
  • Bathrooms Total: 4
  • Upper Level Bathrooms: 3
  • Main Level Bathrooms: 1
  • Lower Level Bathrooms: 0
  • Basement Level Bathrooms: 0
  • Bathrooms Full: 3
  • Bathrooms Three Quarter: 0
  • Bathrooms Half: 1
  • Bathrooms One Quarter: 0
Detailed Room Info
Room 1
  • Room Type: Kitchen
  • Room Level: Main
  • Room Description: Tile Flooring
  • Room Length: 14
  • Room Width: 12
Room 2
  • Room Type: Family Room
  • Room Level: Main
  • Room Description: Carpet
  • Room Length: 17
  • Room Width: 18
Room 3
  • Room Type: Dining Room
  • Room Level: Main
  • Room Description: Dining room just off the kitchen/ Tile Flooring
  • Room Length: 20
  • Room Width: 12
Room 4
  • Room Type: Bathroom (Full)
  • Room Level: Upper
  • Room Description: Carpet
  • Room Length: 12
  • Room Width: 11
Room 5
  • Room Type: Laundry
  • Room Level: Upper
  • Room Description: Conveniently located upstairs with bedrooms
  • Room Length: 20
  • Room Width: 12
Room 6
  • Room Type: Bedroom
  • Room Level: Upper
  • Room Description: Carpet
  • Room Length: 11
  • Room Width: 12
Room 7
  • Room Type: Bedroom
  • Room Level: Upper
  • Room Description: Carpet
  • Room Length: 12
  • Room Width: 10
Room 8
  • Room Type: Bedroom
  • Room Level: Upper
  • Room Description: Carpet
  • Room Length: 17
  • Room Width: 17
Room 9
  • Room Type: Primary Bedroom
  • Room Level: Upper
  • Room Description: Double sided fire Place to bathtub and bedroom
  • Room Length: 16
  • Room Width: 17
Room 10
  • Room Type: Primary Bathroom (Full)
  • Room Level: Upper
  • Room Description: 5 Piece Bathroom
Room 11
  • Room Type: Mud Room
  • Room Level: Main
  • Room Description: Mud Room with bench storage
Room 12
  • Room Type: Loft
  • Room Level: Upper
  • Room Description: Loft opens up to 2nd floor balcony
  • Room Length: 8
  • Room Width: 7
Room 13
  • Room Type: Bathroom (1/2)
  • Room Level: Main
  • Room Description: powder room on main foor
Room 14
  • Room Type: Bathroom (Full)
  • Room Level: Upper
  • Room Description: located in 2nd bedroom
Room 15
  • Room Type: Bathroom (3/4)
  • Room Level: Basement
Parking
Parking
  • Parking Features: Concrete, Oversized
  • Attached Garage: Yes
  • Parking Type: Garage (Attached), Off-Street
  • Parking Description: Garage (Attached)-3, Off-Street-5
  • Parking Details: 3, 5
  • Parking Total: 2
  • Garage Spaces: 3
  • Offstreet Spaces: 5
  • Parking Count: 8
  • Carport Spaces: 0
  • Reserved Spaces: 0
  • RV Spaces: 0
Association Information
Association Information
  • Association Fee Total Annual: $0
  • Association Amenities: Park
  • Senior Community: No
Site & Location Information
School Information
  • School Of Choice: No
  • Elementary School: Legacy
  • Elementary School District: St. Vrain Valley RE-1J
  • Middle Or Junior School: Coal Ridge
  • High School: Frederick
  • High School District: St. Vrain Valley RE-1J
Site & Location Information
  • Lot Size Acres: 0
  • Lot Size Square Feet: 7150
  • PSF Lot: $86
  • Lot Features: Sprinklers In Front, Sprinklers In Rear
  • Zoning: RES
  • Property Exclusions: Sellers Personal property, Refridgerator in the garage, Curtains, Chickens in the yard and small blue chicken coop. All staging decor, towels, curtains, rugs.
Building Information
Green Features
  • Green Verification Count: 0
Outbuildings
  • Out Building Count: 1
  • Number of Out Buildings: 2.0
  • Horse: No
Building Information
  • Builder Name: Saint Aubyn Homes LLC
  • Construction Materials: Brick, Wood Siding
  • Roof: Composition
  • Exterior Features: Balcony
  • Patio And Porch Features: Front Porch, Patio
  • Builder Model: St Aubryn Home
  • Livable Structure Count: 0
Water & Utilities
Water & Utilities
  • Sewer Tap: No
  • Water Included: Yes
  • Water Source: Public
  • Water Tap Paid: No
  • Utilities: Cable Available, Electricity Connected, Internet Access (Wired), Natural Gas Available
  • Sewer: Public Sewer
  • Electric: 110V, 220 Volts

Property History for 9043 Harlequin Circle

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 9043 Harlequin Circle

Taxable ValueLand$9,130Additions$37,180Total$46,310
Tax Record2023$4,547 ($379 / month)
Home Facts
Beds4Total Finished SqFt3,702 SqFtAbove Grade Finished SqFt2,666 SqFtFinished Basement SqFt1,036 SqFtUnfinished Basement SqFt1,156 SqFtStories2Lot Size7,144 SqFtStyleSingle Family ResidenceYear Built2012CountyWELDAPNR0737901

Schools near 9043 Harlequin Circle

This home is within St Vrain Valley Re 1j School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Charter - PK to 8
Rating
School
Distance
Centennial Elementary School
PublicPK to 5

Coal Ridge Middle School
Public6 to 8

Mead High School
Public9 to 12

Firestone Charter Academy
CharterPK to 8

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Coldwell Banker Realty - LoveLand, Marie Warren

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than Compass are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified. This publication is designed to provide information with regard to the subject matter covered. It is displayed with the understanding that the publisher and authors are not engaged in rendering real estate, legal, accounting, tax, or other professional services and that the publisher and authors are not offering such advice in this publication. If real estate, legal, or other expert assistance is required, the services of a competent, professional person should be sought. The information contained in this publication is subject to change without notice. METROLIST, INC., DBA RECOLORADO MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. METROLIST, INC., DBA RECOLORADO SHALL NOT BE LIABLE FOR ERRORS CONTAINED HEREIN OR FOR ANY DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL. All real estate advertised herein is subject to the Federal Fair Housing Act and the Colorado Fair Housing Act, which Acts make it illegal to make or publish any advertisement that indicates any preference, limitation, or discrimination based on race, color, religion, sex, handicap, familial status, or national origin. METROLIST, INC., DBA RECOLORADO will not knowingly accept any advertising for real estate that is in violation of the law. All persons are hereby informed that all dwellings advertised are available on an equal opportunity basis. © 2024 METROLIST, INC., DBA RECOLORADO® - All Rights Reserved 6455 S. Yosemite St., Suite 300 Greenwood Village, CO 80111 USA. ALL RIGHTS RESERVED WORLDWIDE. No part of this publication may be reproduced, adapted, translated, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. The information contained herein including but not limited to all text, photographs, digital images, virtual tours, may be seeded and monitored for protection and tracking.