Upgrade
Photo 1 of 39 of not provided house
Photo 2 of 39 of not provided house
Photo 3 of 39 of not provided house
Photo 4 of 39 of not provided house
Photo 5 of 39 of not provided house
Photo 6 of 39 of not provided house
Photo 7 of 39 of not provided house
Photo 8 of 39 of not provided house
Photo 9 of 39 of not provided house
Photo 10 of 39 of not provided house
Photo 11 of 39 of not provided house
Photo 12 of 39 of not provided house
Photo 13 of 39 of not provided house
Photo 14 of 39 of not provided house
Photo 15 of 39 of not provided house
Photo 16 of 39 of not provided house
Photo 17 of 39 of not provided house
Photo 18 of 39 of not provided house
Photo 19 of 39 of not provided house
Photo 20 of 39 of not provided house
Photo 21 of 39 of not provided house
Photo 22 of 39 of not provided house
Photo 23 of 39 of not provided house
Photo 24 of 39 of not provided house
Photo 25 of 39 of not provided house
Photo 26 of 39 of not provided house
Photo 27 of 39 of not provided house
Photo 28 of 39 of not provided house
Photo 29 of 39 of not provided house
Photo 30 of 39 of not provided house
Photo 31 of 39 of not provided house
Photo 32 of 39 of not provided house
Photo 33 of 39 of not provided house
Photo 34 of 39 of not provided house
Photo 35 of 39 of not provided house
Photo 36 of 39 of not provided house
Photo 37 of 39 of not provided house
Photo 38 of 39 of not provided house
Photo 39 of 39 of not provided house
  • Overview

  • Monthly cost

  • Get pre-approved

  • Fees & commissions

  • Related

  • Intelligence reports

Save

Off market

Buy a house

$3,450,000

$0/mo

Get pre-approved

Residential

5,819 Sq. Ft.

20,473 Sq. Ft. lot

4 Bedrooms

8 Bathrooms

717 Days on market

2068780 MLS ID

Click to interact

Property position on map

Click the map to interact

Intelligence

Investor Highlights
Price per square foot history
Property sales history

Subscribe to Intelligence

Discover advanced property insights, stats and many more.

Learn More

About not provided house

Enjoy a rare opportunity to own a home designed by HGTV Renovation Island stars Bryan and Sarah Baumler, as featured on season 4 of Rock the Block. This Aspen Chalet design is nestled on a peaceful cul-de-sac in the gated Rookery portion of Heron Lakes. Instantly relax w/ the soothing finishes and unobstructed views of the Rookery, Lone tree reservoir & the Rocky Mountains. Each luxury, interior design showcases custom finishes thoughtfully and meticulously planned. This stunning, open concept plan features Calacatta double marble, waterfall islands facing mountain and water views. Special touches throughout the home create a spa-like feel. Retreat to the study tucked at the back of the home off the garage w/ a glass garage door connecting you to the back deck to enjoy beautiful Colorado days. Experience a true get away right in your own home in the spa wing in the walk-out basement, complete with Chromotherapy infinity tub, sauna and massage room. 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.
Enjoy a rare opportunity to own a home designed by HGTV Renovation Island stars Bryan and Sarah Baumler, as featured on season 4 of Rock the Block. This Aspen Chalet design is nestled on a peaceful cul-de-sac in the gated Rookery portion of Heron Lakes. Instantly relax w/ the soothing finishes and unobstructed views of the Rookery, Lone tree reservoir & the Rocky Mountains. Each luxury, interior design showcases custom finishes thoughtfully and meticulously planned. This stunning, open concept plan features Calacatta double marble, waterfall islands facing mountain and water views. Special touches throughout the home create a spa-like feel. Retreat to the study tucked at the back of the home off the garage w/ a glass garage door connecting you to the back deck to enjoy beautiful Colorado days. Experience a true get away right in your own home in the spa wing in the walk-out basement, complete with Chromotherapy infinity tub, sauna and massage room. 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.

Property details

House

