We use cookies for basic analytics + follow-up. Privacy
We remember this notice, run basic analytics, and use account activity like saved homes and listing views to provide real-estate follow-up. Privacy.
240074 Highway 546
Buyer alert automation
Get matching homes sent on your schedule. This uses this home's city, style, bedroom count, and price band as the starting filter.
Choose alert settings, then sign in
Rural Foothills County · Single Family · under $3,625,000 · 7+ bed · 8+ bath. Alerts only send when there are new or meaningfully updated matching homes.
Alert speed
Send by
Watch for
Swipe through similar matches — tap the heart to save, or open one for the full read.
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. (id:65958)
Basement
| Room | Dimensions | Features |
|---|---|---|
| Other | 49.75 Ft x 26.17 Ft |
Main level
| Room | Dimensions | Features |
|---|---|---|
| 2pc Bathroom | 6.33 Ft x 5.42 Ft | |
| 4pc Bathroom | 8.75 Ft x 11.83 Ft | |
| 6pc Bathroom | 14.50 Ft x 15.08 Ft | |
| Foyer | 27.42 Ft x 14.58 Ft | |
| Living room | 34.67 Ft x 25.58 Ft | |
| Other | 14.08 Ft x 18.92 Ft | |
| Other | 11.50 Ft x 5.75 Ft | |
| Other | 8.83 Ft x 14.42 Ft | |
| Storage | 19.17 Ft x 20.50 Ft | |
| Storage | 14.17 Ft x 9.67 Ft | |
| Storage | 7.00 Ft x 8.58 Ft | |
| Other | 13.25 Ft x 17.67 Ft | |
| Sunroom | 34.33 Ft x 83.00 Ft | |
| Furnace | 13.50 Ft x 15.50 Ft | |
| Furnace | 6.50 Ft x 22.17 Ft | |
| Wine Cellar | 6.75 Ft x 13.42 Ft | |
| Workshop | 19.17 Ft x 10.92 Ft |
Second level
| Room | Dimensions | Features |
|---|---|---|
| 2pc Bathroom | 3.83 Ft x 8.17 Ft | |
| 3pc Bathroom | 6.25 Ft x 11.00 Ft | |
| 4pc Bathroom | 8.00 Ft x 6.33 Ft | |
| 5pc Bathroom | 10.58 Ft x 7.00 Ft | |
| 5pc Bathroom | 10.58 Ft x 6.92 Ft | |
| Other | 7.67 Ft x 22.25 Ft | |
| Other | 6.33 Ft x 9.92 Ft | |
| Bedroom | 14.58 Ft x 14.67 Ft | |
| Bedroom | 17.92 Ft x 8.75 Ft | |
| Bedroom | 14.67 Ft x 14.58 Ft | |
| Bedroom | 14.42 Ft x 12.75 Ft |
Third level
| Room | Dimensions | Features |
|---|---|---|
| Loft | 34.50 Ft x 13.67 Ft | |
| Office | 6.00 Ft x 13.67 Ft | |
| Storage | 14.00 Ft x 5.67 Ft |
10-item due-diligence checklist. We can pre-flight most of these for you on a CMA call.
Comparable sales
Ask for 3–5 recent solds within ~1 km and the same beds/baths so the list price has context.
Property condition
Roof age, furnace age, hot-water tank age, electrical panel size, windows. Cosmetic vs structural.
Zoning
Confirm zoning matches your intent (single-family vs duplex vs secondary suite vs commercial).
Suite legality / potential
If suited or being marketed as suited: confirm permits, separate entrance, ceiling height, egress windows.
Monthly carrying cost
Mortgage + property tax + insurance + condo fee (if any) + utilities. Compare to your max budget.
Property taxes
Confirm the annual tax amount on the current assessment — and whether a reassessment is pending.
Insurance estimate
Get a same-day quote. Older homes, knob-and-tube wiring, polybutylene plumbing, flood plains all change the number.
Commute
Drive it (or transit it) at the actual time of day you'd commute. Map ETA lies during peak hours.
Deposit and financing conditions
Deposit size, financing condition window, condition removal date, possession date — all negotiable.
Inspection considerations
Budget for a home inspector ($500–700) and any specialty inspections (sewer scope, mould, asbestos for pre-1990 builds).
Pick a down payment and tap any underlined number to edit. Total updates live. Confirm with a mortgage broker before writing an offer.
Monthly carrying costs (shared)
Approximation only. CMHC default insurance is included when down payment is under 20%. Property tax and condo fees come from MLS when listed and may not reflect the current billing year. Accelerated bi-weekly frequency reduces total interest paid vs. monthly — confirm with a broker. Suite rental income depends on permits, market rent, and vacancy. Always validate with a mortgage broker before writing an offer.
We'll reply by text within a few hours. Comparable sales, condition flags, things worth checking — sent before you book a showing.
Listing brokerage
Listing brokerage on file
Listing data via CREA DDF®. Information is deemed reliable but not guaranteed accurate by CREA. Last updated May 27, 2026.
| Bedroom | 13.17 Ft x 17.25 Ft |
| Bedroom | 14.67 Ft x 14.58 Ft |
| Bedroom | 14.67 Ft x 14.50 Ft |
| Bonus Room | 17.92 Ft x 11.83 Ft |
| Dining room | 20.50 Ft x 15.92 Ft |
| Dining room | 14.00 Ft x 13.75 Ft |
| Family room | 27.83 Ft x 34.67 Ft |
| Kitchen | 13.58 Ft x 23.08 Ft |
| Laundry room | 14.42 Ft x 6.58 Ft |
| Pantry | 7.08 Ft x 6.75 Ft |
| Other | 33.92 Ft x 20.92 Ft |
| Primary Bedroom | 20.75 Ft x 23.17 Ft |
| Other | 13.75 Ft x 10.25 Ft |
| 5pc Bathroom | 21.50 Ft x 8.67 Ft |
| Recreational, Games room | 16.50 Ft x 13.50 Ft |
| Other | 6.75 Ft x 9.00 Ft |
| Other | 7.83 Ft x 8.00 Ft |
| Other | 27.50 Ft x 13.75 Ft |
Location of this listing. Distances are straight-line.
Full neighbourhood intelligence (schools, halal, mosques, transit) is still building for this address.