Contact Agent

Douglas Hauck

Douglas A. Hauck is an expert in the real estate industry with over 43 years of experience. As one of the top producing Broker Associates with RE/MAX ...

Office: RE/MAX Professionals
Phone: (303) 400-0472
Mobile: (720) 219-8218

Scan this QR Code
and keep Agent contact details

Note Tags

No public note tag yet...
Log in to enter new private note tag

Video Tags

No public video tag yet...
Log in to record new video tag

Listing Source

With courtesy of
American Legend Homes LLC
Posted by
REcolorado (Denver)

The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ('IDX') program of RECOLORADO®, Real estate listings held by brokers other than RE/MAX Professionals are marked with the IDX Logo. This information is being provided for the consumers' personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.

5891 Aspenglow Street

Longmont, CO 80504 — Weld County — Barefoot Lakes Fg 6 Neighborhood

Residential $846,465 Active Listing# IR1033867

4 beds 4 baths 3842.00 sqft Lot size: 5750.00 sqft 0.13 acres 2025 build

Showing Request

Updated: 06-05-2025 02:41pm

You will initiate a Showing Request.
Enter your contact details below.
An Agent will contact you as soon as possible.

Your First Name *

Your Last Name *

Your Email *

Your Phone *

Message *

+ 25 photos

+ 24 photos

+ 23 photos

Property 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

Listing Details

Property Type: Residential
Listing#: IR1033867
Source: REcolorado (Denver)
Last Updated: 06-05-2025 02:41pm
Status: Active
Off Market Date: 11-30--0001 12:00am

Property Details

Property Subtype: Single Family Residence
Sold Price: $846,465
Original Price: $828,715
Location: Longmont, CO 80504
SqFT: 3842.00
Year Built: 2025
Acres: 0.13
Bedrooms: 4
Bathrooms: 4
Levels: One

Map

Property Level and Sizes

SqFt Lot: 5750.00
Lot Features: Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Smart Thermostat, Walk-In Closet(s)
Lot Size: 0.13

Financial Details

Previous Year Tax: 1278.00
Year Tax: 2024
Primary HOA Amenities: Business Center, Clubhouse, Fitness Center, Park, Playground, Pool
Primary HOA Fees Included: Trash
Primary HOA Fees: 0.00

Interior Details

Interior Features: Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Smart Thermostat, Walk-In Closet(s)
Appliances: Dishwasher, Disposal, Microwave, Oven, Self Cleaning Oven
Laundry Features: In Unit
Electric: Ceiling Fan(s), Central Air
Flooring: Tile
Cooling: Ceiling Fan(s), Central Air
Heating: Forced Air, Hot Water
Fireplaces Features: Family Room, Gas
Utilities: Cable Available, Electricity Available, Internet Access (Wired), Natural Gas Available