Above Grade Finished Area: 3129

Architectural Style: "Ranch"

Below Grade Finished Area: 2690

Building Area Total: 3129

Construction Materials: "Stone"

Lower Sq Ft: 2690

Living Area: 5819

Living Area Source: Plans

Living Area Units: Square Feet

New Construction YN: t

Stories: 1

Year Built: 2022

Appliances and Equipment

Appliances: "Dishwasher", "Refrigerator", "Washer", "Dryer", "Microwave", "Disposal"

Garage

Attached Garage YN: t

Covered Spaces: 3

Garage Spaces: 3

Garage YN: t

Garage Type: Attached

Basement

Basement: "Full", "Walk-Out Access", "Structural Floor", "Sump Pump"

Bathrooms

Bathrooms Full: 5

Bathrooms Half: 3

Bathrooms Total Integer: 8

Baths Full Additional: 0

Baths Full Basement: 3

Baths Half Additional: 0

Baths Half Basement: 1

Baths Three Quarters Additional: 0

Baths Three Quarters Basement: 0

Baths Three Quarters Lower: 0

Baths Three Quarters Upper: 0

Bedrooms

Bedrooms Total: 4

Location

City: Berthoud

Country: US

County Or Parish: Larimer

Locale: Berthoud

Latitude: 40.334648

Longitude: -105.119583

MLS Area Major: Loveland/Berthoud

Postal Code: 80513

State Or Province: CO

Street Name: Southwind

Street Number: 2517

Street Suffix: Rd

Subdivision Name: Heron Lakes

Unparsed Address: 2517 Southwind Rd Berthoud CO 80513

Cooling

Cooling: "Central Air"

Cooling YN: t

Utilities

Electric: "Electric"

Gas: "Natural Gas"

Utilities: "Natural Gas Available", "Electricity Available", "Cable Available"

Schools

Elementary School: Carrie Martin

High School: Thompson Valley

High School District: Thompson R2-J

Middle Or Junior School: Bill Reed

Fireplaces

Fireplace Features: "Living Room", "Family/Recreation Room Fireplace"

Fireplace YN: t

Energy Saving

Green Energy Efficient: "Thermostat"

Heating

Heating: "Forced Air", "Humidity Control"

Heating YN: t

Property

Crops: None

Property Condition: "New, Unknown Status"

Property Sub Type: Residential-Detached

Property Type: Residential

Road Surface Type: "Paved"

View: "Mountain(s)", "Water"

Water Body Name: Pond

Waterfront Features: "Abuts Pond/Lake"

Waterfront YN: t

Family Room

Has Family Room: t

Room Family Room Area: 304

Room Family Room Length: 19

Room Family Room Level: Basement

Room Family Room Width: 16

Taxes

Has Metro Tax District: Yes

Tax Year: 2023

Water

Has Water Rights: No

Water Source: "City Water"

Laundry

Laundry Room Length: 7

Laundry Room Width: 7

Laundry Features: "In Basement"

Sitting Room

Study Length: 15

Study Level Code: Main

Study Width: 18

Interior Features

Interior Features: "Study Area", "Eat-in Kitchen", "Cathedral/Vaulted Ceilings", "Open Floorplan", "Pantry", "Walk-In Closet(s)", "Sauna", "Wet Bar", "Kitchen Island"

Listing

Listing Id: 2068780

Listing Terms: "Cash", "Conventional", "VA Loan"

List Price: 3450000

Mls Status: Pending

Special Listing Conditions: "Builder"

Standard Status: Pending

Lot

Lot Features: "Lawn Sprinkler System", "Cul-De-Sac"

Lot Size Acres: 0.47

Lot Size Area: 20473

Lot Size Square Feet: 20473

Lot Size Units: Square Feet

Parking

Parking Features: ">8' Garage Door", "Oversized"

Exterior Features

Patio And Porch Features: "Patio", "Deck"

Second Bedroom

Room Bedroom 2 Area: 180

Room Bedroom 2 Length: 15

Room Bedroom 2 Level: Main

