Open House Sat, Sep 19th 11:00 AM - 04:00 PM - Views - New Construction
Address
5841 Aspenglow St, Firestone, CO
Price
$ 799,000
Property Attributes
  • MLS#1038462
  • TypeSingle Family
  • Listing Status Active
  • CountyWELD
  • CityFirestone
  • AreaGreeley-Weld
  • NeighborhoodBarefoot Lakes Fg 6
  • Zip80504
  • StyleContemporary
  • Year Built2025
  • Taxes$ 1278
  • Price$ 799,000
  • Bedrooms5
  • Full Bathrooms4
  • Half Bathrooms1
  • Sqr Footage3117
  • Lot Size0.15 Acres
Data Source:
Information and Real Estate Services (IRES)
Property Description

This 5-bedroom two-story home includes 4.5 baths, and a finished basement! This home has a charming front porch and perfect curb appeal. Enjoy a large and open family room, dining room and kitchen on the main level. Upstairs you will find the owner's suite and 2 additional bedrooms, both with walk-in closets. In the finished basement you have a rec room plus an additional bedroom & bathroom! This stunning home has designer features throughout including a gourmet kitchen, a fireplace in the great room, matte black hardware, sleek quartz counter-tops and beautiful trim work. Upgraded cabinets with soft-close doors and soft-close dovetail drawers. Kitchen appliance package includes stainless steel with a 36" 5 burner gas cook-top, an exterior vented hood, microwave and convection oven. Home also features zoned A/C with 2 A/C units, and smart thermostats for each level of the home. Enjoy the large covered outdoor patio for evening meals and summer entertainment. This South facing home backs to open space. Enjoy lake living where you can paddle board, kayak and fish. Enjoy miles of trails in the community where you can take a sunset stroll, enjoy a bike ride or take the dog for a walk. Other amenities include basketball and pickleball courts, fitness stations, outdoor grills & fire-pits, a pavilion lawn, a resort style outdoor pool (with a splash pad for kids) and a beautiful indoor community hub with remote working stations, and a fitness center.

Elementary School Middle School High School
Mead Elementary School Mead Middle School Mead High School
Price History
7/7/2025 Listed $823,529
5/5/2026 3$799,000

General Features

Living Area 3117
Sewer Public Sewer
Heating Forced Air,Zoned,2 or more Heat Sources
Cooling Central Air
Utilities Natural Gas Available,Electricity Available,Cable Available,High Speed Avail
Roof Composition
Appliances Gas Range,Dishwasher,Microwave,Disposal,Fire Alarm
Zoning RES
Garage Spaces 3
Patio/Porch Features Patio
Architectural Style Contemporary
Construction Materials Stone,Composition
Year Built 2025
Electric United Power
View Plains View
Levels Two
Property Subtype Single Family Residence
Tax Year 2024
Parcel Number R8981597
Community Features Clubhouse,Tennis Court(s),Pool,Fitness Center,Park,Trail(s)
Accessibility Main Floor Bath
County Weld
New Construction Yes
Property Type Residential
HOA No
Energy Efficient Windows,High Efficiency Furnace,Energy Survey Complete,Thermostat
Subdivision Name Barefoot Lakes Fg 6
Possible Use Single Family
Full Baths 3
Status Active
Directions Barefoot Lakes is located in Firestone,Colorado. 15 minutes east of Longmont and north of Erie. Just 30 minutes north of Downtown Denver. Barefoot Lakes is at exit 240 off of I-25.
High School Mead
City Firestone
Disclosures Home Protection Plan
High School District ST Vrain Dist RE 1J
MLS Area Greeley/Weld
Elementary School Mead
Property Attached Y/N No
Tax Annual Amount 1278
Middle/Junior High School Mead
Builder Name American Legend Homes
Standard Status Active
Expected Active Date 2025-07-07
AttributionContact 9724105713

Interior Features

Interior Amenities Eat-in Kitchen,Pantry,Walk-In Closet(s),Washer/Dryer Hookup,Kitchen Island
Basement Partially Finished,Built-In Radon,Sump Pump
Fireplace Features Gas
Above Grade Finished Area 2497
Half Baths 1
3/4 Baths 1
Total Bedrooms 5
LivingAreaSource Plans
Total Baths 5

Exterior Features

Exterior Amenities Sprinkler System
Fencing Partial,Fenced
Parking Features Garage Door Opener,Attached
Lot Features Level,House Faces South,Paved,Curbs,Gutters,Street Light,Water Rights Excluded,Mineral Rights Excluded
Water Source District
Lot Size Area 6721
Lot Size Acres 0.15
Road Surface Type Asphalt
Waterfront Y/N No
Road Frontage Type City Street
Builder Model V433B
Irrigation Water Rights Y/N No

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Primary On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool

Property vs Single Family Average in 80504

Price
AVG $770K
$800K
Taxes
AVG $7,647
$1,278
Year Built
AVG 2007
2025
Visits
AVG 135
587
Data Provided by Inside Real Estate®

Looking for a more comfortable experience?

Download our mobile app for a personalized browsing experience.

Areas We Cover