Connect

Find us on...

Dashboard

Login using...

Justin Havre Real Estate Team

Real Estate Advisor

  • Office 403.217.0003
Questions?

40075 299 Avenue E, Rural Foothills County, Alberta – $2,999,999

  • 6 Beds
  • Baths
  • 4,614 Sqft
  • 5.07 Acres
  • 6 Beds
  • Baths
  • 4,614 Sqft
  • 5.07 Acres

40075 299 Avenue E

For more info, please click the "More Information" button. Welcome to an extraordinary blend of modern elegance and countryside charm. Built in 2023, this stunning 6-bedroom, 5.5-bathroom estate offers over 7,200 sq. ft. of meticulously designed living space, nestled on a picturesque 5-acre property. More than just a home, it’s a peaceful retreat surrounded by nature, yet conveniently close to Calgary’s South Campus hospital, top-rated schools, and urban amenities, offering the perfect balance of serene country living and city convenience. As you enter through natural flat stone pillars, a grand entryway welcomes you into warm and expansive living areas set against the breathtaking backdrop of the Rocky Mountains. The living room features a towering stone fireplace that serves as a centerpiece, while a glass-surround walkway bathes the space in natural light. Telescoping glass doors seamlessly connect indoor and outdoor spaces, making it ideal for entertaining or relaxing with loved ones. The chef’s kitchen is the heart of the home, featuring double islands perfect for hosting, high-end appliances including a combination steam oven, and two butler’s pantries. These pantries provide ample storage and include access to a hidden workspace and a single garage, adding both functionality and convenience to the kitchen’s design. The main-floor primary suite is a true sanctuary, boasting floor-to-ceiling west-facing windows that frame stunning views. The spa-inspired en-suite includes luxurious stone-accented walls, an oversized soaker tub, and a walk-in shower, while the custom-designed closet caters to a modern lifestyle with ample space and organization. Upstairs, three spacious bedrooms, each with walk-in closets and private bathrooms, provide comfort and privacy for family or guests. A striking glass walkway connects a custom home office and a cozy family room, creating a unique and inviting upper-level retreat. The lower level is designed for both relaxation and activity. Highlights include a home gym with a pro-height basketball hoop, a luxurious steam shower for post-workout relaxation, an additional bedroom, and a versatile flex room that opens directly to the backyard. The outdoor space offers endless possibilities. The expansive backyard is a blank canvas awaiting your vision—whether it’s a vibrant garden, a playground, or even space for animals. The property’s 5-acre expanse ensures privacy and room to customize. Behind the beauty of this estate lies impeccable functionality. Two mechanical rooms house high-end systems, including advanced A/C, on-demand hot water, and multiple furnaces and boilers, ensuring comfort year-round. Premium finishes, custom flooring, and thoughtful details elevate the home’s design. This property is more than a residence - it’s a lifestyle. Whether hosting grand gatherings, seeking a tranquil retreat, or making cherished family memories, this estate delivers it all. Don’t miss your opportunity to own this incredible country home.

Essential Information

  • MLS® #A2190123
  • Price$2,999,999
  • Bedrooms6
  • Bathrooms5.5
  • Full Baths5
  • Half Baths1
  • Square Footage4,614
  • Lot SQFT220,849
  • Year Built2023
  • TypeResidential
  • Sub-TypeDetached
  • StatusActive

Style

2 Storey, Acreage with Residence

Community Information

Amenities

  • Parking Spaces10
  • # of Garages2

Parking

Double Garage Attached, Parking Pad, Single Garage Attached

Interior

  • CoolingCentral Air, Sep. HVAC Units
  • Has BasementYes
  • FireplaceYes
  • # of Fireplaces2
  • FireplacesElectric, Gas
  • Basement DevelopmentFull
  • Basement TypeFull

Goods Included

Bidet, Built-in Features, Central Vacuum, Chandelier, Closet Organizers, Double Vanity, French Door, High Ceilings, Jetted Tub, Kitchen Island, Open Floorplan, Pantry, Primary Downstairs, Recessed Lighting, Recreation Facilities, Separate Entrance, Soaking Tub, Steam Room, Storage, Sump Pump(s), Walk-In Closet(s), Wired for Sound

Appliances

Convection Oven, Dishwasher, Dryer, Freezer, Garage Control(s), Garburator, Gas Cooktop, Gas Range, Gas Water Heater, Humidifier, Microwave, Range Hood, Refrigerator, Warming Drawer, Washer, Window Coverings, Wine Refrigerator

Heating

In Floor, Fireplace(s), Forced Air, Natural Gas, Radiant

Flooring

Carpet, Ceramic Tile, Hardwood, Tile

Exterior

  • Front ExposureNE
  • Frontage Metres240.14M 787`11"

Exterior Features

Barbecue, Covered Courtyard, Electric Grill, Gas Grill, Lighting, Playground, Private Entrance, Rain Barrel/Cistern(s)

Lot Description

Backs on to Park/Green Space, No Neighbours Behind, Other, Views

Roof

Asphalt Shingle, Membrane, Mixed

Construction

ICFs (Insulated Concrete Forms), Mixed, Stone, Stucco, Wood Frame

Foundation

Combination, ICF Block, Poured Concrete, Slab

Site Influence

Backs on to Park/Green Space, No Neighbours Behind, Other, Views

Additional Information

  • ZoningCR

Room Dimensions

  • Den14`1" x 17`3"
  • Dining Room13`6" x 17`7"
  • Kitchen15`8" x 17`7"
  • Living Room29`11" x 20`1"
  • Master Bedroom19`6" x 18`0"
  • Bedroom 217`2" x 26`2"
  • Bedroom 315`3" x 13`5"
  • Bedroom 412`7" x 16`7"
  • Other Room 19`5" x 7`4"

Listing Details

  • OfficeEasy List Realty

Schedule a Tour

Saturday
7
Mar
Sunday
8
Mar
Monday
9
Mar
Tuesday
10
Mar
Wednesday
11
Mar
Thursday
12
Mar
Friday
13
Mar
Saturday
14
Mar
Sunday
15
Mar
Monday
16
Mar
Tuesday
17
Mar
Wednesday
18
Mar
Thursday
19
Mar

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.

Easy List Realty.

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 March 6th, 2026 at 4:24pm MST.

CalgaryHomes.ca