NOT LISTED FOR SALE

9800 W Us Highway 34 Loveland, CO 80537

Estimated Value: $2,380,000

3 Beds
4 Baths
8,734 Sq Ft
$272/Sq Ft Est. Value

Last Sold January 12, 2023

Last sale price $16,000,000 $1,832 Per Sq Ft

Current estimated payment $13,144/month

14 Days on Market

Highlights

  • Parking available for a boat
  • Barn or Stable
  • City View
  • Big Thompson Elementary School Rated A-
  • Private Pool
  • 1,547 Acre Lot

About This Home

As of January 2023

Never listed before in its entirety is Heaven's Door Ranch! Located just west of Downtown Loveland and off of Highway 34, the gateway to Estes Park and Rocky Mountain National Park, is this 1,547 acre ranch consisting of 15 parcels and featuring 100 shares of highly desirable C-BT Water! The private gated access with 1 mile of new asphalt driveway takes you to the centrally located 8734 sq ft home which includes both a large heated indoor and scenic outdoor swimming pool, large owner's suite, and a primary kitchen as well as a caretaker kitchen. Rustic upstairs loft also includes its own private bath and kitchen as well! Separate guest house on East side of the property overlooks the City of Loveland. There's a rustic cabin on the west side of property with adventurous 4x4 access. Plenty of parking including a 2-car oversized detached garage. For the horse lovers there's the attached 1131 sq ft heated 4 stall horse barn, riding pen, loafing sheds, abundant pastures, and your own private riding trails to explore! There's even an additional bunkhouse and greenhouse as well. Tour this amazing property by appointment only. Call for your private showing today!

Last Agent to Sell the Property

John Feeney

C3 Real Estate Solutions, LLC Listed on: 08/19/2022

C3 Real Estate Solutions, LLC

Co-Listed By

John Simmons

C3 Real Estate Solutions, LLC

Last Buyer's Agent

John Feeney

C3 Real Estate Solutions, LLC Listed on: 08/19/2022

C3 Real Estate Solutions, LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,496

Year Built

  • Built in 1996

Lot Details

  • 1,547 Acre Lot
  • Property fronts a highway
  • Open Space
  • Unincorporated Location
  • Southern Exposure
  • Partially Fenced Property
  • Wood Fence
  • Chain Link Fence
  • Wire Fence
  • Rock Outcropping
  • Level Lot
  • Sprinkler System
  • Meadow
  • Wooded Lot
  • Property is zoned RR2

Parking

  • 2 Car Detached Garage
  • Oversized Parking
  • Driveway Level
  • Parking available for a boat

Home Design

  • 1.5-Story Property
  • Farmhouse Style Home
  • Cabin
  • Wood Frame Construction
  • Composition Roof
  • Wood Siding

Interior Spaces

  • 8,734 Sq Ft Home
  • Open Floorplan
  • Beamed Ceilings
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Multiple Fireplaces
  • Gas Log Fireplace
  • Double Pane Windows
  • Window Treatments
  • French Doors
  • Living Room with Fireplace
  • Dining Room
  • Recreation Room with Fireplace
  • Sun or Florida Room
  • City Views

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Microwave
  • Freezer
  • Dishwasher
  • Disposal
  • Fireplace in Kitchen

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • In-Law or Guest Suite
  • Primary bathroom on main floor
  • Bathtub and Shower Combination in Primary Bathroom
  • Walk-in Shower

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Pool

  • Private Pool
  • Spa

Outdoor Features

  • Access to stream, creek or river
  • Balcony
  • Deck
  • Enclosed Patio or Porch
  • Separate Outdoor Workshop
  • Outdoor Storage
  • Outbuilding

Schools

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

Farming

  • Loafing Shed
  • Pasture

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Corral
  • Tack Room
  • Hay Storage
  • Barn or Stable
  • Riding Trail

Utilities

  • Zoned Heating and Cooling System
  • Radiant Heating System
  • Baseboard Heating
  • Propane
  • Water Rights
  • Septic System
  • Satellite Dish

Additional Features

  • Energy-Efficient Thermostat
  • Near Farm

Community Details

  • No Home Owners Association
  • Heaven's Door Ranch Subdivision
  • Near a National Forest

Listing and Financial Details

  • Assessor Parcel Number R1434667

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,496

Year Built

Built in 1996

Lot Details

0

Parking

2

