$1,150,000
SOLD MAY 1, 2025

15850 Steller Ridge Rd Loveland, CO 80538

3 Beds
2 Baths
2,645 Sq Ft
39.64 Acres

Recently Sold

$435 Per Sq Ft

34 Days on Market

Highlights

  • Parking available for a boat
  • City View
  • Open Floorplan
  • Horses Allowed On Property
  • 39.64 Acre Lot
  • Fireplace in Primary Bedroom

About This Home

As of May 2025

Nature Lover's Dream in beautiful Redstone Canyon! Custom Architectural 3-bedroom, 2-bath home located on top of the ridge just north of Horsetooth Rock, overlooking Horsetooth Reservoir, Fort Collins, and 50+ miles out over the eastern plains! Enjoy spectacular sunrises, gorgeous afternoon rainbows, and peaceful mountain sunsets. 39+ acres of healthy mountain forest (extensively fire mitigated) and seasonal creek (upper Mill Creek) with multiple waterfalls and pools. A paradise for kids of all ages, complete with multiple ziplines, a full disc golf course, an amazing sledding/ snowboarding/ skiing hill, a great treehouse, and an astonishing variety of wildlife of all kinds. Property backs to Lory State Park with close access to Lory and Horsetooth Open Space trails, and a short drive to Horsetooth Reservoir for watersports. Privately owned off-grid backup solar system with 10.8kW solar, battery backup, and 12kW inverters. 2-Car attached garage plus a separate 960-sqft 4-Car detached garage for spare vehicles, toys, or storage! Plus a finished, insulated/heated, high quality, 2048-sqft workshop with 150A/240VAC service, including a half bath and a 600-sqft private office/ HT room/ rec room/ man cave/ guest room! This stunning property offers the perfect blend of seclusion, recreation, and serenity.

Last Agent to Sell the Property

Beth Edens

Edens Real Estate Listed on: 03/28/2025

Last Buyer's Agent

Jason Levi

Real

Real

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,344

Year Built

  • Built in 1999

Lot Details

  • 39.64 Acre Lot
  • Dirt Road
  • West Facing Home
  • Wood Fence
  • Rock Outcropping
  • Lot Has A Rolling Slope
  • Wooded Lot

HOA Fees

  • $23 Monthly HOA Fees

Parking

  • 8 Car Attached Garage
  • Garage Door Opener
  • Parking available for a boat

Property Views

  • City
  • Mountain

Home Design

  • Contemporary Architecture
  • Pillar, Post or Pier Foundation
  • Wood Frame Construction
  • Composition Roof
  • Cedar

Interior Spaces

  • 2,645 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Multiple Fireplaces
  • Gas Fireplace
  • Double Pane Windows
  • Great Room with Fireplace
  • Crawl Space

Kitchen

  • Gas Oven or Range
  • Freezer
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Main Floor Bedroom
  • Fireplace in Primary Bedroom
  • 2 Full Bathrooms
  • Primary bathroom on main floor
  • Bathtub and Shower Combination in Primary Bathroom

Laundry

  • Laundry on lower level
  • Dryer
  • Washer

Outdoor Features

  • Balcony
  • Deck
  • Outdoor Storage
  • Outbuilding

Schools

  • Big Thompson Elementary School
  • Clark Middle School
  • Thompson Valley High School

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Riding Trail

Utilities

  • Cooling Available
  • Zoned Heating
  • Heating System Uses Wood
  • Baseboard Heating
  • Propane
  • Septic System
  • Satellite Dish

Additional Features

  • Green Energy Fireplace or Wood Stove
  • Property is near a park

Community Details

  • Association fees include management
  • Redstone Canyon Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0239739

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,344

Year Built

Built in 1999

Lot Details

0

HOA Fees

$23 per month

Parking

8

