NOT LISTED FOR SALE

404 Ellie Way Berthoud, CO 80513

Estimated Value: $565,000 - $612,000

4 Beds
3 Baths
2,400 Sq Ft
$244/Sq Ft Est. Value

Last Sold May 15, 2024

Last sale price $620,000 $258 Per Sq Ft

Est. 6% decrease in value since last sale

Current estimated payment $3,595/month

8 Days on Market

Highlights

  • Located in a master-planned community
  • Deck
  • High Ceiling
  • Primary Bedroom Suite
  • Traditional Architecture
  • Granite Countertops

About This Home

As of May 2024

Schedule a visit to tour this unique property in a quaint yet progressive community, a true hidden gem. Minutes to Boulder, Loveland and Fort Collins, as well as recreation opportunities including Carter Lake and foothills. Expansive ranch floor plan with 2400 Finished Sq.Feet nestled within a recently developed yet established neighborhood. Just steps to community pool, park, trails and open space. Built in 2018, this 4 br/3 ba home features newer flooring and updated light fixtures on the main level. Kitchen has abundant amounts of granite counters and cooking/prep island. All bathrooms also have granite countertops. Living Room, Kitchen, Dining Room and Primary bedroom all have vaulted ceilings with primary closet organizer system. The finished basement is as bright as a garden level basement and contains two bedrooms, bath, rec area and unfinished storage space. Backyard is fully fenced, has a composite deck AND large patio space with mountain views. Well established landscaping with raised garden beds, drip systems, grape vines and a small pond with water feature. Shed with electrical service for extra storage and work space.
Elementary and high school within walking distance. Walk, bike, or drive your golf cart to downtown Berthoud, complete with restaurants, breweries, coffee shops, retail and bakery. Enjoy the farmers market and downtown events, as well as new recreation center, large community park and outdoor amenities. Great care has been taken with this home in a tranquil community at a great price. Don’t miss your opportunity to live your best life in this unique home and community! Check back for pictures of downtown amenities.

Last Agent to Sell the Property

Karen King

Keller Williams DTC Brokerage Email: KARENKING@KW.COM,720-384-3884 License #40044474 Listed on: 04/04/2024

Keller Williams DTC

Last Buyer's Agent

Josh Roberson

Ideal Team Homes License #100000539

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,625

Year Built

  • Built in 2018

Lot Details

  • 5,887 Sq Ft Lot
  • South Facing Home
  • Property is Fully Fenced
  • Front Yard Sprinklers
  • Private Yard
  • Garden
  • Property is zoned PUD

HOA Fees

  • $18 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Composition Roof
  • Wood Siding
  • Radon Mitigation System
  • Concrete Perimeter Foundation

Interior Spaces

  • 1-Story Property
  • High Ceiling
  • Double Pane Windows
  • Smart Doorbell

Kitchen

  • Self-Cleaning Oven
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms | 2 Main Level Bedrooms
  • Primary Bedroom Suite
  • 3 Full Bathrooms

Finished Basement

  • Basement Fills Entire Space Under The House
  • 2 Bedrooms in Basement

Home Security

  • Radon Detector
  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Outdoor Features

  • Deck
  • Patio
  • Outdoor Water Feature
  • Rain Gutters
  • Front Porch

Schools

  • Ivy Stockwell Elementary School
  • Turner Middle School
  • Berthoud High School

Additional Features

  • Smoke Free Home
  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Exclusions: Sellers personal belongings. Any TV's or TV mounts currently attached. Washer and Dryer. Fold down LED light in basement storage/utility room.
  • Assessor Parcel Number R1665463

Community Details

Overview

  • Association fees include reserves
  • Heritage Ridge Metro District Association, Phone Number (970) 484-0101
  • Built by Saint Aubyn Homes LLC
  • Heritage Ridge Subdivision, Ranch Floorplan
  • Located in a master-planned community

Recreation

  • Community Playground
  • Community Pool
  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,625

Year Built

Built in 2018

Lot Details

0

HOA Fees

$18 per month

Parking

2

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Structure Type: House
  • Levels: One
  • Year Built: 2018
  • Above Grade Finished Sq Ft: 1243
  • Exclusions: Sellers personal belongings. Any TV's or TV mounts currently attached. Washer and Dryer. Fold down LED light in basement storage/utility room.
  • Living Area: 2400
  • SubdivisionName: Heritage Ridge
  • Ownership: Individual
  • Property Attached Yn: No
  • ResoBuildingAreaSource: PublicRecords
  • REC_BasementLevelBathrooms: 1
  • REC_BasementLevelBedrooms: 2
  • REC_BelowGradeUnfinishedArea: 86.00
  • REC_ExpectedActiveDate: 2024-04-04
  • REC_RVSpaces: 0
  • REC_UpperLevelBathrooms: 0
  • REC_UpperLevelBedrooms: 0
  • REC_WaterIncludedYN: 1
  • Ratio Close Price By Original Li: 1.00000
  • Attribution Contact: KARENKING@KW.COM,720-384-3884
  • Special Features: None

