$777,315
NEW CONSTRUCTION $18K PRICE INCREASE

5901 Aspenglow St Longmont, CO 80504

Estimated payment $4,416/month

4 Beds
3 Baths
2,407 Sq Ft
$323 Price per Sq Ft

Highlights

  • Fitness Center
  • Under Construction
  • Open Floorplan
  • Mead Elementary School Rated A-
  • Green Energy Generation
  • Clubhouse

About This Home

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!

Listing Agent

Chris Bright

American Legend Homes LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $1,278

Year Built

  • Built in 2025 | Under Construction

Lot Details

  • 6,023 Sq Ft Lot
  • South Facing Home
  • Southern Exposure
  • Partially Fenced Property
  • Wood Fence
  • Level Lot
  • Sprinkler System

Parking

  • 3 Car Attached Garage
  • Garage Door Opener
  • Driveway Level

Home Design

  • Contemporary Architecture
  • Wood Frame Construction
  • Composition Roof
  • Composition Shingle
  • Stone

Interior Spaces

  • 2,407 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Double Pane Windows
  • Dining Room
  • Property Views

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Self-Cleaning Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Luxury Vinyl Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 3 Full Bathrooms

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump

Home Security

  • Radon Detector
  • Fire and Smoke Detector

Eco-Friendly Details

  • Energy-Efficient HVAC
  • Green Energy Generation
  • Energy-Efficient Thermostat

Outdoor Features

  • Patio
  • Exterior Lighting

Schools

  • Mead Elementary And Middle School
  • Mead High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Hot Water Heating System
  • Water Rights Not Included
  • High Speed Internet
  • Cable TV Available

Additional Features

  • Low Pile Carpeting
  • Mineral Rights Excluded

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number R8981623

Community Details

Overview

  • No Home Owners Association
  • Association fees include common amenities, trash
  • Built by American Legend Homes
  • Barefoot Lakes Fg 6 Subdivision, V435 Floorplan

Amenities

  • Clubhouse
  • Business Center

Recreation

  • Community Playground
  • Fitness Center
  • Community Pool
  • Park
  • Hiking Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$1,278

Year Built

Built in 2025 | Under Construction

Lot Details

0

Parking

3

Listing Details

  • Inclusions: Gas Range/Oven,Self-Cleaning Oven,Dishwasher,Microwave,Garage Door Opener,Disposal,Smoke Alarm(s)
  • Year Built: 2025
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.14
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Barefoot Lakes Fg 6
  • Directions: Barefoot Lakes is located in Firestone, Colorado. 15 minutes east of Longmont and north of Erie. Just 30 minutes north of Downtown Denver. Barefoot Lakes is at exit 240 off of I-25.
  • Above Grade Finished Sq Ft: 2407
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: Yes
  • Efficiency: Southern Exposure, HVAC, Energy Survey Complete, Thermostat, Energy Rated
  • Building Stories: 2
  • Kitchen Level: Main
  • ResoBuildingAreaSource: Plans
  • Special Features: NewHome
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Self Cleaning Oven, Dishwasher, Microwave, Disposal
  • Accessibility Features: Level Lot, Level Drive, Low Carpet
  • Has Basement: Full, Unfinished, Built-In Radon, Sump Pump
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1114
  • Interior Amenities: High Speed Internet, Eat-in Kitchen, Separate Dining Room, Open Floorplan, Pantry, Walk-In Closet(s), Kitchen Island, 9ft+ Ceilings
  • Living Area: 2407
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows
  • Room Bedroom4 Area: 143
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Luxury Vinyl Floor
  • Room Bedroom4 Level: Main
  • Room Bedroom3 Area: 156
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 143
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 13
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Luxury Vinyl Floor
  • Room Kitchen Area: 1
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 208
  • Room Dining Room Area: 121
  • Master Bathroom Features: 3/4 Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Composition
  • Builder Name: American Legend Homes
  • Fencing: Partial, Wood
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Water Rights Excluded, Mineral Rights Excluded, Sloped
  • View: Plains View
  • View: Yes
  • Waterfront: No
  • Disclosures: Home Warranty
  • Home Warranty: Yes
  • Construction Type: Wood/Frame, Stone, Composition Siding
  • Direction Faces: South
  • Exterior Features: Lighting
  • Patio And Porch Features: Patio
  • Property Condition: Under Construction

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, Oversized
  • IRESDS_Garage Sq Ft: 625
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, United Power
  • Heating: Forced Air, Hot Water, Zoned
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electricity On Property: No
  • Sewer: District Sewer
  • Water Source: District Water, Little ThompsonWater
  • Gas Company: Natural Gas, Black Hills

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Trash
  • Community Features: Clubhouse, Pool, Playground, Fitness Center, Park, Hiking/Biking Trails, Business Center
  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

  • Elementary School: Mead
  • HighSchool: Mead
  • Junior High Dist: ST Vrain Dist RE 1J
  • Middle Or Junior School: Mead

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 6023
  • Parcel #: R8981623
  • Irrigation Water Rights: No
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 1278

Multi Family

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2024 $7 $6,970 $6,970 --
2023 $7 $10 $10 --
2022 -- $10 $10 --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/13/2025 05/13/25 For Sale $759,565 -- $316 / Sq Ft
Source: IRES MLS

