$539,500
PENDING NEW CONSTRUCTION $18K PRICE DROP

4204 Sandstone Dr Longmont, CO 80504

Estimated payment $3,545/month

Total Views 2,198
4 Beds
2.5 Baths
2,124 Sq Ft
$254 Price per Sq Ft

Highlights

  • Primary Bedroom Suite
  • Open Floorplan
  • Granite Countertops
  • Mead Elementary School Rated A-
  • High Ceiling
  • Home Office

About This Home

Beautiful, new 4 bedroom home in the highly desirable Lakeside Canyon Community! Stunning, contemporary white cabinetry throughout, granite countertops, a full suite of stainless steel appliances, including a gas stove, a large island and a walk in pantry. The open design floorplan is complimented with 9' ceilings, a main floor Study/flex space and a front porch to enjoy the Colorado evenings from! The list of included features is long, let's start with the front yard and the backyard landscaping, washer & dryer, tankless hot water heater, air conditioning, blinds throughout and today's smart home technology! Enjoy miles of trails, 2 dog parks, a large central park and playground, just steps from the Barefoot Lakes state park and the St. Vrain state park area. Buying a brand-new home has never been easier! Come live playfully at Lakeside Canyon! ***Estimated Delivery Date: July. Photos are representative and not of actual property***

Listing Agent

Jodi Bright

D.R. Horton Realty, LLC Brokerage Email: sales@drhrealty.com License #40028178 Listed on: 05/15/2025

D.R. Horton Realty, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,542

Year Built

  • Built in 2025 | Under Construction

Lot Details

  • 7,150 Sq Ft Lot
  • Front and Back Yard Sprinklers

HOA Fees

  • $60 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Smart Garage Door

Home Design

  • Stone Siding
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,124 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • High Ceiling
  • Electric Fireplace
  • Double Pane Windows
  • Smart Doorbell
  • Living Room
  • Dining Room
  • Home Office
  • Crawl Space
  • Smart Thermostat
  • Dryer

Kitchen

  • Eat-In Kitchen
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Quartz Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet

Eco-Friendly Details

  • Smoke Free Home

Schools

  • Mead Elementary And Middle School
  • Mead High School

Utilities

  • Forced Air Heating and Cooling System
  • 220 Volts
  • 110 Volts
  • Natural Gas Connected
  • Tankless Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 120735204010

Community Details

Overview

  • Rm Mead Metro District Association, Phone Number (970) 484-0101
  • Built by D.R. Horton, Inc
  • Lakeside Canyon Subdivision, Bellamy Floorplan
  • Community Parking

Recreation

  • Community Playground
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,542

Year Built

Built in 2025 | Under Construction

Lot Details

0

HOA Fees

$60 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Structure Type: House
  • Levels: Two
  • Year Built: 2025
  • Above Grade Finished Sq Ft: 2124
  • Exclusions: n/a
  • Living Area: 2124
  • Property Condition: Under Construction
  • Directions: East on Hwy 66 from I 25, right on county road 9 1/2, right on Gypsum to sales office.
  • SubdivisionName: Lakeside Canyon
  • Ownership: Builder
  • Property Attached Yn: No
  • REC_BasementLevelBathrooms: 0
  • REC_BasementLevelBedrooms: 0
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 2
  • REC_UpperLevelBedrooms: 4
  • REC_WaterIncludedYN: 1
  • Attribution Contact: sales@drhrealty.com
  • Special Features: NewHome

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range, Refrigerator, Tankless Water Heater
  • Fireplaces: 1
  • Interior Amenities: Eat-in Kitchen, Granite Counters, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Smart Thermostat, Smoke Free, Walk-In Closet(s)
  • Flooring: Carpet, Laminate
  • Fireplace Features: Electric
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Crawl Space
  • Basement: No
  • Total Bedrooms: 4
  • Main Level Bathrooms: 1
  • Window Features: Double Pane Windows

Exterior Features

  • Foundation Details: Concrete Perimeter
  • Roof: Shingle
  • Construction Materials: Stone
  • Road Surface Type: Paved

Garage/Parking

  • Parking Features: Concrete, Smart Garage Door
  • Attached Garage: Yes
  • Garage Spaces: 2
  • Total Parking Spaces: 2
  • REC_ParkingCount: 1

Utilities

  • Utilities: Cable Available, Electricity Connected, Natural Gas Connected
  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Electric: 110V, 220 Volts
  • Security: Video Doorbell

Condo/Co-op/Association

  • Association Name: RM Mead Metro District
  • Association Fee Frequency: Monthly
  • Association Amenities: Park, Parking, Playground
  • Association Fee: 60
  • Phone: 970-484-0101
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 720.00
  • REC_AssociationFeeTotalAnnual: 720.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationTransferAmount: $350.00

Schools

  • Middle Or Junior School: Mead

Lot Info

  • Parcel Number: 120735204010
  • Lot Size Acres: 0.16
  • Building Area Total: 2124
  • Lot Features: Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 7150

Building Info

  • Builder Name: D.R. Horton, Inc

Tax Info

  • Tax Year: 2025
  • Tax Annual Amount: 6542

MLS Schools

  • Elementary School: Mead
  • High School: Mead

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
2025 $1,203 $28,810 $28,810 --
2024 $1,203 $28,810 $28,810 --
2023 $491 $2,890 $2,890 $0
2022 $257 $1,510 $1,510 $0
2021 $181 $1,070 $1,070 $0
2020 $2 $10 $10 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/05/2025 08/05/25 Sold $547,900 0.0% $258 / Sq Ft
07/31/2025 07/31/25 Off Market $547,900 -- --
06/25/2025 06/25/25 For Sale $547,900 -- $258 / Sq Ft
Source: REcolorado®

