Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
Copied
Photo
Copied
Photo
Photo
Photo
Photo
See all photos

$1,890,000

For Sale - Active
8280 Queen St, Arvada, CO 80005
5 Beds
5 Baths
8,078 Square Feet
1.68 Acres Lot
Built in 1964
For Sale - Active
1 Units
Checked: 13 hours ago
Updated: Aug 24, 2025 at 10:09AM

Investment Summary


Monthly Cash Flow
-$4,649
Cap Rate
2.7%
Cash-on-Cash Return
-12.8%
Debt Coverage Ratio
0.48
Internal Rate of Return (5 years)
-8.4%

Property Description


1.68 Acres Lot
Built in 1964
For Sale - Active
1 Units

Welcome to Your Private Tropical Oasis.This extraordinary custom-built home offers 8,078 square feet of unparalleled luxury, nestled on a sprawling 1.68-acre horse property.Designed with no detail spared, this home includes a large 2-story barn/outbuilding and the space to accommodate up to 3 horses.This building also includes a large loft area.Surrounded by mature pine trees, you'll enjoy total privacy, with a sweeping wrap around deck that encompasses the entire back of the home.Step outside to your own paradise—relax in the hot tub, gather around the fire pit, or hang out on the numerous deck areas and enjoy the mountain views. Inside, the home is a masterpiece of design & comfort.The chef’s kitchen is a culinary dream, featuring a massive granite island with sink, dual Sub-Zero refrigerators, Jenn-Air convection oven, warming drawers, ice maker, 2 Bosch dishwashers, 2 additional sinks and top-tier appliances including a Gaggeneau convection oven and an electric steamer.Custom cabinetry with under cabinet lighting, radiant heated floors, & a huge custom made pantry with five lazy Susans complete the space.The home also boasts bamboo flooring, a fully integrated audio system with Klipsch speakers, custom lighting, and Pella windows with skylights that flood the interior with natural light.Unwind in the stunning sunroom with its interior garden and water feature, or retreat to your Primary suite where Koi fish glide through the room.The Primary bath features a gas fireplace, jetted tub with infinite hot water, a steam shower, and an expansive cedar walk-in closet.For fitness enthusiasts, a large workout room with floor-to-ceiling mirrors awaits, alongside a full spa complete with a indoor 9-foot-deep custom saltwater pool, & fiber-optic lighting.A luxurious steam room, crafted from custom stone, is equipped with three steam generators.This is truly a once-in-a-lifetime opportunity to own a slice of paradise, all while being minutes from town. Truly an amazing home!

Build Your Team


Quickly find investor-friendly professionals who can help you succeed in real estate investing at any stage of the investing journey.

Avatar
Avatar
Avatar

Agents

Match with investor-friendly agents who can help you find, analyze, and close your next deal

Find an Agent
Avatar
Avatar
Avatar

Lenders

Get the best funding…find investor-friendly lenders who specialize in your deal strategy

Find a Lender
Avatar
Avatar
Avatar

Property Managers

Transition to passive investing. Find a trusted property management partnership that lasts.

Find a Property Manager
Avatar
Avatar
Avatar

Tax Pros & Accountants

Taxes and financial reporting made easy—find experts to create tax savings strategies, file taxes, and more

Find a Tax Pro

Location


Property Details


Parking

  • Description: Attached Garage
  • Details: Oversized, Attached
  • Garage Spaces: 2
  • Spaces Total: 2

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

  • # of Baths (Full): 2
  • # of Baths (Total): 5.0

Interior Features

  • # of Rooms: 18
  • Basement: Yes
  • Basement Description: Partial, Walk-Out Access
  • Fireplace: Yes

Exterior Features

  • Roof Material: Composition, Concrete
  • Pool: Yes

HOA

  • Has HOA: Yes
  • Association: Meadowgate Farms Home Owners
  • HOA Fee: $200/annually

Land Information

  • Land Use: Residential
  • Land Use Subtype: Single Family Residential

Lot Information

  • Parcel ID: 2928301006
  • Lot Size: 73180 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Mid-Century Modern
  • Year Built: 1964

Tax Information

  • Annual Tax: $8,703

Utilities

  • Water & Sewer: Public
  • Heating: Forced Air, Hot Water, Radiant
  • Cooling: Ceiling Fan(s), Central Air

Location

  • County: Jefferson

Listing Details


Listed by:
Ricky Harr
HomeSmart Realty
(303) 506-3600

Source:
REColorado
MLS#: 5185518
REColorado

Investment Summary


Monthly Cash Flow
-$4,649
Cap Rate
2.7%
Cash-on-Cash Return
-12.8%
Debt Coverage Ratio
0.48
Internal Rate of Return (5 years)
-8.4%

Purchase Details

Find an Agent

Purchase price:
$1,890,000
Amount financed:
-$1,512,000
Down payment:
$378,000
Closing costs:
$56,700
Rehab costs:
$0
Initial cash invested:
$434,700
Square feet:
8,078
Cost per square foot:
$234
Monthly rent per square foot:
$0.90

Financing Details

Find a Lender

Loan amount:
$1,512,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$8,944
Property tax:
$725
Insurance:
$511
Private mortgage insurance (PMI):
$0
Monthly payment:
$10,180

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$7,300 $87,600
Vacancy loss: (6%)
6% -$438 -$5,256
Operating income:
$6,862 $82,344

Operating Expenses


% Rent Monthly Yearly
Property taxes: (10%)
10%-$725-$8,703
Insurance: (7%)
7%-$511-$6,132
Property management: (8%)
8%-$584-$7,008
Repairs & maintenance: (5%)
5%-$365-$4,380
Capital expenditures: (5%)
5%-$365-$4,380
HOA fees: (0%)
0%-$17-$204
Total operating expenses: (35%)
35%-$2,567-$30,807

Cash Flow


Monthly Yearly
Net operating income:
$4,295 $51,540
Mortgage payments:
-$8,944 -$107,328
Cash flow:
$4,649 $55,788