Seller's Agent in 2023
Tamara Sherrill
RE/MAX
(970) 482-1781
19 in this area
483 Total Sales
2490 Southwind Rd Berthoud, CO 80513
Estimated Value: $2,973,000 - $3,110,256
4
Beds
7
Baths
5,819
Sq Ft
$521/Sq Ft
Est. Value
Highlights
- Water Views
- Fitness Center
- 0.49 Acre Lot
- Carrie Martin Elementary School Rated 9+
- New Construction
- Open Floorplan
About This Home
As of October 2023Designed by HGTV Fix my Flips stars Page Turner and Mitch Glew, as featured on season 4 of Rock the Block, this Alpine Chic design is nestled on a peaceful cul-de-sac. Escape to your private, unobstructed, 180 degree views of the Rookery, McNeil and Lone tree lakes w/ mountain views. Step into an entertainer's delight w/ stunning, luxury interior design in the gorgeous kitchen including double Calacatta marble, waterfall islands, built-in wine rack entrance to dining room with stone wall accent, and luxury primary bathroom complete with fireplace and oversized shower. Cleverly designed fitness studio off the connected back deck w/a glass garage door to open on perfect Colorado days. Continue the entertainment in the open-concept walk-out basement with a full kitchen, golf simulator, built in the bunk area, built-in outdoor grill & Traeger smoker. Step outdoors and sit by the fire pit in custom-made ski Adirondack chairs, or set up your outdoor chess set on the built-in cement board in the backyard. Experience a resort lifestyle in a one-of-a -kind, HGTV star designed home. Includes $40k TPC championship golf membership, access to luxury pool w/ swim up bar, oversized hot tub & concession cabana, fitness studio, golf lockers, & golf simulator. Lake club available with registration and fee. Sold fully furnished.
Home Details
Home Type
- Single Family
Year Built
- Built in 2022 | New Construction
Lot Details
- 0.49 Acre Lot
- Open Space
- Cul-De-Sac
- Southern Exposure
- Sprinkler System
- Property is zoned RL
Parking
- 3 Car Attached Garage
- Garage Door Opener
Property Views
- Water
- Mountain
Home Design
- Wood Frame Construction
- Concrete Roof
- Rough-in for Radon
- Stone
Interior Spaces
- 5,819 Sq Ft Home
- 1-Story Property
- Open Floorplan
- Wet Bar
- Bar Fridge
- Cathedral Ceiling
- Multiple Fireplaces
- Gas Fireplace
- Double Pane Windows
- Window Treatments
- Family Room
- Living Room with Fireplace
- Dining Room
- Home Office
- Wood Flooring
Kitchen
- Eat-In Kitchen
- Gas Oven or Range
- Microwave
- Dishwasher
- Kitchen Island
- Disposal
Bedrooms and Bathrooms
- 4 Bedrooms
- Walk-In Closet
- Primary bathroom on main floor
- Walk-in Shower
Laundry
- Laundry on main level
- Dryer
- Washer
Basement
- Walk-Out Basement
- Basement Fills Entire Space Under The House
- Sump Pump
Accessible Home Design
- Garage doors are at least 85 inches wide
Eco-Friendly Details
- Energy-Efficient HVAC
- Energy-Efficient Thermostat
Outdoor Features
- River Nearby
- Deck
- Patio
- Exterior Lighting
Location
- Mineral Rights Excluded
- Property is near golf course
Schools
- Carrie Martin Elementary School
- Bill Reed Middle School
- Thompson Valley High School
Utilities
- Humidity Control
- Forced Air Heating and Cooling System
- High Speed Internet
- Satellite Dish
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number R1661719
Community Details
Overview
- No Home Owners Association
- Built by Landmark Homes
- Heron Lakes Subdivision
Amenities
- Clubhouse
Recreation
- Fitness Center
- Community Pool
- Community Spa
- Park
- Hiking Trails
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 9, 2023
Closed on
Oct 2, 2023
Sold by
Project Xl Llc
Bought by
Kimball Trust and Kimball
Seller's Agent
Tamara Sherrill
RE/MAX Alliance-FTC Dwtn
Buyer's Agent
Aimee Welch
LIV Sotheby's Intl Realty
List Price
$3,250,000
Sold Price
$3,200,000
Premium/Discount to List
-$50,000
-1.54%
Views
194
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$166,581
Avg. Annual Appreciation
-2.15%
Original Mortgage
$1,800,000
Outstanding Balance
$1,757,485
Interest Rate
6.38%
Mortgage Type
New Conventional
Estimated Equity
$1,275,934
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Kimball Trust | $3,200,000 | None Listed On Document |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Kimball Trust | $1,800,000 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 10/02/2023 10/02/23 | Sold | $3,200,000 | -1.5% | $550 / Sq Ft |
| 07/26/2023 07/26/23 | Pending | -- | -- | -- |
| 07/13/2023 07/13/23 | Price Changed | $3,250,000 | 0.0% | $559 / Sq Ft |
| 07/13/2023 07/13/23 | For Sale | $3,250,000 | +1.6% | $559 / Sq Ft |
| 07/12/2023 07/12/23 | Off Market | $3,200,000 | -- | -- |
| 05/12/2023 05/12/23 | For Sale | $3,350,000 | -- | $576 / Sq Ft |
Source: IRES MLS
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 | $19,368 | $130,744 | $40,269 | $90,475 |
| 2024 | $18,890 | $118,369 | $32,656 | $85,713 |
| 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
Agents Affiliated with this Home
-
Tamara Sherrill
-
Aimee Welch
Buyer's Agent in 2023
Aimee Welch
LIV Sotheby's Intl Realty
(970) 420-4640
17 in this area
35 Total Sales
Map
Source: IRES MLS
MLS Number: IRE987354
APN: 94044-29-015
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.
Information source: Information and Real Estate Services, LLC. Provided for limited non-commercial use only under IRES Rules © Copyright IRES.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website. 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.
Based on information submitted to the MLS GRID
Nearby Homes
- 2517 Southwind Rd
- 2668 Big Creek Ct
- 2672 Bluewater Rd
- 2635 Southwind Rd
- 2669 Southwind Rd
- 2622 Bluewater Rd
- 2554 Southwind Rd
- 2568 Southwind Rd
- 2682 Southwind Rd
- 2664 Southwind Rd
- 2734 Southwind Rd
- 2774 Heron Lakes Pkwy
- 2766 Heron Lakes Pkwy
- 2761 Heron Lakes Pkwy
- 2675 Heron Lakes Pkwy
- 2805 Potomac Ct
- 2806 Potomac Ct
- 2923 Heron Lakes Pkwy
- 2116 Scottsdale Rd
- 2100 Scottsdale Rd
- 2506 Southwind Rd
- 2531 Southwind Rd
- 2657 Big Creek Ct
- 2643 Big Creek Ct
- 2654 Big Creek Ct
- 2636 Big Creek Ct
- 2627 Big Creek Ct
- 2622 Big Creek Ct
- 2660 Bluewater Rd
- 2685 Bluewater Rd
- 2684 Bluewater Rd
- 2697 Bluewater Rd
- 2653 Bluewater Rd
- 2552 Bluewater Rd
- 2612 Bluewater Rd
- 2598 Bluewater Rd
- 2673 Bluewater Rd
- 2696 Bluewater Rd
- 2677 Southwind Rd
- 2685 Southwind Rd
Your Personal Tour Guide
Ask me questions while you tour the home.