Primary photo of 100, 274256 272 Street W, Rural Foothills County
1 / 52

Agriculture For Sale

$5,995,000

MLS® Number: A2314878

Bedrooms

6

Bathrooms

6

Floor Area

4,840

Land Size

122.12

Year Built

2009

100, 274256 272 Street W, Rural Foothills County, Alberta

About This Property

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. Feat. 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 feat. a stunning pond w/a fountain, a COVERED Front Porch w/a VERANDA, HARDY BOARD siding + RUBBER ROOF w/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 feat. a PRIVATE OFFICE w/CUSTOM BOOKCASE + a spiral staircase to the PRIVATE STUDIO LOFT, an inviting LIVING ROOM w/GAS FIREPLACE, a CHEF-INSPIRED KITCHEN w/GRANITE countertops + SS appliances + LARGE PANTRY, a PRIVATE FITNESS ROOM + SUN-DRENCHED 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 al l w/walk-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 feat. 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!!

Property Details

Interior Details

Appliances

Washer, Refrigerator, Cooktop - Gas, Dishwasher, Stove, Oven, Dryer, Microwave, Freezer, Microwave Range Hood Combo, Hood Fan, Hot Water Instant, Garage door opener

Basement

Finished, Full, Separate entrance, Walk out

Bathrooms Partial

2

Bathrooms Total

6

Bedrooms Total

6

Cooling

Central air conditioning

Flooring

Hardwood, Carpeted, Ceramic Tile

Heating

In Floor Heating, Natural gas, Other

Living Area

4840 sqft

Building & Exterior

Exterior Features

Stone

Foundation Details

Poured Concrete

Number Of Buildings

3

Parking Features

Detached Garage, Garage, Garage, Parking Pad, RV, Oversize, Shared, Heated Garage

Stories

1.5

Year Built

2009

Land & Location

Lot Features

Paved lane, Elevator, PVC window, Closet Organizers, No Animal Home, No Smoking Home, Gazebo, Sauna, Gas BBQ Hookup

Lot Size Area

122.12 acres

Lot Size Dimensions

122.12

Parcel Number

0033341223

Postal Code

T0K1K0

View

View

Utilities & Services

Utilities

Natural Gas, Electricity

Listing & Financials

Listing Office

RE/MAX House of Real Estate

Originating System Name

Calgary Real Estate Board

Other Specifications

Common Interest

Freehold

Country

Canada

Security Features

Smoke Detectors

Mortgage Calculator

20% ($1,199,000)
5.5%
25 Years

Estimated Monthly Payment

$29,452

Principal and interest only. Actual rates may vary.

Location & Map

Similar Listings

List Property