**!!READY SPIRNG 2024!!**This expansive Skylar is waiting to impress its residents with two stories of creatively designed living spaces! The main floor is ideal for entertaining with its open layout and a versatile flex room off the entry. The great room at the heart of the home welcomes you to relax and offers access to the covered, walk-out deck. Beyond, the gourmet kitchen impresses any level of chef with its quartz center island, walk-in pantry and stainless steel appliances. A connected sunroom is available for more formal meals and conversation. Added conveniences include a spacious laundry room and a main level powder. Retreat upstairs to find two generous bedrooms and a shared full bath, that makes perfect accommodations for family or guests. A comfortable loft rests outside the lavish primary suite, which showcases a private bathroom and spacious walk-in closet. If that wasn't enough, this home includes a finished, walk-out basement that boasts a wide-open rec room, an additional bedroom and a shared bath with a shower.
Sold for $958,950
$958,950
5174 Queen Court, Arvada, CO 80002
4beds
3,894sqft
Single Family Residence
Built in 2023
5,200 Square Feet Lot
$999,200 Zestimate®
$246/sqft
$4,661 Estimated rent
Home value
$999,200
$949,000 - $1.05M
$4,661/mo
Zestimate® history
Owner options
List your home for rent
$4,661/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,661/mo
Rent Zestimate®
Refinance and save
$5,536/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,536/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Walk-out basementVersatile flex roomShared bathGreat roomLavish primary suiteWide-open rec roomWalk-in pantry
Zillow last checked:
Listing updated:
Listed by:
Matthew Tonge 303-850-5757,
Richmond Realty Inc
Bought with:
Amy Mancini, 100089121
LIV Sotheby's International Realty
Source: REcolorado as distributed by MLS GRID,MLS#: 8517139
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 1
- 3/4 bathrooms: 2
- 1/2 bathrooms: 1
- Main level bathrooms: 1
Primary bedroom
- Description: Walk-In Closet
- Level: Upper
- Area: 195 Square Feet
- Dimensions: 13 x 15
Bedroom
- Description: Bedroom 2
- Level: Upper
- Area: 110 Square Feet
- Dimensions: 11 x 10
Bedroom
- Description: Bedroom 3
- Level: Upper
- Area: 120 Square Feet
- Dimensions: 12 x 10
Bedroom
- Description: Basement Bedroom: Walk-In Closet
- Level: Basement
- Area: 143 Square Feet
- Dimensions: 13 x 11
Primary bathroom
- Description: En Suite: Dual Sinks
- Level: Upper
Bathroom
- Level: Main
Bathroom
- Description: Dual Sinks
- Level: Upper
Bathroom
- Level: Basement
Bonus room
- Description: Flex Room
- Level: Main
- Area: 165 Square Feet
- Dimensions: 15 x 11
Bonus room
- Description: Rec Room
- Level: Basement
- Area: 390 Square Feet
- Dimensions: 15 x 26
Bonus room
- Description: Extension Of Rec Room
- Level: Basement
- Area: 130 Square Feet
- Dimensions: 10 x 13
Great room
- Description: Fireplace
- Level: Main
- Area: 272 Square Feet
- Dimensions: 16 x 17
Kitchen
- Description: Gourmet Kitchen: Walk-In Pantry
- Level: Main
- Area: 352 Square Feet
- Dimensions: 16 x 22
Laundry
- Level: Main
Loft
- Level: Upper
- Area: 221 Square Feet
- Dimensions: 13 x 17
Sun room
- Description: Vaulted Ceiling
- Level: Main
- Area: 135 Square Feet
- Dimensions: 9 x 15
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Cooktop, Dishwasher, Disposal, Microwave, Oven, Range Hood
Features
- Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Walk-In Closet(s)
- Flooring: Carpet, Tile
- Windows: Double Pane Windows
- Basement: Finished,Full,Sump Pump
- Number of fireplaces: 1
- Fireplace features: Gas, Great Room
Interior area
- Total structure area: 3,894
- Total interior livable area: 3,894 sqft
- Finished area above ground: 2,686
- Finished area below ground: 875
Property
Parking
- Total spaces: 2
- Parking features: Oversized
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered, Deck, Patio
Lot
- Size: 5,200 Square Feet
- Features: Master Planned, Open Space, Sprinklers In Front
Details
- Parcel number: 513677
- Zoning: Residential
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame
- Foundation: Slab
- Roof: Composition
Condition
- Under Construction
- New construction: Yes
- Year built: 2023
Details
- Builder model: Skylar / D
- Builder name: Richmond American Homes
Utilities & green energy
- Sewer: Public Sewer
Community & HOA
Community
- Subdivision: Haskins Station
HOA
- Has HOA: Yes
- HOA fee: $47 monthly
- HOA name: White Bear, Ankele Tanaka & Waldron, Attorneys at
- HOA phone: 303-858-1800
Location
- Region: Arvada
Financial & listing details
- Price per square foot: $246/sqft
- Tax assessed value: $990,500
- Annual tax amount: $5,839
- Date on market: 7/31/2023
- Listing terms: Cash,Conventional,FHA,VA Loan
- Exclusions: None
- Ownership: Builder
Price history
| Date | Event | Price |
|---|---|---|
| 2/21/2024 | Sold | $958,950$246/sqft |
Source:  REcolorado as distributed by MLS GRID #8517139 Report a problem | ||
| 1/17/2024 | Pending sale | $958,950$246/sqft |
Source: REcolorado as distributed by MLS GRID #8517139 Report a problem | ||
| 10/31/2023 | Price change | $958,950+0.9%$246/sqft |
Source: REcolorado as distributed by MLS GRID #8517139 Report a problem | ||
| 9/22/2023 | Price change | $949,950-5%$244/sqft |
Source: REcolorado as distributed by MLS GRID #8517139 Report a problem | ||
| 7/31/2023 | Listed for sale | $999,950$257/sqft |
Source: REcolorado as distributed by MLS GRID #8517139 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $5,839 +28.2% | $61,907 +83.3% |
| 2024 | $4,555 +38% | $33,766 +29.1% |
| 2023 | $3,301 +46.4% | $26,149 +31.9% |
| 2022 | $2,254 +46.6% | $19,819 +50.3% |
| 2021 | $1,537 | $13,183 |
| 2020 | $1,537 | -- |
Find assessor info on the county website
Neighborhood: Skyline
Nearby homes
- $939,9505 bd4 ba4k sqft5184 Queen Ct, Arvada, CO 80002Sold
- $924,9504 bd4 ba4.2k sqft5164 Queen Ct, Arvada, CO 80002Sold
- $972,1004 bd3 ba3.9k sqft5154 Queen Ct, Arvada, CO 80002Sold
- $875,0004 bd3 ba3.7k sqft5194 Queen Ct, Arvada, CO 80002Sold
- $674,9503 bd3 ba1.8k sqft5175 Queen Ct, Arvada, CO 80002Sold
- $673,9503 bd3 ba1.9k sqft5171 Queen Ct, Arvada, CO 80002Sold
- $671,7503 bd3 ba1.9k sqft5165 Queen Ct, Arvada, CO 80002Sold
- $929,9504 bd4 ba4k sqft5204 Queen Ct, Arvada, CO 80002Sold
Nearby schools
GreatSchools rating
- 5/10Vanderhoof Elementary SchoolGrades: K-5Distance: 0.8 mi
- 7/10Drake Junior High SchoolGrades: 6-8Distance: 0.9 mi
- 7/10Arvada West High SchoolGrades: 9-12Distance: 1.4 mi
Schools provided by the listing agent
- Elementary: Vanderhoof
- Middle: Drake
- High: Arvada West
- District: Jefferson County R-1
Source: REcolorado as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$999,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$999,200
- Colorado
- Jefferson County
- Arvada
- 80002
- Skyline
- 5174 Queen Court
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Arvada Topics
