NOT LISTED FOR SALE

2734 Southwind Rd Berthoud, CO 80513

Estimated Value: $1,859,000 - $2,278,000

6 Beds
4.5 Baths
6,095 Sq Ft
$339/Sq Ft Est. Value

Last Sold July 11, 2022

Last sale price $1,739,556 $285 Per Sq Ft

Est. 19% increase in value since last sale

Current estimated payment $12,878/month

113 Days on Market

Highlights

  • Fitness Center
  • Under Construction
  • Open Floorplan
  • Carrie Martin Elementary School Rated 9+
  • Spa
  • Clubhouse

About This Home

As of July 2022

This amazing home was built to reflect the desires of the buyer. Some of the features include full landscaping and an oversized 3 car garage.The main floor includes large decks off the great room and morning room. Extended hardwood flooring in great room, dining room, study, halls, kitchen and morning room. In the kitchen you will love the oversized kitchen island and generous appliance allowance. The living room features a fireplace with stone to the ceiling and custom, built in entertainment cabinets. Upstairs in the primary bedroom, you will find an oversized shower, cabinetry for coffee bar and a large deck.The 1700 sq ft finished, walk-out basement features a family room, game area and two bedrooms plus bath. Also, a fireplace and wet bar have been added for additional enjoyment.

Last Agent to Sell the Property

Tara Moreno

RE/MAX Alliance-Loveland Listed on: 03/23/2021

RE/MAX Alliance-Loveland

Last Buyer's Agent

Tiffany Brodie

RE/MAX Town and Country

RE/MAX Town and Country

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,918

Year Built

  • Built in 2022 | Under Construction

Lot Details

  • 0.32 Acre Lot
  • Southern Exposure
  • Partially Fenced Property
  • Level Lot
  • Sprinkler System

Parking

  • 3 Car Attached Garage
  • Tandem Parking
  • Garage Door Opener

Home Design

  • Slab Foundation
  • Tile Roof
  • Stucco
  • Stone

Interior Spaces

  • 6,095 Sq Ft Home
  • 2-Story Property
  • Open Floorplan
  • Cathedral Ceiling
  • Multiple Fireplaces
  • Gas Fireplace
  • Double Pane Windows
  • Great Room with Fireplace
  • Family Room
  • Home Office

Kitchen

  • Gas Oven or Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Primary bathroom on main floor
  • Bathtub and Shower Combination in Primary Bathroom
  • Walk-in Shower

Laundry

  • Laundry on main level
  • Washer and Dryer Hookup

Finished Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Fireplace in Basement

Outdoor Features

  • Spa
  • Balcony
  • Patio

Schools

  • Carrie Martin Elementary School
  • Bill Reed Middle School
  • Thompson Valley High School

Utilities

  • Humidity Control
  • Forced Air Zoned Heating and Cooling System

Additional Features

  • Energy-Efficient HVAC
  • Property is near a golf course

Listing and Financial Details

  • Assessor Parcel Number R1661751

Community Details

Overview

  • No Home Owners Association
  • Association fees include common amenities, management
  • Built by Custom On-Site Builders
  • Heron Lakes Subdivision

Amenities

  • Clubhouse

Recreation

  • Fitness Center
  • Community Pool
  • Park
  • Hiking Trails

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,918

Year Built

Built in 2022 | Under Construction

Lot Details

0

Parking

3

Listing Details

  • Year Built: 2022
  • Property Sub Type: Residential-Detached
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 0.32
  • Road Surface Type: Paved
  • Subdivision Name: HERON LAKES
  • Directions: From Hwy 287 and Berthoud Pkwy, head north on Berthoud Pkwy and head west onto Grand Market Ave and take right on TPC Parkway, then take right onto Heron Lakes Parkway. Take a left into the Rookery and a right on Southwind to arrive at Lot.
  • Above Grade Finished Sq Ft: 4315
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: Yes
  • Efficiency: Southern Exposure, HVAC
  • Building Stories: 2
  • Kitchen Level: Main
  • Special Features: NewHome
  • Stories: 2

