NOT LISTED FOR SALE

288 Hewlett Gulch Rd Livermore, CO 80536

Estimated Value: $800,000 - $1,061,000

5 Beds
3.5 Baths
2,634 Sq Ft
$352/Sq Ft Est. Value

Last Sold December 21, 2021

Last sale price $960,000 $364 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $5,328/month

17 Days on Market

Highlights

  • Barn or Stable
  • 44.13 Acre Lot
  • Deck
  • Spa
  • Mountain View
  • Wooded Lot

About This Home

As of December 2021

Take a look at this mountain dream home. Custom stone entranceway welcomes you to this mountain home situated on 44 acres adjoining State of Colorado land. This property features a breath-taking view of the Mummy Mountain Range. Perfect horse set-up with a 40' x 48' Cleary barn, 60' round pen, and 60' x 120' outdoor arena. The barn could easily be converted to a large shop for toys. Shop/Barn is insulated with electric waterer and has a separate bathroom. Enjoy hiking, mountain biking, and horseback riding at Eagles Nest Open Space, Mount Margaret and Lady Moon trails, all within 20 minutes of the property. This home is currently a single-family home but could easily be utilized for other opportunities. Please do not drive by property without an agent.

Last Agent to Sell the Property

Celina Rodriguez

The Station Real Estate Listed on: 10/27/2021

Last Buyer's Agent

April Brokhausen

Brokers Guild Homes

Brokers Guild Homes

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,082

Year Built

  • Built in 1996

Lot Details

  • 44.13 Acre Lot
  • Dirt Road
  • South Facing Home
  • Southern Exposure
  • Partially Fenced Property
  • Wood Fence
  • Electric Fence
  • Wire Fence
  • Rock Outcropping
  • Sloped Lot
  • Wooded Lot

Parking

  • 1 Car Attached Garage

Home Design

  • Wood Frame Construction
  • Metal Roof

Interior Spaces

  • 2,634 Sq Ft Home
  • 1.5-Story Property
  • Beamed Ceilings
  • Cathedral Ceiling
  • Ceiling Fan
  • Skylights
  • Fireplace
  • Window Treatments
  • Family Room
  • Home Office
  • Loft
  • Mountain Views
  • Storm Doors

Kitchen

  • Electric Oven or Range
  • Microwave
  • Freezer
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Spa Bath

Laundry

  • Laundry on main level
  • Dryer
  • Washer
  • Sink Near Laundry

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House

Outdoor Features

  • Spa
  • Balcony
  • Deck
  • Patio
  • Separate Outdoor Workshop
  • Outdoor Storage

Schools

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

Farming

  • Pasture

Horse Facilities and Amenities

  • Horses Allowed On Property
  • Tack Room
  • Barn or Stable

Utilities

  • Cooling Available
  • Pellet Stove burns compressed wood to generate heat
  • Radiant Heating System
  • Septic System
  • High Speed Internet
  • Satellite Dish

Community Details

  • No Home Owners Association
  • Hewlett Gulch Subdivision

Listing and Financial Details

  • Assessor Parcel Number R0256137

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,082

Year Built

Built in 1996

Lot Details

0

Parking

1

Listing Details

  • Year Built: 1996
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 44.13
  • Road Frontage Type: Priv Rd up to County Standards
  • Road Surface Type: Dirt
  • Subdivision Name: Hewlett Gulch
  • Directions: Driving Directions: From Livermore drive 10.5 miles west on C.R. 74E (Red Feather Lakes Rd.).Turn left at the top of the hill on Deer Meadow Way. Go 1/4 mile to the Y . Stay left. The property is the third driveway on the left past the Y .
  • Garage Yn: Yes
  • Unit Levels: One and One Half
  • New Construction: No
  • Efficiency: Southern Exposure
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 2634
  • Special Features: None
  • Stories: 0

