Enjoy living in the foothills of the world-class Rocky Mountains surrounded by NATURE ~ rolling hills, trees, wildlife and STUNNING VIEWS! This large two-story home with nearly 4,800 sq/ft of above grade living space + 1500 sq/ft developed walk-out- basement living + large deck, front patio and covered front porch has been recently & thoroughly RENOVATED and UPGRADED. With superb curb appeal, the exterior has also been fully upgraded ~ NEW WINDOWS & DOORS, HARDIE BOARD, and NEW SOFFIT, FASCIA & EAVES. The Main Entrance of this home greets you with a functional sitting area & MAGNIFICANT GRAND DOUBLE STAIRCASE that climbs up to the 2nd level. The large windows throughout flood the home with NATURAL LIGHT. This beautiful 5-bedroom home was designed with an abundance of space for LUXURIOUS, COMFORTABLE LIVING and includes an EXTRA-LARGE KITCHEN, 3 FIREPLACES, a Family Room off the kitchen + FORMAL Living and Dining Rooms, 3 FULL BATHROOMS with rough-in for a 4th in the lower level, OFFICE/GAMES ROOM with MURPHY BED, and a convenient MAIN FLOOR BEDROOM and Bathroom that could be used for live-in child care or extended family. The second-floor hosts 4 bedrooms, and two RECENTLY RENOVATED BATHROOMS ~ the Main Bathroom has a double vanity and an above-average 6’ long bathtub. The Primary Ensuite Bathroom also has a double vanity and a 46” x 58” shower. With plenty of space for a workshop, gym or art studio, the walk-out basement also has a large open Family Room with beautiful Pella patio doors that open to the back yard patio. Enjoy the luxury of fresh air-dining in the fully protected SUN ROOM which sits off the back of the house or in the Gazebo in the front yard. With a FANTASTIC LOCATION, this quiet, private 11.9-acre treed property with trails and a creek running through it, sits on a cul-de-sac ~ a GREAT FAMILY HOME to make memories to last a lifetime!
For sale
C$1,449,000
352270 S 242nd Ave W, Foothills County, AB T0L 1W4
5beds
4,792sqft
Single Family Residence
Built in 1980
11.9 Acres Lot
$-- Zestimate®
C$302/sqft
C$-- HOA
What's special
Surrounded by natureRolling hillsStunning viewsLarge two-story homeSuperb curb appealNew windows and doorsHardie board
- 80 days
- on Zillow |
- 143 |
- 3 |
Zillow last checked: 7 hours ago
Listing updated: April 20, 2025 at 11:00am
Listed by:
Susan Rust, Associate,
Sotheby's International Realty Canada
Source: courtesy of Pillar9 System,MLS®#: A2187443
Originating MLS®#: Calgary

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Other
- Level: Second
- Dimensions: 57`5" x 59`1"
Bedroom
- Level: Second
- Dimensions: 40`2" x 38`7"
Bedroom
- Level: Main
- Dimensions: 43`3" x 51`1"
Bedroom
- Level: Second
- Dimensions: 36`11" x 54`2"
Bedroom
- Level: Second
- Dimensions: 33`4" x 62`11"
Other
- Level: Main
- Dimensions: 18`1" x 24`7"
Other
- Level: Main
- Dimensions: 21`4" x 13`8"
Other
- Level: Basement
Other
- Level: Second
- Dimensions: 52`3" x 38`0"
Other
- Level: Second
- Dimensions: 51`8" x 33`11"
Other
- Level: Main
- Dimensions: 26`3" x 64`0"
Den
- Level: Main
- Dimensions: 24`10" x 36`11"
Dining room
- Level: Main
- Dimensions: 56`10" x 47`4"
Dining room
- Level: Main
- Dimensions: 39`8" x 57`5"
Exercise room
- Level: Basement
- Dimensions: 46`6" x 36`1"
Family room
- Level: Main
- Dimensions: 57`5" x 63`9"
Family room
- Level: Lower
- Dimensions: 114`10" x 55`9"
Flex space
- Level: Basement
- Dimensions: 78`9" x 51`1"
Foyer
- Level: Main
- Dimensions: 63`5" x 39`4"
Kitchen
- Level: Main
- Dimensions: 57`5" x 63`2"
Other
- Level: Basement
- Dimensions: 32`3" x 62`1"
Laundry
- Level: Main
- Dimensions: 31`2" x 24`10"
Living room
- Level: Main
- Dimensions: 62`4" x 50`10"
Loft
- Level: Second
- Dimensions: 46`6" x 41`10"
Mud room
- Level: Main
- Dimensions: 32`10" x 32`10"
Office
- Level: Main
- Dimensions: 62`11" x 48`2"
Storage
- Level: Basement
- Dimensions: 38`10" x 33`4"
Other
- Level: Main
- Dimensions: 47`4" x 64`0"
Heating
- Forced Air, Natural Gas
Cooling
- Central Air, Partial
Appliances
- Included: Dishwasher, Dryer, Garage Control(s), Microwave, Oven-Built-In, Range, Refrigerator, Washer
- Laundry: Laundry Room, Main Level
Features
- Breakfast Bar, Ceiling Fan(s), Chandelier, Closet Organizers, Crown Molding, Double Vanity, Granite Counters, Kitchen Island, Quartz Counters, Recessed Lighting, Storage, Walk-In Closet(s), Wired for Data
- Flooring: Carpet, Ceramic Tile, Hardwood, Laminate
- Doors: French Doors
- Windows: Skylight(s), Vinyl Windows
- Basement: Full,Partially Finished,Walk-Out Access
- Number of fireplaces: 3
- Fireplace features: Den, Electric, Family Room, Master Bedroom, Oak, Raised Hearth, Stone, Wood Burning
Interior area
- Total interior livable area: 4,792 sqft
- Finished area above ground: 4,792
- Finished area below ground: 1,509
Property
Parking
- Total spaces: 5
- Parking features: Aggregate, Double Garage Attached, Garage Door Opener, Garage Faces Front, Insulated
- Attached garage spaces: 2
- Has uncovered spaces: Yes
Features
- Levels: Two,2 Storey
- Stories: 1
- Entry location: Below Grade
- Patio & porch: Deck, Front Porch
- Exterior features: Fire Pit, Private Entrance, Private Yard
- Fencing: None
Lot
- Size: 11.9 Acres
- Features: Creek/River/Stream/Pond, Gazebo, Gentle Sloping, Private, Rectangular Lot, Secluded, Treed
Details
- Additional structures: Equipment Storage
- Parcel number: 93155366
- Zoning: CR
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Acreage with Residence
- Property subtype: Single Family Residence
Materials
- Cedar, Composite Siding, Stone
- Foundation: Wood
- Roof: Asphalt Shingle
Condition
- New construction: No
- Year built: 1980
Utilities & green energy
- Electric: 200+ Amp Service
- Sewer: Septic System
- Water: Well
- Utilities for property: Cable Connected, Electricity Connected, Natural Gas Available
Community & HOA
Community
- Subdivision: NONE
HOA
- Has HOA: No
Location
- Region: Foothills County
Financial & listing details
- Price per square foot: C$302/sqft
- Date on market: 2/15/2025
- Inclusions: Murphy Bed, 7' Pool Table, Starlink System
- Electric utility on property: Yes
- Loading