Listing Details

  • Year Built: 1999
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 39.64
  • Road Frontage Type: Priv Rd up to County Standards
  • Road Surface Type: Dirt, Gravel
  • Subdivision Name: Redstone Canyon
  • Directions: From 38E/25E (mailboxes): Head N. on 25E for 2.2 miles to the gate on right side. The sign says "Red Canyon Ranch Road Gate 2" NOTE: GPS is WRONG. GPS will say "Redcliff Rd" -which doesn't exist. Once through the gate, continue on Red Canyon Ranch Road for 2 miles. At the "Y" - Veer right on Goldfinch. Continue on Goldfinch Rd for 1 mile. At the end - turn right onto Steller Ridge Road and property is at the end of the road.
  • Above Grade Finished Sq Ft: 2645
  • Architectural Style: Contemporary/Modern
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Building Stories: 2
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 2645
  • Special Features: VirtualTour
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Freezer, Disposal
  • Accessibility Features: Main Floor Bath, Main Level Bedroom
  • Has Basement: None, Crawl Space
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace Features: 2+ Fireplaces, Gas, Primary Bedroom, Great Room
  • Fireplace: Yes
  • Interior Amenities: Satellite Avail, Open Floorplan
  • Living Area: 2645
  • Window Features: Double Pane Windows
  • Room Bedroom3 Features: Hardwood
  • Dining Room Features: Hardwood
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom3 Area: 165
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 300
  • Room Bedroom3 Level: Main
  • Master Bedroom Master Bedroom Width: 24
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Kitchen Features: Tile Floor
  • Room Kitchen Area: 132
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 696
  • Room Dining Room Area: 195
  • Master Bathroom Features: Full Primary Bath, Tub+Shower Primary, 5 Piece Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Composition
  • Fencing: Fenced, Wood
  • Lot Features: Wooded, Rolling Slope, Sloped, Rock Outcropping, Abuts Park
  • View: Mountain(s), Foothills View, Plains View, City
  • Waterfront: No
  • Construction Type: Wood/Frame, Cedar/Redwood
  • Direction Faces: West
  • Exterior Features: Balcony
  • Foundation Details: Pillar/Post/Pier
  • Other Structures: Storage, Outbuildings
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 8
  • Garage Spaces: 8
  • Parking Features: Garage Door Opener, RV/Boat Parking, Oversized
  • IRESDS_Garage Sq Ft: 604
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Ceiling Fan(s)
  • Heating: Baseboard, Wood Stove, Zoned, 2 or more Heat Sources, Wood/Coal
  • Utilities: Propane
  • Laundry Features: Lower Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: Septic
  • Water Source: Well, Cistern

Condo/Co-op/Association

  • HOA Fee Includes: Management
  • Senior Community: No
  • Association Fee: 275
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Big Thompson
  • HighSchool: Thompson Valley
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Clark (Walt)

Lot Info

  • Zoning: RES
  • Current Use: Horses, Zoning Appropriate for 4+ Horses
  • Horse Amenities: Riding Trail
  • Lot Size Sq Ft: 1726802
  • Parcel #: R0239739
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2023
  • Tax Annual Amount: 6343.99

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 28, 2025
Closed on
May 1, 2025
Sold by
Schuemann Karl E and Schuemann Teresa L
Bought by
Main Douglas Brian and Main Julie Ann
Seller's Agent
Beth Edens
Edens Real Estate
Buyer's Agent
Jason Levi
Real
List Price
$1,150,000
Sold Price
$1,150,000
Views
79
Current Estimated Value
$1,152,547

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$2,547
Avg. Annual Appreciation
0.65%

Purchase Details

Closed on
Oct 26, 2022
Sold by
Schuemann Sonai J
Bought by
Schuemann Teresa L and Schuemann Karl E

Purchase Details

Closed on
Jan 30, 2017
Sold by
Schuemann Karl E and Schuemann Teresa L
Bought by
Schuemann Wilfred C and Schuemann Karl E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
3.57%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 14, 2016
Sold by
Schuemann Wilfred C
Bought by
Schuemann Karl E and Schuemann Teresa L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
3.57%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 14, 2016
Sold by
Schuemann Karl E and Schuemann Teresa L
Bought by
Schuemann Wilfred C and Schuemann Karl E

