NOT LISTED FOR SALE

3457 Snowy Egret Ln Berthoud, CO 80513

Estimated Value: $2,145,000 - $2,377,000

3 Beds
4 Baths
4,584 Sq Ft
$488/Sq Ft Est. Value

Last Sold January 08, 2021

Last sale price $1,850,000 $404 Per Sq Ft

Est. 21% increase in value since last sale

Current estimated payment $12,880/month

133 Days on Market

Highlights

  • Parking available for a boat
  • Spa
  • Open Floorplan
  • Berthoud Elementary School Rated A-
  • Solar Power System
  • Mountain View

About This Home

As of January 2021

Welcome to this one-of-a-kind, custom-built home in west Berthoud!!! This meticulously-maintained, energy efficient home offers breathtaking Front Range views, over 4,000 sf of main floor living with an abundance of natural light, gourmet and prep kitchens, and a wealth of luxury finishes. Features include a luxury master bath, geothermal radiant heating and cooling, stone countertops, custom cabinetry, touch faucets, artistic accents and glass mosaics, building automation and AV systems, and SO MUCH MORE! Two garages offer over 2,500 sf of climate-controlled space with RV storage. Exterior features include a photovoltaic system (owned), snowmelt system in patios and driveway, professional landscaping with drip irrigation, rooftop patio, dog run, and an expansive outdoor patio and kitchen perfect for entertaining. Home abuts 80 acres of private open space and HOA owns 7.5 shares of irrigation water. Property is located just minutes from the TPC Colorado golf course and Carter Lake.

Last Agent to Sell the Property

Marshall Massaro

C3 Real Estate Solutions, LLC Listed on: 06/22/2020

C3 Real Estate Solutions, LLC

Last Buyer's Agent

Beth Bishop

Group Harmony

Group Harmony

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,227

Year Built

  • Built in 2015

Lot Details

  • 2.38 Acre Lot
  • Open Space
  • Cul-De-Sac
  • Unincorporated Location
  • Southern Exposure
  • Northeast Facing Home
  • Kennel or Dog Run
  • Corner Lot
  • Level Lot
  • Sprinkler System
  • Property is zoned FA1

HOA Fees

  • $176 Monthly HOA Fees

Parking

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

Home Design

  • Contemporary Architecture
  • Brick Veneer
  • Wood Frame Construction
  • Composition Roof
  • Stucco
  • Stone

Interior Spaces

  • 4,584 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Wet Bar
  • Central Vacuum
  • Bar Fridge
  • Cathedral Ceiling
  • Ceiling Fan
  • Multiple Fireplaces
  • Double Sided Fireplace
  • Gas Log Fireplace
  • Double Pane Windows
  • Window Treatments
  • Great Room with Fireplace
  • Home Office
  • Mountain Views
  • Crawl Space

Kitchen

  • Eat-In Kitchen
  • Double Self-Cleaning Oven
  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Painted or Stained Flooring
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Primary bathroom on main floor
  • Steam Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Accessible Home Design

  • Garage doors are at least 85 inches wide
  • Accessible Entrance

Eco-Friendly Details

  • Solar Power System

Outdoor Features

  • Spa
  • Balcony
  • Enclosed Patio or Porch
  • Outdoor Gas Grill

Schools

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

Utilities

  • Zoned Heating and Cooling System
  • Heat Pump System
  • Radiant Heating System
  • Water Rights
  • Septic System
  • High Speed Internet
  • Satellite Dish
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R1626093

Community Details

Overview

  • Association fees include common amenities, snow removal, management
  • Farm At Blue Mountain Meadow Subdivision

Recreation

  • Park

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,227

Year Built

Built in 2015

Lot Details

0

HOA Fees

$176 per month

Parking

6

