For Sale: 24008 241 Avenue E, Foothills County, AB - REW
Boost your listing
Listing featured. Your listing will be featured on REW.
View featured placement
$1,999,900
8 bd 5 ba 3718 sf House

24008 241st Avenue EFoothills County, AB, T1S 4B8

  • 8 Bed
  • 5 Bath
  • 3718 Sqft
  • House

About this home

Welcome to this beautifully designed multigenerational home, offering flexible living spaces ideal for extended family, nanny or a fantastic mortgage helper opportunity. This is an extraordinary custom-built estate nestled on a beautifully manicured 2-acre parcel, including a high-earning legal suite, just a short drive from the vibrant heart of Calgary. This exceptional 8-bedroom, 4.5-bathroom residence offers 4,941 square feet of exquisitely designed living space, crafted with a seamless blend of architectural sophistication and everyday comfort. From the moment you arrive, you're greeted by the striking contemporary design—featuring clean lines, a sleek metal roof, and purposeful elements that make this home as stylish as it is functional. Expansive floor-to-ceiling windows invite an abundance of natural light throughout, illuminating polished concrete floors and emphasizing the spacious, open-concept layout. The main dining area flows effortlessly from the state-of-the-art kitchen—complete with high-end appliances, extensive quartz countertops, custom cabinetry, and a large center island—into a generous living room with a real wood-burning fireplace, perfect for cozy gatherings and enjoying panoramic views. A dedicated den offers a quiet space for a home office or study. Each of the six well-proportioned bedrooms provides a private sanctuary, with the luxurious primary suite featuring a spa-inspired ensuite with dual vanities, a walk-in shower, makeup vanity, and open-concept closet. The remaining bathrooms are outfitted with sleek, contemporary fixtures that reflect the home's modern character. Downstairs, the fully developed walk-out basement opens up a world of possibility, with a home theater, gym, and recreation room ready to suit any lifestyle. Adding incredible value is the thoughtfully designed 2-bedroom legal suite above the triple-attached garage, with a private entrance and full kitchen—currently generating $2,100 per month in consistent rental income, making it ideal for investors, multigenerational living, or offsetting mortgage costs. The expansive lot includes mature landscaping, a 3,500-gallon cistern, a large deck for entertaining, and wide open spaces perfect for gardening or play—all set against sweeping prairie views. Lovingly maintained by the original owner and built with premium materials throughout, this home combines modern luxury with practical functionality. Despite its peaceful rural setting, the property is just minutes from Calgary’s city limits, the South Health Campus, top-rated schools, shopping, restaurants, and all essential services. Whether you're searching for a luxurious family retreat, a flexible multigenerational setup, or a savvy investment opportunity, this extraordinary estate offers unmatched versatility and timeless appeal. This property is a must see in person to truly take it all in. Ask your favorite realtor and come on Buy!
Listed by: Sam Baker, RE/MAX House of Real Estate

Home facts and features

Price details
List Price
Home facts
Bedrooms
8
Full Bathrooms
4
Partial Bathrooms
1
Parking Spaces
3
Property Type
House
Lot Size
2 ft²
Year Built
Built in 2011 (15 yrs old)
Style
2 Storey,Acreage with Residence
Heating Type
High Efficiency,Forced Air
Basement Details
Full
Features
Balcony, Chandelier, Closet Organizers, Cul-de-Sac, Double Vanity, Fire Pit, Front Yard, Fruit Trees/shrub(s), High Ceilings, Kitchen Island, Landscaped, Laundry Room, Many Trees, No Smoking Home, Open Floorplan, Pantry, Private Yard, Quartz Counters, Rain Gutters, Recessed Lighting, Schools Nearby, Square Shaped Lot, Upper Level, Views, Vinyl Windows, Wood Burning
Amenities
Shopping Nearby, Storage
Appliances
Dishwasher, Dryer, Electric Cooktop, Garage Control(s), Humidifier, Microwave, Refrigerator, Washer, Window Coverings
Agent details
Primary Agent
Primary Broker
RE/MAX House of Real Estate
Listing details
Days on REW
93 Days
Property Views
69
MLS® Number
A2290889
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

Aamir Khalique

Aamir Khalique

Dominion Lending

I provide excellent customer service, grant access to a wide range of lenders, and offer expert advice and guidance, saving you time. Let me tailor a solution to your unique needs and situation.

Connect with a mortgage expert

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

St. Francis Of Assisi Academy
  • n/a
  • -
Heritage Heights School
  • 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
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-06.