Purchase Details

Closed on
Aug 26, 2011
Sold by
Soulen Ric and Soulen Julie
Bought by
Schuemann Karl E and Schuemann Teresa L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$417,000
Interest Rate
4.54%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 23, 1998
Sold by
Barker Construction Co Inc
Bought by
Soulen Ric and Soulen Julie
Source: Public Records

Similar Homes in the area

  • 1031 W Us Highway 34, Loveland, CO 80537

    $1,075,000

    • 5 Beds
    • 3 Baths
    • 3,015 Sq Ft
    • 1031 W Us Highway 34
    • Loveland, CO

    Nestled in the scenic Big Thompson Canyon just 15 minutes west of Loveland, Colorado, Nugget Springs is a historic 52-acre estate that blends rich heritage with modern upgrades and unmatched natural beauty. Established in 1922 on the site of an old trapper's cabin, it later became a rustic resort with guest cabins, a restaurant, and a dance hall. The name comes from local legend-after a miner

    John Feeney C3 Real Estate Solutions, LLC

    Section Image
  • 400 Rugged Rock Rd, Loveland, CO 80537

    $1,350,000

    • 5 Beds
    • 6 Baths
    • 4,338 Sq Ft
    • 400 Rugged Rock Rd
    • Loveland, CO

    Offered for the first time by its original owners, this custom-designed 40+ acre estate combines privacy, function, and timeless charm in one of Northern Colorado's most scenic foothill settings. Tucked behind a private gate at the end of Rugged Rock Road, the property offers end-of-road seclusion and sweeping views of the surrounding hillsides between Loveland and Berthoud. The nearly 5,000

    John Feeney C3 Real Estate Solutions LLC

    Section Image
  • 729 Sawmill Rd, Loveland, CO 80537

    $1,295,000

    • 3 Beds
    • 3 Baths
    • 4,372 Sq Ft
    • 729 Sawmill Rd
    • Loveland, CO

    Experience mountain living in this custom-built contemporary home nestled on 35 private acres in the Saddle Notch Ranch area just west of the City of Loveland. Designed for comfort, energy efficiency, and connection to nature, this property offers unmatched views through soaring floor-to-ceiling windows in the expansive great room, showcasing the stunning natural surroundings. Thoughtfully

    John Feeney C3 Real Estate Solutions, LLC

    Section Image
  • 689 Cattle Drive Rd, Loveland, CO 80537

    $1,350,000

    • 3 Beds
    • 2 Baths
    • 1,764 Sq Ft
    • 689 Cattle Drive Rd
    • Loveland, CO

    !!! listed $75,000 below apprised value (instant equity)!!! Exceptional 40-acre equestrian property with stunning Longs Peak views and direct access to Pinewood Reservoir. Watch elk herds migrate through your backyard or enjoy fishing and kayaking steps from your door.Turnkey horse facilities include a 96x40 barn with 10 stalls, 2 foaling stalls, tack room and wash bay. Additional 7-stall barn, 3

    Matthew Fugate The Fugate Property Group

    Section Image
  • 859 Schrage Way, Loveland, CO 80537

    $1,100,000

    • 6 Beds
    • 6 Baths
    • 4,913 Sq Ft
    • 859 Schrage Way
    • Loveland, CO

    2.9% VA Assumable loan....Welcome to wide-open living with front-row views of Colorado's beauty. This Loveland home offers privacy, space, and flexibility to live your best life! Set on 3 acres, this home isn't just big-it's built for living large. With 6 bedrooms, 5 bathrooms, a dedicated office, and a fully finished walkout basement (complete with 3 beds, 2 baths, family room, and a bonus

    Rudy Alcaraz Keller Williams-Advantage Rlty

    Section Image
  • 752 Willow Patch Ln, Bellvue, CO 80512

    $1,195,000

    • 3 Beds
    • 2 Baths
    • 4,054 Sq Ft
    • 752 Willow Patch Ln
    • Bellvue, CO

    Is driving on the crowded roads and city streets an aggravation? Has urban noise, HOA rules and expense become unacceptable? Perhaps it's time to investigate the advantages of living in a more tranquil setting in home on 35 acres in the peaceful Buckhorn Canyon with scenic views of the mountains and prairie, starlit evening skies, with wildlife and hummingbirds for neighbors. Yet, still with easy

    Robert Grotluschen RE/MAX of Boulder, Inc

    Section Image
  • 5801 Norwood Ave, Loveland, CO 80538

    $1,250,000

    • 5 Beds
    • 5 Baths
    • 5,007 Sq Ft
    • 5801 Norwood Ave
    • Loveland, CO

    More than a house - this is a lifestyle. Perched on 4.45 acres with sweeping views of the foothills and Devil's Backbone, this 5,000+ sq ft custom home is a sanctuary for dreamers, artists, adventurers, and anyone who feels connected to nature. Every day here feels like a story worth telling. Sunsets paint the sky, and rainbows span the foothills. Great horned owls perch on the rooftop as deer

    Wynn Washle Group Mulberry

    Section Image
  • 10297 N Forest View Dr, Loveland, CO 80538

    $1,250,000

    • 3 Beds
    • 4 Baths
    • 3,511 Sq Ft
    • 10297 N Forest View Dr
    • Loveland, CO

    First time on the market in over 35 years!This beautifully remodeled 2-story home sits on 75 breathtaking acres that can be divided into two parcels. Bordering Roosevelt National Forest and the Sylvan Dale Guest Ranch Conservation Easement Land, the property offers unmatched privacy, panoramic views, and direct access to endless trails.Inside, you'll find light-filled living spaces, 3 bedrooms,

    Kristine Leoffler Realty One Group Fourpoints

    Section Image
  • 3244 Huckleberry Way, Loveland, CO 80538

    $975,000

    • 5 Beds
    • 3.5 Baths
    • 4,385 Sq Ft
    • 3244 Huckleberry Way
    • Loveland, CO

    Discover your dream home nestled on a 2.15-acre property with breathtaking views of the foothills. Sit on your covered front porch relaxing while looking for elk. Stunning 2-story, 3-car garage, home offers space and touches designed for elegant, comfortable, country living. 5 bedrooms, 4 bath home features a main floor primary suite with five-piece bathroom, walk in closet and back patio access,

    Nanci Garnand Real

    Section Image

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

