Mountain Homes Realty
Enter City, Zip or MLS

5195 queen ct

Arvada, CO 80002

$615,000

2 BEDS 3 BATHS
1,840 SQFT0.03 AC LOT
Residential - Single Family
Price Changed
Image 1
Image 2
Image 3
Image 4
Bedrooms 2
Total Baths 3
Full Baths 2
Square Feet 1840
Acreage 0.04
Status Active
MLS # 5679645
County Jefferson
More Info
Category Residential - Single Family
Status Active
Square Feet 1840
Acreage 0.04
MLS # 5679645
County Jefferson
Listed By: Listing Agent Veronica Trotta
Real Broker, LLC DBA Real - (954) 681-3755
Elevated living in one of Arvada's most sought-after new home communities. This stunning 4-level single family home, built in 2024, offers thoughtful design and jaw-dropping views that rarely come together in one address. Step outside to your private rooftop deck and take in panoramic views of downtown Denver and the Rocky Mountains, the perfect backdrop for morning coffee, sunset cocktails, or weekend entertaining under Colorado's famous blue skies. Each level has a purpose. A dedicated home office sits just off the entrance, ideal for greeting clients or working from home. Upstairs, an open-concept living room, kitchen, and second built-in office create a bright, functional hub, along with a massive walk-in pantry offering rare storage. Bedrooms enjoy their own private level, separating rest from the rest of the home. Set on a desirable corner lot, this property offers extra outdoor space and enhanced curb appeal. This home sits inside the vibrant Haskins Station community, where new construction meets an unbeatable commuter and lifestyle location. Enjoy walking distance to the light rail for an easy commute without fighting Denver traffic, and just 8 miles (about 15 to 20 minutes) to downtown Denver, close enough for city access, far enough to skip the hustle and bustle. Minutes from Olde Town Arvada, you'll find local bars, restaurants, breweries, and shops. I-70 is 3 minutes away for easy mountain getaways, and downtown Golden is under 15 minutes out. Community amenities include walking trails, parks, and playgrounds with sweeping views of the Flatirons. Whether commuting downtown, working from home, or unwinding on your rooftop deck, this Haskins Station gem offers the best of Colorado living in one exceptional new home.
Location not available
Listing
Street
Satellite

Exterior Features

  • Construction Single Family Residence
  • Siding Frame
  • Exterior Sprinkler System, Balcony
  • Roof Composition, Fiberglass
  • Garage Yes
  • Garage Description Attached
  • Water City
  • Sewer Public Sewer
  • Lot Description Corner Lot, House Faces East, Paved

Interior Features

  • Appliances Dishwasher, Refrigerator, Washer, Dryer, Microwave, Gas Bar-B-Q, Disposal, Fire Alarm
  • Heating Forced Air
  • Cooling Central Air, Ceiling Fan(s)
  • Basement Built-In Radon
  • Living Area 1,840 SQFT
  • Year Built 2024
  • Stories Three Or More

Neighborhood & Schools

  • Subdivision Haskins Station
  • School Disrict Jefferson Dist R-1
  • Elementary School Vanderhoof
  • Middle School Drake
  • High School Arvada West

Financial Information

  • Zoning Residential

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Real Broker, LLC DBA Real - (954) 681-3755
Listings provided courtesy of the IRESDS MLS as distributed by MLS GRID.

Information is deemed reliable but is not guaranteed by MLS GRID, and that the use of the MLS GRID Data may be subject to an end user license agreement prescribed by the Member Participant's applicable MLS if any and as amended from time to time. MLS GRID may, at its discretion, require use of other disclaimers as necessary to protect Member Participant, and/or their MLS from liability.

Based on information submitted to the MLS GRID as of 08/04/2026 03:48:05 UTC. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA") provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices must be sent in writing by email to DMCAnotice@MLSGrid.com.

The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and email address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.

© 2026 IRESDS MLS, Inc.
Listing data is current as of 08/04/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.