Save
Ask
Tour
Hide
Share
$2,999,999
371 Days On Site

40075 299 Avenue E
Rural Foothills County, AB T1S 4R2

For Sale|Single Family Residence|Active
6
Beds
6
Total Baths
5
Full Baths
1
Partial Bath
4,614.19
SqFt
$650
/SqFt
2023
Built
County:
Foothills County
Call Now: 587-871-4523
Is this the listing for you? We can help make it yours.
587-871-4523
40075 299 Avenue E40075 299 Avenue E40075 299 Avenue E40075 299 Avenue E
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$13,687
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$2,999,999
Days On Site 
371 Days
Bedrooms 
6
Inside Area (SqFt) 
4,614.19 sqft
Total Baths 
6
Full Baths 
5
Partial Baths 
1
Lot Size 
5.07 Acres
Year Built 
2023
MLS® Number 
A2190123
Status 
Active
Property Tax 
$12,776
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
a year agoListing first seen on site
a year agoListing updated with changes from the MLS®
General Features
Acres 
5.07
Attached Garage 
Yes
Foundation 
CombinationSlab
Garage 
Yes
Garage Spaces 
2
Levels 
Two
Parking 
AttachedGarageGarage Door Opener
Parking Spaces 
10
Property Condition 
New Construction
Property Sub Type 
Single Family Residence
Sewer 
Mound Septic
SqFt Above 
4614.2
SqFt Below 
2517.23
Style 
2 StoreyAcreage with Residence
Water Source 
Well
Zoning 
CR
Interior Features
Appliances 
Convection OvenDishwasherDryerFreezerGas CooktopGas RangeGas Water HeaterHumidifierMicrowaveRange HoodRefrigeratorWarming DrawerWasherWine RefrigeratorDisposal
Basement 
FullFinishedExterior EntrySump Pump
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
ElectricGas
Fireplaces 
2
Flooring 
CarpetCeramic TileHardwoodTile
Heating 
Fireplace(s)Forced AirNatural GasRadiant
Interior 
BidetBuilt-in FeaturesCentral VacuumChandelierDouble VanityHigh CeilingsKitchen IslandOpen FloorplanPantryRecessed LightingSoaking TubStorageWalk-In Closet(s)Wired for SoundSaunaMaster Downstairs
Laundry Features 
Electric Dryer HookupLaundry RoomMain LevelMultiple LocationsSinkUpper LevelWasher Hookup
Window Features 
Window Coverings
2pc Bathroom 
Dimensions - 2`11" x 7`8"Level - Main
3pc Bathroom 
Dimensions - 11`0" x 4`11"Level - Basement
3pc Ensuite bath 
Dimensions - 6`5" x 10`8"Level - Upper
5pc Ensuite bath 
Dimensions - 17`2" x 11`2"Level - Main
6pc Bathroom 
Dimensions - 12`6" x 11`2"Level - Upper
Bedroom 
Dimensions - 13`5" x 14`0"Level - Basement
Bedroom - Primary 
Dimensions - 19`6" x 18`0"Level - Main
Den 
Dimensions - 14`1" x 17`3"Level - Upper
Dining Room 
Dimensions - 13`6" x 17`7"Level - Main
Exercise Room 
Dimensions - 37`10" x 24`6"Level - Basement
Furnace/Utility Room 
Dimensions - 10`1" x 4`11"Level - Basement
Game Room 
Dimensions - 28`11" x 20`1"Level - Basement
Kitchen 
Dimensions - 15`8" x 17`7"Level - Main
Laundry 
Dimensions - 11`9" x 8`0"Level - Main
Living Room 
Dimensions - 29`11" x 20`1"Level - Main
Mud Room 
Dimensions - 11`3" x 24`0"Level - Main
Office 
Dimensions - 12`0" x 15`4"Level - Upper
Other 
Dimensions - 9`5" x 7`4"Level - Main
Pantry 
Dimensions - 9`4" x 9`2"Level - Main
Storage 
Dimensions - 13`11" x 7`6"Level - Main
Walk-In Closet 
Dimensions - 13`3" x 13`0"Level - Main
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
ICFs (Insulated Concrete Forms)StoneStuccoFrame
Exterior 
BarbecueCovered CourtyardElectric GrillGas GrillLightingPlaygroundPrivate EntranceRain Barrel/Cistern(s)
Frontage 
240.14M 787`11"
Lot Features 
OtherViews
Patio And Porch 
DeckEnclosedFront PorchPorchRear PorchScreened
Roof 
MembraneMixedShingleAsphalt
Windows/Doors 
Window Coverings
Community Features
Accessibility Features 
Therapeutic Whirlpool
Community Features 
ClubhouseGolfParkPlayground
Township 
21
Listing courtesy of Darya Pfund of Easy List Realty

Listing information is provided by Participants of the Alberta One Realty Listing Services (Pillar 9). IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, Alberta One Realty Listing Services (Pillar 9)
Last checked 2026-01-31 11:16 AM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share