Interior Features

  • Appliances: Dishwasher, Disposal, Microwave, Oven, Range, Self Cleaning Oven
  • Interior Amenities: Granite Counters, High Ceilings, Kitchen Island, Pantry, Primary Suite, Radon Mitigation System, Smoke Free
  • Flooring: Carpet, Laminate, Tile
  • Full Bathrooms: 3
  • Basement: Finished, Full
  • Basement: Yes
  • Total Bedrooms: 4
  • Below Grade Sq Ft: 1157
  • Main Level Bathrooms: 2
  • Main Level Bedrooms: 2
  • Window Features: Double Pane Windows

Exterior Features

  • Direction Faces: South
  • Foundation Details: Concrete Perimeter, Slab
  • Roof: Composition
  • Construction Materials: Brick, Wood Siding
  • Exterior Features: Garden, Private Yard, Rain Gutters, Water Feature
  • Patio and Porch Features: Deck, Front Porch, Patio
  • Road Frontage Type: Public
  • Road Surface Type: Paved

Garage/Parking

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

Utilities

  • Sewer: Public Sewer
  • Cooling: Central Air
  • Heating: Forced Air
  • Water Source: Public
  • Security: Carbon Monoxide Detector(s), Radon Detector, Smoke Detector(s), Video Doorbell

Condo/Co-op/Association

  • HOA Fee Includes: Reserves
  • Association Name: Heritage Ridge Metro district
  • Association Fee Frequency: Annually
  • Association Amenities: Park, Playground, Pool
  • Association Fee: 216
  • Phone: 970-484-0101
  • Association: Yes
  • Senior Community: No

Association/Amenities

  • REC_AssociationFee2Annual: 0.00
  • REC_AssociationFee3Annual: 0.00
  • REC_AssociationFeeAnnual: 216.00
  • REC_AssociationFeeTotalAnnual: 216.00
  • REC_AssociationManagementType: Professionally Managed
  • REC_MultipleAssociationsYN: 0
  • REC_AssociationURL: https://www.heritageridgemd.com/

Schools

  • Middle Or Junior School: Turner

Lot Info

  • Parcel Number: R1665463
  • Lot Size Acres: 0.14
  • Fencing: Full
  • Building Area Total: 2486
  • Lot Features: Master Planned, Sprinklers In Front
  • Lot Size Sq Ft: 5887
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Saint Aubyn Homes LLC

Tax Info

  • Tax Year: 2022
  • Tax Annual Amount: 4625

MLS Schools

  • Elementary School: Ivy Stockwell
  • High School: Berthoud

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 4, 2024
Closed on
May 15, 2024
Sold by
Weeks Scott M
Bought by
Kalisch Monte and Riva Jeremy J
Seller's Agent
Karen King
Keller Williams DTC
Buyer's Agent
Josh Roberson
Ideal Team Homes
List Price
$620,000
Sold Price
$620,000
Views
19
Current Estimated Value
$585,017

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$34,983
Avg. Annual Appreciation
-4.12%
Original Mortgage
$375,000
Outstanding Balance
$370,606
Interest Rate
7.09%
Mortgage Type
New Conventional
Estimated Equity
$214,411

Purchase Details

Listed on
Jun 24, 2022
Closed on
Aug 25, 2022
Sold by
Lengner Donald M
Bought by
Weeks Scott Ni
Seller's Agent
Debbie Haubert
WK Real Estate Longmont
Buyer's Agent
Paige Lilienfeld
Porchlight RE Group-Boulder
List Price
$575,000
Sold Price
$575,000

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.48%

Purchase Details

Closed on
Jan 22, 2020
Sold by
Saint Aubyn Homes Llc
Bought by
Lengner Donald M and Lengner Stacy A

Purchase Details

Closed on
Jan 17, 2019
Sold by
Saint Aubyn Homes Llc
Bought by
Lengner Donald M and Lengner Stacy A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$269,000
Interest Rate
4.6%
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
Kalisch Monte $620,000 First American Title
Weeks Scott Ni $575,000 Land Title
Lengner Donald M $397,000 Unified Title Co
Lengner Donald M $397,000 Unified Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Kalisch Monte $375,000
Previous Owner Lengner Donald M $269,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/15/2024 05/15/24 Sold $620,000 0.0% $258 / Sq Ft
04/13/2024 04/13/24 Pending -- -- --
04/04/2024 04/04/24 For Sale $620,000 +7.8% $258 / Sq Ft
08/25/2022 08/25/22 Sold $575,000 0.0% $231 / Sq Ft
06/24/2022 06/24/22 For Sale $575,000 -- $231 / 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 $5,698 $36,052 $10,780 $25,272
2024 $5,580 $36,052 $10,780 $25,272
2022 $4,727 $27,599 $7,993 $19,606
2021 $4,727 $28,393 $8,223 $20,170
2020 $4,370 $26,241 $7,901 $18,340
2019 $2,730 $16,667 $7,901 $8,766
2018 $9 $23 $23 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: REcolorado®

MLS Number: 3456744

REcolorado®

APN: 94234-33-011