Calgary Homes for Sale - Our Agents' Listings

Get the most of your property investments in Alberta, CA. Find affordable, luxurious, and even one-of-a-kind homes for sale in Calgary. Check these available listings from our professional agents today!

Back to Listings » Listing Details

24062 236 Avenue E: Rural Foothills County Detached for sale : MLS®# A2210274

24062 236 Avenue E Rural Foothills County T1S 4B3 : Rural Foothills County

Main Photo: 24062 236 Avenue E: Rural Foothills County Detached for sale : MLS®# A2210274banner
$6,995,000
Prop. Type:
Residential
MLS® Num:
A2210274
Status:
Active
Bedrooms:
8
Bathrooms:
7
Year Built:
2017
This exquisite custom-built bungalow with a walkout basement offers over 14,000 sq ft of luxurious living space on 4.66 acres just south of Calgary. From the moment you arrive beneath the porte-cochère—crowned with a striking steel chandelier—you’re greeted by timeless craftsmanship, featuring natural stone, 100-year-old reclaimed barnwood, and a design that blends rustic elegance with modern convenience. In addition to the main residence, the estate includes a private nanny suite with hydraulic lift and a beautifully appointed carriage house with a double attached garage—perfect for multigenerational living or guests. Step into the grand great room, where a floor-to-ceiling stone fireplace, 13’ coffered ceilings and the surrounding windows overlooking the Bow River impress. White oak hardwood, 12” custom stone baseboards, solid wood doors, stone counters, and Gaulhofer triple-glazed windows and doors are a few of the home's features and unmatched quality. The home is fully automated with heated floors, zoned climate control, and in-floor up-lighting, all while showcasing panoramic views of the Bow River and serene morning sunrises. The chef’s kitchen impresses with dual islands and includes professional grade luxury built-in appliances, 60" Wolf Gas Range and Dekton countertops. A hidden prep pantry offers two freezers, custom shelving, and a peninsula island. Step out to a patio with Phantom screens, TV hookup, and gas line for al fresco dining. The elegant dining room provides an abundance of space for hosting and opens onto a wraparound deck with glass railing, gas fire bowls, planters, and built-in speakers, all overlooking the Bow River. The primary retreat features vaulted ceilings, private patio access, a natural stone fireplace, and a spa-inspired ensuite with dual vanities, jetted tub, and a Kohler steam shower with rain head and pebble floor. The walk-in closet offers a custom island, built-ins, and bay window bench. Two additional bedrooms share a 4-piece ensuite. The main floor also features a custom laundry room, executive home office, and cedar-lined sunroom with barnwood beams and a waterfall wall. The walkout basement is an entertainer’s dream with a Brunswick bowling alley, onyx bar, home theatre, gym, cedar sauna, lounge, second bar, three more bedrooms (one with ensuite), den, additional bathroom, and laundry. The concrete patio, irrigated lawn, firepit, and Phantom screens create the perfect outdoor escape. The garage accommodates 8 vehicles with stackers and connects to an oversized mudroom with individual lockers and Blanco sink. The 1,800+ sqft nanny suite includes a kitchen, living room, two bedrooms with ensuites, and private HVAC. The 1,300+ sqft carriage house features vaulted ceilings, Juliet balcony, open-concept kitchen, luxury bath, laundry, deck, and double garage. Located 15 minutes from Calgary and Okotoks, near Policeman’s Flats, this legacy estate is the perfect blend of refined luxury, privacy, and natural beauty.
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Possession:
45 days / Neg
Suite:
Suite - Legal
Home Style:
Acreage with Residence, Bungalow
Total Living Area:
Switch units of measure7,235.5 sq. ft.
Main Level Finished Area:
Switch units of measure7,235.5 sq. ft.
Below Grade Finished Area:
Switch units of measure6,822.31 sq. ft.
Taxes:
$21,508 / 2024
Tax Assessed Value:
3565320.0
Lot Area:
Switch units of measure4.66 acre(s)
Front Exposure:
West
Levels:
One
Total Rooms Above Grade:
9
Year built:
2017 (Age: 8)
Bedrooms:
8 (Above Grd: 3)
Bedrooms Above Grade:
3
Bedrooms Below Grade:
5
Bathrooms:
7.0 (Full:6, Half:1)
Plan:
0012707
Heating:
Boiler, Fan Coil, In Floor, Forced Air, Hot Water, Humidity Control, Zoned
Basement:
Finished, Full, Walk-Out To Grade
Foundation:
Poured Concrete
New Constr.:
No
Construction Material:
Metal Siding, Stone, Stucco, Wood Frame, Wood Siding
Structure Type:
House
Roof:
Asphalt Shingle, Metal
Ensuite:
Yes
Flooring:
Carpet, Ceramic Tile, Hardwood, Slate, Stone, Tile, Vinyl Plank
Cooling:
Central Air
Fireplaces:
4
Fireplace Details:
Double Sided, Gas, See Remarks, Stone, Three-Sided
Water Supply:
Well
Sewer:
Septic Field, Septic Tank
Garage:
1
Garage Spaces:
14
Parking:
Double Garage Detached, Gated, Insulated, Paved, Quad or More Attached
Laundry Features:
Laundry Room, Lower Level, Main Level, Multiple Locations
NONE
See Remarks
Main House: 3x Miele Dishwashers, 2x 42" Subzero Refrigerators, 2x Subzero Ice Maker, 2x Pullout Fridge Drawers, 3x Microwave, 60" Wolf Gas Range, Range Hood, Wolf Steam Oven, Wolf Warming Drawer, 2x Garburators, 2x Freezers, Subzero Glass Door Fridge, Bar Fridge, 2x LG Washers, 2x LG Dryers, All Aquarium Parts, Epson Projector, Projection Screen, Built-in Theatre Speakers, Finnleo Sauna System, Bruswick Bowling System & Balls, Window Coverings, Showcase Automation System, All Central AC Units, All Humidifiers, Canature Water Filtration System, Garage Door Openers & Controls, Outdoor Camera System, Automatic Patio Phantom Screens, 2x InfraRed Patio Heaters, Irrigation System, Fire Pit | Nanny Suite: Microwave, Miele Dishwasher, Dryer, Range Hood, Refrigerator, Microwave, Gas Stove, Washer, Window Coverings, Central Air Conditioner, Humidifier | Carriage House: Dishwasher, Dryer w/ Pedestal, Electric Stove, Garage Control(s) & Opener(s), Microwave Hood Fan, Refrigerator, Washer, Central AC, Window Coverings
Restrictive Covenant, Utility Right Of Way
Floor
Type
Dimensions
Other
Main Floor
Foyer
Switch units of measure11'7" x 6'6"
Main Floor
Great Room
Switch units of measure32'4" x 27'5"
Main Floor
Kitchen
Switch units of measure45'10" x 26'2"
Main Floor
Pantry
Switch units of measure15'5" x 14'5"
Main Floor
Dining Room
Switch units of measure28'7" x 11'
Main Floor
Bedroom - Primary
Switch units of measure30'2" x 23'3"
Main Floor
Walk-In Closet
Switch units of measure12'10" x 12'7"
Main Floor
Laundry
Switch units of measure9'4" x 8'2"
Main Floor
Bedroom
Switch units of measure13'3" x 13'3"
Main Floor
Bedroom
Switch units of measure13'9" x 11'7"
Main Floor
Office
Switch units of measure12'11" x 9'11"
Main Floor
Sunroom/Solarium
Switch units of measure13'2" x 9'1"
Main Floor
Mud Room
Switch units of measure17'2" x 15'5"
Basement
Game Room
Switch units of measure52'9" x 52'1"
Basement
Exercise Room
Switch units of measure23'11" x 21'8"
Basement
Media Room
Switch units of measure19' x 18'7"
Basement
Bedroom
Switch units of measure17'8" x 11'5"
Basement
Den
Switch units of measure16'4" x 13'1"
Basement
Family Room
Switch units of measure34'7" x 19'5"
Basement
Bedroom
Switch units of measure14'11" x 13'2"
Basement
Bedroom
Switch units of measure14'11" x 11'11"
Basement
Laundry
Switch units of measure13'2" x 11'4"
Suite
Living Room
Switch units of measure19'7" x 16'8"
Suite
Dining Room
Switch units of measure15'3" x 11'2"
Suite
Kitchen
Switch units of measure21'8" x 15'
Suite
Bedroom
Switch units of measure14'8" x 14'8"
Suite
Office
Switch units of measure11'2" x 10'
Suite
Laundry
Switch units of measure11'2" x 6'
Suite
Furnace/Utility Room
Switch units of measure7'10" x 5'6"
Suite
Bedroom
Switch units of measure16'4" x 11'1"
Floor
Ensuite
Pieces
Other
Main Floor
Yes
5
16'3" x 19'10"
Main Floor
Yes
4
12' x 14'5"
Main Floor
No
2
10'7" x 5'2"
Basement
Yes
4
5'6" x 17'8"
Basement
No
4
8'7" x 8'2"
Suite
Yes
5
17'2" x 10'2"
Suite
Yes
3
11'1" x 16'4"
Title to Land:
Fee Simple
Community Features:
Fishing, Golf, Walking/Bike Paths
Interior Features:
Bar, Beamed Ceilings, Breakfast Bar, Built-in Features, Closet Organizers, Double Vanity, Elevator, High Ceilings, Jetted Tub, Kitchen Island, Natural Woodwork, Open Floorplan, Pantry, Quartz Counters, Recreation Facilities, See Remarks, Smart Home, Soaking Tub, Stone Counters, Storage, Vaulted Ceiling(s), Walk-In Closet(s)
Exterior Features:
Fire Pit, Lighting, Misting System
Patio And Porch Features:
Deck, Patio, Wrap Around
Lot Features:
Back Yard, Backs on to Park/Green Space, Brush, Creek/River/Stream/Pond, Landscaped, Many Trees, No Neighbours Behind, Open Lot, Private, Treed, Underground Sprinklers, Zero Lot Line
Num. of Parcels:
0
Outbuildings:
See Remarks
Fencing:
Partial
Nearest Town:
Calgary
Region:
Foothills County
Zoning:
CRA
Listed Date:
Apr 11, 2025
Days on Mkt:
14
Listed by RE/MAX First
Data was last updated April 25, 2025 at 04:05 AM (UTC)

Have Questions? Contact me at: 403-651-8910

Data is supplied by Pillar 9™ MLS® System. Pillar 9™ is the owner of the copyright in its MLS®System. Data is deemed reliable but is not guaranteed accurate by Pillar 9™.
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.