Discover acreages, land, farms and homes for sale. Acreage near Calgary, Acreages in Rocky View, Acreages in Mountain view, Acreages in the MD of Bighorn, and Acreages in Clearwater. There is also land for sale in these county’s, land for sale near Calgary. View homes in smaller communities like Water Valley Acreages, Bottrel homes, Bergen Acreages, Cremona homes, Sundre homes for sale.

Forgot password Extend Verify Contact

338009 2 Street E
NONE Rural Foothills County T1S 7B3

$2,398,800
Residential beds: 5 baths: 7.0 3,301 sq. ft. built: 2008

Main Photo: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 1: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 2: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 3: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 4: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 5: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 6: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 7: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 8: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 9: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 10: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 11: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 12: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 13: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 14: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 15: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 16: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 17: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 18: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 19: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 20: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 21: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 22: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 23: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 24: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 25: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 26: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 27: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 28: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 29: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 30: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 31: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 32: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 33: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 34: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 35: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 36: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 37: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 38: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 39: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 40: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 41: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 42: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 43: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 44: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 45: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 46: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 47: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 48: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 49: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Photo 50: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
Status:
Active
Prop. Type:
Residential
MLS® Num:
A2191585
Bedrooms:
5
Bathrooms:
7
Year Built:
2008
Luxury Estate with Breathtaking Mountain Views & Exceptional Amenities! Experience exquisite craftsmanship and timeless design in this breathtaking 3.5 acre gated estate built by Millarcreek Homes. Encased by elegant post-and-rail fencing, this private retreat offers unrivalled mountain views and a setting that seamlessly blends luxury with nature. Every detail has been meticulously curated to provide an elevated living experience where quality and functionality take center stage. The outdoor spaces are designed for both recreation and relaxation. A versatile sport court transforms into an ice rink for winter hockey, while a cascading waterfall and fire pit enhance the tranquil ambiance. An advanced irrigation system nourishes every tree and flowerbed, ensuring lush landscaping year-round. The inviting covered outdoor patio—equipped with a gas fireplace and built-in gas BBQ—creates an inviting space for year-round entertaining, all while taking in the breathtaking west-facing mountain vistas. Beyond the striking barrel-ceiling grand entrance, the foyer’s expansive windows perfectly frame the mountain backdrop, immediately drawing you into the home’s warm yet sophisticated atmosphere. Solid fir beams and rich alder floors set the tone for the exquisite details found within. The heart of the home is the chef’s dream kitchen, thoughtfully designed for both function and style. Equipped with professional grade appliances, dual dishwashers, an ice maker, and a built-in espresso machine, making it ideal for both daily living and entertaining. The sun-drenched master retreat is a true sanctuary, featuring a private deck, a cozy fireplace, and an elegant ensuite. A granite island, spa-like finishes, and a massive walk-in closet complete this opulent space. The home offers five full baths and two half baths, with each of the five bedrooms boasting its own private ensuite, ensuring comfort and convenience for family and guests alike. The lower level walk-out is an entertainer’s paradise with heated floors, three-sided fireplace and soaring 10 ft. ceilings. This level is designed for endless enjoyment, offering a state-of-the-art theatre room for immersive movie nights, a golf simulator for year-round practice, a spacious games room, luxurious sauna for ultimate relaxation and a custom bar with TVs, perfect for watching the game while playing poker. This home is as practical as it is luxurious, with an oversized four-car garage, pre-wiring for a hot tub, and a built-in speaker system throughout. A comprehensive security camera system offers peace of mind, ensuring both safely and privacy. Every element of this exceptional property reflects a no-expense-spared commitment to luxury, comfort, and seamless indoor-outdoor living. Whether you're hosting lavish gathering or enjoying family time, if you're looking for a private retreat that combines natural beauty with world-class amenities, this exceptional home is a must-see.
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Suite:
No
Home Style:
Acreage with Residence, Bungalow
Total Living Area:
3,300.62 sq. ft.
Main Level Finished Area:
3,300.62 sq. ft.
Below Grade Finished Area:
3,288.84 sq. ft.
Lot Area:
3.5 acre(s)
Front Exposure:
East
Levels:
One
Total Rooms Above Grade:
7
Year built:
2008 (Age: 17)
Bedrooms:
5 (Above Grd: 2)
Bedrooms Above Grade:
2
Bedrooms Below Grade:
3
Bathrooms:
7.0 (Full:5, Half:2)
Plan:
0613269
Heating:
Fan Coil, In Floor, Hot Water, Natural Gas
Basement:
Finished, Full, Walk-Out To Grade
Foundation:
Poured Concrete
Builder:
Millarbrook Homes
New Constr.:
No
Construction Material:
Stone, Stucco, Wood Frame
Structure Type:
House
Roof:
Asphalt Shingle
Ensuite:
Yes
Flooring:
Carpet, Ceramic Tile, Hardwood, Stone
Cooling:
Central Air
Fireplaces:
4
Fireplace Details:
Gas
Water Supply:
Well
Sewer:
Septic Field, Septic Tank
Garage:
1
Parking:
Quad or More Attached
Laundry Features:
Laundry Room, Main Level
NONE
Bar Fridge, Built-In Refrigerator, Central Air Conditioner, Dishwasher, Dryer, Freezer, Garage Control(s), Gas Range, Microwave, Range Hood, Washer, Window Coverings, Wine Refrigerator
N/A
Restrictive Covenant-Building Design/Size, Utility Right Of Way
Floor
Type
Size
Other
Main Floor
Bedroom - Primary
57'2" × 52'3"
Main Floor
Bedroom
43'6" × 37'6"
Main Floor
Living Room
65'7" × 61'9"
Main Floor
Kitchen
68'4" × 58'3"
Main Floor
Pantry
20'3" × 19'8"
Main Floor
Dining Room
48'11" × 35'
Main Floor
Breakfast Nook
53'4" × 31'2"
Main Floor
Walk-In Closet
47' × 37'2"
Main Floor
Foyer
42'1" × 26'3"
Main Floor
Mud Room
41'10" × 41'
Main Floor
Office
41' × 39'1"
Main Floor
Laundry
42'1" × 33'4"
Lower Level
Bedroom
37'2" × 36'4"
Lower Level
Bedroom
47' × 35'3"
Lower Level
Bedroom
47'4" × 43'6"
Lower Level
Family Room
73'10" × 73'
Lower Level
Game Room
86'2" × 51'1"
Lower Level
Media Room
52'3" × 47'7"
Lower Level
Flex Space
59'7" × 37'6"
Lower Level
Storage
60'8" × 40'2"
Lower Level
Furnace/Utility Room
32'10" × 18'1"
Floor
Ensuite
Pieces
Other
Main Floor
Yes
5
50' x 54'5"
Main Floor
Yes
4
16'2" x 26'6"
Main Floor
No
2
19'5" x 21'1"
Main Floor
No
2
16'2" x 16'2"
Lower Level
Yes
4
15'10" x 25'8"
Lower Level
Yes
4
16'2" x 26'3"
Lower Level
Yes
3
16'2" x 29'9"
Title to Land:
Fee Simple
Community Features:
Golf, Schools Nearby, Shopping Nearby
Interior Features:
Bar, Beamed Ceilings, Breakfast Bar, Built-in Features, Ceiling Fan(s), Central Vacuum, Closet Organizers, Double Vanity, High Ceilings, No Animal Home, No Smoking Home, Open Floorplan, Pantry, Sauna, Storage, Walk-In Closet(s), Wired for Sound
Exterior Features:
Balcony, Basketball Court, Built-in Barbecue, Fire Pit, Private Yard, Tennis Court(s)
Patio And Porch Features:
Balcony(s), Deck
Lot Features:
Back Yard, Front Yard, Lawn, No Neighbours Behind, Landscaped, Level, Many Trees, Underground Sprinklers, Pasture, Waterfall
Num. of Parcels:
0
Outbuildings:
Shed
Fencing:
Fenced
Nearest Town:
Okotoks
Region:
Foothills County
Zoning:
CR
Listed Date:
Feb 07, 2025
  • Photo 1: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 1 of 50
  • Photo 2: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 2 of 50
  • Photo 3: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 3 of 50
  • Photo 4: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 4 of 50
  • Photo 5: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 5 of 50
  • Photo 6: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 6 of 50
  • Photo 7: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 7 of 50
  • Photo 8: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 8 of 50
  • Photo 9: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 9 of 50
  • Photo 10: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 10 of 50
  • Photo 11: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 11 of 50
  • Photo 12: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 12 of 50
  • Photo 13: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 13 of 50
  • Photo 14: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 14 of 50
  • Photo 15: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 15 of 50
  • Photo 16: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 16 of 50
  • Photo 17: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 17 of 50
  • Photo 18: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 18 of 50
  • Photo 19: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 19 of 50
  • Photo 20: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 20 of 50
  • Photo 21: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 21 of 50
  • Photo 22: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 22 of 50
  • Photo 23: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 23 of 50
  • Photo 24: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 24 of 50
  • Photo 25: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 25 of 50
  • Photo 26: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 26 of 50
  • Photo 27: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 27 of 50
  • Photo 28: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 28 of 50
  • Photo 29: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 29 of 50
  • Photo 30: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 30 of 50
  • Photo 31: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 31 of 50
  • Photo 32: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 32 of 50
  • Photo 33: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 33 of 50
  • Photo 34: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 34 of 50
  • Photo 35: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 35 of 50
  • Photo 36: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 36 of 50
  • Photo 37: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 37 of 50
  • Photo 38: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 38 of 50
  • Photo 39: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 39 of 50
  • Photo 40: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 40 of 50
  • Photo 41: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 41 of 50
  • Photo 42: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 42 of 50
  • Photo 43: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 43 of 50
  • Photo 44: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 44 of 50
  • Photo 45: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 45 of 50
  • Photo 46: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 46 of 50
  • Photo 47: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 47 of 50
  • Photo 48: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 48 of 50
  • Photo 49: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 49 of 50
  • Photo 50: 338009 2 Street E: Rural Foothills County Detached for sale : MLS®# A2191585
    Photo 50 of 50
Listed by The Agency Calgary
Data was last updated February 12, 2025 at 08:05 PM (UTC)
Area Statistics
Listings on market:
49
Avg list price:
$2,100,000
Min list price:
$1,049,000
Max list price:
$14,900,000
Avg days on market:
46
Min days on market:
1
Max days on market:
617
Avg price per sq.ft.:
$730.99
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.