View all the acreages for sale near Okotoks and South Calgary – I specialize in helping clients buy and sell acreages, please call or text me to view any of these properties – Samantha 403.605.7200
40090 Retreat Road
Rural Rocky View County
Rural Rocky View County
T4C 1A2
$2,900,000
Residential
beds: 8
baths: 10.0
5,942 sq. ft.
built: 2005
- Status:
- Active
- Prop. Type:
- Residential
- MLS® Num:
- A2295217
- Bedrooms:
- 8
- Bathrooms:
- 10
- Year Built:
- 2005
- Photos (50)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
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.
- Property Type:
- Residential
- Property Sub Type:
- Detached
- Condo Type:
- Not a Condo
- Transaction Type:
- For Sale
- Suite:
- No
- Num Legal Suites:
- 0
- Num Illegal Suites:
- 0
- Home Style:
- 2 Storey, Acreage with Residence
- Total Living Area:
- 5,942 sq. ft.552 m2
- Main Level Finished Area:
- 3,798 sq. ft.353 m2
- Below Grade Finished Area:
- 4,195 sq. ft.390 m2
- Acreage:
- Yes
- Lot Area:
- 9.17 acre(s)3.71 hectare(s)
- Front Exposure:
- West
- Levels:
- Two
- Total Rooms Above Grade:
- 12
- Year built:
- 2005 (Age: 21)
- Bedrooms:
- 8 (Above Grd: 4)
- Bedrooms Above Grade:
- 4
- Bedrooms Below Grade:
- 4
- Bathrooms:
- 10.0 (Full:9, Half:1)
- Plan:
- 9913369
- Heating:
- High Efficiency, In Floor, Fireplace(s), Forced Air, Natural Gas, Wood
- Basement:
- Full, Finished, Separate/Exterior Entry, Walk Out
- Foundation:
- Poured Concrete
- New Constr.:
- No
- Construction Material:
- Stone, Wood Frame
- Structure Type:
- House
- Roof:
- Asphalt Shingle
- Ensuite:
- Yes
- Flooring:
- Ceramic Tile, Hardwood, Laminate
- Cooling:
- None
- Fireplaces:
- 6
- Fireplace Details:
- Basement, Bedroom, Family Room, Gas, Library, Primary Bedroom, See Remarks, Sun Room, Wood Burning
- Water Supply:
- Well
- Sewer:
- Septic Tank
- Garage:
- Yes
- Garage Spaces:
- 10
- Parking:
- Quad or More Attached, Quad or More Detached
- Laundry Features:
- Laundry Room, Lower Level, Main Level, Multiple Locations
- Bar Fridge, Built-In Electric Range, Built-In Gas Range, Built-In Oven, Built-In Refrigerator, Dishwasher, Dryer, Garage Control(s), Microwave, Microwave Hood Fan, Oven-Built-In, Refrigerator, Water Purifier, Water Softener, Wine Refrigerator
- N/A
- None Known
- Floor
- Type
- Size
- Other
- Main Floor
- Foyer
- 9'2.74 m × 7'10"2.39 m
- Main Floor
- Dining Room
- 21'3"6.48 m × 13'9"4.19 m
- Main Floor
- Laundry
- 11'8"3.56 m × 7'9"2.36 m
- Main Floor
- Nook
- 15'9"4.80 m × 10'7"3.23 m
- Main Floor
- Pantry
- 11'8"3.56 m × 5'9"1.75 m
- Main Floor
- Bedroom - Primary
- 17'11"5.46 m × 17'5.18 m
- Main Floor
- Kitchen
- 18'2"5.54 m × 8'4"2.54 m
- Main Floor
- Kitchen
- 23'4"7.11 m × 18'11"5.77 m
- Main Floor
- Mud Room
- 10'10"3.30 m × 4'11"1.50 m
- Main Floor
- Library
- 13'11"4.24 m × 11'10"3.61 m
- Main Floor
- Living Room
- 25'11"7.90 m × 17'9"5.41 m
- Upper Level
- Bedroom - Primary
- 18'5"5.61 m × 16'4.88 m
- Upper Level
- Bedroom - Primary
- 17'10"5.44 m × 12'5"3.78 m
- Upper Level
- Bedroom - Primary
- 15'11"4.85 m × 13'9"4.19 m
- Upper Level
- Family Room
- 21'3"6.48 m × 18'11"5.77 m
- Upper Level
- Library
- 23'5"7.14 m × 18'3"5.56 m
- Lower Level
- Game Room
- 51'10"15.80 m × 35'2"10.70 m
- Lower Level
- Bedroom - Primary
- 19'10"6.05 m × 15'5"4.70 m
- Lower Level
- Bedroom - Primary
- 16'11"5.16 m × 16'1"4.90 m
- Lower Level
- Bedroom
- 11'9"3.58 m × 9'11"3.02 m
- Lower Level
- Bedroom
- 12'3"3.73 m × 9'7"2.92 m
- Lower Level
- Dining Room
- 16'8"5.08 m × 11'9"3.58 m
- Lower Level
- Sunroom/Solarium
- 31'3"9.53 m × 25'5"7.75 m
- Floor
- Ensuite
- Pieces
- Other
- Main Floor
- No
- 3
- 6'9" x 6'5"
- Main Floor
- Yes
- 5
- 15'2" x 16'10"
- Main Floor
- No
- 2
- 4'6" x 4'7"
- Upper Level
- Yes
- 4
- 6'4" x 10'4"
- Upper Level
- Yes
- 4
- 8' x 8'2"
- Upper Level
- Yes
- 4
- 4'9" x 10'3"
- Lower Level
- Yes
- 3
- 10'6" x 10'7"
- Lower Level
- Yes
- 3
- 7' x 9'2"
- Lower Level
- Yes
- 3
- 11'10" x 9'3"
- Lower Level
- No
- 3
- 7'4" x 4'6"
- Title to Land:
- Fee Simple
- Community Features:
- Gated, Schools Nearby, Shopping Nearby
- Interior Features:
- Bar, Bookcases, Central Vacuum, Crown Molding, Double Vanity, Granite Counters
- Exterior Features:
- Courtyard, Private Entrance, Rain Gutters
- Patio And Porch Features:
- Deck, Front Porch, See Remarks, Wrap Around
- Lot Features:
- Landscaped
- Num. of Parcels:
- 0
- Fencing:
- Fenced
- Nearest Town:
- Cochrane
- Region:
- Rocky View County
- Zoning:
- R2
- Listed Date:
- Mar 25, 2026
-
Photo 1 of 50
-
Photo 2 of 50
-
Photo 3 of 50
-
Photo 4 of 50
-
Photo 5 of 50
-
Photo 6 of 50
-
Photo 7 of 50
-
Grand Entry
-
Grand Entry
-
Photo 10 of 50
-
Photo 11 of 50
-
Photo 12 of 50
-
Photo 13 of 50
-
Photo 14 of 50
-
Photo 15 of 50
-
Photo 16 of 50
-
Photo 17 of 50
-
Photo 18 of 50
-
Photo 19 of 50
-
Kitchen Main
-
Photo 21 of 50
-
Photo 22 of 50
-
Photo 23 of 50
-
Spice Kitchen
-
Photo 25 of 50
-
Photo 26 of 50
-
Main Floor Bedroom
-
Photo 28 of 50
-
Primary Bathroom
-
Primary Bathroom
-
Primary Shower
-
Main Floor Study
-
Main Floor 2nd Bedroom
-
Window Stairwell
-
Photo 35 of 50
-
Photo 36 of 50
-
Bedroom 1 w/ full En-Suite
-
Bedroom 2 w/ Full En-Suite
-
Photo 39 of 50
-
Photo 40 of 50
-
Photo 41 of 50
-
Covered Indoor / Outdoor Patio
-
Basement Bedroom 1
-
Basement Bathroom 1 w/ Steam Room
-
Theater Room
-
Photo 46 of 50
-
Photo 47 of 50
-
Photo 48 of 50
-
Photo 49 of 50
-
Photo 50 of 50
Virtual Tour
Larger map options:
Listed by Century 21 Bravo Realty
Data was last updated March 27, 2026 at 08:05 AM (UTC)
Area Statistics
- Listings on market:
- 166
- Avg list price:
- $1,329,894
- Min list price:
- $429,900
- Max list price:
- $13,500,000
- Avg days on market:
- 49
- Min days on market:
- 1
- Max days on market:
- 1,767
- Avg price per sq.ft.:
- $520.4
These statistics are generated based on the current listing's property type
and located in
Rural Rocky View County. Average values are
derived using median calculations. This data is not produced by
the MLS® system.
- SAMANTHA CLEMENT
- Okotoks Alberta
- 1 (403) 605 7200
- Contact by Email
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.
powered by myRealPage.com