ACTIVE
SOLD
Price
Filters

JUST LISTED ROCKY VIEW COUNTY & FOOTHILLS COUNTY ACREAGES

Forgot password Extend Verify Contact

338025 40 Street W
NONE Rural Foothills County T1S 7B5

$2,999,995
Residential beds: 4 baths: 5.0 3,262 sq. ft. built: 2008

Main Photo: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 1: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 2: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 3: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 4: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 5: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 6: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 7: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 8: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 9: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 10: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 11: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 12: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 13: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 14: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 15: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 16: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 17: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 18: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 19: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 20: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 21: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 22: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 23: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 24: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 25: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 26: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 27: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 28: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 29: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 30: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 31: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 32: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 33: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 34: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 35: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 36: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 37: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 38: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 39: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 40: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 41: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 42: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 43: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 44: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 45: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 46: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Photo 47: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
Status:
Active
Prop. Type:
Residential
MLS® Num:
A2217491
Bedrooms:
4
Bathrooms:
5
Year Built:
2008
This extraordinary estate offers an unmatched lifestyle of luxury, serenity, and elegance. Set on 7.98 acres of meticulously manicured, gated grounds, this private sanctuary provides sweeping views of the majestic mountains and picturesque valleys. Located just minutes from the vibrant city of Calgary, the charming town of Okotoks, the Calgary Polo Club, and the prestigious Strathcona-Tweedsmuir School, this property blends the best of secluded country living with urban convenience. As you approach Through the secure private gates and drive up to your front door via a circular paved driveway, the estate makes a grand impression with a central fountain and a stately portico framing the striking Black Forest front door. The three-acre homesite is beautifully framed by low-maintenance white vinyl fencing and serene landscaping, creating a peaceful oasis that sets the tone for what lies within. Step inside and discover a home where comfort meets sophistication. The grand foyer with 85 ft barrel ceiling welcomes you with a stunning combination of pearlescent marble and black walnut flooring as you enter the main living area a crystal chandelier with hoist capability crowns the main level, adding a sparkling touch of refinement over your open Stairway to the lower level which offers more exquisite living space .The open-concept layout flows seamlessly into the great room, anchored by a custom wood-burning fireplace, creating a warm and inviting atmosphere perfect for quiet evenings or lively gatherings. This then leads you to a chef’s dream kitchen outfitted with a walnut island, premium Sub-Zero and Dacor appliances, and four dishwashers—designed for effortless entertaining. The primary suite is a private retreat, complete with a spa-inspired lounge and a dream-worthy walk-in closet. Throughout the home, thoughtful design and high-end finishes enhance every room. As you head down to the lower level Walk-out you will enjoy your evening with movies, sports or game in your large Recreation games room with a dedicated sports bar with four televisions. This level also offers a workout area along with 2 additional spacious bedrooms and access to your fantastic indoor pool with State of the art ventilation system, indoor area with solarium area and hot tub, and sauna, from here you also have out door access to a huge aggregate patio, ideal for entertaining guests or just relaxing taking in the amazing sunsets, or (for the golf enthusiast) you are just steps to your four-hole putting green-that adds a playful and social element to the home. Outdoors, the luxury continues with a tranquil waterfall and lounge area, and a spacious patio ideal for entertaining or simply enjoying Alberta’s stunning sunsets. Car enthusiasts will appreciate the attached and detached quad garages-both finished to the highest standard—with a car lift, loft space, and ample storage
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Possession:
Possession Date:
Suite:
No
Home Style:
Acreage with Residence, Bungalow
Total Living Area:
3,261.8 sq. ft.
Main Level Finished Area:
1,203.96 sq. ft.
Lower Level Finished Area:
Above Grade Finished Area:
Below Grade Finished Area:
4,855.01 sq. ft.
Taxes:
Tax Assessed Value:
HOA Fee Includes:
Lot Area:
7.98 acre(s)
Lot Frontage:
582'3"
Acres Cleared:
Acres Cultivated:
Acres Irrigated:
Acres Leasehold:
Acres Not Cultivated:
Acres Freehold:
Acres Seeded:
Acres Tame Hay:
Acres Treed:
Acres Waste:
Acres Water Rights:
Front Exposure:
East
Reg. Size:
Reg. Size Includes:
Levels:
One
Total Rooms Above Grade:
7
Year built:
2008 (Age: 17)
Bedrooms:
4 (Above Grd: 1)
Bedrooms Above Grade:
1
Bedrooms Below Grade:
3
Bathrooms:
5.0 (Full:3, Half:2)
Plan:
1110989
Heating:
Boiler, In Floor, Natural Gas, Solar
Basement:
Finished, Full, Walk-Out To Grade
Foundation:
Poured Concrete
New Constr.:
No
Construction Material:
Stone, Stucco, Wood Frame
Structure Type:
House
Roof:
Asphalt Shingle
Ensuite:
Yes
Flooring:
Carpet, Cork, Hardwood, Marble
Cooling:
Central Air
Fireplaces:
2
Fireplace Details:
Heatilator, Mantle, Wood Burning
Water Supply:
Well
Sewer:
Septic Field
Garage:
1
Parking:
Additional Parking, Asphalt, Covered, Drive Through, Heated Garage, Oversized, Paved, Quad or More Attached, Quad or More Detached, See Remarks, Workshop in Garage
Parking Places:
20
Parking Total/Covered:
20 / -
Laundry Features:
Laundry Room, Main Level
NONE
Bar Fridge, Built-In Electric Range, Dishwasher, Dryer, ENERGY STAR Qualified Dishwasher, Garage Control(s), Gas Cooktop, Microwave, Oven-Built-In, Range Hood, Refrigerator, Trash Compactor, Washer, Window Coverings, Wine Refrigerator
N/A
None Known
Floor
Type
Size
Other
Main Floor
Foyer
14'1" × 5'8"
Main Floor
Library
15'8" × 11'5"
Main Floor
Dining Room
22'10" × 12'11"
Main Floor
Living Room
26'5" × 19'2"
Main Floor
Kitchen
20'1" × 11'
Main Floor
Breakfast Nook
15'10" × 10'9"
Main Floor
Office
10'5" × 9'10"
Main Floor
Pantry
9'8" × 6'6"
Main Floor
Laundry
10'10" × 9'2"
Main Floor
Bedroom - Primary
29'1" × 15'11"
Main Floor
Walk-In Closet
18'9" × 13'2"
Lower Level
Game Room
46'8" × 36'9"
Lower Level
Bedroom
15'11" × 12'1"
Lower Level
Bedroom
14'10" × 14'2"
Lower Level
Bedroom
15'9" × 13'6"
Lower Level
Other
58'7" × 48'4"
Lower Level
Furnace/Utility Room
13'4" × 10'2"
Lower Level
Furnace/Utility Room
18'4" × 9'5"
Floor
Ensuite
Pieces
Other
Main Floor
No
2
5'1" x 5'9"
Main Floor
No
2
4'9" x 4'9"
Main Floor
Yes
5
14'2" x 15'1"
Lower Level
No
5
12'1" x 13'
Lower Level
No
4
10'8" x 6'
Title to Land:
Fee Simple
Community Features:
Golf
Interior Features:
Bar, Bookcases, Breakfast Bar, Built-in Features
Exterior Features:
Lighting, Private Entrance, Private Yard, Rain Barrel/Cistern(s), Storage
Patio And Porch Features:
Balcony(s), Front Porch, Patio
Lot Features:
Back Yard, Front Yard, Landscaped, Lawn, Low Maintenance Landscape, No Neighbours Behind, Other, Private, Rectangular Lot, See Remarks, Treed, Underground Sprinklers, Waterfall
Num. of Parcels:
0
Fencing:
Cross Fenced, Fenced
Nearest Town:
De Winton
Region:
Foothills County
Zoning:
CR
Listed Date:
May 03, 2025
Days on Mkt:
  • Photo 1: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 1 of 47
  • Photo 2: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 2 of 47
  • Photo 3: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 3 of 47
  • Photo 4: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 4 of 47
  • Photo 5: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 5 of 47
  • Photo 6: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 6 of 47
  • Photo 7: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 7 of 47
  • Photo 8: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 8 of 47
  • Photo 9: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 9 of 47
  • Photo 10: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 10 of 47
  • Photo 11: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 11 of 47
  • Photo 12: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 12 of 47
  • Photo 13: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 13 of 47
  • Photo 14: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 14 of 47
  • Photo 15: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 15 of 47
  • Photo 16: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 16 of 47
  • Photo 17: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 17 of 47
  • Photo 18: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 18 of 47
  • Photo 19: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 19 of 47
  • Photo 20: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 20 of 47
  • Photo 21: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 21 of 47
  • Photo 22: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 22 of 47
  • Photo 23: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 23 of 47
  • Photo 24: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 24 of 47
  • Photo 25: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 25 of 47
  • Photo 26: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 26 of 47
  • Photo 27: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 27 of 47
  • Photo 28: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 28 of 47
  • Photo 29: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 29 of 47
  • Photo 30: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 30 of 47
  • Photo 31: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 31 of 47
  • Photo 32: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 32 of 47
  • Photo 33: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 33 of 47
  • Photo 34: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 34 of 47
  • Photo 35: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 35 of 47
  • Photo 36: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 36 of 47
  • Photo 37: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 37 of 47
  • Photo 38: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 38 of 47
  • Photo 39: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 39 of 47
  • Photo 40: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 40 of 47
  • Photo 41: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 41 of 47
  • Photo 42: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 42 of 47
  • Photo 43: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 43 of 47
  • Photo 44: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 44 of 47
  • Photo 45: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 45 of 47
  • Photo 46: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 46 of 47
  • Photo 47: 338025 40 Street W: Rural Foothills County Detached for sale : MLS®# A2217491
    Photo 47 of 47
Listed by RE/MAX Realty Professionals
Data was last updated May 5, 2025 at 08:05 AM (UTC)
Area Statistics
Listings on market:
71
Avg list price:
$2,199,900
Min list price:
$1,050,000
Max list price:
$14,900,000
Avg days on market:
38
Min days on market:
2
Max days on market:
699
Avg price per sq.ft.:
$753.72
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.
Stewart J Lowe
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.