Home » Real Estate » CO » Longmont » 80504 »
$709,990
5901 Aspenglow St, Longmont, CO, 80504
4
Beds
3
Baths
2,407
Square Feet
Large, two story, plan features 2,407 square feet of living space including an unfinished basement. Enjoy 3 roomy bedrooms on the upper level and 1 on the main. 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 unfinished basement is a blank canvas! Lots of upgraded modern finishes to enjoy. This South facing lot backs to open space! Enjoy the oversized 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 Associate 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,407
MLS #
1033861
Appliances
Gas Range, Self Cleaning Oven, Dishwasher, Microwave, Disposal, Fire Alarm
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
Full, Unfinished, Built-In Radon, Sump Pump
FINISHED BASEMENT SIZE
1114.0
NEW CONSTRUCTION
1
ACCESSIBILITY FEATURES
1
ARCHITECTURAL STYLE
Contemporary/Modern
Roof
Composition
EXTERIOR FEATURES
Sprinkler System, Oversized 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
3
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:55.630Z
DAYS ON MARKET
289
PRICE CHANGE(S)
$709,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,407
MLS #
1033861
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
$799,000
2010 Glenarbor Ct
Longmont, CO
6
Beds
| 4
Baths
| 4,792
Square Feet
Offered By Mark Varga RE/MAX Momentum
$792,990
5881 Aspenglow St
Longmont, CO
4
Beds
| 4
Baths
| 2,966
Square Feet
Offered By Parker Bright American Legend Homes LLC
$789,900
2407 Water Cress Ct
Longmont, CO
5
Beds
| 4
Baths
| 3,125
Square Feet
Offered By Holly Vermeern HomeSmart Realty Partners FTC
$774,990
5891 Aspenglow St
Longmont, CO
4
Beds
| 4
Baths
| 3,236
Square Feet
Offered By Parker Bright American Legend Homes LLC