This EXTRAORDINARY 122.12 Acre COUNTRY ESTATE offers the ULTIMATE LUXURY LIFESTYLE w/the most SPECTACULAR MOUNTAIN VIEWS - perfectly positioned atop the rolling hills of Rural Foothills County near Millarville!!! An IMPRESSIVE 8,365 SQ FT of CUSTOM-BUILT LIVING SPACE w/6 BEDROOMS, 4 FULL BATHS + 2 HALF BATHS, CENTRAL A/C, an OVERSIZED HEATED ATTACHED 4 CAR GARAGE + WALK-OUT BASEMENT, this ONE-OF-A-KIND property also incl/an BARN w/8 STALLS for equestrian use, a FULLY Serviced SHOP, BEAUTIFUL PASTURELAND ideal for cattle + endless potential for a BED & BREAKFAST, WEDDING/EVENT VENUE, MULTI-GENERATIONAL COMPOUND or future SECOND RESIDENCE (subject to county approval). This property is to be SOLD TOGETHER w/the adjoining property located at #200 274256 272 Street W - creating an incredibly rare opportunity to own a multi-parcel COUNTRY ESTATE w/unmatched versatility, scale + income-generating potential. A GATED paved driveway welcomes you into this FULLY FENCED Estate w/STUNNING pond + fountain, a COVERED Front Porch incl/a VERANDA, HARDY BOARD siding, RUBBER ROOF + a 60 YEAR WARRANTY. Inside showcases SOARING vaulted ceilings, a dramatic CURVED STAIRCASE w/Custom water feature, rich OAK trim, HICKORY flooring, METAL + WOOD railings, built-in SPEAKERS Inside/Outside + ELEVATOR access connecting all levels. Designed for both EVERYDAY COMFORT + entertaining, the main level has a PRIVATE OFFICE w/CUSTOM BOOKCASE, a SPIRAL staircase to the PRIVATE STUDIO LOFT, + the LIVING ROOM incl/GAS FIREPLACE. The CHEF-INSPIRED KITCHEN has White Cabinets, GRANITE countertops + SS appliances + LARGE PANTRY, a PRIVATE FITNESS ROOM + SUNROOM w/WEST MOUNTAIN VIEWS!!! The PRIMARY RETREAT offers breathtaking views, SPA-INSPIRED 6 PC ENSUITE w/HEATED FLOORS + LARGE WALK-IN CLOSET, while a 2ND ACCESSIBLE Bedroom, 3 PC Bath, Laundry + MUDROOM complete the level. The BASEMENT is designed for ENTERTAINING, feat. a FAMILY ROOM w/GAS FIREPLACE, FULL 2nd KITCHEN, 3rd, 4th, 5th + 6th BEDROOM all w/w alk-in closets + WEST-FACING MOUNTAIN VIEWS, TWO 4 PC Baths, 2nd Laundry, Playroom, TEMP-CONTROLLED WINE CELLAR for 660 BOTTLES, THEATRE ROOM w/seating + 2nd mudroom w/private staircase access upstairs. Step outside + enjoy an AMAZING PERGOLA w/REMOTE CONTROL SCREENS, expansive WEST-FACING terraces, CHILDREN'S PLAYGROUND, flowing stream + 2 PONDS - creating the perfect setting for relaxing or entertaining. Beyond the luxury lifestyle appeal, this estate offers INCREDIBLE INCOME-GENERATING POTENTIAL as a LUXURY AIRBNB, BED & BREAKFAST, EVENT VENUE or WORKING RANCH. The BARN has 8 STALLS, WASH BAY, TACK ROOM, STORAGE + an UPPER EVENT SPACE w/a WET BAR, Two 2 PC bathrooms + WEST-FACING deck, while the MASSIVE TURN-KEY SHOP offers 16' ceilings, TWO 14' x 12' OVERHEAD DOORS, HUGE STORAGE LOFT, workshop/headquarters space, 3 PC BATH + kitchen/lunch room. Whether you envision a WORKING RANCH, EVENT VENUE, AIRBNB BUSINESS or FAMILY LEGACY PROPERTY, this EXTRAORDINARY estate offers unmatched opportunity!!! (id:374)
| MLS # | A2314878 |
|---|---|
| Listing Type | For Sale |
| Status | Active |
| Year | 2009 |
| Days On Site | 145 |
| Listing Provided By | RE/MAX House of Real Estate | Simon D. Hunt |
| Bed(s) | 6 |
|---|---|
| Bath(s) | 6 Total |
| SQ Feet | 4,840 |
| Basement | Y |
| Story(s) | 1 |
| Building(s) | 3 |
| Zoning | A |
| Acreage | 122.12 |
| Property View | View |
| Cooling | Central air conditioning |
|---|---|
| Heating | In Floor Heating, Natural gas, Other |
| Appliances | Washer, Refrigerator, Cooktop - Gas, Dishwasher, Stove, Oven, Dryer, Microwave, Freezer, Microwave Range Hood Combo, Hood Fan, Hot Water Instant, Garage door opener |
| Fireplace Yes / No | No |
| Security Features | Smoke Detectors |
|---|---|
| Lot Features | Paved lane, Elevator, PVC window, Closet Organizers, No Animal Home, No Smoking Home, Gazebo, Sauna, Gas BBQ Hookup |
| Construction Materials | Wood frame |
| Foundation Details | Poured Concrete |
| Fencing | Fence |
| Parking Features | Detached Garage, Garage, Garage, Parking Pad, RV, Oversize, Shared, Heated Garage |
|---|
| Utilities | Natural Gas, Electricity |
|---|---|
| Sewer | Septic tank, Septic System, Septic Field |
| Water Source | Well |
| Tax Annual Amount | 17222.12 |
|---|---|
| Tax Year | 2026 |
| Province | AB |
|---|---|
| City | Rural Foothills County |
| Postal Code | T0K1K0 |
| Listing VS Median (in T0K1K0) | |
Price: $5,995,000 low | high Med: $5,995,000 sqft: 4,840 low | high Med: 4,840 $ / sqft: $1,239 low | high Med: $1,239 On site: 145 low | high Med: 145 | |
| Province | AB |
|---|---|
| City | Rural Foothills County |
| Postal Code | T0K1K0 |
| Listing VS Median (in T0K1K0) | |
Price: $5,995,000 low | high Med: $5,995,000 sqft: 4,840 low | high Med: 4,840 $ / sqft: $1,239 low | high Med: $1,239 On site: 145 low | high Med: 145 | |