Map
Listed price in listed location currency (CAD).
$2,899,999

666

MLS® A2332999

Overview

Key Facts

Type Single Family Residence
Levels Residential
Size 4614 sqft
Garage Yes
Taxes 
Days Active 6
Lot Size 5.07 Acres
Approx. Age 2023
Avg. Price Per Sqft $628
MLS® Number A2332999

Property Address: 40075 299 Ave E, Foothills, AB, T1S4R2

Average square foot calculated using Size range provided by listing agent.

Description

*** For more info, please click "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.
MLS® NumberA2332999
Laundry LevelMain
Central VacNo
FireplaceYes
Acreage
Exterior
GarageYes
Approx. Age2023
BasementFull
DrivewayDouble Garage Attached, Single Garage Attached
Garage Spaces
HeatIn Floor, Fireplace(s), Forced Air, Natural Gas, Radiant
A/CCentral Air, Sep. HVAC Units

Extras

n/a

Price History

Last Sold Price

----

Appreciation

--

Avg. Days Listed

--

Today, For Sale for $2,899,999

For Sale · 6 days

$2,899,999

MLS® A2332999

7 days ago

Not Sold Yet

July 2026, For Sale for $2,899,999

For Sale · 6 days

$2,899,999

MLS® A2332999

7 days ago

Not Sold Yet

  • Jul 8, 2026, Expired for $2,899,999

Real estate boards require that you sign in to see the full details of this property. Log in or sign up to see price history.

Map

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment
Loading...

Similar Listings

Comparable Properties