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 enjoy the unobstructed views 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.
Sold for $2,850,000
$2,850,000
2506 Southwind Rd, Berthoud, CO 80513
5beds
5,811sqft
Single Family Residence
Built in 2022
0.4 Acres Lot
$3,447,800 Zestimate®
$490/sqft
$5,075 Estimated rent
Home value
$3,447,800
$3.07M - $3.90M
$5,075/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$5,075/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,075/mo
Rent Zestimate®
Refinance and save
$16,269/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$16,269/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 20, 2025 at 06:44pm
Listed by:
Tamara Sherrill 9704821781,
RE/MAX Alliance-FTC Dwtn
Bought with:
Andrea Tuell, 40042886
Group Harmony
Source: IRES,MLS#: 987350
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 8
- Full bathrooms: 5
- 1/2 bathrooms: 3
- Main level bathrooms: 4
Primary bedroom
- Description: Wood
- Features: Luxury Features Primary Bath
- Level: Main
- Area: 256 Square Feet
- Dimensions: 16 x 16
Bedroom 2
- Description: Carpet
- Level: Main
- Area: 180 Square Feet
- Dimensions: 12 x 15
Bedroom 3
- Description: Carpet
- Level: Basement
- Area: 154 Square Feet
- Dimensions: 14 x 11
Bedroom 4
- Description: Carpet
- Level: Basement
- Area: 192 Square Feet
- Dimensions: 12 x 16
Bedroom 5
- Description: Wood
- Level: Basement
- Area: 224 Square Feet
- Dimensions: 16 x 14
Dining room
- Description: Wood
- Level: Main
- Area: 165 Square Feet
- Dimensions: 11 x 15
Family room
- Description: Wood
- Level: Basement
- Area: 589 Square Feet
- Dimensions: 31 x 19
Kitchen
- Description: Wood
- Level: Main
- Area: 368 Square Feet
- Dimensions: 23 x 16
Laundry
- Description: Wood
- Level: Main
- Area: 54 Square Feet
- Dimensions: 9 x 6
Living room
- Description: Wood
- Level: Main
- Area: 380 Square Feet
- Dimensions: 20 x 19
Recreation room
- Description: Wood
- Level: Basement
- Area: 266 Square Feet
- Dimensions: 19 x 14
Study
- Description: Brick
- Level: Main
- Area: 48 Square Feet
- Dimensions: 8 x 6
Heating
- Forced Air, 2 or more Heat Sources, Humidity Control, 2 or more H20 Heaters
Appliances
- Included: Gas Range, Dishwasher, Refrigerator, Bar Fridge, Washer, Dryer, Disposal
- Laundry: Sink, Washer/Dryer Hookup
Features
- Eat-in Kitchen, Separate Dining Room, Cathedral Ceiling(s), Open Floorplan, Pantry, Walk-In Closet(s), Wet Bar, Kitchen Island, High Ceilings, Beamed Ceilings
- Flooring: Wood
- Windows: Window Coverings, Wood Frames
- Basement: Full,Partially Finished,Walk-Out Access,Rough-in for Radon,Sump Pump
- Has fireplace: Yes
- Fireplace features: Two or More, Gas, Living Room, Bedroom
Interior area
- Total structure area: 5,811
- Total interior livable area: 5,811 sqft
- Finished area above ground: 3,129
- Finished area below ground: 2,682
Property
Parking
- Total spaces: 3
- Parking features: Garage Door Opener, >8' Garage Door, Oversized
- Attached garage spaces: 3
- Details: Attached
Accessibility
- Accessibility features: Low Carpet, Main Floor Bath, Accessible Bedroom, Stall Shower, Main Level Laundry
Features
- Levels: One
- Stories: 1
- Patio & porch: Patio, Deck
- Exterior features: Sprinkler System
- Spa features: Community
- Has view: Yes
- View description: Water
- Has water view: Yes
- Water view: Water
- Waterfront features: Abuts Pond/Lake
Lot
- Size: 0.40 Acres
- Features: Cul-De-Sac, Near Golf Course, Paved, Curbs, Gutters, Sidewalks, Street Light, Mineral Rights Excluded
Details
- Parcel number: R1661718
- Zoning: RL
- Special conditions: Builder
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Frame, Stone
- Foundation: Structural Floor
- Roof: Tile
Condition
- New construction: Yes
- Year built: 2022
Details
- Builder name: Landmark Homes
Utilities & green energy
- Electric: REA
- Gas: XCEL
- Sewer: Public Sewer
- Water: City
- Utilities for property: Natural Gas Available, Electricity Available, Cable Available, Satellite Avail, High Speed Avail
Green energy
- Energy efficient items: Windows, High Efficiency Furnace, Thermostat
Community & neighborhood
Security
- Security features: Fire Alarm, Security Gate
Community
- Community features: Clubhouse, Pool, Fitness Center, Park, Trail(s)
Location
- Region: Berthoud
- Subdivision: Heron Lakes
Other
Other facts
- Listing terms: Cash,Conventional,VA Loan
- Road surface type: Asphalt
Price history
| Date | Event | Price |
|---|---|---|
| 2/28/2024 | Sold | $2,850,000-7.9%$490/sqft |
Source:  IRES #987350 Report a problem | ||
| 1/26/2024 | Pending sale | $3,095,000$533/sqft |
Source:  REcolorado #IR987350 Report a problem | ||
| 11/28/2023 | Listed for sale | $3,095,000$533/sqft |
Source: REcolorado #IR987350 Report a problem | ||
| 11/25/2023 | Pending sale | $3,095,000$533/sqft |
Source: REcolorado #IR987350 Report a problem | ||
| 11/10/2023 | Price change | $3,095,000-1.7%$533/sqft |
Source: REcolorado #IR987350 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,Loveland Classical
- Middle: Bill Reed
- High: Thompson Valley
Source: IRES. 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,447,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,447,800
- Colorado
- Larimer County
- Berthoud
- 80513
- 2506 Southwind Rd