For Sale: 240074 Highway 546, Foothills County, AB - REW
Boost your listing
Listing featured. Your listing will be featured on REW.
View featured placement
$3,350,000
8 bd • 9 ba • 17809 sf • House
240074 Highway 546
Street ViewDirections
$3,350,000
Get pre-approved

240074 Highway 546Foothills County, AB, T0L 2A0

  • 8 Bed
  • 9 Bath
  • 17809 Sqft
  • House

About this home

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.
Listed by: Robin Burwash, Coldwell Banker Mountain Central

Home facts and features

Price details
List Price
$3,350,000
Get Pre-Approved
Home facts
Bedrooms
8
Full Bathrooms
7
Partial Bathrooms
2
Parking Spaces
6
Property Type
House
Lot Size
81 ft²
Year Built
Built in 1978 (48 yrs old)
Style
3 Level Split,Acreage with Residence
Heating Type
In Floor,Forced Air,Hot Water,Natural Gas
Pool
Indoor Pool
Basement Details
Full
Features
Awning(s), Back Yard, Backs On To Park/green Space, Barbecue, Creek/river/stream/pond, Den, Elevator, Family Room, Fire Pit, Landscaped, Laundry Room, Living Room, Many Trees, Open Floorplan, Other, Pasture, Primary Bedroom, Private Entrance, Private Yard, Rectangular Lot, Stone, Vaulted Ceiling(s), Wood Burning
Amenities
Tennis Courts
Appliances
Bar Fridge, Dishwasher, Oven-built-in, Refrigerator, Stove, Warming Drawer, Washer/Dryer
Agent details
Primary Agent
Primary Broker
Coldwell Banker Mountain Central
Listing details
Days on REW
36 Days
Property Views
59
MLS® Number
A2304112
Source
Pillar 9
Board
Calgary Real Estate Board
Is this your listing? Help it to stand out.

Mortgage Calculator

Estimated Payments
Purchase Price
Mortgage Total
Down Payment
Amortization
25 Years
Interest Rate
3.99%

Connect with our mortgage partner

Aamir Khalique

Aamir Khalique

Dominion Lending

I provide excellent customer service, grant access to a wide range of lenders, and offer expert advice and guidance, saving you time. Let me tailor a solution to your unique needs and situation.

Connect with a mortgage expert

Connect to a mortgage specialist

Aamir Khalique
Dominion Lending

They will connect with you to understand where you are in your journey and how they can best guide you.

  • %
Name*
Email*
Phone*
Purchase City*
What best describes your current situation?
Loan Details
Amortization
Years
Mortgage Amount
Down Payment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

Property Insights

Ron Southern School
  • n/a
  • -
  • In Catchment
Holy Child School
  • n/a
  • -
  • In Catchment
Bridlewood School
  • n/a
  • -
  • In Catchment
Glenmore Christian Academy Junior High
  • n/a
  • -
  • In Catchment
Glenmore Christian Academy
  • n/a
  • -
  • In Catchment
All Saints School
  • n/a
  • -
  • In Catchment
Monsignor J. J. O'Brien
  • n/a
  • -
  • In Catchment
Somerset School
  • n/a
  • -
  • In Catchment
Our Lady Of The Evergreens Catholic School
  • n/a
  • -
  • In Catchment
Marshall Springs School
  • n/a
  • -
  • In Catchment
School catchments and distances are intended to be used as reference only. To verify enrolment eligibility for a property, contact the school directly.Report Incorrect Info
Report Incorrect Info
Full Name*
Email*
Select School
Reason

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.
Thank You!
We really appreciate your help improving our home search experience. Our team will look into this issue as soon as possible.
Close

Cities near Foothills County

Neighborhoods near Foothills County

Listing data is subject to copyright, disclaimer, and additional requirements from the data provider. See our Terms of Use for terms applicable to this listing. Listing data was last updated on 2026-06-09.
Call Agent
Robin Burwash
Phone:
(403) 837-3000
Cell:
(403) 837-3000
Office:
403-775-6950
Share this Property
Text Message
Share this Property
Recipient Email Address*
Your Name
Your Email Address*

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.