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.
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
- 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®#: A2208488
Originating 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