Interior Features

  • Possible Use: Single Family
  • Spa Features: Bath
  • Private Spa: Yes
  • Appliances: Electric Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave, Freezer, Disposal
  • Has Basement: Full, 90%+ Finished Basement, Walk-Out Access
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Door Features: Storm Door(s)
  • Fireplace Features: Pellet Stove
  • Fireplace: Yes
  • Interior Amenities: Study Area, Satellite Avail, High Speed Internet, Cathedral/Vaulted Ceilings, Pantry, Stain/Natural Trim, Walk-In Closet(s), Loft, Beamed Ceilings
  • Window Features: Window Coverings, Skylight(s)
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Upper
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Laminate Floor
  • Room Kitchen Features: Wood Floor
  • Family Room Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: 5 Piece Primary Bath
  • ResoLivingAreaSource: Other

Exterior Features

  • Roof: Metal
  • Fencing: Partial, Wood, Electric, Wire
  • Lot Features: Wooded, Sloped, Rock Outcropping
  • View: Mountain(s)
  • Waterfront: No
  • Construction Type: Wood/Frame
  • Direction Faces: South
  • Exterior Features: Balcony
  • Other Structures: Workshop, Storage
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 1
  • Garage Spaces: 1
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Ceiling Fan(s)
  • Electric: Electric, Poudre REA
  • Heating: Radiant, 2 or more Heat Sources
  • Utilities: Electricity Available
  • Laundry Features: Sink, Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: Septic
  • Water Source: Well, Cistern

Condo/Co-op/Association

  • Senior Community: No
  • Association: No

Schools

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

Lot Info

  • Zoning: Res
  • Current Use: Horses, Zoning Appropriate for 4+ Horses
  • Horse Amenities: Barn with 3+ Stalls, Pasture, Tack Room
  • Lot Size Sq Ft: 1922303
  • Parcel #: R0256137
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2020
  • Tax Annual Amount: 3082

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 27, 2021
Closed on
Dec 12, 2021
Sold by
Rett Timothy F and Rett Mae Linda
Bought by
Brokhausen Jason A and Brokhausen April L
Seller's Agent
Celina Rodriguez
The Station Real Estate
Buyer's Agent
April Brokhausen
Brokers Guild Homes
List Price
$960,000
Sold Price
$960,000
Current Estimated Value
$927,301

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$32,699
Avg. Annual Appreciation
-0.90%
Original Mortgage
$216,700
Outstanding Balance
$104,760
Interest Rate
2.98%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$822,541

Purchase Details

Closed on
Jul 31, 2006
Sold by
Jung Christoph R
Bought by
Rett Timothy F and Rett Mae Linda

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$339,120
Interest Rate
6.78%
Mortgage Type
Purchase Money Mortgage
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
Brokhausen Jason A $960,000 Chicago Title
Rett Timothy F $423,900 Title America
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Brokhausen Jason A $216,700
Previous Owner Rett Timothy F $339,120
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/21/2022 03/21/22 Off Market $960,000 -- --
12/21/2021 12/21/21 Sold $960,000 0.0% $364 / Sq Ft
10/29/2021 10/29/21 For Sale $960,000 -- $364 / 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 $5,688 $61,493 $10,050 $51,443
2024 $5,419 $61,493 $10,050 $51,443
2022 $3,953 $40,811 $9,383 $31,428
2021 $3,997 $41,985 $9,653 $32,332
2020 $3,082 $32,096 $6,864 $25,232
2019 $3,095 $32,096 $6,864 $25,232
2018 $2,533 $28,267 $5,760 $22,507
2017 $2,524 $28,267 $5,760 $22,507
2016 $2,170 $24,182 $3,980 $20,202
2015 $2,154 $24,180 $3,980 $20,200
2014 $1,972 $22,000 $7,960 $14,040
Source: Public Records

Agents Affiliated with this Home

  • Celina Rodriguez

    Seller's Agent in 2021

    Celina Rodriguez

    The Station Real Estate

    (970) 214-1106

    64 Total Sales

    Celina Rodriguez
    Section Image
  • April Brokhausen

    Buyer's Agent in 2021

    April Brokhausen

    Brokers Guild Homes

    (970) 290-0472

    9 Total Sales

    April Brokhausen
    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 954016

IRES MLS

APN: 19170-00-030

Colorado Larimer County Livermore 80536

288 Hewlett Gulch Rd, Livermore, CO

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

IRES MLS Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.

Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Information deemed reliable but not guaranteed by the MLS.

Nearby Homes