Skip main navigation
Sold
  • $958,950

    5174 Queen Court, Arvada, CO 80002

    4beds
    3,894sqft
    Single Family Residence
    Built in 2023
    5,200 Square Feet Lot
    $969,900 Zestimate®
    $246/sqft
    $4,725 Estimated rent

    What's special

    **!!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.

    Zillow last checked: 7 hours ago

    Listing updated: February 21, 2024 at 02:20pm

    Listed by:

    Matthew Tonge 303-850-5757,

    Richmond Realty Inc

    Bought with:

    Amy Mancini, 100089121

    LIV Sotheby's International Realty

    Source: REcolorado,MLS#: 8517139MLS Logo

    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 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
    Bedroom
    • Description: Bedroom 2
    • Level: Upper
    • Area: 110 Square Feet
    • Dimensions: 11 x 10
    Primary bathroom
    • Description: En Suite: Dual Sinks
    • Level: Upper
    Bathroom
    • Description: Dual Sinks
    • Level: Upper
    Bathroom
    • Level: Basement
    Bathroom
    • Level: Main
    Other
    • Level: Main
    Bonus room
    • Description: Flex Room
    • Level: Main
    • Area: 165 Square Feet
    • Dimensions: 15 x 11
    Bonus room
    • Description: Extension Of Rec Room
    • Level: Basement
    • Area: 130 Square Feet
    • Dimensions: 10 x 13
    Bonus room
    • Description: Rec Room
    • Level: Basement
    • Area: 390 Square Feet
    • Dimensions: 15 x 26
    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
    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 sqft
    • 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: Shingle,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 & neighborhood

    Location
    • Region: Arvada
    • Subdivision: Haskins Station

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $47 monthly
    • Association name: White Bear, Ankele Tanaka & Waldron, Attorneys at
    • Association phone: 303-858-1800

    Other

    Other facts
    • Listing terms: Cash,Conventional,FHA,VA Loan
    • Ownership: Builder
    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

    $969,900