Skip main navigation
For sale
    • Price cut: $10K (4/28)
    $870,000

    5134 Queen Court, Arvada, CO 80002

    4beds
    3,743sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 2024
    5,200 Square Feet Lot
    $861,200 Zestimate®
    $232/sqft
    $47/mo HOA

    What's special

    Discover this stunning 4-bedroom, 3-bath home in one of Arvada’s most desirable neighborhoods. Thoughtfully designed with modern elegance, the open-concept main level features a gorgeous kitchen space with designer cabinets, stainless steel appliances, and a large quartz island—perfect for entertaining and everyday living. The main floor includes two spacious bedrooms, including a beautiful primary suite with a walk-in closet and a luxurious en-suite bathroom, plus a dedicated home office ideal for remote work or creative projects. The walkout basement offers two additional bedrooms and a generous living area, providing plenty of flexibility for guests, recreation, or multi-generational living. Step outside to a custom landscaped backyard with a covered patio, creating a serene retreat for outdoor dining or relaxation. Combining style, comfort, and an unbeatable location, this Arvada home truly has it all.
    108 days
    |
    465
    |
    29
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Jacob Eberle 877-366-2213 boards@lpt.com,

    LPT Realty

    Source: REcolorado as distributed by MLS GRID,MLS#: 5849809MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 3
      • Full bathrooms: 2
      • 3/4 bathrooms: 1
      • Main level bathrooms: 2
      • Main level bedrooms: 2
      Bedroom
      • Level: Main
      Bedroom
      • Level: Main
      Bedroom
      • Level: Basement
      Bedroom
      • Level: Basement
      Bathroom
      • Level: Main
      Bathroom
      • Level: Main
      Bathroom
      • Level: Basement
      Bonus room
      • Level: Basement
      Dining room
      • Level: Main
      Great room
      • Level: Main
      Kitchen
      • Level: Main
      Office
      • Level: Main
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Disposal, Dryer, Microwave, Oven, Range, Range Hood, Refrigerator, Washer
      Features
      • Basement: Finished,Full,Sump Pump,Walk-Out Access
      Interior area
      • Total structure area: 3,743
      • Total interior livable area: 3,743 sqft
      • Finished area above ground: 1,927
      • Finished area below ground: 1,550
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage - Attached
      • Attached garage spaces: 2
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Patio
      Lot
      • Size: 5,200 Square Feet
      • Features: Cul-De-Sac, Landscaped, Sprinklers In Front
      Details
      • Parcel number: 513673
      • Special conditions: Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Frame
      • Roof: Composition
      Condition
      • Updated/Remodeled
      • Year built: 2024
      Details
      • Builder model: Avalon/E
      • Builder name: Richmond American Homes

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Subdivision: Haskins Station
      HOA
      • Has HOA: Yes
      • HOA fee: $142 quarterly
      • HOA name: Haskins Station Metropolitan District
      • HOA phone: 303-858-1800
      Location
      • Region: Arvada

      Financial & listing details

      • Price per square foot: $232/sqft
      • Tax assessed value: $806,080
      • Annual tax amount: $8,803
      • Date on market: 4/2/2026
      • Listing terms: Cash,Conventional,FHA,VA Loan
      • Exclusions: Garage Shelving And Peg Boards, Tv Mounting Hardware, In Ceiling Speakers And Amplifiers, Cameras, Home Networking Equipment, Doorbell, Artwork, Sellers Personal Property
      • Ownership: Individual

        Estimated market value

        $861,200

        $818,000 - $904,000

        $4,461/mo

        Price history

        DateEventPrice
        4/28/2026Price change$870,000-1.1%$232/sqft
        Source: REcolorado as distributed by MLS GRID #5849809 Report a problem
        3/28/2026Listed for sale$880,000+3420%$235/sqft
        Source: REcolorado as distributed by MLS GRID #5849809 Report a problem
        8/12/2024Sold$25,000-96.9%$7/sqft
        Source: Public Record Report a problem
        2/29/2024Sold$799,950$214/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        1/16/2024Pending sale$799,950$214/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        11/27/2023Price change$799,950-3%$214/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        11/17/2023Price change$824,950-4%$220/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        10/31/2023Price change$858,950+1.1%$229/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        10/9/2023Price change$849,950-2.9%$227/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        9/22/2023Price change$874,950-5.4%$234/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        9/12/2023Price change$924,950-2.6%$247/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        9/11/2023Price change$949,950+4.4%$254/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        7/3/2023Pending sale$909,950$243/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        6/19/2023Price change$909,950-2.7%$243/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem
        6/6/2023Listed for sale$934,950$250/sqft
        Source: REcolorado as distributed by MLS GRID #3286715 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$8,803 +93.3%$50,380 -1%
        2024$4,555 +38%$50,911 +94.7%
        2023$3,301 +46.4%$26,149 +31.9%
        2022$2,254 +46.6%$19,819 +50.3%
        2021$1,537 $13,183
        2020$1,537 --
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: Skyline

        Getting around

        29 / 100
        Car-Dependent
        39 / 100
        Some Transit
        31 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        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.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Arvada Topics

                Search
                Updates
                Favorites
                Plan
                Inbox