Save
Ask
Tour
Hide
Share
$2,900,000
12 Days On Site

40090 Retreat Road
Rural Rocky View County, AB T4C 1A2

For Sale|Single Family Residence|Active
8
Beds
10
Total Baths
9
Full Baths
1
Partial Bath
5,942
SqFt
$488
/SqFt
2005
Built
County:
Rocky View County
Call Now: 403-278-8663
Is this the listing for you? We can help make it yours.
403-278-8663
40090 Retreat Road40090 Retreat Road40090 Retreat Road40090 Retreat Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$13,231
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

Set on 9.17 acres in Bearspaw, 10 Minutes to the NW Calgary Light Rail Transit, this custom-built estate offers unobstructed west-facing Rocky Mountain views, and minutes to major shopping in Cochrane and Calgary. The 9.17 Acres can be subdivided into two parcels. Boasting over 10,000 sq.ft. of developed living space, the home features 7 bedrooms (4 above grade, 3 on the walk-out lower level, including another Master Suite) and 10 bathrooms, ideal for large or multi-generational families. The upper level includes three junior suites with private ensuites and balconies, along with a stunning primary retreat showcasing vaulted ceilings, fireplace, spa-inspired ensuite, and expansive walk-in closet. The fully developed walk out level in addition to the three bedrooms with ensuites offers an exercise area, steam room, and a full ensuite bathroom. This level also includes an indoor/outdoor area with a Hot Tub Hookup and a woodburning Fireplace. The main level is designed for executive living and entertaining, highlighted by a chef’s kitchen with custom site-built cabinetry, copper inlay detailing, granite countertops, multi-level island, walk-in pantry, and fully equipped Butler’s Kitchen. Formal dining, private offices, a dedicated meeting room with separate veranda access, and multiple fireplaces elevate both function and design. Landscaped grounds feature two wildlife ponds, gated entry, paved driveway, ample RV parking, a detached six-car garage, and an attached four-car garage with 10’ high doors. Subdivision potential into two lots, which has been verified with Rocky View County by the owner/developer. A rare opportunity to secure estate-scale living with mountain views and premier access to Calgary.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,900,000
Days On Site 
12 Days
Bedrooms 
8
Inside Area (SqFt) 
5,942 sqft
Total Baths 
10
Full Baths 
9
Partial Baths 
1
Lot Size 
9.17 Acres
Year Built 
2005
MLS® Number 
A2295217
Status 
Active
Property Tax 
$17,383
Maintenance Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
2 weeks agoListing first seen on site
2 weeks agoListing updated with changes from the MLS®
General Features
Acres 
9.17
Attached Garage 
Yes
Garage 
Yes
Garage Spaces 
4
Levels 
Two
Parking 
Garage Door Opener
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
SqFt Above 
3798
SqFt Below 
4195
Style 
2 StoreyAcreage with Residence
Water Source 
Well
Zoning 
R2
Interior Features
Appliances 
Bar FridgeBuilt-In Electric RangeBuilt-In Gas RangeBuilt-In RefrigeratorDishwasherDryerMicrowaveRefrigeratorWater PurifierWater SoftenerWine RefrigeratorOven
Basement 
FullFinishedExterior EntryWalk-Out Access
Fireplace 
Yes
Fireplace Features 
BasementBedroomFamily RoomGasLibrarySee RemarksWood BurningMaster Bedroom
Fireplaces 
6
Flooring 
Ceramic TileHardwoodLaminate
Heating 
Fireplace(s)Forced AirNatural GasWood
Interior 
BarBookcasesCentral VacuumCrown MoldingDouble VanityGranite Counters
Laundry Features 
Laundry RoomLower LevelMain LevelMultiple Locations
2pc Bathroom 
Dimensions - 4`7" x 4`6"Level - Main
3pc Bathroom 
Dimensions - 4`6" x 7`4"Level - Lower
3pc Ensuite bath 
Dimensions - 9`2" x 7`0"Level - Lower
4pc Ensuite bath 
Dimensions - 10`3" x 4`9"Level - Upper
5pc Ensuite bath 
Dimensions - 16`10" x 15`2"Level - Main
Bedroom 
Dimensions - 9`11" x 11`9"Level - Lower
Bedroom - Primary 
Dimensions - 13`9" x 15`11"Level - Upper
Dining Room 
Dimensions - 11`9" x 16`8"Level - Lower
Family Room 
Dimensions - 21`3" x 18`11"Level - Upper
Foyer 
Dimensions - 9`0" x 7`10"Level - Main
Game Room 
Dimensions - 51`10" x 35`2"Level - Lower
Kitchen 
Dimensions - 23`4" x 18`11"Level - Main
Laundry 
Dimensions - 11`8" x 7`9"Level - Main
Library 
Dimensions - 23`5" x 18`3"Level - Upper
Living Room 
Dimensions - 17`9" x 25`11"Level - Main
Mud Room 
Dimensions - 10`10" x 4`11"Level - Main
Nook 
Dimensions - 15`9" x 10`7"Level - Main
Pantry 
Dimensions - 11`8" x 5`9"Level - Main
Sunroom/Solarium 
Dimensions - 25`5" x 31`3"Level - Lower
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneFrame
Exterior 
CourtyardPrivate EntranceRain Gutters
Fencing 
Fenced
Lot Features 
Landscaped
Patio And Porch 
DeckFront PorchSee RemarksWrap Around
Roof 
ShingleAsphalt
Community Features
Community Features 
Gated
Listing courtesy of Paul Gill of Century 21 Bravo Realty

Listing information is provided by Participants of the Alberta One Realty Listing Services (Pillar 9). IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, Alberta One Realty Listing Services (Pillar 9)
Last checked 2026-04-07 02:37 PM UTC

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share