Room Bedroom 2 Width: 12

Third Bedroom

Room Bedroom 3 Area: 180

Room Bedroom 3 Length: 15

Room Bedroom 3 Level: Basement

Room Bedroom 3 Width: 12

Fourth Bedroom

Room Bedroom 4 Area: 154

Room Bedroom 4 Length: 11

Room Bedroom 4 Level: Basement

Room Bedroom 4 Width: 14

Dining Room

Room Dining Room Area: 165

Room Dining Room Length: 15

Room Dining Room Level: Main

Room Dining Room Width: 11

Kitchen

Room Kitchen Area: 320

Room Kitchen Length: 16

Room Kitchen Level: Main

Room Kitchen Width: 20

Living Room

Room Living Room Area: 380

Room Living Room Length: 19

Room Living Room Level: Main

Room Living Room Width: 20

Primary Bedroom

Room Master Bathroom Features: "Full Primary Bath"

Room Master Bedroom Area: 240

Room Master Bedroom Length: 15

Room Master Bedroom Level: Main

Room Master Bedroom Width

Windows

Window Features: "Window Coverings", "Double Pane Windows"

Monthly cost

Estimated monthly cost

$21,266/mo

All calculations are estimates and provided by Unreal Estate, Inc. for informational purposes only. Actual amounts may vary.

Seller fees & commissions

Home sale price

$

Outstanding mortgage

$

Selling with traditional agent

Selling with Unreal Estate agent

Your total sale proceeds$3,243,000

+$103,500

$3,346,500

Seller agent commission$103,500 (3%)*

$0 (0%)

Buyer agent commission$103,500 (3%)*

$103,500 (3%)*

*Commissions are based on national averages and not intended to represent actual commissions of this property All calculations are estimates and provided by Unreal Estate, Inc. for informational purposes only. Actual amounts may vary.

Get $103,500 more selling your home
with an Unreal Estate agent

Start free MLS listing
View related pages

State

  • Mobile Homes for sale in Colorado
  • Real Estate for Sale in Colorado

Unreal Estate checked: Sep 10, 2024 at 1:32 p.m.

Data updated: Jul 18, 2023 at 4:44 p.m.

Learn more about this property

Request edits for this property

By proceeding, you consent to receive calls and texts at the number you provided, including marketing by autodialer and prerecorded and artificial voice, and email, from unrealestate.com and others about your inquiry and other home related matters, but not as a condition of any purchase.
*By checking this box, I confirm that I am the legal owner of the property listed. Please note, all information is verified for accuracy per U.S. real estate regulations, and submissions from non-owners cannot be processed.

Properties near not provided

Unreal Estate stacked logo

About

BuySellMortgageAgentsCompany

Updated January 2023: By using this website, you agree to our Terms of Service, and Privacy Policy.

⁠Unreal Estate holds real estate brokerage licenses under the following names in multiple states and locations:
Unreal Estate LLC (f/k/a USRealty.com, LLP)
Unreal Estate LLC (f/k/a USRealty Brokerage Solutions, LLP)
Unreal Estate Brokerage LLC
Unreal Estate Inc. (f/k/a Abode Technologies, Inc. (dba USRealty.com))
Main Office Location: 991 Hwy 22, Ste. 200, Bridgewater, NJ 08807
California DRE #01527504
New York § 442-H Standard Operating Procedures
TREC: Info About Brokerage ServicesConsumer Protection Notice

UNREAL ESTATE IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT.

If you are using a screen reader, or having trouble reading this website, please call Unreal Estate Customer Support for help at 1-866-534-3726 
Open Monday – Friday 9:00 – 5:00 EST with the exception of holidays.

*See Terms of Service for details.

LinkedIn Social IconInstagram social iconFacebook social icontwitter social iconYoutube Social Icon

© 2023 Unreal Estate Inc. All Rights Reserved.

Unreal Estate certified trust badge
LinkedIn Social IconInstagram social iconFacebook social icontwitter social iconYoutube Social Icon