NOT LISTED FOR SALE

5519 Foothills Dr Berthoud, CO 80513

Estimated Value: $948,195 - $1,077,000

6 Beds
3.5 Baths
3,528 Sq Ft
$288/Sq Ft Est. Value

Sale Details

Date Sold: May 22, 2015

Last sale price $475,365 $135 Per Sq Ft

Est. 114% increase in value since last sale

Current estimated payment $6,001 / mo

5 Days on Market

Highlights

  • Horses Allowed On Property
  • Open Floorplan
  • Deck
  • Berthoud Elementary School Rated A-
  • Fireplace in Primary Bedroom
  • Contemporary Architecture

About This Home

As of May 2015

Wow! Great location. End of road privacy, foothills views, trails off your backyard, move-in ready, and an unbelievable house for the money. Grab it before someone beats you to it! HOA includes trash pickup, sewer, roads, and common areas.

Last Agent to Sell the Property

Amy Scantlin

Keller Williams Realty NoCo Listed on: 03/26/2015

Last Buyer's Agent

Kelli Couch

Group Centerra License #40023042

Group Centerra

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $2,381

Year Built

  • Built in 1996

Lot Details

  • 2.16 Acre Lot
  • Open Space
  • Partially Fenced Property
  • Sprinkler System
  • Property is zoned FA1

HOA Fees

  • $100 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Wood Frame Construction

Interior Spaces

  • 3,528 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Ceiling Fan
  • Multiple Fireplaces
  • Double Sided Fireplace
  • Gas Fireplace
  • Window Treatments
  • Family Room
  • Living Room with Fireplace
  • Dining Room
  • Recreation Room with Fireplace
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

  • Gas Oven or Range
  • Microwave
  • Dishwasher

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Deck
  • Outdoor Storage

Schools

  • Berthoud Elementary School
  • Turner Middle School
  • Berthoud High School

Additional Features

  • Loafing Shed
  • Horses Allowed On Property
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number R1416642

Community Details

Overview

  • Association fees include trash, snow removal
  • Foothills Estates Subdivision

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,381

Year Built

Built in 1996

Lot Details

2.16 Acres

HOA Fees

$100 per month

Parking

3

Listing Details

  • Year Built: 1996
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: Yes
  • Lot Size Acres: 2.16
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Foothills Estates
  • Directions: From Hwy 287 and County Road 4: head west on CR 4 (aka Wagonwheel Rd). Turn right (north) on CR 23E. Left on Foothills Dr. Follow Foothills Drive to the end - house will be on left
  • 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: 3528
  • Special Features: None
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Washer, Dryer, Microwave
  • Has Basement: Full, 90%+ Finished Basement
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Fireplace Features: 2+ Fireplaces, Gas, Double Sided, Living Room, Family/Recreation Room Fireplace, Primary Bedroom
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Separate Dining Room, Open Floorplan
  • Window Features: Window Coverings
  • Bedroom Features: Carpet
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: Yes
  • Room Bedroom4 Level: Upper
  • Living Room Living Room Level: Main
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom3 Level: Upper
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Carpet
  • Room Kitchen Features: Wood Floor
  • Family Room Features: Wood Floor
  • Living Room Features: Wood Floor
  • Dining Room Dining Room Level: Main
  • Master Bathroom Features: Full Primary Bath
  • ResoLivingAreaSource: Assessor

Exterior Features

  • Roof: Other
  • Fencing: Partial
  • Lot Features: Lawn Sprinkler System, Abuts Private Open Space
  • View: Foothills View
  • Waterfront: No
  • Construction Type: Wood/Frame
  • Other Structures: Storage
  • Patio And Porch Features: Deck
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Oversized
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric
  • Heating: Forced Air
  • Utilities: Natural Gas Available, Electricity Available
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: District Sewer
  • Water Source: District Water, Big Thompson
  • Gas Company: Natural Gas

Condo/Co-op/Association

  • HOA Fee Includes: Trash, Snow Removal
  • Community Features: Park
  • Senior Community: No
  • Association Fee: 100
  • Association Fee Frequency: Monthly
  • Association: Yes

Association/Amenities

  • IRESDS_HasAssociationReserve: Yes
  • IRESDS_HasAssociationFee: Yes

Schools

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

