Designed 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.
Sold for $3,200,000 on 10/05/23
$3,200,000
2490 Southwind Road, Berthoud, CO 80513
--beds
0baths
5,819sqft
Single Family Residence
Built in 2022
0.49 Acres Lot
$3,216,800 Zestimate®
$550/sqft
$4,353 Estimated rent
Home value
$3,216,800
$2.83M - $3.63M
$4,353/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: October 05, 2023 at 07:09am
Listed by:
Tamara Sherrill Lharris@homeincolorado.com,
RE/MAX Alliance -Downtown
Bought with:
Aimee J Welch, 100092642
LIV Sotheby's Intl Realty
Source: REcolorado,MLS#: 9949099
Facts & features
Interior
Bedrooms & bathrooms
- Bathrooms: 0
- Main level bathrooms: 4
- Main level bedrooms: 2
Primary bedroom
- Description: Wood
- Level: Main
- Area: 240 Square Feet
- Dimensions: 16 x 15
Bedroom
- Description: Wood
- Level: Main
- Area: 180 Square Feet
- Dimensions: 12 x 15
Bedroom
- Description: Carpet
- Level: Basement
- Area: 154 Square Feet
- Dimensions: 14 x 11
Bedroom
- Description: Carpet
- Level: Basement
- Area: 180 Square Feet
- Dimensions: 12 x 15
Primary bathroom
- Level: Main
Bathroom
- Level: Main
Bathroom
- Level: Basement
Bathroom
- Level: Basement
Bathroom
- Level: Main
Bathroom
- Level: Basement
Bathroom
- Level: Main
Dining room
- Description: Wood
- Level: Main
- Area: 165 Square Feet
- Dimensions: 11 x 15
Family room
- Description: Wood
- Level: Basement
- Area: 420 Square Feet
- Dimensions: 21 x 20
Game room
- Description: Wood
- Level: Basement
- Area: 266 Square Feet
- Dimensions: 19 x 14
Great room
- Description: Wood
- Level: Basement
- Area: 468 Square Feet
- Dimensions: 26 x 18
Kitchen
- Description: Wood
- Level: Main
- Area: 368 Square Feet
- Dimensions: 23 x 16
Laundry
- Description: Tile
- Level: Main
- Area: 88 Square Feet
- Dimensions: 8 x 11
Living room
- Description: Wood
- Level: Main
- Area: 400 Square Feet
- Dimensions: 20 x 20
Office
- Description: Wood
- Level: Main
- Area: 156 Square Feet
- Dimensions: 13 x 12
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Bar Fridge, Dishwasher, Disposal, Dryer, Humidifier, Microwave, Oven, Refrigerator, Washer
- Laundry: In Unit
Features
- Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Smart Thermostat, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar
- Flooring: Tile, Wood
- Windows: Double Pane Windows, Window Coverings
- Basement: Full,Sump Pump,Walk-Out Access
- Has fireplace: Yes
- Fireplace features: Gas, Living Room
Interior area
- Total structure area: 5,819
- Total interior livable area: 5,819 sqft
- Finished area above ground: 3,129
- Finished area below ground: 2,540
Property
Parking
- Total spaces: 3
- Parking features: Oversized, Oversized Door
- Attached garage spaces: 3
Features
- Levels: One
- Stories: 1
- Patio & porch: Deck, Patio
- Has view: Yes
- View description: Mountain(s), Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Pond
Lot
- Size: 0.49 Acres
- Features: Cul-De-Sac, Open Space, Sprinklers In Front
Details
- Parcel number: R1661719
- Zoning: RL
- Special conditions: Standard
- Other equipment: Satellite Dish
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Stone
- Foundation: Structural
- Roof: Concrete
Condition
- New Construction
- New construction: Yes
- Year built: 2022
Details
- Builder name: Landmark Homes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Cable Available, Internet Access (Wired), Natural Gas Available
Community & neighborhood
Security
- Security features: Smoke Detector(s)
Location
- Region: Berthoud
- Subdivision: Heron Lakes
Other
Other facts
- Listing terms: Cash,Conventional,VA Loan
- Ownership: Builder
- Road surface type: Paved
Price history
| Date | Event | Price |
|---|---|---|
| 10/5/2023 | Sold | $3,200,000-1.5%$550/sqft |
Source:  REcolorado #9949099 Report a problem | ||
| 7/26/2023 | Pending sale | $3,250,000$559/sqft |
Source:  IRES #987354 Report a problem | ||
| 7/13/2023 | Price change | $3,250,000-3%$559/sqft |
Source: IRES #987354 Report a problem | ||
| 5/12/2023 | Listed for sale | $3,350,000$576/sqft |
Source: IRES #987354 Report a problem | ||
Public tax history
Tax history is unavailable.
Neighborhood: 80513
Nearby schools
GreatSchools rating
- 9/10Carrie Martin Elementary SchoolGrades: PK-5Distance: 1.5 mi
- 4/10Bill Reed Middle SchoolGrades: 6-8Distance: 4.7 mi
- 6/10Thompson Valley High SchoolGrades: 9-12Distance: 3.8 mi
Schools provided by the listing agent
- Elementary: Carrie Martin
- Middle: Bill Reed
- High: Thompson Valley
- District: Thompson R2-J
Source: REcolorado. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,216,800
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$3,216,800