Overview
Monthly cost
Get pre-approved
Fees & commissions
Related

Save

Active

Buy a house

$3,150,000

$3,250,000 (-3.08%)

$0/mo

Get pre-approved

Residential

5,811 Sq. Ft.

16,117 Sq. Ft. lot

5 Bedrooms

8 Bathrooms

340 Days on market

6724183 MLS ID

Click to interact

Click the map to interact

About not provided house

Enjoy the ultimate Colorado lifestyle by owning a home designed by HGTV Farmhouse Fixers stars Jonathan Knight and Kristina Crestin. This Modern Farm- house design is nestled on a peaceful cul-de-sac with unobstructed views of McNeil lake and open space. Gorgeous, luxury interior design and custom finishes throughout, including an oversized curved marble kitchen island, inviting back kitchen full of light and storage. Gather to the Colorado room to enjoy integrated indoor/outdoor living complete w/ kegerator and full glass garage door off the outdoor, built in grill and smoker. Entertain in the open concept walk-out basement w/ pub bar, arcade games, dedicated pool room, bunk room and open living space w/ 2 additional guest en-suites. Step outdoors and play on your own bocce court or sit by the sunken fire pit overlooking McNeil Lake. 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: 2682

Building Area Total: 3129

Construction Materials: "Stone"

Lower Sq Ft: 2682

Living Area: 5811

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", "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: 5

Location

City: Berthoud

Country: US

County Or Parish: Larimer

Locale: Berthoud

Latitude: 40.334621

Longitude: -105.118736

MLS Area Major: Loveland/Berthoud

Postal Code: 80513

State Or Province: CO

Street Name: Southwind

Street Number: 2506

Street Suffix: Rd

Subdivision Name: Heron Lakes

Unparsed Address: 2506 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", "Primary Bedroom"

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: "Water"

Water Body Name: Pond

Waterfront Features: "Abuts Pond/Lake"

Waterfront YN: t

Family Room

Has Family Room: t

Room Family Room Area: 589

Room Family Room Length: 19

Room Family Room Level: Basement

Room Family Room Width: 31

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

Laundry Room Width: 9

Laundry Features: "Main Level"

Recreation Room

Rec Room Length: 14

Rec Room Level Code: Basement

Rec Room Width: 19

Sitting Room

Study Length: 6

Study Level Code: Main

Study Width: 8

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

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

List Price: 3150000

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

Room Bedroom 2 Length: 14

Room Bedroom 2 Level: Basement

Room Bedroom 2 Width: 16

Third Bedroom

Room Bedroom 3 Area: 192

Room Bedroom 3 Length: 16

Room Bedroom 3 Level: Basement

Room Bedroom 3 Width: 12

Fourth Bedroom

Room Bedroom 4 Area: 180

Room Bedroom 4 Length: 15

Room Bedroom 4 Level: Main

Room Bedroom 4 Width: 12

Fifth Bedroom

Room Bedroom 5 Area: 154

Room Bedroom 5 Length: 11

Room Bedroom 5 Level: Basement

Room Bedroom 5 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: 256

Room Master Bedroom Length: 16

Room Master Bedroom Level: Main

Room Master Bedroom Width

Windows

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

Monthly cost

Estimated monthly cost

$19,417/mo

Principal & interest

$16,766/mo

Mortgage insurance

$0/mo

Property taxes

$1,339/mo

Home insurance

$1,313/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,961,000	+$94,500 $3,055,500
Seller agent commission	$94,500 (3%)*	$0 (0%)
Buyer agent commission	$94,500 (3%)*	$94,500 (3%)*

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

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

Start free MLS listing

View related pages

State

Unreal Estate checked: Apr 22, 2024 at 12:25 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.