NOT LISTED FOR SALE

1996 Delvin St Berthoud, CO 80513

Estimated Value: $636,795 - $693,000

5 Beds
3 Baths
3,076 Sq Ft
$218/Sq Ft Est. Value

Last Sold August 02, 2024

Last sale price $640,000 $208 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $4,133/month

37 Days on Market

Highlights

  • Located in a master-planned community
  • Primary Bedroom Suite
  • Vaulted Ceiling
  • Berthoud Elementary School Rated A-
  • Open Floorplan
  • Traditional Architecture

About This Home

As of August 2024

Don’t miss this beautiful home in the Hammond Farms community,backing to HOA open space, providing stunning views! Built in 2021, this ranch-style home features a spacious primary suite with an ensuite bath, walk-in closet, as well as two additional junior bedrooms and a full bathroom. Kitchen is complete with granite countertops, stainless steel appliances, gas cooktop and custom cabinetry. The finished basement offers a large recreation room, two more bedrooms, and an additional bathroom. Located just minutes from downtown Berthoud and Loveland, with easy access to major routes, this home combines tranquility with accessibility. The school bus drop-off is conveniently next door, and the neighborhood park is right across the street. Experience the magic of 4th of July fireworks from both your front and backyard. Don't miss out on this exceptional opportunity—call today to schedule your private tour!

Last Agent to Sell the Property

Derrick Dannenbaum

Equity Colorado Real Estate Brokerage Email: ddcorealty@gmail.com,303-717-9819 License #100039035 Listed on: 05/30/2024

Equity Colorado Real Estate

Last Buyer's Agent

Rebecca Weihe

WK Real Estate Longmont License #100032839

WK Real Estate Longmont

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,365

Year Built

  • Built in 2021

Lot Details

  • 6,000 Sq Ft Lot
  • Open Space
  • Property is Fully Fenced
  • Landscaped
  • Level Lot
  • Private Yard

HOA Fees

  • $12 Monthly HOA Fees

Parking

  • 3 Car Attached Garage

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Frame Construction
  • Composition Roof
  • Wood Siding

Interior Spaces

  • 1-Story Property
  • Open Floorplan
  • Vaulted Ceiling
  • Family Room with Fireplace
  • Dryer

Kitchen

  • Eat-In Kitchen
  • Self-Cleaning Oven
  • Range
  • Microwave
  • Dishwasher
  • Wine Cooler
  • Kitchen Island
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms | 3 Main Level Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • 3 Full Bathrooms

Finished Basement

  • Sump Pump
  • 2 Bedrooms in Basement

Home Security

  • Home Security System
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Patio

Schools

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

Utilities

  • Forced Air Heating and Cooling System
  • Mini Split Air Conditioners
  • Humidifier
  • Tankless Water Heater

Listing and Financial Details

  • Exclusions: Sellers Personal Property
  • Assessor Parcel Number R1673371

Community Details

Overview

  • Association fees include reserves
  • Hammond Farms Association, Phone Number (970) 430-9451
  • Built by Tralon Homes LLC
  • Hammond Farms Subdivision, Everest Floorplan
  • Located in a master-planned community

Recreation

  • Community Playground
  • Park
  • Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,365

Year Built

Built in 2021

Lot Details

0

HOA Fees

$12 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Structure Type: House
  • Levels: One
  • Year Built: 2021
  • Above Grade Finished Sq Ft: 1610
  • Exclusions: Sellers Personal Property
  • Living Area: 3076
  • Directions: GPS
  • SubdivisionName: Hammond Farms
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Builder
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 2
  • REC_BelowGradeUnfinishedArea: 100.00
  • REC_ExpectedActiveDate: 2024-05-30
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 0.95537
  • Attribution Contact: ddcorealty@gmail.com,303-717-9819
  • Special Features: VirtualTour

Interior Features

  • Appliances: Dishwasher, Disposal, Dryer, Humidifier, Microwave, Range, Self Cleaning Oven, Sump Pump, Tankless Water Heater, Wine Cooler
  • Fireplaces: 1
  • Interior Amenities: Eat-in Kitchen, Five Piece Bath, Kitchen Island, Open Floorplan, Pantry, Primary Suite, Vaulted Ceiling(s), Walk-In Closet(s)
  • Flooring: Carpet, Laminate, Tile
  • Fireplace Features: Family Room
  • Full Bathrooms: 3
  • Basement: Finished, Sump Pump
  • Basement: Yes
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1466
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 3

