Mehr Reaty
Hardeep SoheeMehr Reaty
HomeListings
BlogsContact
Mehr Realty Logo

Helping Canadians find their dream homes with live MLS listings powered by CREA DDF.

Quick Links

  • Home
  • All Listings
  • About
  • Calgary Listings
  • Airdrie Listings
  • Chestermere Listings
  • Crossfield Listings
  • Cochrane Listings
  • Rocky View Country Listings

Contact

Headshot of Hardeep Sohee, real estate agent

Hardeep Sohee

License #: [Add RECA / license number]

View full bio →

+1 403 700 1375

info@mehrrealty.ca

Mehr Realty is a licensed real estate brokerage in Alberta. Hardeep Sohee is a licensed real estate professional registered with Mehr Realty. All real estate services are provided through Mehr Realty. MLS® listing information is provided through the REALTOR.ca DDF® and is subject to the terms, conditions and accuracy of the applicable listing brokerage and the originating real estate board/association. Information is deemed reliable but not guaranteed and should be independently verified.

Privacy Policy•Terms of Service

© 2026 Mehr Realty. All rights reserved.

ListingsActive
AgricultureFreehold

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

Rural Foothills County, Alberta, Canada· T0K1K0MLS® A2314878
$5,995,000
$1239/sqft
1 / 50
+40
+38
6Bedrooms
6Bathrooms
2Half Baths
4,840sqft (square feet)
124Days on Market

Property Details

Property TypeAgriculture
Year Built2009
Living Area4,840 square feet
Lot Size122.12 acres
StatusActive
Property SubTypeFreehold
Full Address100, 274256 272 Street W, Rural Foothills County, Alberta, T0K1K0

Listing Details

MLS® NumberMLS® A2314878
Listing BrokerageRE/MAX House of Real Estate
Days on Market124 days

Description

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

About This Listing

MLS® #A2314878

Welcome to the vibrant Rural Foothills County community, located in Rural Foothills County, T0K1K0.

Interested in learning more about homes for sale in Rural Foothills County? Read more information about MLS® Number #A2314878 here!

Do you want to learn more about MLS® Number #A2314878? Mehr Realty is committed to providing an outstanding service to our clients. Our REALTORS® are dedicated to helping you find the perfect home.

Ready to see it?+1 403 700 1375and one of our agents will get back to you ASAP!

Contact Agent

Hardeep Sohee
License #: [Add RECA / license number]
Mehr Realty Logo
Headshot of Hardeep Sohee, real estate agent
Call +1 403 700 1375
Request Showing
info@mehrrealty.ca

Schedule a Tour

Thu
1
Oct
Fri
2
Oct
Mon
5
Oct
Tue
6
Oct
Wed
7
Oct
Thu
8
Oct

Appliances

WasherRefrigeratorCooktop - GasDishwasherStoveOvenDryerMicrowaveFreezerMicrowave Range Hood ComboHood FanHot Water InstantGarage door opener

Interior

HeatingIn Floor Heating, Natural gas, Other
CoolingCentral air conditioning
BasementFinished, Full, Separate entrance, Walk out
FireplaceNo
FlooringHardwood, Carpeted, Ceramic Tile
Stories1.5
Bedrooms Above Grade2
Bedrooms Below Grade4

Exterior

Exterior FeaturesStone
Lot FeaturesPaved lane, Elevator, PVC window, Closet Organizers, No Animal Home, No Smoking Home, Gazebo, Sauna, Gas BBQ Hookup
Lot Size122.12 acres
ConstructionWood frame

Parking

Detached GarageGarageGarageParking PadRVOversizeSharedHeated Garage

Room Dimensions

Living room
Main level
19.83 Ft x 19.83 Ft
Kitchen
Main level
15.25 Ft x 16.67 Ft
Dining room
Main level
9.00 Ft x 16.00 Ft
Sunroom
Main level
11.50 Ft x 19.08 Ft
Pantry
Main level
5.58 Ft x 11.83 Ft
Primary Bedroom
Main level
14.08 Ft x 22.17 Ft
Other
Main level
8.83 Ft x 8.92 Ft
6pc Bathroom
Main level
15.83 Ft x 21.75 Ft
Bedroom
Main level
17.25 Ft x 20.08 Ft
3pc Bathroom
Main level
8.08 Ft x 9.08 Ft
Other
Main level
4.58 Ft x 6.58 Ft
Foyer
Main level
9.67 Ft x 15.50 Ft
Office
Main level
16.00 Ft x 16.00 Ft
Laundry room
Main level
8.33 Ft x 10.00 Ft
Exercise room
Main level
17.42 Ft x 18.33 Ft
2pc Bathroom
Main level
5.50 Ft x 6.00 Ft
Other
Main level
10.58 Ft x 25.83 Ft
Other
Main level
3.08 Ft x 5.08 Ft
Other
Second level
19.42 Ft x 19.42 Ft
Storage
Second level
4.75 Ft x 7.42 Ft
Loft
Second level
14.00 Ft x 14.00 Ft
Family room
Basement
19.75 Ft x 20.08 Ft
Media
Basement
15.25 Ft x 22.25 Ft
Bedroom
Basement
11.75 Ft x 15.42 Ft
Other
Basement
4.58 Ft x 6.75 Ft
4pc Bathroom
Basement
7.83 Ft x 11.25 Ft
Bedroom
Basement
12.83 Ft x 14.58 Ft
Other
Basement
4.42 Ft x 8.75 Ft
Recreational, Games room
Basement
12.33 Ft x 20.08 Ft
Wine Cellar
Basement
4.00 Ft x 8.25 Ft
Kitchen
Basement
9.50 Ft x 15.58 Ft
Other
Basement
8.25 Ft x 13.75 Ft
Bedroom
Basement
11.08 Ft x 17.92 Ft
Other
Basement
4.42 Ft x 7.58 Ft
Bedroom
Basement
11.75 Ft x 21.58 Ft
4pc Bathroom
Basement
5.58 Ft x 10.33 Ft
Other
Basement
9.92 Ft x 13.92 Ft
Laundry room
Basement
5.25 Ft x 8.67 Ft
Furnace
Basement
14.50 Ft x 18.17 Ft
2pc Bathroom
Basement
5.58 Ft x 5.83 Ft

Tax Information

Annual Tax$17,222.12
Tax Year2026

Monthly Payment Estimator

Estimate your monthly payment including mortgage, estimated insurance, and property taxes based on past rates.

Estimated Monthly Principal & Interest (P & I)
$29,686
Auto-filled from listing
Total$35,118/month
Principal & Interest
$29,686
Taxes
$1,435
Insurance
$3,997
Total / month$35,118

Estimated only. Actual payments vary based on lender, credit score, taxes, and insurance.

Walkability Score

Nearby Schools

No schools found nearby

Powered by REALTOR.ca

The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA.

The trademarks MLS®, Multiple Listing Service®, and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.