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
$3,200,000
2490 Southwind Road, Berthoud, CO 80513
--beds
0baths
5,819sqft
Single Family Residence
Built in 2022
0.49 Acres Lot
$3,542,800 Zestimate®
$550/sqft
$5,238 Estimated rent
Home value
$3,542,800
$3.08M - $4.00M
$5,238/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$5,238/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$5,238/mo
Rent Zestimate®
Refinance and save
$17,914/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$17,914/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat'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,542,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,542,800
- Colorado
- Larimer County
- Berthoud
- 80513
- 2490 Southwind Road