40090 Retreat Road | Rural Rocky View County | Rural Rocky View County

40090 Retreat Road | Rural Rocky View County

Beds
4 4
Baths
9.5
Sqft
5,942
Lot Sqft
399,445 (9.2ac)
Year Built
2005
Days Listed
20
Type
Detached
Status
Active
Garage
Yes
Foundation
Concrete
Condo Fee
No
Price Change
None

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.

MLS ® #: A2295217
Listing Office: Century 21 Bravo Realty
Date Listed: March 25, 2026 - 21 days on site
Last Updated: Apr 15, 2026 02:05am MST

$2,900,000

Details

Style:
2 storey, acreage with residence

Garage Size:
10

Interior:
bar, bookcases, central vacuum, crown molding, double vanity, granite counters

Exterior:
courtyard, private entrance, rain gutters

Lot:
landscaped

Parking/Garage:
quad or more attached, quad or more detached

Even More Details

Taxes:
$0

Foundation:
poured concrete

Construction:
stone,wood frame

Flooring:
ceramic tile,hardwood,laminate

Roof:
asphalt shingle

Heating:
high efficiency,in floor,fireplace(s),forced air,natural gas,wood

Inclusions:
n/a

Room Sizes

Foyer

9`0" x 7`10"

Dining Room

13`9" x 21`3"

Laundry

11`8" x 7`9"

Nook

15`9" x 10`7"

Pantry

11`8" x 5`9"

3pc Bathroom

6`5" x 6`9"

Bedroom - Primary

17`0" x 17`11"

5pc Ensuite bath

16`10" x 15`2"

2pc Bathroom

4`7" x 4`6"

Kitchen

8`4" x 18`2"

Kitchen

23`4" x 18`11"

Mud Room

10`10" x 4`11"

Library

13`11" x 11`10"

Living Room

17`9" x 25`11"

Bedroom - Primary

16`0" x 18`5"

Bedroom - Primary

17`10" x 12`5"

Bedroom - Primary

13`9" x 15`11"

4pc Ensuite bath

10`4" x 6`4"

4pc Ensuite bath

8`2" x 8`0"

4pc Ensuite bath

10`3" x 4`9"

Family Room

21`3" x 18`11"

Library

23`5" x 18`3"

Game Room

51`10" x 35`2"

Bedroom - Primary

15`5" x 19`10"

Bedroom - Primary

16`1" x 16`11"

Bedroom

9`11" x 11`9"

3pc Ensuite bath

10`7" x 10`6"

3pc Ensuite bath

9`2" x 7`0"

3pc Ensuite bath

9`3" x 11`10"

3pc Bathroom

4`6" x 7`4"

Bedroom

9`7" x 12`3"

Dining Room

11`9" x 16`8"

Sunroom/Solarium

25`5" x 31`3"

Thoughtful | Loyal | Effective

Loving this home?

Breanna will call to discuss.

"I couldn't ask for a better REALTOR ®️ team to help us buy our first home" - S. Stoyles

Similar Properties

620 Varsity Estates Crescent

Varsity 4 Bed 5.5 Bath 4032sqft

CIR Realty

48149 279 Ave.

Deer Creek Estates 5 Bed 4.5 Bath 4168sqft

eXp Realty

14 Pinehurst Drive

NONE 3 Bed 4 Bath 3269sqft

RE/MAX Landan Real Estate

6755 Livingstone Drive

Lakeview 6 Bed 3.5 Bath 2612sqft

RE/MAX Realty Professionals

1911 13 Ave.

Hounsfield Heights/Briar Hill 5 Bed 4.5 Bath 3542sqft

Sotheby's International Realty Canada

412 40 Ave.

Elbow Park 5 Bed 4.5 Bath 3073sqft

Comox Realty

4023 16A St.

Altadore 5 Bed 4.5 Bath 3806sqft

RE/MAX House of Real Estate

14 Lissington Drive

North Glenmore Park 5 Bed 4.5 Bath 3759sqft

Century 21 Bravo Realty

5215 19 St. #5215

North Glenmore Park 4 Bed 4 Bath 3099sqft

URBAN-REALTY.ca

“A lot of people viewed the movie and pictures within the first 24 hours and I believe we had around 10 showings within the first two days.”.
 
- Gerald Lichti
“[Breanna] told me with 100% confidence and certainty she could get the job done and that’s exactly what happened.”.
 
- Channing Pass
“Breanna was a dream to work with - knowledgeable, attentive, professional and organized. I really appreciate how she and Tom operate their business - 'integrity' is the word that comes to mind.”.
 
- Michele Hannay

Breanna
Albrecht