Featured Listings
164 - 3809 45 Street Southwest
$339,888
![](img/pixel.gif)
***OPEN HOUSE 27th April 3:00-5:00PM*** Welcome to this Freshly Renovated Townhouse with a Private Yard. This bright and thoughtfully renovated home features a Generous Brand...
Real Estate Professionals Inc.
120 Heritage Isle
$2,190,000
![](img/pixel.gif)
Welcome home to this incredible and renovated home backing onto a private wooded ravine & situated on a 0.63 acre lot in the estate community...
RE/MAX Landan Real Estate
Public Search
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
- Status:
- Active
- Prop. Type:
- Residential
- MLS® Num:
- A2098854
- Bedrooms:
- 5
- Bathrooms:
- 5
- Year Built:
- 1994
- Photos (50)
- Schedule / Email
- Send listing
- Mortgage calculator
- Print listing
Schedule a viewing:
Cancel any time.
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.239.04 m2
- Main Level Finished Area:
- 1,854 sq. ft.172.24 m2
- Upper Level Finished Area:
- 719 sq. ft.66.8 m2
- Below Grade Finished Area:
- 1,794 sq. ft.166.67 m2
- Lot Area:
- 5.96 acre(s)2.41 hectare(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"5.54 m × 17'7"5.36 m
- Main Floor
- Dining Room
- 12'8"3.86 m × 8'11"2.72 m
- Main Floor
- Kitchen
- 23'1"7.04 m × 19'7"5.97 m
- Main Floor
- Bedroom - Primary
- 17'4"5.28 m × 13'2"4.01 m
- Main Floor
- Laundry
- 9'6"2.90 m × 6'8"2.03 m
- Main Floor
- Mud Room
- 13'1"3.99 m × 7'8"2.34 m
- 2nd Floor
- Bedroom
- 17'11"5.46 m × 13'11"4.24 m
- 2nd Floor
- Bedroom
- 14'5"4.39 m × 14'4.27 m
- Lower Level
- Family Room
- 15'9"4.80 m × 15'1"4.60 m
- Lower Level
- Hobby Room
- 11'10"3.61 m × 7'9"2.36 m
- Lower Level
- Game Room
- 17'2"5.23 m × 15'9"4.80 m
- Lower Level
- Media Room
- 21'10"6.65 m × 13'6"4.11 m
- Lower Level
- Bedroom
- 13'6"4.11 m × 11'7"3.53 m
- Lower Level
- Bedroom
- 16'11"5.16 m × 12'2"3.71 m
- Lower Level
- Furnace/Utility Room
- 14'8"4.47 m × 6'8"2.03 m
- 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 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
-
Wood Burning Stone Fireplace
-
Photo 9 of 50
-
Photo 10 of 50
-
Photo 11 of 50
-
Photo 12 of 50
-
Photo 13 of 50
-
Photo 14 of 50
-
Photo 15 of 50
-
Wolf Gas Range with high CFM built-in hoodfan
-
Photo 17 of 50
-
Mud Room
-
Dog Wash in Garage
-
4 car oversized garage
-
Master
-
Photo 22 of 50
-
Photo 23 of 50
-
Ensuite Bath
-
Photo 25 of 50
-
Upper bedroom as an office
-
Upper bedroom
-
Photo 28 of 50
-
Walkout lower level
-
Photo 30 of 50
-
Photo 31 of 50
-
Media Room with projector, screen and speakers
-
Photo 33 of 50
-
Lower bedroom
-
Lower bath
-
Photo 36 of 50
-
Photo 37 of 50
-
Shop interior
-
Photo 39 of 50
-
Photo 40 of 50
-
Barn laundry and bathroom
-
Tack Room
-
Barn living area
-
Barn mechanical room.
-
Photo 45 of 50
-
Photo 46 of 50
-
Photo 47 of 50
-
Photo 48 of 50
-
Photo 49 of 50
-
Photo 50 of 50
Virtual Tour
Virtual Tour
Larger map options:
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
- CIR REALTY
- 1 (403) 397 3706
- 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.