Skip main navigation
For sale
    • C$2,950,000

    402041 NE 28th St E, Foothills County, AB T1S 6C3

    5beds
    4,807sqft
    Single Family Residence
    Built in 2011
    4 Acres Lot
    $-- Zestimate®
    C$614/sqft
    C$-- HOA

    What's special

    Beautifully landscaped acresChef-inspired kitchenDual oversized islandsPremium built-in appliancesDouble miele ovensSteam ovenBeverage fridge
    Set on 4 beautifully landscaped acres just south of Okotoks, this extraordinary custom-built estate is a masterclass in elevated country living, blending timeless architecture, refined craftsmanship, and resort-inspired amenities across more than 7,200 sq.ft. of thoughtfully designed living space. The home features a chef-inspired kitchen with dual oversized islands, premium built-in appliances including double Miele ovens and steam oven, beverage fridge, multiple dishwashers, and a fully equipped butler’s pantry. Soaring ceilings, dramatic architectural beams, expansive windows, and rich custom millwork create a warm yet grand atmosphere throughout. The main-floor primary retreat offers tranquil views, a spa-inspired ensuite, and boutique-style walk-in dressing room. Upstairs includes three spacious secondary bedrooms, a beautifully appointed 5-piece bath and additional powder room, open family lounge, and built-in workspace, while a separate loft above the garage — privately accessed from the main floor — offers exceptional flexibility for a studio, office, guest retreat, games room, or teen lounge and includes its own 2-piece bath. The walkout lower level is designed for recreation and entertaining, featuring expansive gathering spaces, games and media areas, fitness room, additional bedroom and full bath, custom bar and entertaining zone, plus a private relaxation space with infrared sauna, cold plunge tub, and massage chair. Outside, the property transforms into a private retreat with multiple outdoor living and entertaining spaces, outdoor fireplace, built-in outdoor kitchen, hot tub area, firepit gathering spaces, water features, mature landscaping, and expansive lawns. Additional features include a full-size private sport court for basketball, pickleball, and tennis, a detached greenhouse pavilion ideal for year-round growing, gardening, or entertaining, detached three-bay garage/shop with 220V power and 2-piece bath, dual laundry areas, extensive mechanical infrastructure, and full Control4 smart home automation. A truly rare Foothills offering designed around family living, recreation, entertaining, and elevated acreage living. Perfectly positioned just south of Okotoks, this remarkable estate offers an unrivalled blend of privacy, space, and convenience. Major shopping, dining, recreation, and everyday amenities—including Costco—are only minutes away, while Calgary's south ring road and downtown core remain within an easy commute. Experience the lifestyle of a private country estate without compromising access to the services and connections of the city.
    44 days
    |
    62
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Calley Erickson, Associate,

    Sotheby's International Realty Canada,

    Matthew Doliszny, Associate,

    Sotheby's International Realty Canada

    Source: courtesy of Pillar9 System,MLS®#: A2314998MLS LogoOriginating MLS®#: Calgary

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 6
      • Full bathrooms: 3
      • 1/2 bathrooms: 3
      Other
      • Level: Main
      • Dimensions: 15`11" x 15`8"
      Bedroom
      • Level: Second
      • Dimensions: 13`11" x 11`10"
      Bedroom
      • Level: Second
      • Dimensions: 13`11" x 11`11"
      Bedroom
      • Level: Second
      • Dimensions: 11`11" x 13`10"
      Bedroom
      • Level: Basement
      • Dimensions: 13`8" x 13`1"
      Other
      • Level: Main
      • Dimensions: 6`0" x 4`11"
      Other
      • Level: Second
      • Dimensions: 2`11" x 7`6"
      Other
      • Level: Second
      • Dimensions: 9`0" x 12`7"
      Other
      • Level: Basement
      • Dimensions: 8`6" x 12`7"
      Other
      • Level: Second
      • Dimensions: 7`7" x 4`11"
      Other
      • Level: Main
      • Dimensions: 12`7" x 11`4"
      Breakfast nook
      • Level: Main
      • Dimensions: 11`10" x 11`9"
      Den
      • Level: Basement
      • Dimensions: 11`4" x 15`0"
      Dining room
      • Level: Main
      • Dimensions: 18`2" x 13`4"
      Exercise room
      • Level: Basement
      • Dimensions: 16`7" x 20`9"
      Family room
      • Level: Second
      • Dimensions: 11`6" x 11`5"
      Foyer
      • Level: Main
      • Dimensions: 13`9" x 9`0"
      Other
      • Level: Basement
      • Dimensions: 14`3" x 19`11"
      Game room
      • Level: Basement
      • Dimensions: 24`11" x 23`6"
      Great room
      • Level: Basement
      • Dimensions: 19`9" x 19`11"
      Kitchen
      • Level: Main
      • Dimensions: 18`8" x 22`3"
      Laundry
      • Level: Main
      • Dimensions: 8`0" x 7`10"
      Living room
      • Level: Main
      • Dimensions: 16`2" x 19`4"
      Loft
      • Level: Second
      • Dimensions: 26`11" x 43`4"
      Mud room
      • Level: Main
      • Dimensions: 6`11" x 16`7"
      Other
      • Level: Basement
      • Dimensions: 14`4" x 18`11"
      Storage
      • Level: Second
      • Dimensions: 4`6" x 3`6"
      Storage
      • Level: Basement
      • Dimensions: 11`4" x 4`3"
      Walk in closet
      • Level: Main
      • Dimensions: 12`7" x 14`3"
      Heating
      • Boiler, Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Built-In Gas Range, Built-In Oven, Built-In Refrigerator, Dishwasher, Dryer, Freezer, Microwave, Refrigerator, Washer, Wine Refrigerator
      • Laundry: Laundry Room, Main Level, Multiple Locations, See Remarks, Upper Level
      Features
      • Bar, Bookcases, Breakfast Bar, Built-in Features, Central Vacuum, Chandelier, Closet Organizers, Double Vanity, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Master Downstairs, Recreation Facilities, Sauna, See Remarks, Smart Home, Storage, Walk-In Closet(s)
      • Flooring: Hardwood, Tile
      • Basement: Full
      • Number of fireplaces: 3
      • Fireplace features: Gas, Living Room, Mantle, Outside, Recreation Room, Stone, Wood Burning
      Interior area
      • Total interior livable area: 4,807 sqft
      • Finished area above ground: 4,807
      • Finished area below ground: 2,418
      Video & virtual tour

      Property

      Parking
      • Total spaces: 6
      • Parking features: Garage - Attached
      • Attached garage spaces: 6
      Features
      • Levels: Two,2 Storey
      • Stories: 1
      • Patio & porch: Balcony(s), Deck, Front Porch, Patio, Porch, See Remarks
      • Exterior features: Balcony, Basketball Court, BBQ gas line, Built-in Barbecue, Fire Pit, Garden, Lighting, Outdoor Kitchen, Private Yard, Tennis Court(s)
      • Fencing: Fenced
      Lot
      • Size: 4 Acres
      • Features: Back Yard, Backs on to Park/Green Space, Cul-De-Sac, Front Yard, Landscaped, Lawn, No Neighbours Behind, Pie Shaped Lot, See Remarks, Underground Sprinklers
      Details
      • Additional structures: Greenhouse, Shop
      • Parcel number: 101265302
      • Zoning: CR

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Acreage with Residence
      • Property subtype: Single Family Residence
      Materials
      • Stone, Stucco
      • Foundation: Concrete Perimeter
      • Roof: Asphalt Shingle
      Condition
      • New construction: No
      • Year built: 2011

      Utilities & green energy

      • Sewer: Septic System
      • Water: Well

      Community & HOA

      Community
      • Features: Other
      • Subdivision: NONE
      HOA
      • Has HOA: No
      Location
      • Region: Foothills County

      Financial & listing details

      • Price per square foot: C$614/sqft
      • Date on market: 5/29/2026
      • Inclusions: Washers (2), dryers (2), microwave (2), wall ovens (2), steam oven, dishwashers (3), refrigerators (2), freezers (3), wine fridge, gas cooktop, built-in vacuum system and attachments, massage chair, sauna, and cold plunge spa tub, Hot tub, Pool table, Water softener, Water filtration system
      Calley Erickson, Associate

      Calley Erickson, Associate

      (403) 701-1313

      By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.

        Price history

        Price history is unavailable.

        Public tax history

        Tax history is unavailable.

        Climate risks

        Neighborhood: T0L

        Getting around

        0 / 100
        Car-Dependent
        21 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        No schools nearby

        We couldn't find any schools near this home.

        Similar homes

            Nearby cities

            Nearby zip codes

            Other Foothills County Topics

              Search
              Updates
              Favorites
              Plan
              Inbox