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

$709,990

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

  • Price Reduced
  • Open House Sat. Aug 15; 11:00 AM - 04:00 PM
  • New Listing
  • Coming Soon
  • 4 BedBeds
  • 3 BathBaths
  • 3,521 SqftSqft
  • TypeSingle Family
  • Active
  • MLS# 1033861
6 More Schedule

Property Description

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!

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: 457
  • Style: Contemporary
  • Lot SqFt: 6023
  • Beds: 4
  • Baths: 3.00
  • Full Baths: 3
  • Basement/Foundation: Full, Unfinished, Built-In Radon, Sump Pump
  • Year Built: 2025
  • New construction: Yes
  • Sq Ft (total): 3521
  • Garage/Parking Spaces: 3
  • Garage Description: Attached
  • MLS#: 1033861

Interior Features

  • Heating: Forced Air, Hot Water, Zoned
  • Cooling: Central Air, Ceiling Fan(s)
  • 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
  • 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
    11815 N Beasly Rd, Longmont, CO 80504
    $885,000
    MLS# 1065380Under Contract
    4,986 Sq. Ft.
     
    4 BEDS4 BATHS
    Listing courtesy of Compass - Boulder
    IRE logo
    MLS logo
    Request Info
    Delete
    Details
      • Open House
      • Price Reduced
      • New Listing
      • Pending
      • Coming Soon
      • Sold
      3345 Mourning Dove Ct, Longmont, CO 80504
      $885,000
      MLS# 6730033Active
      2,721 Sq. Ft.
       
      3 BEDS3 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
        619 Crawford Cir, Longmont, CO 80504
        $879,000
        MLS# 1064047Under Contract
        4,658 Sq. Ft.
         
        5 BEDS4 BATHS
        Listing courtesy of LIV Sotheby's Intl Realty
        IRE logo
        MLS logo
        Request Info
        Delete
        Details
          • Open House Sat. Aug 15; 10:00 AM - 12:00 PM
          • Price Reduced
          • New Listing
          • Pending
          • Coming Soon
          • Sold
          6755 Saddleback Ave, Firestone, CO 80504
          $875,000
          MLS# 1065059Active
          4,377 Sq. Ft.
           
          4 BEDS3 BATHS
          Listing courtesy of eXp Realty LLC
          IRE logo
          MLS logo
          Request Info
          Delete
          Details
            • Open House
            • Price Reduced $20,000
            • New Listing
            • Pending
            • Coming Soon
            • Sold
            1029 Katy Ln, Longmont, CO 80504
            $865,000
            MLS# 1056598Under Contract
            2,218 Sq. Ft.
             
            2 BEDS2 BATHS
            Listing courtesy of The Agency - Boulder
            IRE logo
            MLS logo
            Request Info
            Delete
            Details
              • Open House Sun. Aug 16; 02:00 PM - 04:00 PM
              • Price Reduced
              • New Listing
              • Pending
              • Coming Soon
              • Sold
              723 Ridge Creek Ct, Longmont, CO 80504
              $860,000
              MLS# 1058509Active
              4,985 Sq. Ft.
               
              6 BEDS6 BATHS
              Listing courtesy of WK Real Estate
              IRE logo
              MLS logo
              Request Info
              Delete
              Details
                • Open House
                • Price Reduced
                • New Listing
                • Pending
                • Coming Soon
                • Sold
                9060 Ferncrest St, Longmont, CO 80504
                $860,000
                MLS# 5053035Active
                5,102 Sq. Ft.
                 
                5 BEDS5 BATHS
                Listing courtesy of Your Castle Realty LLC
                IRE logo
                MLS logo
                Request Info
                Delete
                Details
                  • Open House
                  • Price Reduced
                  • New Listing
                  • Pending
                  • Coming Soon
                  • Sold
                  11701 Montgomery Cir, Longmont, CO 80504
                  $860,000
                  MLS# 4343788Active
                  3,898 Sq. Ft.
                   
                  3 BEDS3 BATHS
                  Listing courtesy of REMAX PROPERTIES
                  IRE logo
                  MLS logo
                  Request Info
                  Delete
                  Details
                    • Open House
                    • Price Reduced $8,000
                    • New Listing
                    • Pending
                    • Coming Soon
                    • Sold
                    5566 Tamarack Ave, Firestone, CO 80504
                    $859,950
                    MLS# 8928796Active
                    5,440 Sq. Ft.
                     
                    6 BEDS5 BATHS
                    Listing courtesy of Richmond Realty Inc
                    IRE logo
                    MLS logo
                    Request Info
                    Delete
                    Details
                      • Open House
                      • Price Reduced $10,000
                      • New Listing
                      • Pending
                      • Coming Soon
                      • Sold
                      1314 Highway 66, Longmont, CO 80504
                      $855,000
                      MLS# 1034856Active
                      3,865 Sq. Ft.
                       
                      4 BEDS5 BATHS
                      Listing courtesy of RE/MAX Nexus
                      IRE logo
                      MLS logo
                      Request Info
                      Delete
                      Details
                        • Open House
                        • Price Reduced $45,000
                        • New Listing
                        • Pending
                        • Coming Soon
                        • Sold
                        11818 Kenosha Rd, Longmont, CO 80504
                        $850,000
                        MLS# 1057179Under Contract
                        1,700 Sq. Ft.
                         
                        4 BEDS2 BATHS
                        Listing courtesy of RE/MAX of Boulder, Inc
                        IRE logo
                        MLS logo
                        Request Info
                        Delete
                        Details
                          • Open House
                          • Price Reduced
                          • New Listing
                          • Pending
                          • Coming Soon
                          • Sold
                          2012 Charro Ave, Longmont, CO 80504
                          $850,000
                          MLS# 1065649Active
                          2,036 Sq. Ft.
                           
                          4 BEDS3 BATHS
                          Listing courtesy of Homestead Real Estate, LLC
                          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.