REALTOR® Login
Communities 
Calgary Communities
City Centre East   North  North East North West South  South East West 
Calgary Surrounding
Airdrie Brooks Carstairs Chestermere Claresholm Cochrane Crossfield Didsbury High River Irricana Langdon Okotoks Olds Strathmore Sundre Diamond Valley Rural Rockyview County
Edmonton Communities
City Centre North East North West South East South West West 
Edmonton Surrounding
Beaumont Devon Fort Saskatchewan Leduc Sherwood Park Spruce Grove St.Albert Stony Plain
Central Alberta
Camrose Clearwater County Red Deer Rocky Mountain House Sylvan Lake
Southern Alberta
Crowsnest Pass Lethbridge Medicine Hat
West Alberta
Canmore 
British Columbia
Kelowna Osoyoos Peachland Penticton Revelstoke Salmon Arm Sicamous West Kelowna
Home Evaluation 
Resources 
Resources
Buyer Resources Seller Resources Partners Blog Guide to Buying and Selling During COVID-19
Realtors 
Why CIR 
About Us
Best My Nest We Give Back - 1forALL Initiative Join Our Team Luxury Portfolio
Property Management 
Contact Us 
https://www.cirrealty.ca/reb/creb/78/A2314878_2.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_3.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_4.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_5.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_6.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_7.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_8.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_9.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_10.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_11.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_12.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_13.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_14.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_15.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_16.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_17.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_18.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_19.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_20.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_21.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_22.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_23.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_24.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_25.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_26.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_27.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_28.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_29.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_30.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_31.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_32.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_33.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_34.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_35.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_36.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_37.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_38.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_39.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_40.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_41.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_42.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_43.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_44.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_45.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_46.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_47.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_48.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_49.jpg https://www.cirrealty.ca/reb/creb/78/A2314878_50.jpg

100, 274256 272 Street W

Rural Foothills County T0K1K0

MLS® Number:  A2314878

Back to Rural Foothills County   

  • Home \
  • Rural Foothills County \
  • 100, 274256 272 Street W

$ 5,995,000

6

BEDROOMS

4 + 2

BATHROOMS

4,840

SQUARE FEET

2009

YEAR BUILT

https://www.cirrealty.ca/reb/creb/78/A2314878_2.jpg





MLS® Number
A2314878
PROPERTY TYPE
Agriculture
LISTING DATE
May-29-2026

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 all 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!!

COMMUNITY 
PROPERTY TYPE  Agriculture
BUILDING TYPE  House
STYLE  1 and Half Storey
YEAR BUILT 2009
SQUARE FOOTAGE  4,840
BEDROOMS  6
BATHROOMS  6.00
BASEMENT  Full
AMENITIES 
APPLIANCES  Bar Fridge, Central Air Conditioner, Dishwasher, Double Oven, Dryer, Electric Stove, Freezer, Garage Control(s), Gas Cooktop, Instant Hot Water, Microwave, Microwave Hood Fan, Range Hood, Refrigerator, Warming Drawer, Washer
COOLING  Central Air
FIREPLACE  N/A
FLOORING  Carpet, Ceramic Tile, Hardwood
HEATING  Boiler, In Floor, Fireplace(s), Natural Gas
LAUNDRY 
LOT FEATURES  Back Yard, Farm, Front Yard, Fruit Trees/Shrub(s), Garden, Gazebo, Landscaped, Lawn, Many Trees, Pasture, Views
PARKING  Additional Parking, Driveway, Electric Gate, Front Drive, Garage Door Opener, Garage Faces Front, Gated, Heated Garage, Insulated, Oversized, Parking Pad, Paved, Quad or More Detached, RV Access/Parking, Shared Driveway
RESTRICTIONS  Easement Registered On Title, Road Access Agreement, See Remarks, Utility Right Of Way
ROOF  Rubber
TITLE  Fee Simple
BROKER  RE/MAX House of Real Estate

 

 

ROOMS DIMENSIONS (m) LEVEL
Family Room 20`1" x 19`9" Basement
Media Room 22`3" x 15`3" Basement
Bedroom 15`5" x 11`9" Basement
Walk-In Closet 6`9" x 4`7" Basement
4pc Bathroom 11`3" x 7`10" Basement
Bedroom 14`7" x 12`10" Basement
Walk-In Closet 8`9" x 4`5" Basement
Game Room 20`1" x 12`4" Basement
Wine Cellar 8`3" x 4`0" Basement
Kitchen 15`7" x 9`6" Basement
Play Room 13`9" x 8`3" Basement
Bedroom 17`11" x 11`1" Basement
Walk-In Closet 7`7" x 4`5" Basement
Bedroom 21`7" x 11`9" Basement
4pc Bathroom 10`4" x 5`7" Basement
Mud Room 13`11" x 9`11" Basement
Laundry 8`8" x 5`3" Basement
Furnace/Utility Room 18`2" x 14`6" Basement
2pc Bathroom 5`10" x 5`7" Basement
Living Room 19`10" x 19`10" Main
Kitchen 16`8" x 15`3" Main
Dining Room 16`0" x 9`0" Main
Sunroom/Solarium 19`1" x 11`6" Main
Pantry 11`10" x 5`7" Main
Bedroom - Primary 22`2" x 14`1" Main
Walk-In Closet 8`11" x 8`10" Main
6pc Ensuite bath 21`9" x 15`10" Main
Bedroom 20`1" x 17`3" Main
3pc Ensuite bath 9`1" x 8`1" Main
Walk-In Closet 6`7" x 4`7" Main
Foyer 15`6" x 9`8" Main
Office 16`0" x 16`0" Main
Laundry 10`0" x 8`4" Main
Exercise Room 18`4" x 17`5" Main
2pc Bathroom 6`0" x 5`6" Main
Mud Room 25`10" x 10`7" Main
Other 5`1" x 3`1" Main
Other 19`5" x 19`5" Second
Storage 7`5" x 4`9" Second
Loft 14`0" x 14`0" Second
Calgary Real Estate Airdrie Real Estate Okotoks Real Estate Cochrane Real Estate Strathmore Real Estate Chestermere Real Estate Sundre Real Estate High River Real Estate Diamond Valley Real Estate Brooks Real Estate Olds Real Estate Irricana Real Estate Carstairs Real Estate Crossfield Real Estate Claresholm Real Estate Didsbury Real Estate Langdon Real Estate
South Calgary Real Estate Southeast Calgary Real Estate City Centre Calgary Real Estate East Calgary Real Estate North Calgary Real Estate Northwest Calgary Real Estate West Calgary Real Estate Northeast Calgary Real Estate Lethbridge Real Estate Red Deer Real Estate Sylvan Lake Real Estate Brooks Real Estate Edmonton Real Estate Canmore Real Estate Global Real Estate Luxury Real Estate
Home Why CIR Relocation Careers Partners Best My Nest
Realtors Home Evaluation Contact Us




Data supplied by CREB®,CARA®,CREA®,RASCA®,LDAR® or RAE MLS® System. CREB®,CARA®,CREA®,RASCA®,LDAR® or RAE is the owner of the copyright in its MLS® System. The Listing data is deemed reliable but is not guaranteed accurate by CREB®,CARA®,CREA®,RASCA®,LDAR® or RAE. Data is deemed reliable but is not guaranteed accurate by the REALTORS® Association of Edmonton.Copyright [2024] by the REALTORS® Association of Edmonton. All Rights Reserved.