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

    10 NE Stillwater Bay, Foothills County, AB T1S 4K5

    5beds
    3,561sqft
    Single Family Residence
    Built in 2023
    10,454.4 Square Feet Lot
    $-- Zestimate®
    C$639/sqft
    C$256/mo HOA

    What's special

    Desirable lotBuilt-in featuresTop-of-line appliancesEight-foot doorsBlack framed windowsSmart home featuresFour bedrooms
    Welcome to this unparalleled estate home offering nearly 5,000 square feet of custom designed, developed living space. Located on the only cul-de-sac backing onto the main pond in Artesia, this two-story, walk-out, SW facing home sits on one of the most desirable lots in the community. Countless upgrades include stunning built-in features, show-stopping designer lighting, oak and bamboo wood features, top-of-line appliances, eight-foot doors, black framed windows, numerous Smart Home features and an oversized triple-attached garage with space to park a fourth vehicle and incorporate lifts. The upper level offers four bedrooms, three full bathrooms, a huge primary closet that connects to the laundry room and a massive bonus room while still incorporating a stunning ‘open to above’ 20-foot ceiling. The main floor includes a home office located directly off the foyer, a formal dining room with stunning views of the pond, a spectacular great room with soaring ceilings and a designer fireplace, a ‘chef’s kitchen’ with a quartz waterfall island and backsplash slab, a butler’s pantry and a mudroom that any family would love. Walk through the full-width double-sliding doors to the expansive rear balcony where you can enjoy the custom fireplace or revel in the serene view across the pond. The lower level offers a fifth bedroom, a spacious games room, a family room and a dedicated home gym. An approved landscape plan is ready to finish off this one-of-kind home.
    17 days
    on Zillow
    |
    70
    |
    5
    |

    Zillow last checked: 7 hours ago

    Listing updated: April 29, 2025 at 05:50am

    Listed by:

    Niki Taggart, Associate,

    Coldwell Banker Mountain Central,

    Rachelle Starnes, Associate,

    Coldwell Banker Mountain Central

    Source: courtesy of Pillar9 System,MLS®#: A2208488MLS LogoOriginating MLS®#: Calgary
    Travel times

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Bedroom
    • Level: Upper
    • Dimensions: 10`2" x 12`9"
    Bedroom
    • Level: Upper
    • Dimensions: 12`11" x 12`9"
    Other
    • Level: Upper
    • Dimensions: 13`11" x 19`8"
    Bedroom
    • Level: Lower
    • Dimensions: 11`11" x 11`0"
    Bedroom
    • Level: Upper
    • Dimensions: 11`6" x 12`11"
    Other
    • Level: Lower
    • Dimensions: 0`0" x 0`0"
    Other
    • Level: Main
    • Dimensions: 0`0" x 0`0"
    Other
    • Level: Upper
    • Dimensions: 0`0" x 0`0"
    Other
    • Level: Upper
    • Dimensions: 0`0" x 0`0"
    Other
    • Level: Upper
    • Dimensions: 0`0" x 0`0"
    Bonus room
    • Level: Upper
    • Dimensions: 16`0" x 20`7"
    Dining room
    • Level: Main
    • Dimensions: 12`11" x 20`1"
    Exercise room
    • Level: Lower
    • Dimensions: 11`6" x 16`3"
    Game room
    • Level: Lower
    • Dimensions: 12`11" x 35`6"
    Great room
    • Level: Main
    • Dimensions: 17`4" x 16`11"
    Kitchen
    • Level: Main
    • Dimensions: 14`3" x 16`11"
    Laundry
    • Level: Upper
    • Dimensions: 6`0" x 11`2"
    Office
    • Level: Main
    • Dimensions: 10`5" x 12`5"
    Heating
    • Radiant Floor, Fireplace(s), Forced Air
    Cooling
    • Rough-In
    Appliances
    • Included: Bar Fridge, Built-In Freezer, Built-In Refrigerator, Dishwasher, Dryer, Garage Control(s), Garburator, Gas Range, Microwave, Range Hood, Tankless Water Heater, Washer, Water Softener
    • Laundry: Laundry Room, Upper Level
    Features
    • Breakfast Bar, Built-in Features, Chandelier, Closet Organizers, Double Vanity, Dry Bar, Granite Counters, High Ceilings, Kitchen Island, No Animal Home, No Smoking Home, Open Floorplan, Quartz Counters, Smart Home, Soaking Tub, Steam Room, Storage, Sump Pump(s), Tankless Hot Water, Vaulted Ceiling(s), Walk-In Closet(s), Wired for Sound
    • Flooring: Carpet, Hardwood, Tile
    • Doors: French Doors
    • Windows: Vinyl Windows, Window Coverings
    • Basement: Finished,Full,Walk-Out Access
    • Number of fireplaces: 2
    • Fireplace features: Blower Fan, Gas, Great Room, Insert, Mantle, Outside
    Interior area
    • Total interior livable area: 3,561 sqft
    • Finished area above ground: 3,561
    • Finished area below ground: 1,399

    Property

    Parking
    • Total spaces: 6
    • Parking features: Aggregate, Garage Door Opener, Electric Vehicle Charging Station(s), Insulated, Oversized
    • Attached garage spaces: 3
    • Has uncovered spaces: Yes
    Features
    • Levels: Two,2 Storey
    • Stories: 1
    • Patio & porch: Balcony(s), Front Porch, See Remarks
    • Exterior features: Balcony, Lighting
    • Fencing: Partial
    • Frontage length: 24.09M 79`0"
    Lot
    • Size: 10,454.4 Square Feet
    • Features: Back Yard, Creek/River/Stream/Pond, Cul-De-Sac, Front Yard, No Neighbours Behind, Waterfront
    Details
    • Parcel number: 93155950
    • Zoning: RC

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Cement Fiber Board, Stone, Stucco, Wood Siding
    • Foundation: Concrete Perimeter
    • Roof: Asphalt Shingle
    Condition
    • New construction: No
    • Year built: 2023

    Utilities & green energy

    • Water: Co-operative

    Community & HOA

    Community
    • Features: Park, Playground, Tennis Court(s)
    • Subdivision: Artesia at Heritage Pointes
    HOA
    • Has HOA: No
    • Amenities included: Park, Playground, Racquet Courts, Recreation Facilities, Trash
    • HOA fee: C$256 monthly
    Location
    • Region: Foothills County

    Financial & listing details

    • Price per square foot: C$639/sqft
    • Date on market: 4/17/2025
    • Inclusions: Microwave is a Panasonic 'The Genius' which can be used as a microwave, a traditional oven or an air fryer.
    • Loading