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

$774,990

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

  • Price Reduced
  • Open House
  • New Listing
  • Coming Soon
  • 4 BedBeds
  • 4 BathBaths
  • 3,842 SqftSqft
  • TypeSingle Family
  • Under Contract
  • MLS# 1033867
0 More Schedule

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

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: 315
  • Style: Contemporary
  • Lot SqFt: 5750
  • Beds: 4
  • Baths: 4.00
  • Full Baths: 4
  • Basement/Foundation: Partially Finished
  • Year Built: 2025
  • New construction: Yes
  • Sq Ft (total): 3842
  • Garage/Parking Spaces: 3
  • Garage Description: Attached
  • MLS#: 1033867

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, Main Floor Bath, Main Level Bedroom, Main Level Laundry

Exterior Features

  • Construction: Frame, Stone, Composition
  • Roof: Composition
  • Type: Single Family Residence
  • Outdoor Features: Sprinkler System, 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 $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
            • Open House
            • Price Reduced
            • New Listing
            • Pending
            • Coming Soon
            • Sold
            11693 Montgomery Cir, Longmont, CO 80504
            $950,000
            MLS# 1056895Active
            3,878 Sq. Ft.
             
            5 BEDS4 BATHS
            Listing courtesy of Kentwood Real Estate Boulder Valley
            IRE logo
            MLS logo
            Request Info
            Delete
            Details
              • Open House
              • Price Reduced
              • New Listing
              • Pending
              • Coming Soon
              • Sold
              2240 Summitview Dr, Longmont, CO 80504
              $945,000
              MLS# 9444328Under Contract
              4,310 Sq. Ft.
               
              5 BEDS4 BATHS
              Listing courtesy of Engel & Volkers Denver
              IRE logo
              MLS logo
              Request Info
              Delete
              Details
                • Open House
                • Price Reduced
                • New Listing
                • Pending
                • Coming Soon
                • Sold
                1029 Katy Ln, Longmont, CO 80504
                $935,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
                  • Price Reduced
                  • New Listing
                  • Pending
                  • Coming Soon
                  • Sold
                  11818 Kenosha Rd, Longmont, CO 80504
                  $925,000
                  MLS# 1057179Active
                  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
                    2307 Bluebird Dr, Longmont, CO 80504
                    $925,000
                    MLS# 1054898Active
                    3,898 Sq. Ft.
                     
                    5 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
                      2062 Ridgeview Dr, Longmont, CO 80504
                      $925,000
                      MLS# 1053403Under Contract
                      3,870 Sq. Ft.
                       
                      6 BEDS4 BATHS
                      Listing courtesy of RE/MAX Alliance-Longmont
                      IRE logo
                      MLS logo
                      Request Info
                      Delete
                      Details
                        • Open House
                        • Price Reduced $24,000
                        • New Listing
                        • Pending
                        • Coming Soon
                        • Sold
                        Address Undisclosed
                        $925,000
                        MLS# 8436941Under Contract
                        3,870 Sq. Ft.
                         
                        6 BEDS4 BATHS
                        Listing courtesy of RE/MAX Alliance
                        IRE logo
                        MLS logo
                        Request Info
                        Delete
                        Details
                          • Open House
                          • Price Reduced
                          • New Listing
                          • Pending
                          • Coming Soon
                          • Sold
                          8835 Foxfire St, Firestone, CO 80504
                          $925,000
                          MLS# 6437584Active
                          6,125 Sq. Ft.
                           
                          5 BEDS5 BATHS
                          Listing courtesy of MB Bellissimo Homes
                          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.