5891 Aspenglow St, Longmont, CO 80504
Barefoot Lakes Fg 6 · Weld County
Key Facts
Description
Large, and open ranch floor plan features 3,236 square feet of living space including a full finished basement. Enjoy 2 roomy bedrooms on the main level, plus a fireplace in the family room for cozy nights. Enjoy your charming front porch. The dining and kitchen area are open and bright, and the kitchen showcases a stunning center island with quartz counter tops. This home has a covered outdoor dining/entertaining space for warm summer nights. The finished basement includes a rec room, 2 full bathrooms and 2 additional bedrooms! Lots of upgraded modern finishes to enjoy. This South facing lot backs to open space! Enjoy the 3-car tandem garage for all of your toys. At The Lakes you can kayak, paddle board or fish. Get your steps in with miles of parks and trails winding through the neighborhoods, lakes and along the St. Vrain River. The Cove and Pool community hub offers an outdoor pool, grills, fire-pits, a pickleball court and much more! Come enjoy lake life at Barefoot Lakes! Finished Inventory Summer Special! Contact Sales Office for details
Property Information
Property Type
Residential
Sub-Type
Single Family Residence
Style
Contemporary
Year Built
2025
Living Area
3,236 sq ft
Lot Size
0.13 acres
Garage Spaces
3
Zoning
RES
Days on Market
416
MLS® Listing#
1033867
Property Features
Interior
Appliances
Cooling
Heating
Fireplace
Basement
Parking
Laundry
Patio
Fencing
Lot Features
Construction
Roof
Security
Community
Utilities
Sewer
Water Source
Rooms
- 17x28Basement
- 16x13Main
- Bedroom 212x11Main
- Bedroom 312x11Basement
- Bedroom 415x12Basement
- Dining Room10x16Main
- Family Room18x20Main
- Kitchen18x12Main
- Laundry9x8Main
Schools
- Elementary:
- Mead
- Middle:
- Mead
- High:
- Mead
Financial Details
HOA
None
Annual Taxes
$1,278
Tax year 2024
Parcel Number
R8981624
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.
Affordability Calculator
$154,998
Estimated monthly payment
$4,125/mo
Principal $619,992 · Est. interest $864,944 over 30 yrs
Neighborhood Market Statistics
How this home compares to active listings in Longmont, CO
- $610,303
- Median Listing Price
- 50
- Median Days on Market
- 2,118
- Median Sq Ft
- $314
- Median Price / Sq Ft
- 865
- Active Listings
- This home’s price is 27% above the area median.
- Its price per sq ft is 24% below the area median.
Market statistics compiled from active EXIT Realty® and MLS listings in Longmont, CO.
Location
Points of Interest in Longmont, CO
Showing the Longmont area map.
Nearby Schools
Firestone Charter Academy
School · 1.8 mi away
Primrose Schools
Elementary · 2.0 mi away
Coal Ridge Middle School
Secondary · 2.4 mi away
Prairie Ridge Elementary School
Elementary · 2.7 mi away
Centennial Elementary
Elementary · 2.8 mi away
Mead High School
Secondary · 2.8 mi away
Mead Elementary School
Elementary · 4.3 mi away
Mead Middle School
Elementary · 4.4 mi away
Legacy Elementary School
Elementary · 5.4 mi away
Carbon Valley Academy
School · 5.6 mi away
Frederick Senior High School
Secondary · 6.1 mi away
Trail Ridge Middle School
Secondary · 6.1 mi away
Fall River Elementary School
Elementary · 6.3 mi away
Platteville Elementary School
Elementary · 6.4 mi away
Spark Discovery Preschool of St. Vrain
School · 6.4 mi away
Frederick Elementary School
Elementary · 6.4 mi away
Thunder Valley K-8
Elementary · 6.4 mi away
South Valley Middle School
Secondary · 6.5 mi away
Goddard School
School · 6.9 mi away
Little Pinwheels
School · 7.1 mi away
Commute Calculator
Nearby Homes
Similar Homes Nearby
Similar Home Values
Comparable nearby listings and their asking prices.
| Address | Price | Beds | Baths | Sq Ft |
|---|---|---|---|---|
| 1529 16th Pl, Longmont, CO | $545,000 | 3 | 2 | 1,515 |
| 1529 16th Place, Longmont, CO | $545,000 | 3 | 2 | 1,515 |
| 1415 Deerwood Dr, Longmont, CO | $545,000 | 3 | 4 | 1,709 |
| 1415 Deerwood Drive, Longmont, CO | $545,000 | 3 | 4 | 1,709 |
| 3963 Da Vinci Dr, Longmont, CO | $548,800 | 4 | 3 | 2,376 |
| 3963 Da Vinci Drive, Longmont, CO | $548,800 | 4 | 3 | 2,376 |