Listing Details

  • Year Built: 2015
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 2.38
  • Road Frontage Type: Priv Rd up to County Standards
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Farm at Blue Mountain Meadow
  • Directions: From HWY 287 & West CR8, go west ~1.5 miles to CR21, turn right (north) on CR21 and travel 2 miles to CR10, turn left (west) on CR10 and take second right (north) onto Preserve Dr., home is on the SW corner of Preserve Dr. and Snowy Egret Lane.
  • Above Grade Finished Sq Ft: 4584
  • Architectural Style: Contemporary/Modern, Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: No
  • Efficiency: Southern Exposure
  • Building Stories: 1
  • Structure Type: Legal Conforming
  • Power Production Type: Photovoltaics
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: Yes
  • IRESDS_Total Sq Ft: 4584
  • Special Features: None
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Self Cleaning Oven, Double Oven, Dishwasher, Refrigerator, Bar Fridge, Microwave, Disposal
  • Accessibility Features: Level Lot, Level Drive, Accessible Entrance, Main Floor Bath, Main Level Bedroom, Main Level Laundry
  • Has Basement: Crawl Space, Structural Floor
  • Full Bathrooms: 1
  • Half Bathrooms: 2
  • Three Quarter Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace Features: 2+ Fireplaces, Gas, Gas Logs Included, Double Sided, Primary Bedroom, Great Room
  • Fireplace: Yes
  • Interior Amenities: Study Area, Satellite Avail, High Speed Internet, Central Vacuum, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, Steam Shower, 9ft+ Ceilings
  • Living Area: 4584
  • Window Features: Window Coverings, Double Pane Windows
  • Room Bedroom3 Features: Other Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom3 Area: 182
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Area: 169
  • Room Bedroom3 Level: Main
  • Master Bedroom Master Bedroom Width: 14
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Other Floor
  • Master Bedroom Features: Other Floor
  • Room Kitchen Features: Tile Floor
  • Room Kitchen Area: 714
  • Room Master Bedroom Area: 252
  • Master Bathroom Features: Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Composition
  • Lot Features: Fire Hydrant within 500 Feet, Lawn Sprinkler System, Water Rights Included, Cul-De-Sac, Corner Lot, Level, Abuts Private Open Space, Unincorporated
  • View: Mountain(s), Foothills View
  • Waterfront: No
  • Construction Type: Wood/Frame, Brick/Brick Veneer, Stone, Stucco, Painted/Stained
  • Direction Faces: Northeast
  • Exterior Features: Gas Grill, Balcony, Hot Tub Included
  • Other Structures: Kennel/Dog Run
  • Patio And Porch Features: Patio, Enclosed
  • Property Condition: Not New, Previously Owned

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 6
  • Garage Spaces: 6
  • Parking Features: Garage Door Opener, RV/Boat Parking, >8' Garage Door, Heated Garage, Oversized
  • IRESDS_Garage Sq Ft: 2565
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Electric: Electric, PVREA
  • Heating: Heat Pump, Zoned, Radiant, 2 or more Heat Sources
  • Utilities: Natural Gas Available, Electricity Available, Cable Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: Septic
  • Water Source: District Water, Little Thompson
  • Gas Company: Natural Gas, Xcel

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Snow Removal, Management
  • Community Features: Park
  • Senior Community: No
  • Association Fee: 529
  • Association Fee Frequency: Quarterly
  • 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
  • Lot Size Sq Ft: 103847
  • Parcel #: R1626093
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2019
  • Tax Annual Amount: 8227

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 22, 2020
Closed on
Jan 8, 2021
Sold by
Rozek Leonard R and Rozek Diane L
Bought by
Gerber Theunis J and Gerber Jacoba P
Seller's Agent
Marshall Massaro
C3 Real Estate Solutions, LLC
Buyer's Agent
Beth Bishop
Group Harmony
List Price
$1,999,500
Sold Price
$1,850,000
Premium/Discount to List
-$149,500
-7.48%
Current Estimated Value
$2,236,697

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$386,697
Avg. Annual Appreciation
3.84%
Original Mortgage
$1,387,500
Outstanding Balance
$1,250,451
Interest Rate
2.75%
Mortgage Type
New Conventional
Estimated Equity
$959,215

Purchase Details

Listed on
Jul 26, 2013
Closed on
Jan 30, 2015
Sold by
Blue Mountain Holdings Llc
Bought by
Rozek Leonard R and Rozek Diane L
Seller's Agent
Chad Brent
Group Loveland
Buyer's Agent
Chad Brent
Group Loveland
List Price
$130,000
Sold Price
$125,000
Premium/Discount to List
-$5,000
-3.85%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
57.40%

Purchase Details

Closed on
Nov 18, 2010
Sold by
Blue Mountain Holdings Llc
Bought by
Mincher Braun A
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
Gerber Theunis J $1,850,000 Land Title
Rozek Leonard R $125,000 Heritage Title
Mincher Braun A -- None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Gerber Theunis J $1,387,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/08/2022 04/08/22 Off Market $1,850,000 -- --
01/08/2021 01/08/21 Sold $1,850,000 -5.1% $404 / Sq Ft
11/02/2020 11/02/20 Pending -- -- --
08/17/2020 08/17/20 Price Changed $1,949,000 -2.5% $425 / Sq Ft
06/22/2020 06/22/20 For Sale $1,999,500 +1499.6% $436 / Sq Ft
01/28/2019 01/28/19 Off Market $125,000 -- --
02/02/2015 02/02/15 Sold $125,000 -3.8% --
01/03/2015 01/03/15 Pending -- -- --
07/26/2013 07/26/13 For Sale $130,000 -- --
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 $10,145 $120,942 $23,450 $97,492
2024 $9,811 $120,942 $23,450 $97,492
2022 $6,331 $73,392 $19,967 $53,425
2021 $6,507 $75,504 $20,542 $54,962
2020 $8,348 $96,847 $8,716 $88,131
2019 $8,227 $96,847 $8,716 $88,131
2018 $7,190 $80,842 $8,777 $72,065
2017 $6,267 $80,842 $8,777 $72,065
2016 $1,223 $15,299 $9,950 $5,349
2015 $2,227 $28,040 $28,040 $0
2014 $1,312 $15,750 $15,750 $0
Source: Public Records

Agents Affiliated with this Home

  • Marshall Massaro

    Seller's Agent in 2021

    Marshall Massaro

    C3 Real Estate Solutions, LLC

    (303) 912-9124

    21 Total Sales

    Marshall Massaro
    Section Image
  • Beth Bishop

    Buyer's Agent in 2021

    Beth Bishop

    Group Harmony

    (970) 692-9600

    160 Total Sales

    Beth Bishop
    Section Image
  • Chad Brent

    Seller's Agent in 2015

    Chad Brent

    Group Loveland

    (970) 461-7145

    115 Total Sales

    Chad Brent
    Section Image
  • Dave Trujillo

    Seller Co-Listing Agent in 2015

    Dave Trujillo

    Group Centerra

    (970) 222-0340

    210 Total Sales

    Dave Trujillo
    Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 915921

IRES MLS

APN: 94084-05-023

Colorado Larimer County Berthoud 80513

3457 Snowy Egret Ln, Berthoud, CO

This home is located at 3457 Snowy Egret Ln, Berthoud, CO 80513 since 22 June 2020 and is currently estimated at $2,236,697, approximately $487 per square foot. This property was built in 2015. 3457 Snowy Egret Ln is a home located in Larimer County with nearby schools including Berthoud Elementary School, Turner Middle School, and Berthoud High School.

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