Skip main navigation
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

    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!

    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#: 8684791MLS Logo

    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