5174 Queen Court, Arvada, CO 80002
Property image
Property image
OFF MARKET

$974,100

Trulia Estimate
  • 4 Beds
  • 3.5 Baths
  • 3,894 sqft

5174 Queen Court, Arvada, CO 80002

Skyline
Est. Refi. Payment $5,512/mo*
Refinance Your Home
Currently Off Market - Sold Feb 21, 2024 for $958,950

Home Value

Trulia Estimate
$974K
Since last month
Decreased$14K (-1.4%)
Since last year
Increased$23K (+2.4%)
Since last sale
Increased$15K (+1.6%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value decreased by -2% in the last 10 years
MonthEstimated value
2026
August 2026$974K
August 2026$974K
July 2026$988K
June 2026$996K
May 2026$977K
April 2026$977K
March 2026$982K
February 2026$973K
January 2026$964K
2025
2024
2023

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
5194 Queen Court, Arvada, CO
0.02
Single-Family Home
$875,000
12/22/25
4
3
3,760
5311 Routt Ct, Arvada, CO
0.21
Single-Family Home
$955,000
06/18/26
5
3
4,086
11463 W 53rd Place, Arvada, CO
0.26
Single-Family Home
$1,100,000
05/13/26
5
3
4,086
5547 Quail Street, Arvada, CO
0.41
Single-Family Home
$965,000
06/09/26
4
3.5
4,138
11034 W 54th Lane, Arvada, CO
0.37
Single-Family Home
$850,000
06/16/26
4
3.5
2,846
5275 Taft Court, Arvada, CO
0.42
Single-Family Home
$1,065,000
10/30/25
5
3.5
4,138
10975 W 54th Lane, Arvada, CO
0.42
Single-Family Home
$852,000
09/15/25
3
2.5
3,949
5218 Routt Street #A, Arvada, CO
0.12
Single-Family Home
$547,000
06/08/26
3
2.5
1,372
5327 Quail Way, Arvada, CO
0.10
Single-Family Home
$675,000
05/25/26
3
2.5
1,920

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
5164 Queen Court, Arvada, CO 80002
0.01
$955,900
4
3.5
4,200
Off Market
5184 Queen Court, Arvada, CO 80002
0.01
$975,000
5
4
4,041
Off Market
5161 Queen Court, Arvada, CO 80002
0.03
$623,900
3
3
1,840
Off Market
5165 Queen Court, Arvada, CO 80002
0.03
$642,200
3
2.5
1,930
Off Market
5155 Queen Court, Arvada, CO 80002
0.03
$622,200
2
2.5
1,714
Off Market
5171 Queen Court, Arvada, CO 80002
0.03
$644,200
3
2.5
1,943
Off Market
5194 Queen Court, Arvada, CO 80002
0.02
$875,000
4
3
3,760
Recently Sold
5175 Queen Court, Arvada, CO 80002
0.03
$641,400
3
3
1,840
Off Market
5124 Queen Court, Arvada, CO 80002
0.05
$939,100
4
3.5
4,047
Off Market
11319 W 51st Drive, Arvada, CO 80002
0.05
$644,100
2
2.5
1,840
Off Market
5181 Queen Court, Arvada, CO 80002
0.03
$628,100
2
2.5
1,850
Off Market

Local Information

  • Map ViewExplore the area around 5174 Queen Court.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Single-Family Home
Built in 2023
3,894 sqft
$250/sqft
2 Car Garage
HOA $47/mo

About this House

**!!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.
5174 Queen Court, Arvada, CO 80002 is a 4 bedroom, 4 bathroom, 3,894 sqft single-family home in Skyline, built in 2023. It last sold for the $958,950 asking price on Feb 21, 2024. This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $974,100, with a rent estimate of $4,597/month.
Last check for updates: about 6 hours ago
Listed by Matthew Tonge, (303) 850-5757
Richmond Realty Inc
Bought with: Amy Mancini, (508) 688-2772, LIV Sotheby's International Realty
Source: REcolorado as distributed by MLS GRID, MLS#8517139

Home Details for 5174 Queen Court

Interior Features

Interior Details
Basement: Finished,Full,Sump PumpNumber of Rooms: 16Types of Rooms: Master Bedroom, Bedroom, Master Bathroom, Bathroom, Bonus Room, Great Room, Kitchen, Laundry, Loft, Sun Room
Beds & Baths
Number of Bedrooms: 4Number of Bathrooms: 4Number of Bathrooms (full): 1Number of Bathrooms (three quarters): 2Number of Bathrooms (half): 1Number of Bathrooms (main level): 1
Dimensions and Layout
Living Area: 3894 Square Feet
Appliances & Utilities
Appliances: Cooktop, Dishwasher, Disposal, Microwave, Oven, Range HoodDishwasherDisposalMicrowave
Heating & Cooling
Heating: Forced AirHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Number of Fireplaces: 1Fireplace: Gas, Great RoomHas a Fireplace
Windows, Doors, Floors & Walls
Window: Double Pane WindowsFlooring: Carpet, Tile
Levels, Entrance, & Accessibility
Stories: 2Levels: TwoFloors: Carpet, Tile
View
No View

Exterior Features

Exterior Home Features
Roof: CompositionPatio / Porch: Covered, Deck, PatioFoundation: Slab
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageParking Spaces: 2Parking: Oversized
Frontage
Not on Waterfront
Water & Sewer
Sewer: Public Sewer
Finished Area
Finished Area (above surface): 2686 Square FeetFinished Area (below surface): 875 Square Feet

Property Information

Year Built
Year Built: 2023
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceStructure Type: HouseArchitecture: House
Building
Construction Materials: FrameIs a New ConstructionNot Attached Property
Property Information
Condition: Under ConstructionNot Included in Sale: NoneParcel Number: 513677

Price & Status

Price
List Price: $958,950
Status Change & Dates
Off Market Date: Tue Jan 16 2024Possession Timing: Close Of Escrow

Active Status

MLS Status: Closed

Location

Direction & Address
City: ArvadaCommunity: Haskins Station
School Information
Elementary School: VanderhoofElementary School District: Jefferson County R-1Jr High / Middle School: DrakeJr High / Middle School District: Jefferson County R-1High School: Arvada WestHigh School District: Jefferson County R-1

Building

Building Details
Builder Model: Skylar / DBuilder Name: Richmond American Homes
Building Area
Building Area: 3894 Square Feet

Community

Not Senior Community

HOA

HOA Name: White Bear, Ankele Tanaka & Waldron, Attorneys atHOA Phone: 303-858-1800Has an HOAHOA Fee: $47/Monthly

Lot Information

Lot Area: 5200 sqft

Listing Info

Special Conditions: Standard

Offer

Contingencies: None KnownListing Terms: Cash, Conventional, FHA, VA Loan

Mobile R/V

Mobile Home Park
Mobile Home Units: Feet

Business

Business Information
Ownership: Builder

Miscellaneous

BasementMls Number: 8517139Attribution Contact: 303-850-5757Above Grade Unfinished Area: 2686Below Grade Unfinished Area: 333

Price and Tax history

DateEventPrice
Feb 21, 2024
Source: REcolorado as distributed by MLS GRID #8517139
Sold
$958,950
Jan 17, 2024
Source: REcolorado as distributed by MLS GRID #8517139
Pending
$958,950
Oct 31, 2023
Source: REcolorado as distributed by MLS GRID #8517139
PriceChange
$958,950
Price increased by 1%
Sep 22, 2023
Source: REcolorado as distributed by MLS GRID #8517139
PriceChange
$949,950
Price decreased by 5%
Jul 31, 2023
Source: REcolorado as distributed by MLS GRID #8517139
Listed For Sale
$999,950

Market trends in Arvada

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
$638K
$5KMoM
Sale-to-List Price
100.0%
Price per sq ft
$274
$1MoM
Available listings
640
22MoM

Around this home

Neighborhood Overview

Skyline
See Local Highlights
Neighborhood stats provided by third party data sources.

What Locals Say about Skyline

At least 18 Trulia users voted on each feature.

  • 95 % Say it's dog friendly

  • 89 % Say car is needed

  • 75 % Say there are sidewalks

  • 72 % Say it's walkable to grocery stores

  • 67 % Say streets are well-lit

  • 65 % Say parking is easy

  • 65 % Say there's holiday spirit

  • 65 % Say there's wildlife

  • 63 % Say yards are well-kept

  • 56 % Say it's walkable to restaurants

  • 50 % Say people would walk alone at night

  • 48 % Say they plan to stay for at least 5 years

  • 45 % Say it's quiet

  • 45 % Say kids play outside

  • 43 % Say neighbors are friendly

  • 15 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Trulia User
    "Dogs exist here and they nice. Nice dogs. Dogs are sweet. Owners don’t always pick up dog poop. Not nice"
    0
    Flag
  • Briandavid06
    "Lots of motels in the area. Increasing homeless population..............................................."
    0
    Flag
  • Dunnavratil
    "I know most of the dogs in the neighborhood. I also know most of their parents names. The dog owners are usually very friendly. Unfortunately I am not crazy about the dog parks nearby."
    0
    Flag
  • Jessica A. M. S.
    "The Abbey is a very horrible place to live, the community is crowded. I’ve been robbed four times. I’m about to leave the community & will not renew my lease. My husband & I are finally buying a home. "
    8
    Flag

LGBTQ Local Legal Protections

© 2026 REcolorado® All rights reserved. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, REcolorado®. Some IDX listings have been excluded from this website. Click here for more information

Frequently asked questions about 5174 Queen Court

  • What is 5174 Queen Court estimated to be worth?
    Trulia's estimated value for 5174 Queen Court in Arvada, CO is $974,100.
  • What is the price history for 5174 Queen Court?
    5174 Queen Court in Arvada, CO last sold for $958,950 in February 2024.
  • Is Arvada a buyer's or seller's market?
    Arvada is currently a balanced market, based on recent for-sale activity.
  • What's the median sale price in Arvada?
    The median sale price in Arvada is $638K. That is up $5K from the prior month.
  • Does 5174 Queen Court have air conditioning?
    Yes, 5174 Queen Court in Arvada, CO has air conditioning.
  • Does 5174 Queen Court have laundry facilities?
    Yes, 5174 Queen Court in Arvada, CO has laundry facilities.

Explore by feature - Pet Friendly

172 pet-friendly rentals in Arvada, CO

Explore by feature - Garage

125 rentals with a garage in Arvada, CO

Explore by feature - Air Conditioning

213 rentals with air conditioning in Arvada, CO

Explore by feature - Pool

55 rentals with a pool in Arvada, CO

Explore by feature - Washer/dryer

243 rentals with a washer/dryer in Arvada, CO

Explore by feature - Outdoor Space

70 rentals with an outdoor space in Arvada, CO

Apartments for Rent

Skip to last item
Skip to first item

Off Market Homes Near 5174 Queen Court

Skip to last item
Skip to first item

Homes for sale near 5174 Queen Court

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item