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.
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.
Property Details
Price:
$2,999,999
MLS #:
A2190123
Status:
Active
Beds:
6
Baths:
6
Type:
Single Family
Subtype:
Detached
Listed Date:
Jan 25, 2025
Finished Sq Ft:
4,614
Lot Size:
220,849 sqft / 5.07 acres (approx)
Year Built:
2023
See this Listing
Schools
Interior
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
Basement
Separate/ Exterior Entry, Finished, Full
Bathrooms Full
5
Bathrooms Half
1
Laundry Features
Electric Dryer Hookup, Laundry Room, Main Level, Multiple Locations, Sink, Upper Level, Washer Hookup
Exterior
Exterior Features
Barbecue, Covered Courtyard, Electric Grill, Gas Grill, Lighting, Playground, Private Entrance, Rain Barrel/ Cistern(s)
Lot Features
Backs on to Park/ Green Space, No Neighbours Behind, Other, Views
Parking Features
Double Garage Attached, Parking Pad, Single Garage Attached
Parking Total
10
Patio And Porch Features
Deck, Enclosed, Front Porch, Porch, Rear Porch, Screened
Roof
Asphalt Shingle, Membrane, Mixed
Sewer
Mound Septic
Financial
Map
Community
- Address40075 299 Avenue E Rural Foothills County AB
- CityRural Foothills County
- CountyFoothills County
- Zip CodeT1S 4R2
Subdivisions in Rural Foothills County
Market Summary
Current real estate data for Single Family in Rural Foothills County as of Sep 11, 2025
92
Single Family Listed
100
Avg DOM
860
Avg $ / SqFt
$2,131,775
Avg List Price
Property Summary
- 40075 299 Avenue E Rural Foothills County AB is a Single Family for sale in Rural Foothills County, AB, T1S 4R2. It is listed for $2,999,999 and features 6 beds, 6 baths, and has approximately 4,614 square feet of living space, and was originally constructed in 2023. The current price per square foot is $650. The average price per square foot for Single Family listings in Rural Foothills County is $860. The average listing price for Single Family in Rural Foothills County is $2,131,775. To schedule a showing of MLS#a2190123 at 40075 299 Avenue E in Rural Foothills County, AB, contact your STONEMERE REAL ESTATE SOLUTIONS agent at 403-903-5395.
Similar Listings Nearby

40075 299 Avenue E
Rural Foothills County, AB