It's in the top 10% of views. Tour it before it's gone!
Today:
About this home
Pull up to 4143 Limestone Avenue and feel the difference. This is a home that still carries the unmistakable glow of new construction, with the kind of modern design and quality craftsmanship that only comes with a recent build. The smart garage door, the clean architectural lines, and the meticulously kept lot immediately tell you this is a place where pride of ownership is the standard. Step through the front door and discover 1,503 square feet of open, airy living space designed for the way life actually happens. The heart of the home is a spacious great room that flows seamlessly into the kitchen, where a large granite island serves as the perfect gathering spot for everything from quick weekday breakfasts to weekend entertaining. A walk-in pantry, a suite of modern appliances including a self-cleaning oven and tankless water heater, and a smart thermostat round out a kitchen that is as functional as it is beautiful. The primary suite is a true retreat, complete with a walk-in closet and a private ensuite bath. Two additional main-level bedrooms offer flexibility for family, guests, or a dedicated home office. And with no stairs anywhere in the home, this is single-level living at its most effortless. A radon mitigation system is already in place, offering peace of mind from day one. Step outside to the private, partially fenced backyard, where a front-yard sprinkler system keeps the landscape looking sharp. The attached 3-car garage offers ample space for vehicles, outdoor gear, or a workshop. Double-pane windows with coverings are already installed, and the home is wired for data – because modern living demands modern connectivity. Located in the sought-after St. Acacius neighborhood, you are perfectly positioned between the charm of Mead and the convenience of Longmont. Parks, schools, shopping, and major commuter routes are all within easy reach.
Pull up to 4143 Limestone Avenue and feel the difference. This is a home that still carries the unmistakable glow of new construction, with the kind of modern design and quality craftsmanship that only comes with a recent build. The smart garage door, the clean architectural lines, and the meticulously kept lot immediately tell you this is a place where pride of ownership is the standard. Step through the front door and discover 1,503 square feet of open, airy living space designed for the way life actually happens. The heart of the home is a spacious great room that flows seamlessly into the kitchen, where a large granite island serves as the perfect gathering spot for everything from quick weekday breakfasts to weekend entertaining. A walk-in pantry, a suite of modern appliances including a self-cleaning oven and tankless water heater, and a smart thermostat round out a kitchen that is as functional as it is beautiful. The primary suite is a true retreat, complete with a walk-in closet and a private ensuite bath. Two additional main-level bedrooms offer flexibility for family, guests, or a dedicated home office. And with no stairs anywhere in the home, this is single-level living at its most effortless. A radon mitigation system is already in place, offering peace of mind from day one. Step outside to the private, partially fenced backyard, where a front-yard sprinkler system keeps the landscape looking sharp. The attached 3-car garage offers ample space for vehicles, outdoor gear, or a workshop. Double-pane windows with coverings are already installed, and the home is wired for data - because modern living demands modern connectivity. Located in the sought-after St. Acacius neighborhood, you are perfectly positioned between the charm of Mead and the convenience of Longmont. Parks, schools, shopping, and major commuter routes are all within easy reach.
Public Records
Sep 4, 2026
Sold
$545,000
$363/sq ft
REColorado as Distributed by MLS Grid #4427790
Jun 25, 2024
Sold
$525,000
$349/sq ft
Jun 25, 2024
Sold
$525,000
$349/sq ft
May 27, 2024
Pending
—
May 27, 2024
Pending
—
May 8, 2024
Relisted
—
May 8, 2024
Relisted
—
May 2, 2024
Pending
—
May 2, 2024
Pending
—
Apr 26, 2024
Listed
$530,000
$353/sq ft
Apr 26, 2024
Listed
$530,000
$353/sq ft
+17
Hurry before its gone!! This Beautiful 3 bedroom ranch with oversized 3 car garage, feels brand new and has some amazing upgrades!!! Large open kitchen, featuring granite counters, gas-range, a large eat-in kitchen island, and a HUGE corner pantry!! Relax on your newly extended Trex rear patio with a brand new wood pergola to offer some shade as you take in the gorgeous mountain views. Backing to open space, you can enjoy the beautiful sunsets in your fully fenced yard. This home, with so many upgrades, also features a tankless water heater, passive Radon system, and a Smart Home Package. Bring your dogs as there are miles of paths and nearby lakes!
IRES as Distributed by MLS Grid #1958850
Feb 28, 2023
Sold
$505,000
$336/sq ft
Jan 9, 2023
Pending
—
Jan 6, 2023
Price Changed
$505,000
$336/sq ft
Jan 6, 2023
Price Changed
$505,000
$336/sq ft
Jan 4, 2023
Listed
$512,395
$341/sq ft
Jan 4, 2023
Listed
$512,395
$341/sq ft
IRES as Distributed by MLS Grid #979946
Feb 28, 2023
Sold
$505,000
$336/sq ft
Jan 9, 2023
Pending
—
Jan 6, 2023
Price Changed
$505,000
$336/sq ft
Dec 27, 2022
Listed
$512,395
$341/sq ft
Public Records
Apr 20, 2022
Sold
$9,100,000
$6,055/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$5,489 (+16.1%)
$9,060 + $21,100
$30,160
2024
$4,726 (+3.6%)
$9,060 + $21,100
$30,160
2023
$4,562 (+1,675.4%)
$6,370 + $24,140
$30,510
2022
$257 (+41.9%)
$1,510
2021
$181 (+10,679.8%)
$1,510
2020
$2
$1,070
Public record
Public record
Zoning
Beds
3
Baths
2
Stories
1
Lot width
—
Lot depth
—
Lot size
7,150 Sq. Ft.
Year renovated
—
Finished Sq. Ft.
1,494
Unfinished Sq. Ft.
—
Total Sq. Ft.
1,494
Year built
2022
Style
Single Family Residential
County
Weld County
APN
R8968474
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 15, 2026.
RSF-4
Residential Single-Family District
The RSF-4 district is primarily intended to accommodate medium-density, single-family residential development with a density of up to 4 units per acre and to provide land use protection for areas that develop in such a manner.
Permitted uses
Include but are not limited to:
Religious facility
Housing-Single unit
Infrastructure
Bed & breakfast
Educational/school
Park & open space
Local insights from Redfin agents
Perfectly located in the heart of Colorado, Firestone offers residents a remarkable blend of leisure and convenience. The town exhibits stunning landscapes, from the broad open spaces under deep blue skies, the majestic mountain views, to...
breathtaking sunsets and glimmering pristine lakes.