Hideaway Park, Weld County, CO, USA
Recreation
0.8 mi
Distance
This 3-bedroom ranch home includes 2 baths, and a full unfinished 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. This stunning home has designer features throughout including a gourmet kitchen, a fireplace in the great room, satin nickel 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 A/C, full landscaping and fencing. Enjoy the covered outdoor patio for evening meals and summer entertainment. This South facing home backs to a green belt. 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.
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.
Source: Public Records
| Street Address | Beds | Baths | Sold Date | List Price | Valuation Date | Valuation Price |
|---|---|---|---|---|---|---|
| 5425 County Road 32 2 | 2 | 2 | Oct 15, 2025 | $260,000 | Dec 06, 2025 | - |
| 12613 Canoe Street | Listing | 4 | 3 | Nov 22, 2025 | $700,000 | Feb 23, 2024 | $669,966 |
| 12613 Canoe St | Listing | 4 | 3 | Nov 22, 2025 | $700,000 | Feb 23, 2024 | $669,966 |
| 10426 Cherryvale Street | 6 | 4 | Oct 21, 2025 | $635,000 | Dec 06, 2025 | - |
| 10426 Cherryvale St | Listing | 6 | 4 | Oct 21, 2025 | $635,000 | Feb 23, 2024 | $607,480 |
| 11447 Daisy Court | Listing | 5 | 4 | Nov 13, 2025 | $545,000 | Feb 23, 2024 | $478,933 |
| 11447 Daisy Ct | Listing | 5 | 4 | Nov 13, 2025 | $545,000 | Feb 23, 2024 | $478,933 |
| 4702 Clear Creek Dr | Listing | 3 | 3 | Nov 22, 2025 | $600,000 | Feb 23, 2024 | $476,854 |
| 4702 Clear Creek Drive | Listing | 3 | 3 | Nov 22, 2025 | $600,000 | Feb 23, 2024 | $476,854 |
| 11446 Deerfield Dr | 3 | 3 | Oct 16, 2025 | $235,000 | Dec 06, 2025 | - |
Source: Sperling's Best Places
| Zip | City | County | National | |
|---|---|---|---|---|
| Population | 63,162 | 100,211 | 340,903 | 335,858,263 |
| Population Density | 664 | 3,374 | 86 | 95 |
| People per Household | 2.9 | 2.6 | 2.8 | 2.6 |
| Median Age | 39 | 39.9 | 36.5 | 39.1 |
| Median Income | $98,504 | $77,516 | $76,870 | $66,222 |
| Average Income | $39,526 | $37,767 | $33,336 | $35,475 |
| Cost of Living Index | 116 | 102 | 106 | 100 |
| Zip | City | County | National | |
|---|---|---|---|---|
| January Avg. High Temp | 12°F | 12°F | 15.6°F | 22.6°F |
| July Avg. High Temp | 88.9°F | 88.9°F | 88.7°F | 86.2°F |
| Annual Precipitation | 14.15" | 14.15" | 12.72" | 38" |
24/100
Bike Score ®
The average walkability score in the surrounding area is Walk Score: 4/100, Transit Score: 0/100, Bike Score: 26/100.
Hideaway Park, Weld County, CO, USA
Recreation
0.8 mi
Distance
1.62 mi
Distance
1.64 mi
Distance
1.75 mi
Distance
Carrera Airpark, Weld County, CO, USA
Transport
1.89 mi
Distance
1.91 mi
Distance
1.91 mi
Distance
1.91 mi
Distance
Saint Vrain School, Weld County, CO, USA
Education
1.2 mi
Distance
1.8 mi
Distance
1.91 mi
Distance
1.91 mi
Distance
1.91 mi
Distance
0.5 mi
Distance
1.14 mi
Distance
1.21 mi
Distance
1.23 mi
Distance
1.7 mi
Distance
1.73 mi
Distance
1.75 mi
Distance
1.76 mi
Distance
3 bds • 2 ba • 1,816 sqft
5871 Aspenglow St, Firestone, CO 80504
3 bds • 3 ba • 1,875 sqft
5470 Green Thumb, Firestone, CO 80504
3 bds • 3 ba • 1,875 sqft
5450 Green Thumb Avenue, Firestone, CO 80504
3 bds • 2 ba • 1,993 sqft
5806 Farmstead Place, Mead, CO 80504
2 bds • 3 ba • 1,939 sqft
6685 Sage Ave, Firestone, CO 80504
2 bds • 3 ba • 1,939 sqft
6685 Sage Avenue, Firestone, CO 80504
3 bds • 3 ba • 1,937 sqft
9048 Harlequin Circle, Frederick, CO 80504
3 bds • 3 ba • 1,937 sqft
9048 Harlequin Cir, Frederick, CO 80504
3 bds • 3 ba • 1,935 sqft
8894 Forest St, Firestone, CO 80504
3 bds • 3 ba • 1,935 sqft
8894 Forest Street, Firestone, CO 80504
3 bds • 3 ba • 1,911 sqft
16953 Ballinger Circle, Mead, CO 80542
3 bds • 3 ba • 1,911 sqft
16953 Ballinger Circle, Mead, CO 80542
3 bds • 3 ba • 1,911 sqft
16953 Ballinger Cir, Mead, CO 80542
3 bds • 3 ba • 1,917 sqft
3425 Ballinger Cir, Mead, CO 80542
3 bds • 3 ba • 1,917 sqft
3425 Ballinger Circle, Mead, CO 80542
3 bds • 4 ba • 1,917 sqft
3425 Ballinger Circle, Mead, CO 80542
4 bds • 2 ba • 1,591 sqft
122 Granville Avenue, Firestone, CO 80520
3 bds • 3 ba • 1,716 sqft
160 High Point Drive, Longmont, CO 80504
3 bds • 3 ba • 1,716 sqft
160 High Point Dr, Longmont, CO 80504
3 bds • 2 ba • 1816 sqft
5871 Aspenglow St
4 bds • 4 ba • 2966 sqft
5881 Aspenglow St
4 bds • 4 ba • 2966 sqft
5881 Aspenglow Street
4 bds • 4 ba • 3236 sqft
5891 Aspenglow Street
4 bds • 4 ba • 3236 sqft
5891 Aspenglow St
5 bds • 5 ba • 3117 sqft
5841 Aspenglow St
5 bds • 5 ba • 3117 sqft
5841 Aspenglow Street
5 bds • 4 ba • 3699 sqft
5583 Riverbend Avenue
6 bds • 5 ba • 5117 sqft
5566 Tamarack Avenue
3 bds • 3 ba • 1875 sqft
5470 Green Thumb
4 bds • 3 ba • 2630 sqft
5460 Green Thumb Avenue
3 bds • 3 ba • 1875 sqft
5450 Green Thumb Avenue
4 bds • 4 ba • 1939 sqft
13216 Barefoot Lakes Parkway
5 bds • 3 ba • 3609 sqft
5204 Lake Port Avenue
4 bds • 3 ba • 2370 sqft
5164 Preserve Place
4 bds • 3 ba • 2370 sqft
5053 Lake Port Avenue
4 bds • 3 ba • 2370 sqft
12838 Lake Port Street
3 bds • 3 ba • 2560 sqft
12541 Lake View Street
4 bds • 3 ba • 2533 sqft
12944 Grasslands Street
Source: Realty.com
5871 Aspenglow Street, Firestone, CO 80504 is a Single Family 1,816 sq. ft. home listed for sale. Realty.com has 0 photos available of this 3 bed, 2 bath house, listed at $699,990. View sales and tax history, use our mortgage calculator and more on Realty.com
Our records indicate that 5871 Aspenglow Street was built in 2025.
The full address for this home is 5871 Aspenglow Street, Firestone, CO 80504.
5871 Aspenglow Street has been listed on Realty.com since Fri December 05, 2025
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 4/100, Transit Score: 0/100, Bike Score: 26/100.
There are 3 schools assigned to this home. Check out the schools near 5871 Aspenglow Street. Mead (Grades: K - 5), Trail Ridge Middle School (Grades: 6 - 8), Mead High School (Grades: 9 - 12)
Listing provided courtesy of:
American Legend Homes LLC
(tel: 9724105713)
Listing agent:
Parker Bright
(#IRP31598)
This content last refreshed on 2025-12-06 12:31:02. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Export listing data of 5871 Aspenglow Street, Firestone, CO 80504 : MLS# IR1048161