Exterior Features

  • Foundation Details: Slab
  • Roof: Composition
  • Construction Materials: Frame, Wood Siding
  • Exterior Features: Private Yard
  • Patio and Porch Features: Patio

Garage/Parking

  • Parking Features: Concrete
  • Attached Garage: Yes
  • Garage Spaces: 3
  • Total Parking Spaces: 3
  • REC_ParkingCount: 1

Utilities

  • Sewer: Public Sewer
  • Cooling: Air Conditioning-Room, Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Security: Carbon Monoxide Detector(s), Security System, Smart Cameras, Smoke Detector(s)

Condo/Co-op/Association

  • HOA Fee Includes: Reserves
  • Association Name: Hammond Farms
  • Association Fee Frequency: Annually
  • Association Amenities: Park, Playground, Trail(s)
  • Association Fee: 140
  • Phone: 970-430-9451
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 140.00
  • REC_AssociationFeeTotalAnnual: 140.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0

Schools

  • Middle Or Junior School: Turner

Lot Info

  • Parcel Number: R1673371
  • Lot Size Acres: 0.14
  • Fencing: Full
  • Building Area Total: 3176
  • Lot Features: Landscaped, Level, Master Planned, Open Space
  • Lot Size Sq Ft: 6000
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Energy Efficient: Water Heater

Building Info

  • Builder Name: Tralon Homes LLC

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 5365

MLS Schools

  • Elementary School: Berthoud
  • High School: Berthoud

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 30, 2024
Closed on
Jul 31, 2024
Sold by
Hesse Scott M and Hesse Lisa J
Bought by
Parks Patricia M and Parks Scott M
Seller's Agent
Derrick Dannenbaum
Equity Colorado Real Estate
Buyer's Agent
Rebecca Weihe
WK Real Estate Longmont
List Price
$669,900
Sold Price
$640,000
Premium/Discount to List
-$29,900
-4.46%
Views
38
Current Estimated Value
$670,949

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$30,949
Avg. Annual Appreciation
4.05%
Original Mortgage
$215,000
Outstanding Balance
$212,562
Interest Rate
6.86%
Mortgage Type
New Conventional
Estimated Equity
$458,387

Purchase Details

Listed on
Nov 18, 2021
Closed on
Dec 17, 2021
Sold by
Saint Aubyn Homes Llc and Tralon Homes Llc
Bought by
Hesse Scott M and Hesse Lisa J
Seller's Agent
Philip Balliet
Jason Mitchell Real Estate Colorado, LLC
Buyer's Agent
Non-IRES Agent
Non-IRES
List Price
$565,300
Sold Price
$565,300

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.83%
Original Mortgage
$537,035
Interest Rate
3.11%
Mortgage Type
New Conventional
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
Parks Patricia M $640,000 Land Title
Hesse Scott M -- None Listed On Document
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Parks Patricia M $215,000
Previous Owner Hesse Scott M $537,035
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/02/2024 08/02/24 Sold $640,000 -1.5% $208 / Sq Ft
07/07/2024 07/07/24 Pending -- -- --
06/25/2024 06/25/24 Price Changed $649,900 -1.5% $211 / Sq Ft
06/13/2024 06/13/24 Price Changed $659,900 -1.5% $215 / Sq Ft
05/30/2024 05/30/24 For Sale $669,900 +18.5% $218 / Sq Ft
03/17/2022 03/17/22 Off Market $565,300 -- --
12/17/2021 12/17/21 Sold $565,300 0.0% $178 / Sq Ft View Prior Sale
11/18/2021 11/18/21 For Sale $565,300 -- $178 / Sq Ft
Source: REcolorado®

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,765 $42,854 $7,605 $35,249
2024 $6,534 $42,854 $7,605 $35,249
2022 $5,365 $31,497 $7,888 $23,609
2021 $5,294 $32,915 $32,915 $0
2020 $7 $10 $10 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: REcolorado®

MLS Number: 5572152

REcolorado®

APN: 94104-06-020