Connect

Find us on...

Dashboard

Login using...

Justin Havre Real Estate Team

Real Estate Advisor

  • Office 403.217.0003
Questions?

338009 2 Street E, Rural Foothills County, Alberta – $2,250,000

  • 5 Beds
  • 6 Baths
  • 3,301 Sqft
  • Acres
  • 5 Beds
  • 6 Baths
  • 3,301 Sqft
  • Acres

338009 2 Street E

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.

Essential Information

  • MLS® #A2191585
  • Price$2,250,000
  • Bedrooms5
  • Bathrooms6
  • Full Baths5
  • Half Baths2
  • Square Footage3,301
  • Lot SQFT152,460
  • Year Built2008
  • TypeResidential
  • Sub-TypeDetached
  • StatusActive

Style

Acreage with Residence, Bungalow

Community Information

  • Address338009 2 Street E
  • SubdivisionNONE
  • CityRural Foothills County
  • ProvinceAlberta
  • Postal CodeT1S 7B3

Amenities

  • ParkingQuad or More Attached

Interior

  • CoolingCentral Air
  • Has BasementYes
  • FireplaceYes
  • # of Fireplaces4
  • FireplacesGas
  • Basement DevelopmentFinished, Full, Walk-Out
  • Basement TypeFinished, Full, Walk-Out

Goods Included

Bar, Breakfast Bar, Beamed Ceilings, Built-in Features, Ceiling Fan(s), Closet Organizers, Central Vacuum, Double Vanity, High Ceilings, No Animal Home, No Smoking Home, Open Floorplan, Pantry, Sauna, Storage, Wired for Sound, Walk-In Closet(s)

Appliances

Central Air Conditioner, Bar Fridge, Built-In Refrigerator, Dishwasher, Dryer, Freezer, Garage Control(s), Gas Range, Microwave, Range Hood, Washer, Window Coverings, Wine Refrigerator

Heating

Fan Coil, Hot Water, In Floor, Natural Gas

Flooring

Carpet, Ceramic Tile, Hardwood, Stone

Exterior

  • RoofAsphalt Shingle
  • ConstructionStone, Stucco, Wood Frame
  • FoundationPoured Concrete
  • Front ExposureE

Exterior Features

Balcony, Built-in Barbecue, Basketball Court, Fire Pit, Private Yard, Tennis Court(s)

Lot Description

Back Yard, Front Yard, Lawn, Landscaped, Level, Many Trees, No Neighbours Behind, Pasture, Underground Sprinklers, Waterfall

Site Influence

Back Yard, Front Yard, Lawn, Landscaped, Level, Many Trees, No Neighbours Behind, Pasture, Underground Sprinklers, Waterfall

Additional Information

  • ZoningCR

Room Dimensions

  • Dining Room48`11 x 35`0
  • Family Room73`10 x 73`0
  • Kitchen68`4 x 58`3
  • Living Room65`7 x 61`9
  • Master Bedroom57`2 x 52`3
  • Bedroom 243`6 x 37`6
  • Bedroom 337`2 x 36`4
  • Bedroom 447`0 x 35`3

Listing Details

  • OfficeThe Agency Calgary

Schedule a Tour

Wednesday
9
Jul
Thursday
10
Jul
Friday
11
Jul
Saturday
12
Jul
Sunday
13
Jul
Monday
14
Jul
Tuesday
15
Jul
Wednesday
16
Jul
Thursday
17
Jul
Friday
18
Jul
Saturday
19
Jul
Sunday
20
Jul
Monday
21
Jul

Take a tour with a buyer's agent

Request this time
It's free, with no obligation - cancel any time.
Please provide a valid email address.

Disclaimer and Acknowledgment

I acknowledge and authorize calgaryhomes.ca and Justin Havre of eXp Realty to refer me to a suitable agent(s) in a home purchase, sale and/or mortgage approval. In such case, I also acknowledge and authorize that the referred agent(s) may pay a referral fee. (This does not constitute a formal buyers brokerage agreement nor compel me to use the referred agent(s)). My information will not be disclosed to any party in any way not associated with the Privacy Policy.

The Agency Calgary.

MLS listings provided by Pillar 9™. Information Deemed Reliable But Not Guaranteed. The information provided by this website is for the personal, non-commercial use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Listing information last updated on July 8th, 2025 at 8:45am MDT.

CalgaryHomes.ca