Similar Homes in Longmont, CO

  • 11729 Elmer Linn Dr, Longmont, CO 80504

    $700,000

    • 3 Beds
    • 2.5 Baths
    • 2,556 Sq Ft
    • 11729 Elmer Linn Dr
    • Longmont, CO

    Welcome to your dream home in the highly sought-after neighborhood of The Elms at Meadow Vale in Weld county, where the taxes are significantly lower than both the national median of 0.99% and the Colorado state median of 0.55%. This lovely 3-bedroom, 2.5-bath home is perfectly positioned on a corner lot, right across from the community park and mail center. The spacious open floor plan

    Tiffany Osborn Orchard Brokerage LLC

    Section Image
  • 1204 Ptarmigan Dr, Longmont, CO 80504

    $600,000

    • 5 Beds
    • 2.5 Baths
    • 2,058 Sq Ft
    • 1204 Ptarmigan Dr
    • Longmont, CO

    Our preferred lender will offer 1% to the buyer! Welcome to this stunning home, offering a perfect blend of modern updates and comfortable living spaces. As you step inside, you are greeted by an inviting open floor plan with vaulted ceilings, creating a spacious feel throughout. The beautifully updated kitchen is the heart of the home, making it an ideal space for cooking and entertaining. The

    Jenny Hart Keller Williams 1st Realty

    Section Image
  • 1521 Redtail Ct, Longmont, CO 80504

    $625,000

    • 4 Beds
    • 3.5 Baths
    • 2,272 Sq Ft
    • 1521 Redtail Ct
    • Longmont, CO

    Beautifully Renovated Single Family Home in Longmont, ColoradoThis stunning, move-in-ready residence is perfectly designed for modern living with high open ceilings that flood the home with natural light. You will also enjoy the warmth of hardwood floors throughout the main level and a gorgeous, updated kitchen with stylish cabinets and counters-ideal for both everyday living or entertaining

    Kevin Communal Your Castle Real Estate Inc

    Section Image
  • 954 11th Ave, Longmont, CO 80501

    $749,999

    • 3 Beds
    • 2 Baths
    • 2,600 Sq Ft
    • 954 11th Ave
    • Longmont, CO

    Own a piece of history with this exceptional property,once the iconic Mrs.Harvey's Bakery.This historical gem blends timeless architectural elements with modern ($300k+) upgrades,creating an unparalleled living experience.Proud ownership is evident throughout the property,where the original wood floors capture the essence of the home's storied past while contemporary finishes add comfort &

    Jenny Hart Keller Williams 1st Realty

    Section Image
  • 1313 Garden Cir, Longmont, CO 80501

    $650,000

    • 4 Beds
    • 3 Baths
    • 2,616 Sq Ft
    • 1313 Garden Cir
    • Longmont, CO

    Welcome to your private backyard retreat—this Longmont home is built for entertaining and relaxing. The standout feature is the beautifully landscaped yard with a covered outdoor living space, raised garden beds, spacious patios, fire pit, and plenty of grassy space to play or unwind. 2 large sheds offering extra storage in addition to the oversized 2 car garage. A masterfully planned irrigation

    Jeremy Kane eXp Realty, LLC

    Section Image
  • 1016 Katy Ln, Longmont, CO 80504

    $850,000

    • 3 Beds
    • 3.5 Baths
    • 2,160 Sq Ft
    • 1016 Katy Ln
    • Longmont, CO

    Nestled in the heart of highly desirable Prospect New Town, this stunning home is surrounded by tree-lined streets, parks, and a vibrant mix of restaurants, cafes, and boutiques. Known for its welcoming atmosphere and unique charm, this neighborhood offers an unparalleled blend of community and convenience.From the moment you arrive, you'll be captivated by the home's inviting pergola and

    Zana Leiferman Real Realty Colorado

    Section Image
  • 4236 Frederick Cir, Longmont, CO 80503

    $939,900

    • 5 Beds
    • 4 Baths
    • 3,636 Sq Ft
    • 4236 Frederick Cir
    • Longmont, CO

    OPEN HOUSE Sun 5/11 12-3 :) Stunning 2-Story Home in Prime Longmont Location - Backing to Green Space! Welcome to this beautifully maintained and thoughtfully upgraded 2-story home, ideally located on a corner lot backing to peaceful green space-just minutes from Longmont's top-rated schools, shopping, dining, and entertainment.Step inside to discover a warm and inviting main level featuring

    April Neuhaus Neuhaus Real Estate Inc

    Section Image
  • 5017 Bella Vista Dr, Longmont, CO 80503

    $935,000

    • 5 Beds
    • 3.5 Baths
    • 4,332 Sq Ft
    • 5017 Bella Vista Dr
    • Longmont, CO

    Welcome to this beautifully maintained home nestled in the sought-after Renaissance neighborhood of southwest Longmont. From the moment you step into the grand foyer, you'll be impressed by the sweeping staircase and gleaming cherry hardwood floors that flow into the heart of the home. The spacious kitchen is a chef’s dream, offering abundant cherry cabinetry, generous counter space, and natural

    Carly Mayer Compass Colorado, LLC - Boulder

    Section Image
  • 608 W Grange Ct, Longmont, CO 80503

    $959,000

    • 4 Beds
    • 3.5 Baths
    • 2,376 Sq Ft
    • 608 W Grange Ct
    • Longmont, CO

    Fall in love with the natural light and modern design of this stunning 4-bedroom, 4-bath home in Longmont's sought-after West Grange neighborhood. The sellers are offering a $20,000 concession for the buyer's closing costs. Expansive windows and 10-foot ceilings create a bright, airy atmosphere across the open-concept main level, where the living, dining, and kitchen spaces flow seamlessly to a

    Deidra Laurel Compass - Boulder

    Section Image

Source: IRES MLS

MLS Number: 1033861

IRES MLS

APN: R8981623