$4,100,000

16132 Steller Ridge Rd Loveland, CO 80538

Estimated payment $23,865/month

Total Views 1,806
5 Beds
5 Baths
5,725 Sq Ft
$716 Price per Sq Ft

Highlights

  • City View
  • Open Floorplan
  • Contemporary Architecture
  • 39.46 Acre Lot
  • Deck
  • Multiple Fireplaces

About This Home

This is your rare chance to own a truly one-of-a-kind 6801 sq ft mountain modern retreat, complete with a brand new 2025 GMC HUMMER EV, 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.

Listing Agent

Eric Hansen

Group Mulberry

Group Mulberry

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $11,495

Year Built

  • Built in 2021

Lot Details

  • 39.46 Acre Lot
  • Open Space
  • Southern Exposure
  • Rock Outcropping
  • Wooded Lot

HOA Fees

  • $23 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • Garage Door Opener

Property Views

  • City
  • Mountain

Home Design

  • Contemporary Architecture
  • Metal Roof
  • Stucco
  • Cedar
  • Stone

Interior Spaces

  • 5,725 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Bar Fridge
  • Beamed Ceilings
  • Cathedral Ceiling
  • Ceiling Fan
  • Multiple Fireplaces
  • Living Room with Fireplace
  • Dining Room
  • Home Office
  • Wood Flooring
  • Walk-Out Basement

Kitchen

  • Eat-In Kitchen
  • Double Oven
  • Electric Oven or Range
  • Microwave
  • Freezer
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Steam Shower

Laundry

  • Laundry on upper level
  • Dryer
  • Washer

Eco-Friendly Details

  • Green Energy Fireplace or Wood Stove
  • Rough-In for a future solar heating system

Outdoor Features

  • Access to stream, creek or river
  • Balcony
  • Deck
  • Patio
  • Separate Outdoor Workshop
  • Outdoor Gas Grill

Schools

  • Cache La Poudre Elementary And Middle School
  • Poudre High School

Utilities

  • Central Air
  • Radiant Heating System
  • Hot Water Heating System
  • Water Purifier is Owned
  • Septic System
  • High Speed Internet
  • Satellite Dish

Community Details

  • Redstone Canyon Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0239704

Home Details

Home Type

Single Family

Est. Annual Taxes

$11,495

Year Built

Built in 2021

Lot Details

0

HOA Fees

$23 per month

Parking

3

Listing Details

  • Year Built: 2021
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 39.46
  • Subdivision Name: Redstone Canyon
  • Directions: From W County Road 38E- Turn NW onto N Co Rd 25E, then right (E) onto Red Canyon Ranch Road, continue straight (right fork) through the gate onto Goldfinch Rd, at 4 road intersection continue straight up the driveway to property
  • Above Grade Finished Sq Ft: 4061
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Efficiency: Southern Exposure
  • Green Power: Solar Rough-In
  • Building Stories: 2
  • Kitchen Level: Main
  • Special Features: VirtualTour
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Electric Range/Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Microwave, Freezer, Water Purifier Owned, Disposal
  • Has Basement: Partially Finished, Walk-Out Access
  • Full Bathrooms: 1
  • Half Bathrooms: 2
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1766
  • Fireplace Features: 2+ Fireplaces, Living Room
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Satellite Avail, High Speed Internet, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Wet Bar, Kitchen Island, Steam Shower, 9ft+ Ceilings, Beamed Ceilings, Split Bedroom Floor Plan
  • Living Area: 5725
  • Room Bedroom4 Area: 195
  • Room Bedroom3 Features: Wood Floor
  • Dining Room Features: Wood Floor
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 169
  • Room Bedroom4 Features: Wood Floor
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 156
  • Room Bedroom3 Level: Basement
  • Master Bedroom Master Bedroom Width: 15
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Wood Floor
  • Master Bedroom Features: Wood Floor
  • Room Bedroom5 Level: Upper
  • Room Bedroom5 Features: Wood Floor
  • Room Bedroom5 Area: 156
  • Room Kitchen Features: Wood Floor
  • Room Living Room Area: 460
  • Living Room Features: Wood Floor
  • Room Kitchen Area: 391
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 270
  • Room Dining Room Area: 126
  • Master Bathroom Features: Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Metal
  • Lot Features: Irrigation Well Excluded, Wooded, Rock Outcropping, Abuts Public Open Space
  • View: Mountain(s), Foothills View, Plains View, City
  • Waterfront Features: Abuts Stream/Creek/River
  • Waterfront: No
  • Construction Type: Stone, Stucco, Cedar/Redwood, Other
  • Exterior Features: Gas Grill, Balcony
  • Other Structures: Workshop
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, Heated Garage
  • IRESDS_Garage Sq Ft: 912
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Room Air Conditioner, Ceiling Fan(s)
  • Electric: Electric, PVREA
  • Heating: Hot Water, Wood Stove, Radiant, 2 or more Heat Sources
  • Utilities: Electricity Available
  • Laundry Features: Washer/Dryer Hookups, Upper Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: Septic, Septic Field
  • Water Source: Well

