NOT LISTED FOR SALE

Estimated Value: $876,094 - $954,000

5 Beds
3 Baths
3,008 Sq Ft
$306/Sq Ft Est. Value

Sale Details

Date Sold: March 29, 2024

Last sale price $849,000 $282 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $5,445 / mo

43 Days on Market

Highlights

  • Parking available for a boat
  • Barn or Stable
  • Mountain View
  • Berthoud Elementary School Rated A-
  • 2.27 Acre Lot
  • Fireplace in Primary Bedroom

About This Home

As of March 2024

Bring your horses to this desirable horse property in Western Mini Ranches. Features multiple fenced areas and pastures, stalls, hay storage, and loafing shed. This home is a part of an irrigation assoc. that shares 2 1/2 shares of Handy Ditch water. Inside you'll find many upscale amenities. The Gourmet kitchen includes a Sub Zero Refrigerator, Thermador Gas Range and hood, Bosch dishwasher. The large primary bedroom includes a sitting area and luxurious 5-piece bath with jetted tub and double sided fireplace. The fully finished basement has a large family room and rec area, as well as 2 bedrooms, 1 full bath and is plumbed for a wet bar or small kitchen. Quality Pella windows for energy efficiency. The backyard has a large patio and water feature with access from the dining area and primary bdrm. This home provides the county feel and space while still being close to shopping, entertainment, and recreation. Just a few miles away you will find the new TPC golf course and Carter Lake. (Back on Market due to No Fault of Seller - Financing)

Last Agent to Sell the Property

Rob Cieslinski

Resident Realty License #100071663 Listed on: 07/15/2022

Resident Realty

Last Buyer's Agent

Erika Knighton

Equity Colorado-Front Range License #100097122

Equity Colorado-Front Range

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,074

Year Built

  • Built in 1987

Lot Details

  • 2.27 Acre Lot
  • Cul-De-Sac
  • Fenced
  • Sprinkler System
  • Property is zoned FA1

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Driveway Level
  • Parking available for a boat

Home Design

  • Wood Frame Construction
  • Concrete Roof

Interior Spaces

  • 3,008 Sq Ft Home
  • 1-Story Property
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Window Treatments
  • Wood Frame Window
  • Panel Doors
  • Family Room
  • Living Room with Fireplace
  • Mountain Views

Kitchen

  • Gas Oven or Range
  • Self-Cleaning Oven
  • Dishwasher

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • 3 Full Bathrooms
  • Primary bathroom on main floor

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Outdoor Features

  • Deck
  • Patio
  • Outdoor Storage

Schools

  • Berthoud Elementary School
  • Turner Middle School
  • Berthoud 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

  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number R0119652

Community Details

Overview

  • Western Mini Ranches Subdivision

Recreation

  • Hiking Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,074

Year Built

Built in 1987

Lot Details

2.27 Acres

HOA Fees

$8 per month

Parking

2

Listing Details

  • Year Built: 1987
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 2.27
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Western Mini-Ranches
  • Directions: FROM BERTHOUD: West on HWY 56 (CR 8), South on CR 21, West into Western Mini Ranches on Sundown Dr. Go to the end and go South on Sundown Ct. Home at the end of cul-de-sac.
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Building Stories: 1
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 3008
  • Special Features: None
  • Stories: 1

Interior Features

  • Possible Use: Single Family, Farm
  • Private Spa: No
  • Appliances: Gas Range/Oven, Self Cleaning Oven, Dishwasher, Refrigerator
  • Accessibility Features: Level Drive, Main Floor Bath, Main Level Bedroom, Main Level Laundry
  • Has Basement: Partially Finished
  • Full Bathrooms: 3
  • Total Bedrooms: 5
  • Door Features: 6-Panel Doors
  • Fireplace Features: Gas, Living Room, Primary Bedroom
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Walk-In Closet(s)
  • Window Features: Window Coverings, Wood Frames, Double Pane Windows
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Basement
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom3 Level: Main
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Carpet
  • Room Family Room Level: Basement
  • Room Kitchen Features: Wood Floor
  • Family Room Features: Carpet
  • Living Room Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: 5 Piece Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Concrete
  • Fencing: Fenced
  • Lot Features: Lawn Sprinkler System, Cul-De-Sac
  • View: Mountain(s), Foothills View
  • Waterfront: No
  • Construction Type: Wood/Frame
  • Other Structures: Storage
  • Patio And Porch Features: Patio, Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: Garage Door Opener, RV/Boat Parking
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, Pdre Valley REA
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: District Sewer
  • Water Source: District Water, Little Thompson
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • Community Features: Hiking/Biking Trails
  • Senior Community: No
  • Association Fee: 90
  • Association Fee Frequency: Annually
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

  • Elementary School: Berthoud,Ivy Stockwell
  • HighSchool: Berthoud
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Turner

Lot Info

  • Zoning: FA1
  • Horse Amenities: Barn with 1-2 Stalls, Corral(s), Pasture, Tack Room, Loafing Shed, Hay Storage, Riding Trail
  • Lot Size Sq Ft: 98881
  • Parcel #: R0119652
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2021
  • Tax Annual Amount: 5074

Multi Family

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 15, 2022
Closed on
Mar 29, 2024
Sold by
Bought by
Seller's Agent
Rob Cieslinski
Resident Realty
Buyer's Agent
Erika Knighton
Equity Colorado-Front Range
List Price
$849,000
Sold Price
$849,000
Current Estimated Value
$921,524

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$72,524
Avg. Annual Appreciation
3.58%
Original Mortgage
$764,100
Interest Rate
0.0677%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 11, 2011
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000
Interest Rate
0.045%
Mortgage Type
Seller Take Back

Purchase Details

Closed on
Feb 9, 2010
Sold by
Bought by

Purchase Details

Closed on
Jun 4, 2008
Sold by
Bought by

Purchase Details

Closed on
Apr 2, 2004
Sold by
Bought by
Source: Public Records
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$849,000 Land Title
-- None Available
-- None Available
-- None Available
$424,050 --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $771,250
Closed $764,100
Previous Owner $1,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
03/29/2024 03/29/24 Sold $849,000 0.0% $282 / Sq Ft
09/15/2022 09/15/22 Off Market $849,000 -- --
07/15/2022 07/15/22 For Sale $849,000 -- $282 / Sq Ft
Source: IRES MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $4,511 $53,201 $17,188 $36,013
2024 $5,612 $55,818 $18,425 $37,393
2022 $4,970 $43,131 $8,166 $34,965
2021 $5,074 $44,373 $8,401 $35,972
2020 $4,742 $40,505 $8,401 $32,104
2019 $4,691 $40,505 $8,401 $32,104
2018 $4,449 $35,971 $8,460 $27,511
2017 $4,039 $35,971 $8,460 $27,511
2016 $4,002 $34,419 $9,353 $25,066
2015 $3,984 $34,420 $9,350 $25,070
2014 $2,149 $25,800 $9,350 $16,450
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: IRE971157

IRES MLS

APN: 94291-06-009

Your Personal Tour Guide

Ask me questions while you tour the home.