6 hours on Market

240074 Highway 546, Rural Foothills County, Alberta T0L 2A0

Detached
8
9 + 2
~17808.21 sqft
$3,350,000
Get pre-qualifiedPowered by nesto
Detached
8
9 + 2
~17808.21 sqft

Contact us about this property

Call

Highlights

Property Estimate

Days on market6 hours

Estimated valueNot available

Price/Sqft$188/sqft

Monthly cost

Open Calculator

Description

Welcome to a home built for the art of gathering — a place where generations come together, friends linger long past sunset, and the Rocky Mountain horizon stretches endlessly before you. Nestled in the foothills west of Diamond Valley, this magnificent 17,808 sq ft estate captures the timeless spirit of 1978 country living. Follow the sweeping, evergreen-lined paved driveway as it climbs to reveal one of Alberta's most breathtaking panoramic mountain and Sheep River valley views that will stop you in your tracks and greet you every single morning. Step through the doors of this oversized mansion and into living room where walls of windows frame the mountains like living art, anchored by a spectacular floor-to-ceiling natural stone and wood-burning fireplace. The bright, spacious kitchen is outfitted for serious entertaining with a high end gas range and Asko dishwasher, while the formal dining room sets the stage for memorable gatherings. Beyond the main living spaces, discover room after room designed for every mood and occasion, a cozy den with its own fireplace, a generous family room, a games/rec room, dedicated music room, a gun room, and a wine cellar waiting to be stocked. An in-home elevator connects the floors with effortless ease. Seven guest and family bedrooms plus separate staff quarters ensure everyone has their own retreat, with each room positioned to drink in those stunning foothills and mountain views. When it's time to escape, the master bedroom wing awaits. This self-contained retreat features a sun-filled living area, a natural stone fireplace, a generous walk-in closet, a luxurious 5pc ensuite, and a dedicated dressing/glam room — your own personal haven at the end of the day. Behind the scenes, a massive 40 x 30 ft utility room with 12-foot ceilings houses the cistern, boilers, walk-in refrigerators, and a full backup generator — ensuring this estate runs seamlessly in any weather. A 1723 sq ft, six-car attached garage, and workshop provides room for every vehicle, toy, and project. Time for the The Great Outdoors for this is where this property truly comes alive with a fully landscaped yard, private tennis court, indoor swimming pool, and a year-round pond. The eight-stall hip-roof barn is ready for your horses, and the surrounding landscape, is a mosaic of hay fields, open pasture, aspen, and towering spruce, to ride, roam, and explore. Whether you're saddling up or lacing up your hiking boots. the legendary trails of Kananaskis are just minutes away — Sandy McNabb is 10 min, and Blue Rock only 25 min, A separate 858 sq ft bi-level residence on the property is ideal for retired parents, a full-time groundskeeper, or guests, offering privacy and independence. Despite its idyllic seclusion, daily life is effortless: 15 minutes to Oilfields Hospital, 30 minutes to Okotoks for Costco, Home Depot, and Walmart, and just one hour to Calgary Int Airport. This is more than a home— it's a lifestyle. Step into life west of Diamond Valley.


Property Details

Style3 Level Split,Acreage with Residence
View-
Age of property1978
SqFt~17808.21 SqFt
Lot Size-
Parking Spaces-
MLS ®NumberA2304112
Community NameFoothills County
Data SourcePILLAR 9
Listing byColdwell Banker Mountain Central

Features

Heating: In Floor,Forced Air,Hot Water,Natural Gas
Basement: Full,Finished,Walk Out

Main Floor

2pc Bathroom

5`5" x 6`4"

4pc Bathroom

11`10" x 8`9"

6pc Bathroom

15`1" x 14`6"

Foyer

14`7" x 27`5"


Features

Patio: Awning(s),Deck,Patio
Pool: Indoor

Property History

May 5, 2026
ListedActive
$3,350,000
6 hours on market
history photo preview50
Listing by pillar 9®
Property listed by Coldwell Banker Mountain Central, Brokerage
Agent Banner Image
Interested in this property?Get in touch to get the inside scoop.

Market Data - Foothills County

Geo Zone Map ThumbnailFoothills County

Seller's Market

View Market Data

Detached house - for the past 30 days

Buyer's market Seller's market

Avg. Days on Market

Past 30 days

32 days

Compared to

2025

28 days

2024

38 days

2023

33 days

New Listings

Past 30 days

147 listings

Compared to

2025

163 listings

2024

132 listings

2023

143 listings

Units sold

Past 30 days

94 units

Compared to

2025

81 units

2024

83 units

2023

93 units

Median Sold Price

Past 30 days

$799,000

Compared to

2025

$755,000

2024

$722,500

2023

$695,000


What’s nearby?Essentials within 5 km

Local Logic

Transportation Scores

Estimated Budget