Diane Richardson

Cell: 403-397-3706 |

Public Search

Forgot password Extend Verify Contact

40191 Retreat Road N
Rural Rocky View MD Rural Rocky View County T4C 2W4

$3,600,000
Residential beds: 5 baths: 5.0 2,573 sq. ft. built: 1994

Main Photo: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 1: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 2: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 3: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 4: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 5: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 6: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 7: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 8: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 9: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 10: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 11: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 12: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 13: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 14: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 15: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 16: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 17: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 18: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 19: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 20: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 21: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 22: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 23: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 24: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 25: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 26: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 27: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 28: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 29: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 30: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 31: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 32: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 33: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 34: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 35: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 36: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 37: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 38: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 39: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 40: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 41: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 42: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 43: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 44: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 45: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 46: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 47: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 48: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 49: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Photo 50: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
Status:
Active
Prop. Type:
Residential
MLS® Num:
A2098854
Bedrooms:
5
Bathrooms:
5
Year Built:
1994
Tucked in behind the escarpment and nestled in the trees, this spectacular custom built home with Rundle stone exterior sits on a 6 acre lot, on the very private Retreat Road adjacent to Cochrane. The home marries old world craftsmanship with contemporary finishes the highest level of state-of-the-art materials and systems. The expanse of windows, magnified by the main area ceiling heights allow the fully treed outside to be seen from within. Recently renovated throughout, the home reflects high level current designer finishes including Hickory hardwood and Travertine floors, painted maple woodwork and contemporary Denca cabinets all offset by a Rundle stone fireplace. The kitchen is perfect; large, functional and highlighted by stainless steel appliances including a Wolf Gas Range (enhanced with a high CFM capacity built in hoodfan) and Sub-Zero Beverage/Wine Fridge, refrigerator, dishwasher and microwave. It bespeaks quality. Cleverly designed, the home offers a main floor master retreat complete with premium ensuite bath and walk in closet. The same hallway accesses the laundry room featuring a rarely seen built-in clothes steamer system. There are two sizeable bedrooms up and each offers their own bath and oversized closet. A walkdown the exquisitely blended hardwood and white spindle staircase leads you to the lower level. Here a partial walkout allows natural light to flow into the space. You can sit by the second stone fireplace, recreate next to the wet bar or sit and enjoy popcorn and a movie in the home theatre with built in projector, screen and speakers that elevate the high-fidelity sound system. And 2 large bedrooms with bath and Sauna. From a utility perspective enjoy the oversized 4 car garage complete with dog wash. Four separate stalls, large enough for pickups and each with a separate entry door. Journey down to the 47’x30’ shop with oversized doors, and appreciate the over insulated, heated and pine finished interior where even on the coldest days your propane bills are negligible. A 70’x120’ outdoor riding arena, the flat surface created by the installation of a large rock retaining wall, is built to exacting standards with the footing surface from imported German GGT, suitable for Hunter/Jumpers. Those horses need a barn and this 36’x25’ structure is finely built in every detail with cedar finish outside and pine inside. Two box stalls, tack room, main floor laundry and bath support the office and living area available upstairs from the main floor. This boutique equestrian property uses split rail wood fences to create paddock and pasture areas complete with cedar horse shelters and waterers. The entire property is enhanced by full perimeter split rail fence, includes an electric gate and is then upgraded by electric dog fencing. For security a Control 4 system monitors the security cameras throughout the property and the main gate. This is an exceptionally high-quality property with many upgrades. You will not be disappointed when you tour.
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Suite:
No
Home Style:
2 Storey, Acreage with Residence
Total Living Area:
2,573 sq. ft.
Main Level Finished Area:
1,854 sq. ft.
Upper Level Finished Area:
719 sq. ft.
Below Grade Finished Area:
1,794 sq. ft.
Lot Area:
5.96 acre(s)
Front Exposure:
East
Unit Exposure:
East
Levels:
Two
End Unit:
No Common Walls
Total Rooms Above Grade:
6
Year built:
1994 (Age: 30)
Bedrooms:
5 (Above Grd: 3)
Bedrooms Above Grade:
3
Bedrooms Below Grade:
2
Bathrooms:
5.0 (Full:3, Half:2)
Plan:
9211334
Heating:
Combination, Forced Air, Natural Gas
Basement:
Finished, Full, Walk-Out To Grade
Foundation:
Poured Concrete
New Constr.:
No
Construction Material:
Stone, Stucco
Structure Type:
House
Roof:
Cedar Shake
Ensuite:
Yes
Flooring:
Carpet, Hardwood, Slate, Stone
Cooling:
Central Air
Fireplaces:
2
Fireplace Details:
Basement, Gas, Living Room, Stone, Wood Burning
Water Supply:
Well
Sewer:
Septic Field, Septic Tank
Garage:
1
Garage Spaces:
4
Parking:
Asphalt, Quad or More Attached
Laundry Features:
Laundry Room
NONE
Central Air Conditioner, Dishwasher, Garage Control(s), Garburator, Gas Stove, Microwave, Other, Range Hood, Refrigerator, Washer, Water Softener, Window Coverings, Wine Refrigerator
Clothing Steamer System, Projector, Screen and Speakers in Theatre Room
Road Access Agreement, Underground Utility Right of Way
Floor
Type
Size
Other
Main Floor
Living Room
18'2" × 17'7"
Main Floor
Dining Room
12'8" × 8'11"
Main Floor
Kitchen
23'1" × 19'7"
Main Floor
Bedroom - Primary
17'4" × 13'2"
Main Floor
Laundry
9'6" × 6'8"
Main Floor
Mud Room
13'1" × 7'8"
2nd Floor
Bedroom
17'11" × 13'11"
2nd Floor
Bedroom
14'5" × 14'
Lower Level
Family Room
15'9" × 15'1"
Lower Level
Hobby Room
11'10" × 7'9"
Lower Level
Game Room
17'2" × 15'9"
Lower Level
Media Room
21'10" × 13'6"
Lower Level
Bedroom
13'6" × 11'7"
Lower Level
Bedroom
16'11" × 12'2"
Lower Level
Furnace/Utility Room
14'8" × 6'8"
Floor
Ensuite
Pieces
Other
Main Floor
Yes
4
0' x 0'
Main Floor
No
2
2nd Floor
Yes
2
2nd Floor
No
3
Lower Level
No
3
Title to Land:
Fee Simple
Community Features:
None
Interior Features:
Bookcases, Breakfast Bar, Central Vacuum, Kitchen Island, Open Floorplan, Sauna, Walk-In Closet(s), Wet Bar, Wired for Data, Wired for Sound
Exterior Features:
Private Yard, Storage
Patio And Porch Features:
Front Porch, Patio, Rear Porch
Lot Features:
Irregular Lot, Paved, Private, Wooded
Num. of Parcels:
0
Outbuildings:
See Remarks, Shed, Barn, Greenhouse, Shop
Fencing:
Fenced
Nearest Town:
Cochrane
Region:
Rocky View County
Zoning:
R-Rur
Listed Date:
Feb 17, 2024
  • Photo 1: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 1 of 50
  • Photo 2: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 2 of 50
  • Photo 3: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 3 of 50
  • Photo 4: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 4 of 50
  • Photo 5: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 5 of 50
  • Photo 6: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 6 of 50
  • Photo 7: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 7 of 50
  • Photo 8: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Wood Burning Stone Fireplace
  • Photo 9: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 9 of 50
  • Photo 10: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 10 of 50
  • Photo 11: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 11 of 50
  • Photo 12: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 12 of 50
  • Photo 13: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 13 of 50
  • Photo 14: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 14 of 50
  • Photo 15: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 15 of 50
  • Photo 16: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Wolf Gas Range with high CFM built-in hoodfan
  • Photo 17: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 17 of 50
  • Photo 18: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Mud Room
  • Photo 19: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Dog Wash in Garage
  • Photo 20: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    4 car oversized garage
  • Photo 21: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Master
  • Photo 22: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 22 of 50
  • Photo 23: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 23 of 50
  • Photo 24: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Ensuite Bath
  • Photo 25: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 25 of 50
  • Photo 26: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Upper bedroom as an office
  • Photo 27: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Upper bedroom
  • Photo 28: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 28 of 50
  • Photo 29: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Walkout lower level
  • Photo 30: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 30 of 50
  • Photo 31: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 31 of 50
  • Photo 32: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Media Room with projector, screen and speakers
  • Photo 33: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 33 of 50
  • Photo 34: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Lower bedroom
  • Photo 35: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Lower bath
  • Photo 36: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 36 of 50
  • Photo 37: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 37 of 50
  • Photo 38: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Shop interior
  • Photo 39: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 39 of 50
  • Photo 40: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 40 of 50
  • Photo 41: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Barn laundry and bathroom
  • Photo 42: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Tack Room
  • Photo 43: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Barn living area
  • Photo 44: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Barn mechanical room.
  • Photo 45: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 45 of 50
  • Photo 46: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 46 of 50
  • Photo 47: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 47 of 50
  • Photo 48: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 48 of 50
  • Photo 49: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 49 of 50
  • Photo 50: 40191 Retreat Road N in Rural Rocky View County: Rural Rocky View MD Detached for sale : MLS®# A2098854
    Photo 50 of 50

Virtual Tour

Virtual Tour

Listed by Sotheby's International Realty Canada
Data was last updated June 25, 2024 at 06:05 AM (UTC)
Area Statistics
Listings on market:
202
Avg list price:
$1,799,900
Min list price:
$529,900
Max list price:
$13,450,000
Avg days on market:
45
Min days on market:
2
Max days on market:
1,126
Avg price per sq.ft.:
$650.06
These statistics are generated based on the current listing's property type and located in Rural Rocky View MD. Average values are derived using median calculations.
DIANE RICHARDSON
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.