Purchase History

Date Type Sale Price Title Company
Warranty Deed $1,150,000 Fntc (Fidelity National Title)
Quit Claim Deed -- --
Quit Claim Deed -- --
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- Stewart Title
Interfamily Deed Transfer -- None Available
Warranty Deed $550,000 Heritage Title
Warranty Deed $50,000 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $417,000 New Conventional
Previous Owner $408,000 New Conventional
Previous Owner $417,000 New Conventional
Previous Owner $417,000 Unknown
Previous Owner $50,000 Credit Line Revolving
Previous Owner $375,000 Unknown
Previous Owner $330,000 Unknown
Previous Owner $50,000 Credit Line Revolving
Previous Owner $285,000 Unknown
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/01/2025 05/01/25 Sold $1,150,000 0.0% $435 / Sq Ft
03/28/2025 03/28/25 For Sale $1,150,000 -- $435 / Sq Ft
Source: IRES MLS

Tax History Compared to Growth

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 $6,669 $73,402 $11,501 $61,901
2024 $6,344 $73,402 $11,501 $61,901
2022 $5,129 $54,560 $8,773 $45,787
2021 $5,170 $56,163 $9,059 $47,104
2020 $4,010 $43,183 $1,641 $41,542
2019 $4,029 $43,183 $1,641 $41,542
2018 $3,894 $43,074 $464 $42,610
2017 $3,880 $43,074 $464 $42,610
2016 $3,512 $38,783 $432 $38,351
2015 $3,486 $38,780 $430 $38,350
2014 $2,665 $29,460 $400 $29,060
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 1029659

IRES MLS

APN: 07230-00-037