Interior Features

  • Possible Use: Single Family
  • Private Spa: No
  • Appliances: Gas Range/Oven, Dishwasher, Microwave, Disposal
  • Accessibility Features: Level Lot, Main Floor Bath, Main Level Bedroom, Stall Shower, Main Level Laundry
  • Has Basement: Full, 90%+ Finished Basement, Walk-Out Access
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 2252
  • Fireplace Features: 2+ Fireplaces, Gas, Great Room, Basement
  • Fireplace: Yes
  • Flooring: Wood Floors
  • Interior Amenities: Study Area, Cathedral/Vaulted Ceilings, Open Floorplan, Pantry, Stain/Natural Trim, Walk-In Closet(s), Kitchen Island, 9ft+ Ceilings
  • Living Area: 6095
  • Window Features: Double Pane Windows
  • Bedroom Features: Carpet
  • Room Bedroom4 Area: 132
  • Room Bedroom3 Features: Carpet
  • Dining Room Features: Wood Floor
  • Room Bedroom4 Level: Basement
  • Living Room Living Room Level: Main
  • Room Bedroom3 Area: 176
  • Room Bedroom4 Features: Carpet
  • Master Bedroom Master Bedroom Level: Upper
  • Room Bedroom2 Area: 168
  • Room Bedroom3 Level: Upper
  • Master Bedroom Master Bedroom Width: 19
  • Room Family Room Area: 380
  • Room Bedroom2 Level: Upper
  • Room Bedroom2 Features: Carpet
  • Master Bedroom Features: Carpet
  • Room Bedroom5 Level: Basement
  • Room Family Room Level: Basement
  • Room Bedroom5 Area: 144
  • Room Kitchen Features: Wood Floor
  • Room Living Room Area: 441
  • Family Room Features: Carpet
  • Living Room Features: Wood Floor
  • Room Kitchen Area: 208
  • Dining Room Dining Room Level: Main
  • Room Master Bedroom Area: 247
  • Room Dining Room Area: 208
  • Master Bathroom Features: Full Primary Bath, Tub+Shower Primary, Luxury Features Primary Bath, 5 Piece Primary Bath
  • ResoLivingAreaSource: Plans

Exterior Features

  • Roof: Tile
  • Builder Name: Custom On-Site Builders
  • Fencing: Partial
  • Lot Features: Curbs, Gutters, Sidewalks, Lawn Sprinkler System, Level, Near Golf Course, Within City Limits
  • Waterfront: No
  • Construction Type: Stone, Stucco
  • Exterior Features: Balcony
  • Foundation Details: Slab
  • Patio And Porch Features: Patio
  • Property Condition: Under Construction

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Parking Features: Garage Door Opener, Oversized, Tandem
  • IRESDS_Garage Sq Ft: 1083
  • IRESDS_GarageType: Attached

Utilities

  • Cooling: Central Air
  • Electric: Electric, XCEL
  • Heating: Forced Air, Zoned, Humidity Control
  • Utilities: Natural Gas Available, Electricity Available
  • Laundry Features: Washer/Dryer Hookups, Main Level
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer: City Sewer
  • Water Source: City Water, Town of Windsor
  • Gas Company: Natural Gas, PVREA

Condo/Co-op/Association

  • HOA Fee Includes: Common Amenities, Management
  • Community Features: Clubhouse, Hot Tub, Pool, Fitness Center, Park, Hiking/Biking Trails
  • Senior Community: No
  • Association: No

Schools

  • Elementary School: Carrie Martin
  • HighSchool: Thompson Valley
  • Junior High Dist: Thompson R2-J
  • Middle Or Junior School: Bill Reed

Lot Info

  • Zoning: RES
  • Lot Size Sq Ft: 13891
  • Parcel #: R1661751
  • ResoLotSizeUnits: SquareFeet

Tax Info

  • Tax Year: 2019
  • Tax Annual Amount: 5918