Lot Info

  • Zoning: FA1
  • Current Use: Horses
  • Horse Amenities: Loafing Shed
  • Lot Size Sq Ft: 94090
  • Parcel #: R1416642
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2014
  • Tax Annual Amount: 2381

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 26, 2015
Closed on
May 22, 2015
Sold by
Lint Angie
Bought by
Schnell Kyle A and Schnell Megan M
Seller's Agent
Amy Scantlin
Keller Williams Realty NoCo
Buyer's Agent
Kelli Couch
Group Centerra
List Price
$452,900
Sold Price
$475,365
Premium/Discount to List
$22,465
4.96%
Current Estimated Value
$1,017,299

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$541,934
Avg. Annual Appreciation
7.18%
Original Mortgage
$380,284
Outstanding Balance
$292,957
Interest Rate
3.68%
Mortgage Type
New Conventional
Estimated Equity
$724,342

Purchase Details

Closed on
Jul 24, 2013
Sold by
Lint Brian
Bought by
Lint Angie

Home Financials for this Owner

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

Purchase Details

Listed on
Mar 29, 2012
Closed on
May 18, 2012
Sold by
Beckmann Edward M and Beckmann Christi S
Bought by
Lint Angie and Lint Brian
Seller's Agent
Jared English
Congress Realty
Buyer's Agent
Amy Scantlin
Keller Williams Realty NoCo
List Price
$430,000
Sold Price
$412,000
Premium/Discount to List
-$18,000
-4.19%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.68%
Original Mortgage
$329,600
Interest Rate
3.75%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 26, 2003
Sold by
Lowe Christopher A and Lowe Angela R
Bought by
Beckmann Edward M and Beckmann Christi S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$188,000
Interest Rate
5.93%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 3, 1999
Sold by
Long Beach Mtg Company
Bought by
Lowe Christopher A and Lowe Angela R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$211,000
Interest Rate
7.95%

Purchase Details

Closed on
Jun 7, 1999
Sold by
Miller Jeffrey R Catherine L
Bought by
Long Beach Mtg Company

Purchase Details

Closed on
Apr 23, 1997
Sold by
Miller Jeffrey R and Miller Catherine L
Bought by
Miller Jeffrey R and Miller Catherine L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$240,000
Interest Rate
8.62%

Purchase Details

Closed on
Jun 14, 1996
Sold by
Miller Jeffrey R
Bought by
Miller Jeffrey R and Gilliam Catherine L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$177,600
Interest Rate
9.85%
Mortgage Type
Construction
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

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
Schnell Kyle A $475,356 Stewart Title
Lint Angie -- None Available
Lint Angie $412,000 Land Title Guarantee Company
Beckmann Edward M $410,000 Larimer County Title Co Llc
Lowe Christopher A $286,000 North American Title Co
Long Beach Mtg Company $281,890 --
Miller Jeffrey R -- --
Miller Jeffrey R -- --
Miller Jeffrey R $65,000 --
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 Schnell Kyle A $380,284
Previous Owner Lint Angie $231,000
Previous Owner Lint Angie $329,600
Previous Owner Beckmann Edward M $188,000
Previous Owner Lowe Christopher A $211,000
Previous Owner Miller Jeffrey R $240,000
Previous Owner Miller Jeffrey R $177,600
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
05/03/2020 05/03/20 Off Market $412,000 -- --
05/03/2020 05/03/20 Off Market $475,365 -- --
05/22/2015 05/22/15 Sold $475,365 +5.0% $135 / Sq Ft
04/22/2015 04/22/15 Pending -- -- --
03/26/2015 03/26/15 For Sale $452,900 +9.9% $128 / Sq Ft
05/18/2012 05/18/12 Sold $412,000 -4.2% $106 / Sq Ft View Prior Sale
04/18/2012 04/18/12 Pending -- -- --
03/29/2012 03/29/12 For Sale $430,000 -- $110 / Sq Ft
Source: IRES MLS

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,641 $59,563 $13,438 $46,125
2024 $5,467 $64,588 $14,405 $50,183
2022 $4,600 $49,019 $6,839 $42,180
2021 $4,717 $50,429 $7,036 $43,393
2020 $4,124 $43,530 $7,036 $36,494
2019 $4,069 $43,530 $7,036 $36,494
2018 $3,836 $38,952 $7,085 $31,867
2017 $3,391 $38,952 $7,085 $31,867
2016 $3,286 $36,449 $7,833 $28,616
2015 $2,731 $34,380 $7,830 $26,550
2014 -- $28,580 $7,830 $20,750
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: IRE758623

IRES MLS

APN: 04251-08-036

Your Personal Tour Guide

Ask me questions while you tour the home.