This stunning Frederick home is only two years old, sits on a quiet cul-de-sac facing the Rocky Mountains, boasts high-end upgrades from top to bottom and has the backyard you've been dreaming of. Step inside the front door to discover a floor plan flooded with natural light, luxury vinyl floors, designer fixtures and a bold kitchen with rich, dark cabinetry, dark leathered countertops and woven rattan pendant lights. Draw open the double sliding doors to a generous sized, covered back concrete patio perfect for summertime dinners with the family, entertaining guests and relaxing on a Sunday. The fenced yard includes flower beds, raised garden beds, an added storage shed and a lush, level lawn perfect for playing and running. The main-floor office with a closet offers flexibility as a fourth bedroom, home gym, playroom, or guest space. Conveniently located just off the entry, it's paired with a nearby half bath and sits privately apart from the main living and kitchen. Upstairs, the primary suite shares the same bold, sophisticated feel as the kitchen and overlooks the green backyard. The second level is finished with two more bedrooms - one capturing the Rocky Mountain views, convenient laundry room and full bath. These sellers spared no expense when choosing upgrades for this home (including pre-wiring for whole home audio) and you'll be thankful when it becomes yours! Located in a desirable, new neighborhood with soccer and toddler park, close to the brand King Soopers shopping center, Frederick High School and just minutes from I25.
Utility FeaturesNatural Gas Available, Electricity Available
SEWERCity Sewer
WATER SOURCECity Water, Town of Frederick
Year Built2023
BasementNone, Built-In Radon
FINISHED BASEMENT SIZE0.0
RoofComposition
FenceFenced
Lot FeaturesLawn Sprinkler System
Garage spaces2
Other StructuresStorage
CITYFrederick
SUBDIVISIONSilverstone Fg 1 Rplt B
COUNTYWeld
AREAGreeley/Weld
STATECO
SENIOR COMMUNITYNo
HOA1
TAX AMOUNT5399.0
HOA FEE60.0
HOA FREQUENCYMonthly
LATEST UPDATE2025-10-09T01:05:12.290Z
DAYS ON MARKET22
PRICE CHANGE(S)
$560,000 Sep 13, 2025
$555,000 Oct 6, 2025
CUMULATIVE DAYS ON MARKET22
Market Trends
New Properties On Market
101
13%
Increase In New Listings
Average Asking Price
$677,473
$148,409 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$226
$34 Decrease In List Price/Sq. Ft.
Average Days On Market
14
29 Day
Decrease In Days On Market
Data as of Oct 08, 2025.
Remaining statistics above are calculated on activity within the period from Aug 01, 2025 to Sep 30, 2025.
Mortgage Calculator
The information provided by this calculator is for illustrative purposes only and accuracy is not guaranteed. The values and figures shown are hypothetical and may not be applicable to your individual situation. Be sure to consult a financial professional prior to relying on the results. This calculator does not have the ability to pre-qualify you for any mortgage or loan program. Qualification for mortgages or loans requires additional information such as credit scores and existing debts which is not gathered in this calculator. Information such as interest rates and pricing are subject to change at any time and without notice. All information such as interest rates, taxes, insurance, monthly mortgage payments, etc. are estimates and should be used for comparison only.