PerformAction
 logo  logo  logo
  • (303) 443-2240
  • BUY
    • Search
    • Just Listed
    • Open Houses
    • Buyers
      • Home Buying Process
      • Get Pre Approved
      • Find a Broker
    • Mortgage Calculator
  • SELL
    • Sellers
      • Home Selling Process
      • Market Analysis
      • Five Reasons a Property Sells
      • Moving Out Of The Area
      • Find The Right Broker
  • Commercial
    • Commercial Services
    • Our Listings
    • Recent Closings
    • Find The Right Broker
  • Relocation
    • Individual and Family Solutions
    • Corporate Services
    • Meet the Relocation Team
    • Global Affiliations and Awards
    • National Home Search
  • OUR COMPANY
    • Our Brokers
    • Our Story
      • Who We Are
      • Community Engagement
      • Awards
      • Managing Team
    • Testimonials
    • Join our team
    • Blog
  • COMMUNITIES
  • CONTACT US
    • BUY
      • Search
      • Just Listed
      • Open Houses
      • Buyers
        • Home Buying Process
        • Get Pre Approved
        • Find a Broker
      • Mortgage Calculator
    • SELL
      • Sellers
        • Home Selling Process
        • Market Analysis
        • Five Reasons a Property Sells
        • Moving Out Of The Area
        • Find The Right Broker
    • Commercial
      • Commercial Services
      • Our Listings
      • Recent Closings
      • Find The Right Broker
    • Relocation
      • Individual and Family Solutions
      • Corporate Services
      • Meet the Relocation Team
      • Global Affiliations and Awards
      • National Home Search
    • OUR COMPANY
      • Our Brokers
      • Our Story
        • Who We Are
        • Community Engagement
        • Awards
        • Managing Team
      • Testimonials
      • Join our team
      • Blog
    • COMMUNITIES
    • CONTACT US
Log In Or Register
 logo  logo  logo
(303) 443-2240
Log In Or Register
Clear Price
Cancel
Done Search
  • Property Video
  • Virtual Tour
  • Interactive Brochure
  • 3D Property Tour
  • Website
  • Save Listing
  • Share Listing
  • Print

$792,990

5881 Aspenglow St, Longmont, CO 80504  (Sold on )

  • Price Reduced
  • Open House Sat. May 02; 11:00 AM - 04:00 PM
  • New Listing
  • Coming Soon
  • 4 BedBeds
  • 4 BathBaths
  • 3,388 SqftSqft
  • TypeSingle Family
  • Active
  • MLS# 1033854
10 More Schedule

Property Description

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

Thank you for requesting a showing of this property. A representative will be in touch with you shortly to confirm the requested showing date and time.
Please note that your appointment is not confirmed until someone contacts you.

Request Info/ Schedule Showing

Submit

Property Details

General

  • Subdivision: Barefoot Lakes Fg 6
  • County: Weld
  • List Date: 05/13/2025
  • Expected Active Date: 05/13/2025
  • DOM: 353
  • Style: Contemporary
  • Lot SqFt: 5750
  • Beds: 4
  • Baths: 4.00
  • Full Baths: 3
  • Half Baths: 1
  • Basement/Foundation: Partially Finished, Built-In Radon, Sump Pump
  • Year Built: 2025
  • New construction: Yes
  • Sq Ft (total): 3388
  • Garage/Parking Spaces: 2
  • Garage Description: Attached
  • MLS#: 1033854

Interior Features

  • Heating: Forced Air, Hot Water, Zoned
  • Cooling: Central Air, Ceiling Fan(s)
  • Fireplace: Gas, Family Room
  • Disability Accessibility: Level Lot, Level Drive, Low Carpet

Exterior Features

  • Construction: Frame, Stone, Composition
  • Roof: Composition
  • Type: Single Family Residence
  • Outdoor Features: Sprinkler System, Oversized Garage, Tandem Garage
  • Fences: Partial, Wood
  • Road Access: City Street
  • Waterfront: NO
  • Views: Plains View

Schools

  • School District: ST Vrain Dist RE 1J
  • Elementry: Mead
  • Middle/Jr: Mead
  • High School: Mead

Financial Considerations

  • Tax Year: 2024
  • Tax Amount: $1278

Utilities

  • Utilities: Natural Gas Available, Electricity Available, Cable Available, High Speed Avail
  • Water/Sewer: Public Sewer
  • Water: District
 

