Erica Broad Real Estate Professionals Inc.

Office 403-606-3541 | EMAIL erica@ericabroad.com |

Office Listings

338025 40 Street W
NONE Rural Foothills County T1S 1A1

$3,499,500
Residential beds: 3 baths: 5.0 3,243 sq. ft. built: 2008

Main Photo: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 1: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 2: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 3: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 4: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 5: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 6: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 7: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 8: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 9: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 10: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 11: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 12: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 13: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 14: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 15: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 16: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 17: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 18: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 19: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 20: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 21: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 22: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 23: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 24: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 25: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 26: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 27: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 28: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 29: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 30: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 31: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 32: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 33: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 34: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 35: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 36: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 37: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 38: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 39: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 40: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 41: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 42: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 43: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 44: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 45: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 46: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 47: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 48: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Photo 49: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
Status:
Active
Prop. Type:
Residential
MLS® Num:
A1101925
Bedrooms:
3
Bathrooms:
5
Year Built:
2008
WHAT DREAMS ARE MADE OF....THIS SPECTACULAR PROPERTY HAS IT ALL!! Feast your eyes on the majestic mountain and valley views from this sophisticated and luxurious executive home depicting true country elegance, designed by renowned architect, John Haddon. This home is a masterpiece of design and craftmanship for the most discriminating buyer. Perfectly situated on 8 acres m/l with a premier location, surrounded by tree-lined gracefully manicured grounds, offering a private parklike setting, only minutes to Calgary, Okotoks, prestigious Strathcona Tweedmuir School, and several riding facilities and golf courses. Over 8,200 sq. ft. of custom quality shines throughout this palatial home with grand foyer, soaring barrel ceiling, towering windows, and sprawling entertaining spaces including massive indoor swimming pool wing with hot tub, and lounge areas. Attention to detail throughout creates a functional and impressive design with exceptional finishing touches. Polished marble and black walnut flooring, designer crystal light fixtures, granite, top quality appliances, smart home technology, infloor heat, energy efficient with solar panels and wind turbine, and much more. This exquisite home features 3 bdrms, 6 baths, 2nd den overlooking pool area. Stunning gourmet is a chef's dream. Elaborate great room with attractive woodburning fireplace and towering windows, deluxe main level office, and exquisite formal dining room with hammered tin ceiling. Spectacular master bdrm with 156 sq. ft. closet/dressing room and stunning ensuite. Fully developed walkout basement featuring sports bar with 4 TV screens, games, media areas. Let's not forget the elaborate indoor pool wing surrounded by lounging areas, hot tub, water feature, providing you and your family with your own at home resort/spa. Dream quad attached and quad detached garage/shop accommodating 8 inside stalls plus lift and upper loft areas provide the man cave space for the avid car/collector/handyman enthusiast. Absolutely nothing spared to the very last detail. THIS EXCEPTIONAL PROPERTY MUST BE SEEN TO BE TRULY APPRECIATED! See virtual tour.
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Possession:
60 Days / Neg
Suite:
Suite - None
Home Style:
Acreage with Residence, Bungalow
Total Living Area:
3,243 sq. ft.
Main Level Finished Area:
3,243 sq. ft.
Below Grade Finished Area:
4,976 sq. ft.
Lot Area:
7.98 acre(s)
Lot Frontage:
582'3"
Acres Freehold:
0.0
Front Exposure:
East
Entry Level:
0
Stories Total:
0
Levels:
One
Total Rooms Above Grade:
6
Year built:
2008 (Age: 13)
Bedrooms:
3 (Above Grd: 1)
Bedrooms Above Grade:
1
Bedrooms Below Grade:
2
Bathrooms:
5.0 (Full:3, Half:2)
Plan:
1110989
Heating:
In Floor, Natural Gas, See Remarks
Basement:
Finished, Walk-Out
Foundation:
Poured Concrete
New Constr.:
No
Construction Material:
Asphalt, See Remarks, Stone, Stucco, Wood Frame
Structure Type:
House
Roof:
Asphalt Shingle
Ensuite:
Yes
Flooring:
Cork, Hardwood, Marble, See Remarks
Cooling:
Central Air
Fireplaces:
2
Fireplace Details:
Gas
Water Supply:
Well
Sewer:
Septic Field, Septic Tank
Utilities:
Heating Paid For, Electricity Paid For, Phone Paid For, Water Paid For
Garage:
1
Garage Spaces:
13
Parking:
Driveway, Asphalt, Quad or More Attached, Quad or More Detached
Parking Places:
13.0
Energized Pkg:
0
Parking Total/Covered:
13 / -
Assigned Pkg:
0
Common Pkg:
0
Laundry Features:
Laundry Room, Main Level
NONE
Dishwasher, Dryer, ENERGY STAR Qualified Dishwasher, Garage Control(s), Gas Cooktop, Microwave, Oven-Built-In, Range Hood, Refrigerator, See Remarks, Washer, Window Coverings, Wine Refrigerator
Floor
Type
Size
Other
Main Floor
Master Bedroom
23'6" × 16'
Main Floor
Den
10'8" × 9'8"
Main Floor
Office
16'4" × 11'5"
Main Floor
Breakfast Nook
15'10" × 15'
Main Floor
Kitchen
15'10" × 15'8"
Main Floor
Dining Room
16'4" × 12'4"
Main Floor
Great Room
22'10" × 18'2"
Lower Level
Bedroom
14' × 13'4"
Lower Level
Bedroom
16' × 12'
Lower Level
Game Room
38' × 15'2"
Lower Level
Game Room
21'6" × 21'2"
Lower Level
Furnace/Utility Room
19' × 9'4"
Lower Level
Furnace/Utility Room
13'6" × 10'6"
Lower Level
Den
15'10" × 13'6"
Lower Level
Other
14'8" × 11'
Floor
Ensuite
Pieces
Other
Main Floor
Yes
5
Main Floor
No
2
0' x 0'
Main Floor
No
2
Lower Level
No
3
0' x 0'
Lower Level
No
4
0' x 0'
School Bus:
No
Title to Land:
Fee Simple
Community Features:
Golf
Interior Features:
Bookcases, No Smoking Home, Vaulted Ceiling(s)
Exterior Features:
Private Entrance, Private Yard
Patio And Porch Features:
Deck, Patio
Lot Features:
Cul-De-Sac, Fruit Trees/Shrub(s), Landscaped, Level, Private, Rectangular Lot, See Remarks, Treed, Views
Pool Features:
Indoor
Num. of Parcels:
0
Fencing:
Partial
Nearest Town:
Okotoks
Region:
Foothills County
Zoning:
CRES
Listed Date:
Apr 30, 2021
  • Photo 1: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 1 of 49
  • Photo 2: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 2 of 49
  • Photo 3: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 3 of 49
  • Photo 4: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 4 of 49
  • Photo 5: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 5 of 49
  • Photo 6: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 6 of 49
  • Photo 7: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 7 of 49
  • Photo 8: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 8 of 49
  • Photo 9: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 9 of 49
  • Photo 10: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 10 of 49
  • Photo 11: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 11 of 49
  • Photo 12: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 12 of 49
  • Photo 13: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 13 of 49
  • Photo 14: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 14 of 49
  • Photo 15: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 15 of 49
  • Photo 16: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 16 of 49
  • Photo 17: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 17 of 49
  • Photo 18: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 18 of 49
  • Photo 19: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 19 of 49
  • Photo 20: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 20 of 49
  • Photo 21: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 21 of 49
  • Photo 22: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 22 of 49
  • Photo 23: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 23 of 49
  • Photo 24: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 24 of 49
  • Photo 25: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 25 of 49
  • Photo 26: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 26 of 49
  • Photo 27: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 27 of 49
  • Photo 28: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 28 of 49
  • Photo 29: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 29 of 49
  • Photo 30: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 30 of 49
  • Photo 31: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 31 of 49
  • Photo 32: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 32 of 49
  • Photo 33: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 33 of 49
  • Photo 34: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 34 of 49
  • Photo 35: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 35 of 49
  • Photo 36: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 36 of 49
  • Photo 37: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 37 of 49
  • Photo 38: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 38 of 49
  • Photo 39: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 39 of 49
  • Photo 40: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 40 of 49
  • Photo 41: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 41 of 49
  • Photo 42: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 42 of 49
  • Photo 43: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 43 of 49
  • Photo 44: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 44 of 49
  • Photo 45: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 45 of 49
  • Photo 46: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 46 of 49
  • Photo 47: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 47 of 49
  • Photo 48: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 48 of 49
  • Photo 49: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A1101925
    Photo 49 of 49
Listed by Sheryl Lauinger of REAL ESTATE PROFESSIONALS INC.
Data was last updated May 15, 2021 at 02:05 PM (UTC)
Area Statistics
Listings on market:
107
Avg list price:
$1,290,000
Min list price:
$135,000
Max list price:
$3,688,000
Avg days on market:
36
Min days on market:
1
Max days on market:
1,885
Avg price per sq.ft.:
$535.2
These statistics are generated based on the current listing's property type and located in Rural Foothills County. Average values are derived using median calculations.
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.