Listing Details

  • Year Built: 1996
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 1547
  • Road Frontage Type: Highway
  • Road Surface Type: Paved, Asphalt
  • Co List Office Mls Id: JCSRE
  • Subdivision Name: Heaven's Door Ranch
  • Directions: From Central Loveland head west approximately 8.5 miles on US Highway 34. The gated entrance and driveway will be on your left. All access is by appointment only. Absolutely no trespassing.
  • Architectural Style: Farm House, Cabin, Ranch
  • Garage Yn: Yes
  • Unit Levels: One, One and One Half
  • New Construction: No
  • Efficiency: Southern Exposure, Thermostat
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: Yes
  • IRESDS_Total Sq Ft: 8734
  • Special Features: None
  • Stories: 0

Interior Features

  • Possible Use: Single Family, Farm
  • Private Spa: Yes
  • Appliances: 2 or more H20 Heaters, Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Freezer, Disposal
  • Accessibility Features: Level Lot, Level Drive, Main Floor Bath, Main Level Bedroom, Stall Shower, Main Level Laundry
  • Has Basement: None
  • Full Bathrooms: 3
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 3
  • Door Features: French Doors
  • Fireplace Features: 2+ Fireplaces, Gas, Gas Logs Included, Living Room, Family/Recreation Room Fireplace, Kitchen
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: In-Law Floorplan, Satellite Avail, Eat-in Kitchen, Separate Dining Room, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), 9ft+ Ceilings, Beamed Ceilings, Sun Space
  • Window Features: Window Coverings, Skylight(s), Double Pane Windows
  • Room Bedroom3 Features: Wood Floor
  • Dining Room Features: Tile Floor
  • IRESDS_HasFamilyRoom: No
  • Living Room Living Room Level: Main
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Wood Floor
  • Room Kitchen Features: Tile Floor
  • Living Room Features: Tile Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Full Primary Bath, Tub+Shower Primary, Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Composition
  • Fencing: Partial, Fenced, Wood, Chain Link, Other, Wire
  • Lot Features: Lawn Sprinkler System, Water Rights Included, Wooded, Level, Rolling Slope, Sloped, Steep Slope, Rock Outcropping, Abuts Ditch, Abuts Farm Land, Abuts National Forest, Abuts Private Open Space, Meadow, Unincorporated
  • Pool Features: Private
  • Pool Private: Yes
  • View: Foothills View, Plains View, City
  • Waterfront Features: Abuts Stream/Creek/River
  • Waterfront: No
  • Construction Type: Wood/Frame, Wood Siding
  • Direction Faces: East,West
  • Exterior Features: Balcony
  • Other Structures: Workshop, Storage, Outbuildings
  • Patio And Porch Features: Patio, Deck, Enclosed
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: No
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: RV/Boat Parking, Oversized
  • IRESDS_GarageType: Detached

Utilities

  • Cooling: Central Air, Room Air Conditioner, Ceiling Fan(s)
  • Electric: Electric, PV REA
  • Heating: Baseboard, Zoned, Radiant, 2 or more Heat Sources
  • Utilities: Electricity Available, Propane
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: Septic
  • Water Source: Well, Private Well

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

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

Lot Info

  • Zoning: RR2
  • Current Use: Horses, Zoning Appropriate for 1 Horse, Zoning Appropriate for 2 Horses, Zoning Appropriate for 3 Horses, Zoning Appropriate for 4+ Horses
  • Horse Amenities: Barn with 1-2 Stalls, Barn with 3+ Stalls, Corral(s), Pasture, Tack Room, Loafing Shed, Hay Storage, Riding Trail
  • Lot Size Sq Ft: 67387320
  • Parcel #: R1434667
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2021

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 1, 1995
Sold by
Rubin Susan M By Aif
Bought by
1455 Loveland Ranch Llc
Current Estimated Value
$2,380,000

Purchase Details

Closed on
Nov 1, 1994
Sold by
Maitland Ruth V By Thomas Mcc Aif
Bought by
Geltner Jo M
Source: Public Records

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 Buyer Sale Price Title Company
1455 Loveland Ranch Llc $1,550,000 --
Geltner Jo M -- --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/12/2023 01/12/23 Sold $16,000,000 -11.1% $1,832 / Sq Ft
09/02/2022 09/02/22 Pending -- -- --
08/19/2022 08/19/22 For Sale $18,000,000 -- $2,061 / 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 $7,496 $9,434 $9,434 --
2024 $7,496 $80,106 $9,434 $70,672
2022 $7,496 $88,081 $9,782 $78,299
2021 $7,881 $85,864 $10,067 $75,797
2020 $9,445 $106,149 $10,067 $96,082
2019 $9,275 $106,149 $10,067 $96,082
2018 $8,228 $88,366 $10,138 $78,228
2017 $7,192 $88,366 $10,138 $78,228
2016 $6,604 $81,352 $11,208 $70,144
2015 $6,285 $81,350 $11,210 $70,140
2014 $6,081 $76,400 $11,210 $65,190
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 973703

IRES MLS

APN: 05150-00-910