Similar Listings

    • Open House
    • Price Reduced
    • New Listing
    • Pending
    • Coming Soon
    • Sold
    14798 N 115th St, Longmont, CO 80504
    $980,000
    MLS# 6997011Active
    904 Sq. Ft.
     
    2 BEDS1 BATHS
    Listing courtesy of RE/MAX Momentum
    IRE logo
    MLS logo
    Request Info
    Delete
    Details
      • Open House
      • Price Reduced
      • New Listing
      • Pending
      • Coming Soon
      • Sold
      14798 N 115th St, Longmont, CO 80504
      $980,000
      MLS# 1053538Active
      904 Sq. Ft.
       
      2 BEDS1 BATHS
      Listing courtesy of RE/MAX Momentum Westminster
      IRE logo
      MLS logo
      Request Info
      Delete
      Details
        • Open House
        • Price Reduced $10,000
        • New Listing
        • Pending
        • Coming Soon
        • Sold
        1720 Twilight Ct, Longmont, CO 80504
        $975,000
        MLS# 1045963Active
        4,407 Sq. Ft.
         
        3 BEDS4 BATHS
        Listing courtesy of HomeSmart
        IRE logo
        MLS logo
        Request Info
        Delete
        Details
          • Open House
          • Price Reduced $10,000
          • New Listing
          • Pending
          • Coming Soon
          • Sold
          1720 Twilight Ct, Longmont, CO 80504
          $975,000
          MLS# 2993212Active
          4,407 Sq. Ft.
           
          3 BEDS4 BATHS
          Listing courtesy of HomeSmart
          IRE logo
          MLS logo
          Request Info
          Delete
          Details
            • Open House
            • Price Reduced
            • New Listing
            • Pending
            • Coming Soon
            • Sold
            1328 Highway 66, Longmont, CO 80504
            $975,000
            MLS# 1055944Under Contract
            4,342 Sq. Ft.
             
            4 BEDS5 BATHS
            Listing courtesy of eXp Realty - Northern CO
            IRE logo
            MLS logo
            Request Info
            Delete
            Details
              • Open House
              • Price Reduced $28,000
              • New Listing
              • Pending
              • Coming Soon
              • Sold
              5701 Wayfarer Cir, Firestone, CO 80504
              $974,950
              MLS# 3917107Active
              6,667 Sq. Ft.
               
              7 BEDS8 BATHS
              Listing courtesy of Richmond Realty Inc
              IRE logo
              MLS logo
              Request Info
              Delete
              Details
                • Open House Sat. May 02; 11:00 AM - 01:00 PM
                • Price Reduced $10,100
                • New Listing
                • Pending
                • Coming Soon
                • Sold
                9375 Homestead Dr, Frederick, CO 80504
                $974,900
                MLS# 6654031Active
                4,224 Sq. Ft.
                 
                3 BEDS3 BATHS
                Listing courtesy of Roam Real Estate Group
                IRE logo
                MLS logo
                Request Info
                Delete
                Details
                  • Open House
                  • Price Reduced $10,100
                  • New Listing
                  • Pending
                  • Coming Soon
                  • Sold
                  9375 Homestead Dr, Frederick, CO 80504
                  $974,900
                  MLS# 1054478Active
                  4,224 Sq. Ft.
                   
                  3 BEDS3 BATHS
                  Listing courtesy of Roam Real Estate Group LLC
                  IRE logo
                  MLS logo
                  Request Info
                  Delete
                  Details
                    • Open House
                    • Price Reduced $28,000
                    • New Listing
                    • Pending
                    • Coming Soon
                    • Sold
                    1613 Horseshoe Cir N, Longmont, CO 80504
                    $967,000
                    MLS# 1055696Active
                    2,731 Sq. Ft.
                     
                    4 BEDS3 BATHS
                    Listing courtesy of RE/MAX Alliance-Lsvl
                    IRE logo
                    MLS logo
                    Request Info
                    Delete
                    Details
                      • Open House
                      • Price Reduced $28,000
                      • New Listing
                      • Pending
                      • Coming Soon
                      • Sold
                      1613 Horseshoe Cir, Longmont, CO 80504
                      $967,000
                      MLS# 2613131Active
                      2,731 Sq. Ft.
                       
                      4 BEDS3 BATHS
                      Listing courtesy of RE/MAX Alliance
                      IRE logo
                      MLS logo
                      Request Info
                      Delete
                      Details
                        • Open House
                        • Price Reduced $34,000
                        • New Listing
                        • Pending
                        • Coming Soon
                        • Sold
                        2548 Horseshoe Cir, Longmont, CO 80504
                        $965,000
                        MLS# 1042310Under Contract
                        3,429 Sq. Ft.
                         
                        5 BEDS3 BATHS
                        Listing courtesy of Coldwell Banker Realty- Fort Collins
                        IRE logo
                        MLS logo
                        Request Info
                        Delete
                        Details
                          • Open House
                          • Price Reduced $15,000
                          • New Listing
                          • Pending
                          • Coming Soon
                          • Sold
                          5584 Moosehead Cir, Longmont, CO 80504
                          $964,900
                          MLS# 8435301Active
                          3,064 Sq. Ft.
                           
                          3 BEDS3 BATHS
                          Listing courtesy of Jesus Orozco Jr
                          IRE logo
                          MLS logo
                          Request Info
                          Delete
                          Details
                          COL Logo IRE Logo
                          • Get in Touch

                          • (303) 443-2240 info@wkre.com
                          • 4875 Pearl E. Circle, Suite #100 BoulderCO80301
                          • 2101 Ken Pratt Blvd, Suite #100, Longmont, CO 80501

                          Follow Us

                          Luxury Portfolio Leading RE WKR Footer logo

                          Policies

                          • Privacy Policy
                          • Careers
                          • Accessibility Policy
                          • Agent Resources
                          • DMCA Notice
                          • Agent Login
                          Copyright © 2026 WK Real Estate. All Rights Reserved.
                          • Comparison List   0

                          WK Real Estate is powered by Burrow Services, Inc.