Stunning former model home with countless upgrades & design features. Walk trails to Bella Rosa golf course and lake Milavec, plus private neighborhood pool. A grand staircase greets you as you enter this beautiful home. The huge open kitchen has granite counters, double oven, separate cooktop, dishwasher, refrigerator, microwave (all appliances included) plus expansive counter and cabinet space, walk-in pantry, wrap around bar, and huge separate eat-in area. The kitchen opens to the bright family room w/cozy fireplace, soaring ceilings and lookout to upstairs. Formal dining room off the kitchen w/coffered ceilings. Main level suite with design features, walk-in closet and 3/4 bath. Main level also boasts a large private office w/french doors, and a living room w/vaulted ceiling. The upper level has a large open loft w/built-in desk; roomy bedrooms 2 & 3 with a jack-and-jill full bath/double sinks. The masterpiece of the upper level is the huge primary bedroom with breathtaking views, fireplace, large walk-in closet plus luxury 5 piece bath w/quartz counters and freestanding designer soak tub. The finished basement has a large bedroom w/walk-in closet, 3/4 bath, huge media room - projector & surround system included; fitness area, and three separate storage rooms. The beautiful professionally landscaped backyard looks out to open space with walking trail. Huge wrap around patio includes gazebo and landscaped walk to built-in firepit. Oversized garage with finished floor, cabinets, shop vac, EV HOOKUP, TV and shelves included. Home has dual zone heat and AC for added comfort. H2O heater, furnace and roof have all been replaced in last 5 years. Tons of upgrades and designer features throughout this stunner!
Utility FeaturesNatural Gas Available, Electricity Available
WATER SOURCECity Water, town of frederick
Year Built2008
BasementPartially Finished
FINISHED BASEMENT SIZE1663.0
RoofComposition
Parking FeaturesOversized
FenceFenced
Lot FeaturesZero Lot Line, Lawn Sprinkler System, Corner Lot, Abuts Public Open Space
Garage spaces3
ViewMountain
CITYFrederick
SUBDIVISIONMoore Farm Sub
COUNTYWeld
AREAGreeley/Weld
STATECO
SENIOR COMMUNITYNo
COMMUNITY FEATURESPool, Hiking/Biking Trails
HOA1
TAX AMOUNT5263.0
HOA FEE693.0
HOA FREQUENCYAnnually
LATEST UPDATE2025-06-05T19:43:07.894Z
DAYS ON MARKET2
PRICE CHANGE(S)
$924,900 Jun 4, 2025
CUMULATIVE DAYS ON MARKET2
Market Trends
New Properties On Market
95
6%
Increase In New Listings
Average Asking Price
$724,551
$2,638 Decrease In Avg Asking Price
Average Asking Price / Sq. Ft.
$247
$20 Decrease In List Price/Sq. Ft.
Average Days On Market
10
24 Day
Decrease In Days On Market
Data as of Jun 07, 2025.
Remaining statistics above are calculated on activity within the period from Apr 01, 2025 to May 31, 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.