9100 Harlequin Cir Frederick, CO 80504
5
Beds
4.5
Baths
3,788
Sq Ft
0.42
Acres
Highlights
- Outdoor Pool
- Open Floorplan
- Deck
- Primary Bedroom Suite
- Fireplace in Primary Bedroom
- Contemporary Architecture
About This Home
As of February 2024This Gorgeous Home features five bedrooms, three full bathrooms (upper level), one 3/4 bathroom (basement), and a half bath (main Level). The open floor plan provides for easy entertaining. The Kitchen has ample cabinet space, stainless steel appliances, and granite countertops with a breakfast bar. There's plenty of room for formal dining. You will relax and enjoy the large living room next to the fireplace. The Primary Bedroom also features a two-sided fireplace when you want to enjoy those quiet moments with your significant other or enjoy a bath under the warmth of your fireplace. The basement has been professionally finished and features a custom wet bar, media room, large bedroom, and 3/4 bath. The third stall of the 3-car garage has been converted into a work studio with a separate entrance for those who prefer to work from home. The lot is over 18,000 square feet (almost a half acre) and features a fenced garden area and an above-ground swimming pool. No HOA fees to deal with!
Last Agent to Sell the Property
Aragon Realty Group Brokerage Email: Paul@TheAragonGroup.net,303-525-8915 License #001312797 Listed on: 01/04/2024
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $3,849
Year Built
- Built in 2012 | Remodeled
Lot Details
- 0.42 Acre Lot
- Cul-De-Sac
- Northwest Facing Home
- Partially Fenced Property
- Landscaped
- Level Lot
- Front and Back Yard Sprinklers
- Irrigation
- Garden
- Grass Covered Lot
Parking
- 3 Car Attached Garage
- Exterior Access Door
Home Design
- Contemporary Architecture
- Frame Construction
- Composition Roof
- Cement Siding
- Stone Siding
- Concrete Perimeter Foundation
Interior Spaces
- 2-Story Property
- Open Floorplan
- High Ceiling
- Ceiling Fan
- Gas Log Fireplace
- Double Pane Windows
- Entrance Foyer
- Living Room with Fireplace
- 2 Fireplaces
Kitchen
- Breakfast Area or Nook
- Eat-In Kitchen
- Self-Cleaning Oven
- Range
- Microwave
- Dishwasher
- Granite Countertops
- Disposal
Flooring
- Wood
- Carpet
- Laminate
- Tile
Bedrooms and Bathrooms
- 5 Bedrooms
- Fireplace in Primary Bedroom
- Primary Bedroom Suite
Finished Basement
- Basement Fills Entire Space Under The House
- Interior Basement Entry
- 1 Bedroom in Basement
Eco-Friendly Details
- Smoke Free Home
Outdoor Features
- Outdoor Pool
- Balcony
- Deck
Schools
- Legacy Elementary School
- Coal Ridge Middle School
- Frederick High School
Utilities
- Forced Air Heating and Cooling System
- 220 Volts
- 110 Volts
- Natural Gas Connected
- Gas Water Heater
- Cable TV Available
Community Details
- No Home Owners Association
- No Name Creek Subdivision
Listing and Financial Details
- Exclusions: Washer/Dryer Garage Fridge, Bar Fridge, Garage freezer, Hot tub, All TV’s, Outdoor Speakers, outdoor Cameras, Stereo receiver in basement
- Assessor Parcel Number R0742601
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jan 4, 2024
Closed on
Feb 29, 2024
Sold by
Willis Lindsay Rae and Willis Gwen
Bought by
Hanson Dustin Jon
Seller's Agent
Paul Aragon
Aragon Realty Group
Buyer's Agent
Katherine McCaslin
Real Broker, LLC DBA Real
List Price
$730,000
Sold Price
$695,000
Premium/Discount to List
-$35,000
-4.79%
Views
51
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$31,690
Avg. Annual Appreciation
4.17%
Original Mortgage
$625,500
Outstanding Balance
$616,251
Interest Rate
6.6%
Mortgage Type
New Conventional
Estimated Equity
$119,644
Purchase Details
Closed on
Mar 29, 2019
Sold by
Arriaga Julio and Mestas Lillian
Bought by
Willis Lindsay Rae and Willis Rudolph
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$456,000
Interest Rate
4.3%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jul 27, 2018
Closed on
Aug 31, 2018
Sold by
Kruchten Joshua P and Kruchten Emily M
Bought by
Arriaga Julio and Mestas Lillian
Seller's Agent
Michelle Bodin
LIV Sotheby's Intl Realty
Buyer's Agent
Lacey Valdez
Rockwell Realty
List Price
$445,000
Sold Price
$450,000
Premium/Discount to List
$5,000
1.12%
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.39%
Original Mortgage
$365,079
Interest Rate
4.5%
Mortgage Type
FHA
Purchase Details
Closed on
Dec 28, 2012
Sold by
Saint Aubyn Homes Llc
Bought by
Kruchten Joshua P and Kruchten Emily M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$289,275
Interest Rate
3.35%
Mortgage Type
New Conventional
Similar Homes in the area
-
$614,900
- 5 Beds
- 3 Baths
- 3,704 Sq Ft
- 5708 Wetland Loop
- Longmont, CO
Showings start May 8th. Big dreams need big spaces — and this sprawling ranch delivers! Offering over 3,800 square feet of living space, 5 bedrooms, 3 bathrooms, and a finished basement designed for connection and comfort. The main level features soaring ceilings, an open layout, a sunny eat-in kitchen, and a private primary suite tucked on its own wing with a five-piece bath and sliding doors
Aaron Fernandez Homes Across Colorado
-
$674,900
- 4 Beds
- 2.5 Baths
- 2,681 Sq Ft
- 5520 Morgan Way
- Frederick, CO
4-Car Garage! Welcome to your new, stunning semi-custom home in the heart of the highly sought-after Moore Farm community. As you enter the home, you are greeted by a grand two-sided staircase that sets the tone for the elegant design throughout. The formal dining room and living room open to the entry hall. The extensive wood floors downstairs add warmth and character to a beautifully
Eric Morris Fathom Realty Colorado LLC
-
$690,000
- 3 Beds
- 3.5 Baths
- 3,323 Sq Ft
- 5483 Gunnison Dr
- Longmont, CO
OK, get ready for your next HOME! Before you Walk into the "L" Shaped Front porch to the 2 story entry look to the left and check out the amazing uninterrupted mountain view and beautiful community park across the street!! You'll immediately be impressed with the NEW PAINT and CARPET throughout the home as well as the solid hardwood flooring. The formal dining room allows for holiday
Betsy Moser Moser Real Estate Group
-
$609,900
- 3 Beds
- 2.5 Baths
- 2,033 Sq Ft
- 9046 Sandpiper Dr
- Longmont, CO
Welcome to this stunning home you will want to make your own! You will be delighted to enter the open spacious living room with vaulted ceiling, large windows and gas fireplace. Fabulous kitchen with eat in dining and breakfast bar along with beautiful granite counters, plank flooring, an abundance of cabinet space and a pantry. Highly sought after main floor master bedroom suite with vaulted
Cindi Brady Berkshire Hathaway Home Services, Rocky Mountain Realtors
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
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $695,000 | Land Title Guarantee | |
| Warranty Deed | $480,000 | 8Z Title | |
| Warranty Deed | $450,000 | Heritage Title Co | |
| Special Warranty Deed | $304,500 | Heritage Title |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $625,500 | New Conventional | |
| Previous Owner | $467,500 | New Conventional | |
| Previous Owner | $456,000 | New Conventional | |
| Previous Owner | $365,079 | FHA | |
| Previous Owner | $289,275 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 02/29/2024 02/29/24 | Sold | $695,000 | 0.0% | $183 / Sq Ft |
| 01/19/2024 01/19/24 | Pending | -- | -- | -- |
| 01/16/2024 01/16/24 | Price Changed | $695,000 | -4.8% | $183 / Sq Ft |
| 01/04/2024 01/04/24 | For Sale | $730,000 | +62.2% | $193 / Sq Ft |
| 11/29/2019 11/29/19 | Off Market | $450,000 | -- | -- |
| 08/31/2018 08/31/18 | Sold | $450,000 | +1.1% | $169 / Sq Ft |
| 08/01/2018 08/01/18 | Pending | -- | -- | -- |
| 07/27/2018 07/27/18 | For Sale | $445,000 | -- | $167 / Sq Ft |
Source: REcolorado®
Tax History Compared to Growth
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 | $4,494 | $46,360 | $7,190 | $39,170 |
| 2024 | $4,494 | $46,360 | $7,190 | $39,170 |
| 2023 | $4,431 | $47,300 | $9,130 | $38,170 |
| 2022 | $3,849 | $32,220 | $5,910 | $26,310 |
| 2021 | $3,514 | $33,140 | $6,080 | $27,060 |
| 2020 | $3,500 | $33,270 | $4,220 | $29,050 |
| 2019 | $3,550 | $33,270 | $4,220 | $29,050 |
| 2018 | $2,984 | $30,040 | $3,740 | $26,300 |
| 2017 | $3,050 | $30,040 | $3,740 | $26,300 |
| 2016 | $2,791 | $27,040 | $3,180 | $23,860 |
| 2015 | $2,705 | $27,040 | $3,180 | $23,860 |
| 2014 | $2,226 | $22,270 | $2,390 | $19,880 |
Source: Public Records
Agents Affiliated with this Home
-
Paul Aragon
Seller's Agent in 2024
Paul Aragon
Aragon Realty Group
(303) 525-8915
80 Total Sales
-
Katherine McCaslin
Buyer's Agent in 2024
Katherine McCaslin
Real Broker, LLC DBA Real
(970) 402-9329
156 Total Sales
-
Michelle Bodin
Seller's Agent in 2018
Michelle Bodin
LIV Sotheby's Intl Realty
(303) 884-4442
60 Total Sales
-
L
Buyer's Agent in 2018
Lacey Valdez
Rockwell Realty
Map
Source: REcolorado®
MLS Number: 4514104
APN: R0742601
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.
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 Ten-X 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.
PUBLISHER’S NOTICE: 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.
© 2025 METROLIST, INC., DBA RECOLORADO® – All Rights Reserved. 6455 S. Yosemite St., Suite 500 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.
Nearby Homes
- 8839 Shetland Dr
- 5547 Drake Way
- 9018 Harlequin Cir
- 5708 Wetland Loop
- 5493 Bobcat St
- 5520 Morgan Way
- 9147 Harlequin Cir
- 5483 Gunnison Dr
- 9046 Sandpiper Dr
- 5520 Pinto St
- 5516 Wetlands Dr
- 5475 Shoshone Dr
- 5753 Pintail Way
- 5220 Bella Rosa Pkwy
- 5895 E Conservation Dr
- 6251 County Road 20
- 9650 Raven St
- 9673 Roadrunner Ave
- 5131 Mount Saint Vrain Ave
- 11739 County Road 13