For Sale: 40075 299 Avenue E, Foothills County, AB - REW
Boost your listing
Listing featured. Your listing will be featured on REW.
View featured placement
$2,899,999
6 bd • 6 ba • 4615 sf • House
40075 299 Avenue E
Virtual TourStreet ViewDirections
$2,899,999
Get pre-approved

40075 299th Avenue EFoothills County, AB, T1S 4R2

  • 6 Bed
  • 6 Bath
  • 4615 Sqft
  • House

About this home

*** For more information, 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 count
Listed by: Darya Pfund, Easy List Realty

Home facts and features

Price details
List Price
$2,899,999
Get Pre-Approved
Home facts
Bedrooms
6
Full Bathrooms
5
Partial Bathrooms
1
Parking Spaces
2
Property Type
House
Lot Size
6 ft²
Frontage
787.89 ft
Year Built
Built in 2023 (3 yrs old)
Style
2 Storey,Acreage with Residence
Heating Type
In Floor,Fireplace(s),Forced Air,Natural Gas,Radiant
Cooling
Central Air,Sep. HVAC Units
Basement Details
Full
Features
Backs On To Park/green Space, Barbecue, Bidet, Built-in Features, Central Vacuum, Chandelier, Closet Organizers, Covered Courtyard, Double Vanity, Electric, Electric Dryer Hookup, Electric Grill, French Door, Gas, Gas Grill, High Ceilings, Jetted Tub, Kitchen Island, Laundry Room, Lighting, Main Level, Multiple Locations, No Neighbours Behind, Open Floorplan, Other, Pantry, Park, Primary Downstairs, Private Entrance, Rain Barrel/cistern(s), Recessed Lighting, Recreation Facilities, Schools Nearby, Separate Entrance, Sink, Soaking Tub, Steam Room, Sump Pump(s), Upper Level, Views, Walk-in Closet(s), Washer Hookup, Wired For Sound
Amenities
Clubhouse, Golf Course, Playground, Shopping Nearby, Storage
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
Agent details
Primary Agent
Primary Broker
Easy List Realty
Listing details
Days on REW
90 Days
Property Views
167
MLS® Number
A2291796
Source
Pillar 9
Board
Calgary Real Estate Board
Is this your listing? Help it to stand out.

Mortgage Calculator

Estimated Payments
Purchase Price
Mortgage Total
Down Payment
Amortization
25 Years
Interest Rate
3.99%

Connect with our mortgage partner

Glenn Jorgensen

Glenn Jorgensen

EBS Modern Mortgage Group

No Fees, Great Rates - 15 minutes with us, could save you thousands.

Connect with a mortgage expert

Connect to a mortgage specialist

Glenn Jorgensen
EBS Modern Mortgage Group

They will connect with you to understand where you are in your journey and how they can best guide you.

  • %
Name*
Email*
Phone*
Purchase City*
What best describes your current situation?
Loan Details
Amortization
Years
Mortgage Amount
Down Payment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

Property Insights

Heritage Heights School
  • n/a
  • -
St. Francis Of Assisi Academy
  • n/a
  • -
Edison School
  • n/a
  • -
Holy Trinity Academy
  • n/a
  • -
School catchments and distances are intended to be used as reference only. To verify enrolment eligibility for a property, contact the school directly.Report Incorrect Info
Report Incorrect Info
Full Name*
Email*
Select School
Reason

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.
Thank You!
We really appreciate your help improving our home search experience. Our team will look into this issue as soon as possible.
Close

Cities near Foothills County

Neighborhoods near Foothills County

Listing data is subject to copyright, disclaimer, and additional requirements from the data provider. See our Terms of Use for terms applicable to this listing. Listing data was last updated on 2026-06-05.
Call Agent
Darya Pfund
Phone:
800-831-3726
Office:
888-323-1998
Share this Property
Text Message
Share this Property
Recipient Email Address*
Your Name
Your Email Address*

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.