82031 202 Avenue W Rural Foothills County, Alberta T1S 2X2

4 Bedroom 5 Bathroom 5644 sqft
Fireplace Central Air Conditioning Forced Air Acreage Fruit Trees, Garden Area, Landscaped, Lawn, Underground Sprinkler


OPEN HOUSE every Thursday to Sunday 1-4pm. AUCTION Bid June 24-29! No Reserve! DREAM HOME nestled in picturesque Rural Foothills County on a TRANQUIL 4.9 ACRE OASIS just 2 minutes/1 km from city limits & 3 minutes from Spruce Meadows, the new ring road & Silverado! This luxurious property, custom-built in 2006, showcases the ultimate in sophistication throughout every detail of this home's 8,245 SQFT of breathtaking living space! As you walk through the solid walnut front doors, you are greeted by a spectacular spiral staircase with custom wrought iron/wooden rails & an incredible carved wall sculpture feature, arched knock down ceilings, stunning travertine mosaic stone & Brazilian Cherry Hardwood flooring. Just a taste of the quality of finishing's you will see throughout this beautiful home! The main floor features a living room with full wall of windows drenching the space in natural light, an elegant rotunda living room complimented by a cozy dual sided gas fireplace, exquisite formal dining room, high end laundry room, with custom cabinets & Bosch washer/dryer, stunning 2 piece powder room, mud room with shower & a serene sunroom to bask in your magnificent mountain views! The gourmet kitchen is a home chefs masterpiece boasting premium Wolf/Sub Zero appliance package (Gas range, 2 ovens, uf 1200 hood fan, fridge, freezer, microwave, wine fridge, foodservice elevator, water chiller & trash compactor), lavish granite countertops/massive island, walk through corner pantry, maple cabinetry & breakfast nook. Upstairs offers 3 massive bedrooms with enormous closets & built-ins, library/piano room with built-in bench & bookshelves, a lovely loft with built-in cabinets & 2 office desks, a gorgeous full bathroom with a steam shower & an exquisite meditation room. Your dreamy master retreat is complete with a private balcony to soak up more Mountain views, built-in tv stand/dresser, expansive European style walk-in closet, Romeo & Juliet balcony & a spa- like 5 piece en-suite with a steam shower, relaxing air jet spa tub, dual sinks & make up vanity. Head up the custom wrought iron spiral staircase to the third level, featuring an 4 season atrium viewing deck with unrivalled 360 degree City & Mountain views! The walk-out basement has a 4th Bedroom, full bathroom with steam shower, huge entertaining/games space with a bespoke built-in bar/kitchen area, family room with a fireplace , custom wine cellar (perfect for your fellow wine enthusiasts), sound proofed theatre room with 8 high-end leather media chairs, cold room, utility & storage rooms. The amazing exterior features include Sandstone Exterior, Slate Roof, Duradek Deck, covered pressed concrete patio, numerous gas lines, exquisite landscaping with extensive rock features, focal point water fountain, dog run & concrete sidewalks & driveway. You will be blown away by your fully finished triple garage that includes a spice kitchen, workshop, Epoxy flooring and in-floor heating. (id:44923)

Property Details

MLS® Number A1054837
Property Type Single Family
Amenities Near By Golf Course, Park, Playground
Community Features Golf Course Development, Lake Privileges
Features Treed, See Remarks, Other, Wet Bar, French Door, Closet Organizers, No Animal Home, No Smoking Home, Level
Parking Space Total 12
Plan 2012055
Structure Deck, Porch, Porch, Porch, See Remarks, Dog Run - Fenced In
View Type View


Bathroom Total 5
Bedrooms Above Ground 3
Bedrooms Below Ground 1
Bedrooms Total 4
Appliances Washer, Refrigerator, Cooktop - Gas, Gas Stove(s), Range - Gas, Dishwasher, Dryer, Microwave, Compactor, Garburator, Hood Fan, Garage Door Opener
Basement Development Finished
Basement Features Separate Entrance, Walk Out
Basement Type Unknown (finished)
Constructed Date 2006
Construction Material Wood Frame
Construction Style Attachment Detached
Cooling Type Central Air Conditioning
Exterior Finish See Remarks, Stone, Stucco
Fire Protection Smoke Detectors
Fireplace Present Yes
Fireplace Total 2
Flooring Type Carpeted, Hardwood, Other, Slate, Stone
Foundation Type Poured Concrete
Half Bath Total 2
Heating Fuel Natural Gas
Heating Type Forced Air
Stories Total 3
Size Interior 5644 Sqft
Total Finished Area 5644 Sqft
Type House
Utility Power Generator
Utility Water Well, Cistern, See Remarks


Exposed Aggregate
Visitor Parking
Heated Garage
Parking Pad
Attached Garage 3


Acreage Yes
Fence Type Not Fenced
Land Amenities Golf Course, Park, Playground
Land Disposition Cleared
Landscape Features Fruit Trees, Garden Area, Landscaped, Lawn, Underground Sprinkler
Sewer Septic Tank
Size Irregular 4.77
Size Total 4.77 Ac|2 - 4.99 Acres
Size Total Text 4.77 Ac|2 - 4.99 Acres
Zoning Description Cr


Level Type Dimensions
Third Level Other 19.33 Ft x 11.58 Ft
Basement 3pc Bathroom 8.08 Ft x 8.17 Ft
Basement Other 13.67 Ft x 9.75 Ft
Basement Bedroom 14.33 Ft x 14.75 Ft
Basement Other 25.42 Ft x 28.58 Ft
Basement Family Room 27.42 Ft x 21.58 Ft
Basement Storage 7.92 Ft x 16.33 Ft
Basement Media 17.67 Ft x 17.00 Ft
Basement Furnace 14.25 Ft x 16.42 Ft
Basement Wine Cellar 7.83 Ft x 10.75 Ft
Main Level 1pc Bathroom 8.08 Ft x 7.00 Ft
Main Level 2pc Bathroom 5.67 Ft x 5.08 Ft
Main Level Breakfast 18.25 Ft x 11.08 Ft
Main Level Dining Room 21.92 Ft x 18.42 Ft
Main Level Family Room 27.92 Ft x 23.58 Ft
Main Level Foyer 15.50 Ft x 11.42 Ft
Main Level Kitchen 20.92 Ft x 20.42 Ft
Main Level Laundry Room 8.50 Ft x 10.50 Ft
Main Level Living Room 20.25 Ft x 15.92 Ft
Main Level Other 8.25 Ft x 7.92 Ft
Main Level Sunroom 11.42 Ft x 15.33 Ft
Upper Level 3pc Bathroom 10.50 Ft x 5.25 Ft
Upper Level 5pc Bathroom 15.75 Ft x 17.00 Ft
Upper Level Bedroom 21.50 Ft x 15.00 Ft
Upper Level Bedroom 16.67 Ft x 19.92 Ft
Upper Level Other 5.08 Ft x 14.50 Ft
Upper Level Den 12.75 Ft x 15.92 Ft
Upper Level Loft 26.92 Ft x 18.50 Ft
Upper Level Primary Bedroom 21.58 Ft x 28.00 Ft


Electricity Connected
Natural Gas Connected
Telephone Connected


Scroll to Top