Overview
Monthly cost
Get pre-approved
Fees & commissions
Related

Save

Active

Buy a house

$2,995,000

$3,150,000 (-4.92%)

$0/mo

Get pre-approved

Residential

5,820 Sq. Ft.

16,117 Sq. Ft. lot

4 Bedrooms

6 Bathrooms

333 Days on market

8408291 MLS ID

Click to interact

Click the map to interact

About not provided house

Seize a rare opportunity to own a home designed by HGTV Luxe for Less stars Michel Smith Boyd & Anthony Elle, as featured on season 4 of Rock the Block. This Modern Mountain design is nestled on a peaceful cul-de-sac in the gated Rookery portion of Heron Lakes. Gorgeous, luxury interior finishes throughout, including drop down island in kitchen, 60 range from Italy, designer wallpaper, ceiling accents, custom arched , stained French doors in kitchen, custom panel appliances, beautiful wood accents in exterior covered patios, two full kitchens, & a must see speak easy. Entertain in the expansive walk-out basement complete with a full kitchen and accordion windows connecting to the outdoor built in bar top. 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: 2691

Building Area Total: 3129

Construction Materials: "Stone", "Concrete"

Lower Sq Ft: 2691

Living Area: 5820

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: 4

Bathrooms Half: 2

Bathrooms Three Quarter: 1

Bathrooms Total Integer: 7

Baths Full Additional: 0

Baths Full Basement: 2

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.33503

Longitude: -105.119392

MLS Area Major: Loveland/Berthoud

Postal Code: 80513

State Or Province: CO

Street Name: Southwind

Street Number: 2531

Street Suffix: Rd

Subdivision Name: Heron Lakes

Unparsed Address: 2531 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: "Gas", "Living Room", "Family/Recreation Room Fireplace", "Basement"

Fireplace YN: t

Energy Saving

Green Energy Efficient: "Thermostat"

Heating

Heating: "Forced Air", "Hot Water", "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"

Great Room

Great Room Length: 14

Great Room Level Code: Basement

Great Room Width: 19

Family Room

Has Family Room: t

Room Family Room Area: 912

Room Family Room Length: 38

Room Family Room Level: Basement

Room Family Room Width: 24

Home Owner's Association

Has HOA Covenants: t

Taxes

Has Metro Tax District: Yes

Tax Year: 2023

Water

Has Water Rights: No

Water Source: "City Water"

Laundry

Laundry Room Length: 18

Laundry Room Width: 8

Laundry Features: "Main Level"

Recreation Room

Rec Room Length: 14

Rec Room Level Code: Basement

Rec Room Width: 16

Sitting Room

Study Length: 12

Study Level Code: Main

Study Width: 13

Interior Features

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

Listing

Listing Id: 8408291

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

List Price: 2995000

Mls Status: Active

Special Listing Conditions: "Builder"

Standard Status: Active

Lot

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

Lot Size Acres: 0.37

Lot Size Area: 16117

Lot Size Square Feet: 16117

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: 368

Room Kitchen Length: 16

Room Kitchen Level: Main

Room Kitchen Width: 23

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

$18,461/mo

Principal & interest

$15,941/mo

Mortgage insurance

$0/mo

Property taxes

$1,273/mo

Home insurance

$1,248/mo

HOA fees

$0/mo

Utilities

$0/mo

All calculations are estimates and provided 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	$2,815,300	+$89,850 $2,905,150
Seller agent commission	$89,850 (3%)*	$0 (0%)
Buyer agent commission	$89,850 (3%)*	$89,850 (3%)*

*Commissions are based on national averages and not intended to represent actual commissions of this property

Get $89,850 more selling your home
with a Unreal Estate agent

Start free MLS listing

View related pages

State

Unreal Estate checked: Aug 8, 2023 at 4:37 p.m.

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

Courtesy of Tamara Sherrill, RE/MAX Alliance -Downtown Lharris@homeincolorado.com

This content last updated on 07/18/2023. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.

Provided for limited non-commercial use only under IRES Rules. 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.

Properties near not provided

info@unrealestate.com

(866) 534-3726

About

Buy Sell Mortgage Agents Company

Resources

Find a Home Get Listed on the MLS Blog Submit an Offer Request a Showing Feedback

Legal

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: 1500 Conrad Weiser Parkway, Womelsdorf, PA 19567
California DRE #01527504
New York § 442-H Standard Operating Procedures
TREC: Info About Brokerage Services, Consumer 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.