Condo/Co-op/Association

  • Senior Community: No
  • Association Fee: 275
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Cache La Poudre
  • HighSchool: Poudre
  • Junior High Dist: Poudre
  • Middle Or Junior School: Cache La Poudre

Lot Info

  • Zoning: O
  • Lot Size Sq Ft: 1718756
  • Parcel #: R0239704
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 11495

Multi Family

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $10,936 $123,868 $11,509 $112,359
2024 $10,936 $123,868 $11,509 $112,359
2022 $4,907 $52,205 $8,781 $43,424
2021 $1,887 $20,504 $9,064 $11,440
2020 $1,160 $12,493 $1,053 $11,440
2019 $45 $479 $479 $0
2018 $41 $458 $458 $0
2017 $41 $458 $458 $0
2016 $39 $432 $432 $0
2015 $39 $430 $430 $0
2014 $36 $400 $400 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/17/2025 04/17/25 For Sale $4,100,000 +1852.4% $716 / Sq Ft
01/28/2019 01/28/19 Off Market $210,000 -- --
03/03/2017 03/03/17 Sold $210,000 0.0% --
02/01/2017 02/01/17 Pending -- -- --
03/17/2016 03/17/16 For Sale $210,000 -- --
Source: IRES MLS

Deed History

Date Type Sale Price Title Company
Warranty Deed $210,000 Land Title Guarantee Company
Interfamily Deed Transfer -- None Available
Warranty Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $2,300,000 Construction
Source: Public Records

Similar Homes in the area

  • 3379 Danzante Bay Ct, Berthoud, CO 80513

    $3,300,000

    • 5 Beds
    • 6 Baths
    • 6,658 Sq Ft
    • 3379 Danzante Bay Ct
    • Berthoud, CO

    Welcome to this one-of-a-kind custom home in the prestigious TPC Colorado at Heron Lakes community. Designed to showcase breathtaking mountain views at the base of the Colorado Rockies, this home offers a perfect blend of elegance, comfort, and natural beauty. Step inside to a spacious open floor plan with soaring beamed ceilings and a seamless mix of timeless elegance and modern design. The

    Shavonn Janes The Janes Group

    Section Image
  • 2554 Southwind Rd, Berthoud, CO 80513

    $3,999,500

    • 5 Beds
    • 5.5 Baths
    • 6,669 Sq Ft
    • 2554 Southwind Rd
    • Berthoud, CO

    Experience the zenith of luxury living in this visionary masterpiece meticulously crafted by Lifestyle Custom Homes, Ed Rust. This two-story haven epitomizes modern luxury living, boasting an array of meticulously curated features. The main level offers an inviting space characterized by seamless transitions between rooms and an unmissable grandeur in every detail. The upper floor extends this

    Melissa Doherty Luxury Homes LLC

    Section Image
  • 2664 Southwind Rd, Berthoud, CO 80513

    $3,195,000

    • 4 Beds
    • 4.5 Baths
    • 5,219 Sq Ft
    • 2664 Southwind Rd
    • Berthoud, CO

    Welcome to the Luxury Lifestyle of your Dreams in the gated Rookery enclave of Heron Lakes at TPC Colorado. Amazing location, waterfront property backing to Welch Reservoir with access to Lonetree Reservoir and TPC Golf Course. Experience the meticulous artisanship of RF Home Designs. Offering a unique opportunity to own a modern luxury home designed with contemporary architecture and high-end

    Kathryn Ann Shea C3 Real Estate Solutions, LLC

    Section Image
  • 27132 Coyote Ridge Ln, Johnstown, CO 80534

    $3,390,000

    • 5 Beds
    • 6 Baths
    • 7,684 Sq Ft
    • 27132 Coyote Ridge Ln
    • Johnstown, CO

    Experience luxurious, peaceful living in this stunning 5-bedroom, 6-bathroom home on the corner lot of the gorgeous Coyote Ridge Lane. The private gated entrance and the beautiful tree-lined driveway adds to the homes privacy. On 14.9 acres, this home boasts unhindered mountain views with the ability to have horses, cattle and an outbuilding. The gourmet kitchen features top-of-the-line

    Kerina Zysling New Horizons & Associates

    Section Image

Source: IRES MLS

MLS Number: 1031377

IRES MLS

APN: 07230-00-035