Home » Real Estate » CO » Longmont » 80504 »
$792,990
5881 Aspenglow St, Longmont, CO, 80504
4
Beds
4
Baths
2,966
Square Feet
Large, two story, plan features 2,966 square feet of living space including a finished basement. Enjoy 3 roomy bedrooms on the upper 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, 1 full bathroom and 1 additional bedroom! Lots of upgraded modern finishes to enjoy. This South facing lot backs to open space! Enjoy the oversized 2-car 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
Offered By
Parker Bright, American Legend Homes LLC
Property Details
Property Type
Residential
Status
Active
Bedrooms
4
Bathrooms (Full)
3
Property Sub Type
Single Family Residence
Square Feet
2,966
MLS #
1033854
Bathrooms (Half)
1
Appliances
Gas Range, Self Cleaning Oven, Dishwasher, Microwave, Disposal, Fire Alarm
FIREPLACE FEATURES
Gas, Family Room
Heating
Forced Air, Hot Water, Zoned
Cooling
Central Air, Ceiling Fan(s)
Utility Features
Natural Gas Available, Electricity Available, Cable Available, High Speed Avail
SEWER
Public Sewer
WATER SOURCE
District
Year Built
2025
Builder Name
American Legend Homes
Basement
Partially Finished, Built-In Radon, Sump Pump
FINISHED BASEMENT SIZE
1923.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
EXTERIOR FEATURES
Sprinkler System, Oversized Garage, Tandem Garage
Parking Features
Garage Door Opener, Attached
Fence
Partial, Wood
Lot Features
Sloping Lot, House Faces South, Paved, Curbs, Gutters, Sidewalks, Street Light, Water Rights Excluded, Mineral Rights Excluded
Garage spaces
2
View
Plains View
CITY
Longmont
SUBDIVISION
Barefoot Lakes Fg 6
COUNTY
Weld
AREA
Greeley/Weld
STATE
CO
COMMUNITY FEATURES
Clubhouse, Pool, Playground, Fitness Center, Park, Trail(s), Business Center
TAX AMOUNT
1278.0
LATEST UPDATE
2026-02-25T12:15:27.893Z
DAYS ON MARKET
289
PRICE CHANGE(S)
$792,990 Jan 5, 2026
Property Details
Property Type
Residential
Status
Active
Bedrooms
4
Bathrooms (Full)
3
Property Sub Type
Single Family Residence
Square Feet
2,966
MLS #
1033854
Bathrooms (Half)
1
New Properties On Market
129
135%
Increase In New Listings
Average Asking Price
$646,993
$59,110 Increase In Avg Asking Price
Average Asking Price / Sq. Ft.
$270
$29 Decrease In List Price/Sq. Ft.
Average Days On Market
4
23 Day
Decrease In Days On Market
Data as of Mar 01, 2026.
Remaining statistics above are calculated on activity within the period from Jan 01, 2026 to Feb 28, 2026.
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.
Purchase Price
Loan Type
Down Payment
HOA Dues
Interest Rate
Estimated Property Taxes
Homeowner's Insurance
Private Mortgage Insurance
Similar Listings
$865,000
1314 Highway 66
Longmont, CO
4
Beds
| 5
Baths
| 3,865
Square Feet
Offered By Carol Cizek RE/MAX Nexus
$840,000
5046 Rangeview Ave
Longmont, CO
5
Beds
| 3
Baths
| 4,224
Square Feet
Offered By Jonathan Martinez eXp Realty, LLC
$799,000
2010 Glenarbor Ct
Longmont, CO
6
Beds
| 4
Baths
| 4,792
Square Feet
Offered By Mark Varga RE/MAX Momentum