Multi Family

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 23, 2021
Closed on
Jul 7, 2022
Sold by
Custom On-Site Builders Inc
Bought by
The Mark And Tiffany Brodie Trust
Seller's Agent
Tara Moreno
RE/MAX Alliance-Loveland
Buyer's Agent
Tiffany Brodie
RE/MAX Town and Country
List Price
$1,414,711
Sold Price
$1,739,556
Premium/Discount to List
$324,845
22.96%
Total Days on Market
113
Current Estimated Value
$2,067,710

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$328,154
Avg. Annual Appreciation
6.10%
Original Mortgage
$181,900
Interest Rate
5.51%
Mortgage Type
Credit Line Revolving
Source: Public Records

Similar Homes in the area

  • 2696 Bluewater Rd, Berthoud, CO 80513

    $1,997,700

    • 4 Beds
    • 5 Baths
    • 2,455 Sq Ft
    • 2696 Bluewater Rd
    • Berthoud, CO

    Spectacular Vacant Lot with Mountain, Lake views and TPC Colorado Membership! Build your dream home in this prestigious gated community, offering unparalleled amenities and breathtaking views. This vacant lot boasts stunning, unobstructed mountain views and is conveniently located directly across from a motorized lake, perfect for boating, fishing, and year-round recreation. As a resident, you'll

    Melissa Maersk-Moller Luxury Homes LLC

    Section Image
  • 2774 Heron Lakes Pkwy, Berthoud, CO 80513

    $1,795,000

    • 4 Beds
    • 4.5 Baths
    • 4,682 Sq Ft
    • 2774 Heron Lakes Pkwy
    • Berthoud, CO

    Welcome to this Modern Farmhouse featuring 4-bedroom, 5-bathroom residence spanning 5,124 sq ft that epitomizes modern elegance, formerly a Parade of Homes model. Backing to the 11th tee box at TPC Colorado, this gem is back on the market below construction cost. The gourmet chef's kitchen commands attention on the main level, boasting 10-foot ceilings, stainless steel appliances, and a farm

    Melissa Maersk-Moller Luxury Homes LLC

    Section Image
  • 2682 Southwind Rd, Berthoud, CO 80513

    $2,475,000

    • 5 Beds
    • 4.5 Baths
    • 4,329 Sq Ft
    • 2682 Southwind Rd
    • Berthoud, CO

    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

    Melissa Maersk-Moller Luxury Homes LLC

    Section Image
  • 2294 Stonebrae Ct, Loveland, CO 80537

    $2,395,000

    • 4 Beds
    • 6 Baths
    • 5,450 Sq Ft
    • 2294 Stonebrae Ct
    • Loveland, CO

    Better than new! Move in ready! Over $100k in professional landscaping. This beautiful custom home in Heron Lakes offers incredible views in a luxury setting. This stunning 2 story with a walk-out basement is an entertainer's dream with luxury finishes throughout. The gourmet kitchen is impressive with a large island, JennAir appliances, and a walk-in pantry. The great room features a gorgeous 2

    Douglas Klein Group Harmony

    Section Image
  • 2366 Shoreside Dr, Berthoud, CO 80513

    $2,225,000

    • 5 Beds
    • 5 Baths
    • 5,080 Sq Ft
    • 2366 Shoreside Dr
    • Berthoud, CO

    A True Equestrian Waterfront Estate in Paradise Valley. Set on a 4.25 ac. lot w/2 primary suites on main living level, 2 additional bedrooms in Garden level basement in this 7,000+ sq ft. brick ranch w/ garden level basement. Offers a beautiful setting to enjoy Rocky Mountains sunsets t& stunning lakefront sunrises. This is a unique private lot, that allows horses/lg. animals & the opportunity to

    Allard Johnson Team C3 Real Estate Solutions, LLC

    Section Image
  • 1061 Berthoud Peak Dr, Berthoud, CO 80513

    $2,395,000

    • 5 Beds
    • 6 Baths
    • 5,231 Sq Ft
    • 1061 Berthoud Peak Dr
    • Berthoud, CO

    This new home is to be built in The Estates at Mathews Farm, also known as Belcara. Premier estate lot neighborhood just minutes from downtown Berthoud and TPC Colorado Golf Course, with convenient access to all of Northern Colorado. Situated on a spacious one-acre lot, this ranch home will have a Colorado contemporary design and feature a sprawling main level layout plus a finished basement. The

    Jessica Schroetlin Schroetlin Real Estate LLC

    Section Image
  • 420 E County Road 10, Berthoud, CO 80513

    $1,900,000

    • 5 Beds
    • 6 Baths
    • 4,713 Sq Ft
    • 420 E County Road 10
    • Berthoud, CO

    Amazing Horse Property, gorgeous Mountain Views and just minutes to Downtown. Berthoud and Loveland. This custom-Built Farmhouse is perfect for Multi-Generational Living. The main floor Primary Bedroom has a walk in Tub and 3/4 shower. Upstairs you will find 2 additional HUGE Bedrooms and a full Bath. The Basement has a 2 Bedrooms, 2 Bath, a Bonus Room, its own Kitchen and Laundry room accessed

    Ursula Albers RE/MAX Alliance-Loveland

    Section Image
  • 1720 Chaparro Cir, Berthoud, CO 80513

    $1,550,000

    • 5 Beds
    • 4.5 Baths
    • 5,728 Sq Ft
    • 1720 Chaparro Cir
    • Berthoud, CO

    The dream of Colorado living comes to life here. This exceptional peaceful rural property features a spacious main residence, a fully equipped guest house/ADU, plus a large shop or barn that offers exceptional flexibility-whether for work, recreation, hobbies, horses or farming. In every community, there are a few homes that truly stand out, offering a rare combination of comfort, functionality,

    Mike Bader RE/MAX of Boulder, Inc

    Section Image
  • 1255 Mill Creek Rd, Berthoud, CO 80513

    $1,595,000

    • 4 Beds
    • 4.5 Baths
    • 7,294 Sq Ft
    • 1255 Mill Creek Rd
    • Berthoud, CO

    Exciting update: Recent changes to Weld County and Colorado law now allow accessory buildings to be converted into ADUs (Accessory Dwelling Units). This beautiful rural 5 acre home currently has the perfect accessory building if you are looking to offset your housing expenses. This one owner, custom-built, well-maintained home is exceptional with an unfinished walk-out basement perfect to make

    Andrea Bisnette Realty One Group Fourpoints

    Section Image

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
The Mark And Tiffany Brodie Trust $1,739,556 None Listed On Document
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open The Mark And Tiffany Brodie Tr $1,154,257
Closed Mark And Tiffany Brodie Trust $181,900
Closed The Mark And Tiffany Brodie Trust $1,154,257
Previous Owner Custom On Site Builders Inc $1,250,587
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/11/2022 07/11/22 Sold $1,739,556 +4.1% $285 / Sq Ft
07/16/2021 07/16/21 Price Changed $1,671,003 +14.8% $274 / Sq Ft
05/08/2021 05/08/21 Price Changed $1,456,186 +1.5% $239 / Sq Ft
04/23/2021 04/23/21 Price Changed $1,435,241 +1.5% $235 / Sq Ft
03/23/2021 03/23/21 For Sale $1,414,711 -- $232 / Sq Ft
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 $15,785 $97,157 $17,909 $79,248
2024 $15,396 $97,157 $17,909 $79,248
2022 $6,141 $37,627 $16,819 $20,808
2021 $6,163 $37,961 $37,961 $0
2020 $6,016 $35,757 $35,757 $0
2019 $5,918 $35,757 $35,757 $0
2018 $862 $5,278 $5,278 $0
2017 $721 $5,278 $5,278 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: IRES MLS

MLS Number: 935923

IRES MLS

APN: 94044-30-028