$2,475,000
NEW CONSTRUCTION

2682 Southwind Rd Berthoud, CO 80513

Estimated payment $13,412/month

Total Views 6,891
5 Beds
4.5 Baths
4,329 Sq Ft
$572 Price per Sq Ft

Highlights

  • Water Views
  • Fitness Center
  • Gated Community
  • Carrie Martin Elementary School Rated 9+
  • New Construction
  • 0.42 Acre Lot

About This Home

Presented by Lifestyle Custom Homes by Ed Rust, The Aspen Grove is an exceptional new residence nestled in the exclusive gated enclave of Heron Lakes, known as "The Rookery."This thoughtfully designed home includes a Full TPC Golf Membership, inviting you to enjoy an elite golfing lifestyle in a truly premier setting.Inside, the owner's retreat offers a peaceful sanctuary, ideal for relaxation and renewal. The gourmet kitchen is a chef's dream-outfitted with top-of-the-line stainless steel appliances and elegant granite or quartz countertops-creating the perfect blend of beauty and function.Expansive sliding doors lead to a spacious covered patio, ideal for entertaining or taking in the incredible views. The main floor also features a private guest ensuite and a custom sliding-door office, offering flexibility and comfort.The finished lower level is designed with entertainment in mind, featuring two additional spacious bedrooms, a stylish walk-up wet bar, and an oversized recreation room.Every detail of The Aspen Grove has been carefully curated, from low-voltage smart home technology to luxury finishes throughout. Set on an estate-sized lot with stunning water and mountain views, this home offers an unmatched outdoor living experience from the moment you move in.

Listing Agent

Melissa Maersk-Moller

Luxury Homes LLC Listed on: 04/15/2025

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,482

Year Built

  • Built in 2025 | New Construction

Lot Details

  • 0.42 Acre Lot
  • Partially Fenced Property
  • Level Lot
  • Sprinkler System

Parking

  • 3 Car Attached Garage
  • Heated Garage

Property Views

  • Water
  • Mountain

Home Design

  • Wood Frame Construction
  • Concrete Roof

Interior Spaces

  • 4,329 Sq Ft Home
  • 1-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Living Room with Fireplace
  • Home Office
  • Basement Fills Entire Space Under The House
  • Laundry on main level

Kitchen

  • Eat-In Kitchen
  • Gas Oven or Range
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary bathroom on main floor
  • Bathtub and Shower Combination in Primary Bathroom

Eco-Friendly Details

  • Energy-Efficient Thermostat

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting

Location

  • Property is near a park
  • Property is near a golf course

Schools

  • Carrie Martin Elementary School
  • New Vision Charter Middle School
  • Thompson Valley High School

Utilities

  • Forced Air Heating and Cooling System
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number R1661706

Community Details

Overview

  • No Home Owners Association
  • Built by Ed Rust Lifestyle Custom
  • Heron Lakes 3Rd Filing Subdivision

Recreation

  • Fitness Center
  • Community Pool
  • Park

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,482

Year Built

Built in 2025 | New Construction

Lot Details

0

Parking

3

Listing Details

  • Year Built: 2025
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.42
  • Road Frontage Type: City Street
  • Road Surface Type: Paved, Asphalt
  • Subdivision Name: Heron Lakes 3rd Filing
  • Directions: Berthoud Parkway to Grand Market to Heron Lakes Pkwy turn into the gated section of The Rookery and left at the stop sign house/lot is on the left side of the road also can you Google Maps
  • Above Grade Finished Sq Ft: 2848
  • Architectural Style: Ranch
  • Garage Yn: Yes
  • Unit Levels: One
  • New Construction: Yes
  • Efficiency: Thermostat
  • Building Stories: 1
  • Kitchen Level: Main
  • IRESDS_HasWaterRights: No
  • IRESDS_Total Sq Ft: 4329
  • Special Features: NewHome
  • Stories: 1

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Refrigerator, Disposal
  • Accessibility Features: Level Lot, Main Floor Bath, Main Level Bedroom, Main Level Laundry
  • Has Basement: Full, Partially Finished
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Below Grade Sq Ft: 1481
  • Fireplace Features: Living Room
  • Fireplace: Yes
  • Interior Amenities: Study Area, High Speed Internet, Eat-in Kitchen, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry
  • Living Area: 4329
  • Room Bedroom4 Area: 224
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • IRESDS_HasFamilyRoom: No
  • Room Bedroom4 Level: Basement
  • Room Bedroom3 Area: 182
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Main
  • Room Bedroom2 Area: 196
  • Room Bedroom3 Level: Basement
  • Master Bedroom Master Bedroom Width: 16
  • Room Bedroom2 Level: Main
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Wood Floor
  • Room Bedroom5 Level: Basement
  • Room Bedroom5 Features: Carpet
  • Room Bedroom5 Area: 225
  • Room Kitchen Features: Wood Floor
  • Room Living Room Area: 1
  • Room Kitchen Area: 224
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 240
  • Room Dining Room Area: 208
  • Master Bathroom Features: Tub+Shower Primary, Luxury Features Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Concrete
  • Builder Name: Ed Rust Lifestyle Custom
  • Fencing: Partial
  • Lot Features: Curbs, Gutters, Sidewalks, Fire Hydrant within 500 Feet, Lawn Sprinkler System, Rolling Slope, Near Golf Course, Abuts Park
  • View: Mountain(s), Water
  • Waterfront: No
  • Construction Type: Wood/Frame
  • Exterior Features: Lighting
  • Patio And Porch Features: Patio, Deck
  • Property Condition: New Construction

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Heated Garage, Oversized
  • IRESDS_Garage Sq Ft: 1000
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Heating: Forced Air
  • Utilities: Cable Available
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town Of Berthoud

Condo/Co-op/Association

  • Community Features: Pool, Fitness Center, Park, Gated
  • Senior Community: No
  • Association: No

Association/Amenities

  • IRESDS_HasAssociation2Reserve: No
  • IRESDS_HasAssociation2Fee: No
  • IRESDS_HasAssociationReserve: No
  • IRESDS_HasAssociationFee: No

Schools

  • Elementary School: Carrie Martin,New Vision Charter
  • HighSchool: Thompson Valley
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: New Vision Charter

Lot Info

  • Zoning: Res
  • Lot Size Sq Ft: 18383
  • Parcel #: R1661706
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2024
  • Tax Annual Amount: 3482

Multi Family

Map

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

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 $3,482 $20,618 $20,618 --
2024 $3,299 $20,032 $20,032 --
2022 $6,460 $39,585 $39,585 $0
2021 $6,163 $37,961 $37,961 $0
2020 $1,122 $6,670 $6,670 $0
2019 $1,104 $6,670 $6,670 $0
2018 $862 $5,278 $5,278 $0
2017 $721 $5,278 $5,278 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/15/2025 04/15/25 For Sale $2,475,000 +607.1% $572 / Sq Ft
04/14/2023 04/14/23 Sold $350,000 -6.7% --
07/26/2022 07/26/22 For Sale $375,000 -- --
Source: IRES MLS

Purchase History

Date Type Sale Price Title Company
Special Warranty Deed $350,000 Ascendant Title
Corporate Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Closed $245,000 Credit Line Revolving
Source: Public Records

Source: IRES MLS

MLS Number: 1031230

IRES MLS

APN: 94044-29-002