Similar Homes in Longmont, CO

  • 11729 Elmer Linn Dr, Longmont, CO 80504

    $675,000

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

    Discounted rate options and no lender fee future refinancing may be available for qualified buyers of this home.Welcome to your dream home in the highly sought-after neighborhood of The Elms at Meadow Vale in Weld county, wherethe taxes are significantly lower than both the national median of 0.99% and the Colorado state median of 0.55%. Thislovely 3-bedroom, 2.5-bath home is

    Tiffany Osborn Orchard Brokerage LLC

    Section Image
  • 227 Cattail Ct, Longmont, CO 80501

    $535,000

    • 3 Beds
    • 2.5 Baths
    • 1,496 Sq Ft
    • 227 Cattail Ct
    • Longmont, CO

    Step into a light-filled home featuring a beautifully remodeled kitchen with, sleek countertops, stainless steel appliances, and an open layout perfect for both cooking and entertaining. The living and dining areas flow seamlessly with warm finishes and functional design. Upstairs, you’ll find three generously sized bedrooms, including a spacious primary suite with vaulted ceilings, a soaking

    Adam Mayfield eXp Realty, LLC

    Section Image
  • 1005 E 5th Ave, Longmont, CO 80504

    $675,000

    • 4 Beds
    • 2.5 Baths
    • 3,136 Sq Ft
    • 1005 E 5th Ave
    • Longmont, CO

    Exceptionally unique Fox Hill gem! This distinctive 4-level home sits on a desirable corner lot with fantastic views and gorgeous mature trees providing shade and privacy. Inside, you'll find 4 spacious bedrooms and 3 baths, plus fresh new paint and carpet throughout. The kitchen features brand-new stainless-steel appliances and an inviting eat-in area. A separate dining room adjoins which is

    Janet Leap RE/MAX of Boulder, Inc

    Section Image
  • 2344 Flagstaff Dr, Longmont, CO 80504

    $599,000

    • 4 Beds
    • 3.5 Baths
    • 3,422 Sq Ft
    • 2344 Flagstaff Dr
    • Longmont, CO

    Hard to find beautifully updated ranch style home with 3-car garage in popular Pleasant Valley. Open floor plan. 2000+sf on main floor. Great for entertaining. Vaulted ceilings. Hardwood floors throughout. Refurbished cabinets and granite counters highlight bright and fresh kitchen/eat-in area with access to wrap around patio. Family room off kitchen features cozy gas fireplace. Main floor

    Mark Webber Equity Colorado-Front Range

    Section Image
  • 2442 Collyer St, Longmont, CO 80501

    $525,000

    • 3 Beds
    • 2 Baths
    • 2,745 Sq Ft
    • 2442 Collyer St
    • Longmont, CO

    Welcome to this well-maintained 3-bedroom, 2-bath ranch-style home, ideally situated on a large corner lot in a desirable North Longmont neighborhood. Built in 1972, this home offers timeless charm with modern updates and exceptional potential. The main level features a spacious primary bedroom, while the expansive living areas are filled with natural light. The attached two-car garage is

    Andrew Hawbaker Coldwell Banker Realty-NOCO

    Section Image
  • 940 Gay St, Longmont, CO 80501

    $489,900

    • 2 Beds
    • 1 Bath
    • 1,131 Sq Ft
    • 940 Gay St
    • Longmont, CO

    Welcome to 940 Gay Street, where timeless charm and everyday comfort come together on one of the largest lots on the block. Tucked beneath a canopy of mature trees and surrounded by lush gardens, this 1941 cottage invites you in from the moment you arrive. The front porch swing is perfect for slow mornings, and the private backyard offers a peaceful retreat for birdwatching, relaxing, or

    Heather McChesney Keller Williams 1st Realty

    Section Image
  • 1313 Garden Cir, Longmont, CO 80501

    $595,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
  • 1630 Lincoln Ct, Longmont, CO 80501

    $525,000

    • 2 Beds
    • 2.5 Baths
    • 2,318 Sq Ft
    • 1630 Lincoln Ct
    • Longmont, CO

    Tucked away in a peaceful cul-de-sac in desirable Twin Peaks Estate, this rarely available full-brick ranch offers easy living with no HOA or metro district taxes. The well-designed main level features an open-concept living, dining, and kitchen area, plus a cozy second living room with a gas fireplace-perfect for gatherings or relaxing evenings. The primary suite includes a private 3/4 bath and

    Jenny Hart Keller Williams 1st Realty

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

    $489,900

    • 3 Beds
    • 1.5 Baths
    • 1,168 Sq Ft
    • 1325 11th Ave
    • Longmont, CO

    HUGE PRICE DROP! Make an offer on this better than new home. Beautifully updated 3-bedroom, 2-bathroom bungalow in Longmont's coveted Old Town area. This home blends mature neighborhood charm with modern comforts, featuring new hardwood floors, craftsman details, and an open floor plan flooded with natural light and new energy efficient windows. The chef-inspired kitchen boasts stainless steel

    Jeffrey Goodell Berkshire Hathaway HomeServices Rocky Mountain, Realtors-Fort Collins

    Section Image

Source: REcolorado®

MLS Number: 3852836

REcolorado®

APN: R8968441