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
$950,000
5394 Queen Court, Arvada, CO 80002
4beds
3,684sqft
Single Family Residence
Built in 2023
6,293 Square Feet Lot
$955,400 Zestimate®
$258/sqft
$4,916 Estimated rent
What's special
Zillow last checked: 7 hours ago
Listing updated: October 29, 2024 at 02:06pm
Listed by:
Diana Merrin 303-250-8550 Diana@MileHiHomes.com,
Your Castle Real Estate Inc
Bought with:
Jamie Collins, 100087283
Redfin Corporation
Source: REcolorado,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: 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
Bedroom
- Description: Bright Flow Through Windows, Ceiling Fan
- Level: Main
- Area: 156 Square Feet
- Dimensions: 12 x 13
Primary bathroom
- Description: Exquisite Tile Shower With Bench Seating
- Level: Main
Bathroom
- Description: Classy Tilework Touch!
- Level: Main
Bathroom
- Description: Awesome Tilework!
- Level: Basement
Other
- Description: Convenient Wet Room Location
- Level: Main
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: Wet Bar, Surround Sound, It's Party Time!
- Level: Basement
- Area: 780 Square Feet
- Dimensions: 30 x 26
Great room
- Description: Stunning Fireplace With Custom Mantel
- Level: Main
- Area: 225 Square Feet
- Dimensions: 15 x 15
Kitchen
- Description: Gourmet Kitchen, Walk-In Pantry
- Level: Main
- Area: 208 Square Feet
- Dimensions: 16 x 13
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, Smart Appliances, Sump Pump
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: Shingle,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
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.
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
$955,400