Shereen Muckerman - Mortgage Wizard Shereen Muckerman - Mortgage Wizard
Schedule Tour
$578,340

6902 Quail Ave

Firestone, CO
Active
4
Bedrooms
2.5
Bathrooms
2,429
Square Feet
0.1
Lot Size (acres)
2026
Year Built
26
Days On Market

Anticipated completion in November 2026! Ask a sales counselor about optional rear yard fencing! Open concept kitchen with granite countertops and white cabinets! A Whirlpool appliance package, and full home blinds are also included for move-in convenience. The Durango offers 2,419 sq. ft. of thoughtfully designed living with 4 bedrooms, 2.5 baths, and a 2-car garage. As the largest plan, it features abundant flex space and an open first floor with a spacious great room that flows seamlessly into the kitchen—perfect for hosting and staying connected. The Meritage Home difference includes whole-home blinds for added privacy and style, plus a refrigerator, washer, and dryer, saving you thousands upfront with essential appliances already included. Enjoy improved energy efficiency with spray-foam insulation that helps keep utility costs lower year-round, advanced air filtration for cleaner everyday living, and fire-resistant siding that provides lasting durability and protection. Welcome home to a place where every detail is built for comfort, efficiency, and LIFE. BUILT. BETTER. Frontier Estates in Firestone offers a convenient location with easy access to nearby shopping, dining, parks, and everyday essentials. Residents can enjoy community amenities including a park, playground, tennis court, and open gathering spaces, all while living in a connected Northern Colorado setting. *Interior photos are representative only and not of the actual home. Actual elevations, appliance models and interior finishes may vary. *This home qualifies for special incentives through builder preferred lender for a limited time. Terms and conditions apply. See sales counselor for details!

Listing Information

Listing Updated
12 days ago
Listed By
Kerrie Young, 3033573011 · Kerrie A. Young (Independent), 3033573011
MLS#
3143932
Source
REcolorado
Status
Active

Facts & Features

Location

Community Information

Address
6902 Quail Ave, Firestone, CO 80504
City
Firestone
County
Weld
Neighborhood
Frontier Estates
Zip Code
80504

Architecture

Bedrooms
4
Bathrooms
2.5
Year Built
2026
Style
Mountain Contemporary
Construction Materials
Frame, Stone, Cement Siding, Concrete
Building Area
2,429 sq. ft.
Foundation
Slab
Roof
Composition
Levels
Two
Garage
Yes
Garage Spaces
2
Parking Features
Attached, Concrete

Features & Amenities

Interior Features
High Speed Internet, Eat-in Kitchen, Walk-In Closet(s), Pantry, Kitchen Island, Granite Counters, Wired for Data, Open Floorplan, Smart Thermostat
Appliances
Dryer, Dishwasher, Microwave, Refrigerator, Washer, Range, Disposal, Gas Water Heater
Flooring
Tile, Vinyl, Carpet
Exterior Features
Private Yard
Patio and Porch
Covered, Front Porch
Cooling
Central Air
Heating
Forced Air, Natural Gas

Property Features

Lot Size
0.1 Acres
Lot Features
Landscaped, Sprinklers In Front
Water
Public
Sewer
Public Sewer
Utilities
Cable Available, Natural Gas Available, Natural Gas Connected, Electricity Connected, Phone Available

Square Footage

Above Grade
2,429 sq. ft.
Total
2,429 sq. ft.

Tax & Financial Information

List Price
$578,340
Annual Taxes
$6,825

Schools

99/100
Grand View Elementary
Elementary · Grades PK–05 · 4.8 mi
City
Frederick
Students
284
Student body
72% White · 22% Hispanic / Latino · 3% Asian
Free/reduced lunch
19%
Phone
(303) 702-8000
76/100
Prairie Ridge Elementary School
Elementary · Grades PK–05 · 1.2 mi
City
Firestone
Students
437
Parent reviews
5.0★ avg · 2 reviews
Student body
79% White · 17% Hispanic / Latino · 2% Two or More Races
Free/reduced lunch
18%
Phone
(720) 494-3641
76/100
Legacy Elementary School
Elementary · Grades PK–05 · 2.6 mi
City
Frederick
Students
623
Parent reviews
5.0★ avg · 1 review
Student body
79% White · 16% Hispanic / Latino · 2% Asian
Free/reduced lunch
17%
Phone
(720) 652-8160
70/100
Carbon Valley Academy
Elementary · Grades PK–08 · 3.1 mi
City
Frederick
Students
265
Parent reviews
4.2★ avg · 6 reviews
Student body
50% White · 45% Hispanic / Latino · 3% Two or More Races
Free/reduced lunch
42%
Phone
(303) 774-9555
68/100
Thunder Valley Pk-8
Elementary · Grades PK–08 · 2.6 mi
City
Frederick
Students
814
Parent reviews
4.0★ avg · 2 reviews
Student body
59% Hispanic / Latino · 38% White · 1% Two or More Races
Free/reduced lunch
53%
Phone
(303) 833-2456
67/100
Centennial Elementary
Elementary · Grades PK–05 · 2 mi
City
Firestone
Students
468
Parent reviews
4.0★ avg · 1 review
Student body
67% White · 27% Hispanic / Latino · 3% Asian
Free/reduced lunch
33%
Phone
(720) 652-8240
56/100
Spark! Discovery Preschool
Elementary · Grades PK–PK · 2.7 mi
City
Frederick
Students
293
Student body
50% White · 40% Hispanic / Latino · 5% Asian
Free/reduced lunch
26%
Phone
(720) 652-7906
55/100
Coal Ridge Middle School
Middle · Grades 06–08 · 1.5 mi
City
Firestone
Students
773
Student body
69% White · 26% Hispanic / Latino · 2% Two or More Races
Free/reduced lunch
27%
Phone
(303) 833-4176

School ratings are provided for informational purposes only and are subject to change. Attendance boundaries are for reference only — contact the school or district directly to verify enrollment eligibility.

Historical Data

Price History

DateEventPrice
09/01/2026Price change$578,340
08/19/2026Listed for sale$583,340

Listed by Kerrie Young · Kerrie A. Young (Independent) · 3033573011

Listing information provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed by the MLS. Copyright 2026, REcolorado. All rights reserved.

Last Updated: September 1, 2026 at 8:57 PM | Source: REcolorado | MLS#: 3143932

Let's work together

Start Your Real Estate Journey

Whether you have questions about this listing, want to schedule a showing, or just want to talk through your options, Shereen Muckerman - Mortgage Wizard is here to help. Reach out and expect a response within one business day.

How can I help?

Shereen Muckerman - Mortgage Wizard is here to help. Reach out and expect a response within one business day.

Lending calculator

Make A Plan For Your Purchase

Know what you can afford before you start shopping — then run the numbers on any home you have in mind.

How much house can I afford?

$500,000
You can afford
$0
Monthly payment
  • Principal & interest
  • Property taxes
  • Homeowner's insurance
  • HOA dues

Enter your income, debts, and down payment to see how much home you may qualify for. Estimates only — not a lending decision.

Want to know more?

Team Shereen is here to help. Reach out and expect a response within one business day.

Mortgage pre-approval

Your Next Chapter Starts With Just A Few Steps

Before you fall in love with a home, know what you can afford. Fill out a quick pre-approval so you're ready to make your move — on your timeline.

Team Shereen
The Mortgage Wizard
Team Shereen
LO NMLS: #1396756

Pre-approval made easy

We're here to help you find the best option, not to help the best option find you. Trust that your information will not be shared with many different lenders like so many platforms do.