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

$3,800,000

For Sale - Active
16132 Steller Ridge Rd, Loveland, CO 80538
5 Beds
5 Baths
5,725 Square Feet
39.46 Acres Lot
Built in 2021
For Sale - Active
1 Units
Checked: 6 hours ago
Updated: Jun 11, 2025 at 03:24AM

Investment Summary


Monthly Cash Flow
-$13,996
Cap Rate
1.3%
Cash-on-Cash Return
-19.2%
Debt Coverage Ratio
0.22
Internal Rate of Return (5 years)
-14.6%

Property Description


39.46 Acres Lot
Built in 2021
For Sale - Active
1 Units

This is your rare chance to own a truly one-of-a-kind 6801 sq ft mountain modern retreat on 40 private acres with private trail access to Horsetooth Mountain via Lory State Park, which borders the property on two sides. Whether you're seeking a full-time luxury residence, a high-end second home, or an excellent investment, this property delivers turnkey perfection with trusted service providers already in place. Only 12 miles from Fort Collins, with easy access to Boulder, RMNP, and DIA, this amazing home offers seamless luxury in one of Colorado's most iconic landscapes. Just three years old, impeccably designed, and tucked behind the gates of Redstone Canyon and surrounded by Roosevelt National Forest, this home offers views that go on forever, a profound sense of quiet, and nature in every direction. Floor-to-ceiling windows frame dramatic mountain vistas where passing storms and golden sunsets give way to full rainbows in the valley below - a rare, ever-changing display of Colorado's natural beauty. Crafted by the award winning Vertical Arts and Hammersmith Structures, the architecture fuses warm materials like steel, stone, and concrete with soaring ceilings and wide-open sightlines. This is a home built for real living - thoughtful storage, durable materials, zero-maintenance and fire proof exterior finishes, and energy-conscious systems including solar/geothermal prep, EV chargers, heat pumps, and a 5,000-gallon water cistern. The home features a chef's kitchen with commercial appliances, a massive island, and a full outdoor kitchen. Thoughtfully designed living spaces include flexible offices, a spa-like main suite, en suite guest quarters, a bar and game room, home theater, and a reinforced safe room. Outdoors, enjoy private trail access and an oversized garage with EV chargers and optional third car bay. Every detail is handled-just move in and enjoy.

Build Your Team


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

Agents

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

Find an Agent

Lenders

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

Find a Lender

Property Managers

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

Find a Property Manager

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: Garage Door Opener, Heated Garage
  • Details: Heated Garage, Attached
  • Garage Spaces: 3
  • Spaces Total: 3

Bedroom Information

  • # of Bedrooms: 5

Bathroom Information

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

Interior Features

  • # of Rooms: 16
  • # of Stories: 2
  • Basement: Yes
  • Basement Description: Walk-Out Access
  • Fireplace: Yes

Exterior Features

  • Exterior Walls Materials: Wood Siding
  • Roof Type: IRR/Cathedral
  • Roof Material: Metal
  • Solar Panels: Yes

HOA

  • Has HOA: Yes
  • Association: Redstone Canyon Association
  • HOA Fee: $275/annually

Land Information

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

Lot Information

  • Parcel ID: 0723000035
  • Lot Size: 1718756 sqft

Property Information

  • Property Type: Single Family Residence
  • Style: Contemporary
  • Year Built: 2021

Tax Information

  • Annual Tax: $11,495

Utilities

  • Water & Sewer: Private, Well
  • Heating: Hot Water, Radiant, Wood Stove
  • Cooling: Ceiling Fan(s), Central Air

Location

  • County: Larimer

Listing Details


Listed by:
Eric Hansen
Group Mulberry
(970) 342-3018

Source:
REColorado
MLS#: IR1031377
REColorado

Investment Summary


Monthly Cash Flow
-$13,996
Cap Rate
1.3%
Cash-on-Cash Return
-19.2%
Debt Coverage Ratio
0.22
Internal Rate of Return (5 years)
-14.6%

Purchase Details

Find an Agent

Purchase price:
$3,800,000
Amount financed:
-$3,040,000
Down payment:
$760,000
Closing costs:
$114,000
Rehab costs:
$0
Initial cash invested:
$874,000
Square feet:
5,725
Cost per square foot:
$664
Monthly rent per square foot:
$1.26

Financing Details

Find a Lender

Loan amount:
$3,040,000
Loan to value ratio:
80.0%
Loan type:
Amortizing
Term:
30 years
Interest rate:
5.875%
Principal & interest:
$17,983
Property tax:
$958
Insurance:
$504
Private mortgage insurance (PMI):
$0
Monthly payment:
$19,445

Operating Income

Find a Property Manager

% Rent Monthly Yearly
Gross rent:
$7,200 $86,400
Vacancy loss: (6%)
6% -$432 -$5,184
Operating income:
$6,768 $81,216

Operating Expenses


% Rent Monthly Yearly
Property taxes: (13%)
13%-$958-$11,495
Insurance: (7%)
7%-$504-$6,048
Property management: (8%)
8%-$576-$6,912
Repairs & maintenance: (5%)
5%-$360-$4,320
Capital expenditures: (5%)
5%-$360-$4,320
HOA fees: (0%)
0%-$23-$276
Total operating expenses: (39%)
39%-$2,781-$33,371

Cash Flow


Monthly Yearly
Net operating income:
$3,987 $47,844
Mortgage payments:
-$17,983 -$215,796
Cash flow:
$13,996 $167,952