Location Is Everything!!! You won't find anything that compares to this home at this price with a minute's walk to the light rail station! Don't miss this rare opportunity to own this model-like home in the highly sought-after Haskins Station neighborhood that will check all of your boxes! Minutes to everything, lavishly upgraded throughout and backing to open space-what more could you want? Exquisite tilework in the foyer offers a stunning first impression into the main floor which is home to a great room, gourmet kitchen, huge dining area, private primary bedroom with en suite bath, one secondary bedroom, a spacious office with custom glass French doors & full wall shelving, a large shared bathroom and a convenient laundry/wet room. The great room features a full-height tile fireplace with a custom mantel, smart ceiling fan, built-in shelving, and is flooded with light. The chef’s delight kitchen is packed with upgrades including an enormous quartz center island with a farmhouse sink, brilliant pendant lighting and seating, upgraded soft close cabinetry, a walk-in pantry, an upgraded GE appliance package with gas range and an eye-catching range hood with matching two-tone island cabinets. The luxurious primary suite offers a private bath, convenient linen closet and spacious walk-in closet. The finished basement includes a wide-open rec room with a wet bar and surround sound speakers, two large bedrooms, a shared bath with tile that will astound you and more storage than you could ever need! Relax on the covered patio equipped with speakers and take in the views of the open space & walking trails and will not be developed! Huge oversized garage with plenty of room for that big truck is icing on the cake! Too many upgrades to mention-contact agent for list of upgrades & finishes and hurry before this one-of-a-kind diamond is gone!
Sold for $950,000
$950,000
5394 Queen Court, Arvada, CO 80002
4beds
3,684sqft
Single Family Residence
Built in 2023
6,293 Square Feet Lot
$918,100 Zestimate®
$258/sqft
$4,634 Estimated rent
Home value
$918,100
Estimated sales range
Not available
$4,634/mo
Zestimate® history
Owner options
List your home for rent
$4,634/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$4,634/mo
Rent Zestimate®
Refinance and save
$5,579/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$5,579/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
Full-height tile fireplaceFinished basementGreat roomLuxurious primary suiteWalk-in pantryUpgraded soft close cabinetryUpgraded ge appliance package
Zillow last checked:
Listing updated:
Listed by:
Diana Merrin 303-250-8550 Diana@MileHiHomes.com,
Your Castle Real Estate Inc
Bought with:
Jamie Collins, 100087283
Redfin Corporation
Source: REcolorado as distributed by MLS GRID,MLS#: 8684791
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 1
- 3/4 bathrooms: 2
- Main level bathrooms: 2
- Main level bedrooms: 2
Primary bedroom
- Description: Ceiling Fan, Walk-In Closet
- Level: Main
- Area: 238 Square Feet
- Dimensions: 17 x 14
Bedroom
- Description: Bright Flow Through Windows, Ceiling Fan
- Level: Main
- Area: 156 Square Feet
- Dimensions: 12 x 13
Bedroom
- Description: Huge Walk-In Closet And Bonus Storage Room
- Level: Basement
- Area: 221 Square Feet
- Dimensions: 17 x 13
Bedroom
- Description: 65" Wall Mounted Tv Is Included!
- Level: Basement
- Area: 154 Square Feet
- Dimensions: 14 x 11
Primary bathroom
- Description: Exquisite Tile Shower With Bench Seating
- Level: Main
Bathroom
- Description: Classy Tilework Touch!
- Level: Main
Bathroom
- Description: Awesome Tilework!
- Level: Basement
Bonus room
- Description: Storage Galore!
- Level: Basement
- Area: 65 Square Feet
- Dimensions: 5 x 13
Dining room
- Description: Custom Lighting
- Level: Main
- Area: 160 Square Feet
- Dimensions: 16 x 10
Great room
- Description: Stunning Fireplace With Custom Mantel
- Level: Main
- Area: 225 Square Feet
- Dimensions: 15 x 15
Great room
- Description: Wet Bar, Surround Sound, It's Party Time!
- Level: Basement
- Area: 780 Square Feet
- Dimensions: 30 x 26
Kitchen
- Description: Gourmet Kitchen, Walk-In Pantry
- Level: Main
- Area: 208 Square Feet
- Dimensions: 16 x 13
Laundry
- Description: Convenient Wet Room Location
- Level: Main
Office
- Description: Custom Shelving & Lighting
- Level: Main
- Area: 143 Square Feet
- Dimensions: 11 x 13
Utility room
- Description: More Storage? It Just Keeps Going!
- Level: Basement
- Area: 650 Square Feet
- Dimensions: 25 x 26
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Convection Oven, Dishwasher, Disposal, Microwave, Oven, Range, Range Hood, Refrigerator, Self Cleaning Oven
Features
- Audio/Video Controls, Built-in Features, Ceiling Fan(s), Entrance Foyer, Five Piece Bath, High Ceilings, High Speed Internet, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Quartz Counters, Radon Mitigation System, Smart Thermostat, Smoke Free, Solid Surface Counters, Sound System, Vaulted Ceiling(s), Walk-In Closet(s)
- Flooring: Carpet, Laminate, Tile, Wood
- Windows: Double Pane Windows, Window Coverings
- Basement: Daylight,Finished,Full,Interior Entry,Sump Pump
- Number of fireplaces: 1
- Fireplace features: Electric, Great Room
- Common walls with other units/homes: No Common Walls
Interior area
- Total structure area: 3,684
- Total interior livable area: 3,684 sqft
- Finished area above ground: 1,841
- Finished area below ground: 1,355
Property
Parking
- Total spaces: 4
- Parking features: Concrete, Dry Walled, Exterior Access Door, Insulated Garage, Lighted, Oversized, Oversized Door, Garage Door Opener
- Attached garage spaces: 2
- Details: Off Street Spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Front Porch, Patio
- Exterior features: Private Yard, Rain Gutters, Smart Irrigation
- Has view: Yes
- View description: City, Mountain(s)
Lot
- Size: 6,293 sqft
- Features: Greenbelt, Irrigated, Landscaped, Near Public Transit, Open Space, Sprinklers In Front, Sprinklers In Rear
Details
- Parcel number: 513508
- Zoning: Res
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Frame, Wood Siding
- Foundation: Structural
- Roof: Composition
Condition
- Year built: 2023
Details
- Builder model: Anika / A
- Builder name: Richmond American Homes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected, Internet Access (Wired), Natural Gas Connected
Green energy
- Energy efficient items: Appliances, Construction, Doors, Exposure/Shade, HVAC, Insulation, Lighting, Roof, Thermostat, Water Heater, Windows
Community & neighborhood
Security
- Security features: Carbon Monoxide Detector(s), Security System, Smart Cameras, Smart Security System, Smoke Detector(s), Video Doorbell
Location
- Region: Arvada
- Subdivision: Haskins Station
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $141 quarterly
- Services included: Maintenance Grounds, Recycling, Snow Removal, Trash
- Association name: Haskins Station Metro District (not HOA)
- Association phone: 303-694-4788
Other
Other facts
- Listing terms: Cash,Conventional,FHA,VA Loan
- Ownership: Individual
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 5/27/2025 | Sold | $950,000$258/sqft |
Source: Public Record Report a problem | ||
| 10/28/2024 | Sold | $950,000-9.5%$258/sqft |
Source:  REcolorado as distributed by MLS GRID #8684791 Report a problem | ||
| 10/17/2024 | Pending sale | $1,050,000$285/sqft |
Source: REcolorado as distributed by MLS GRID #8684791 Report a problem | ||
| 9/27/2024 | Price change | $1,050,000-8.7%$285/sqft |
Source: REcolorado as distributed by MLS GRID #8684791 Report a problem | ||
| 8/26/2024 | Listed for sale | $1,150,000+32.2%$312/sqft |
Source: REcolorado as distributed by MLS GRID #8684791 Report a problem | ||
| 10/12/2023 | Sold | $870,000$236/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,809 +309.1% | $55,503 -2.2% |
| 2024 | $2,398 -27.4% | $56,727 +225.1% |
| 2023 | $3,301 +46.4% | $17,450 -12% |
| 2022 | $2,254 +21.3% | $19,819 +50.3% |
| 2021 | $1,859 | $13,183 |
| 2020 | $1,859 | -- |
Find assessor info on the county website
Neighborhood: Skyline
Nearby schools
GreatSchools rating
- 5/10Vanderhoof Elementary SchoolGrades: K-5Distance: 0.6 mi
- 7/10Drake Junior High SchoolGrades: 6-8Distance: 0.9 mi
- 7/10Arvada West High SchoolGrades: 9-12Distance: 1.2 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
$918,100
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
$918,100
- Colorado
- Jefferson County
- Arvada
- 80002
- Skyline
- 5394 Queen Court
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Arvada Topics
