Active Listing

100, 274256 272 Street W

100, 274256 272 Street W, Rural Foothills County

keyboard_arrow_down
6Bedrooms
5.0Bathrooms
$5,995,000Price
4,840Sq Ft

This EXTRAORDINARY 122.

format_quote

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

Refined Amenities

Curated features for a sophisticated lifestyle.

stars

Bidet

stars

Bookcases

stars

Breakfast Bar

stars

Built-in Features

stars

Ceiling Fan(s)

stars

Central Vacuum

Specifications

Property Details

Property TypeAgri-Business
Property SubtypeAgriculture
Style1 and Half Storey
StructureHouse
Transaction TypeFor Sale
Bedrooms6
Full Bathrooms4
Half Bathrooms2
Living Area4,840 sq ft
Living Area (m²)450.0 m²
Lot Size5,319,547 sq ft
Lot Acres122.1200
Year Built2009
LevelsOne and One Half
Garage Spaces4
Parking FeaturesAdditional 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
HeatingBoiler,In Floor,Fireplace(s),Natural Gas
CoolingCentral Air
FlooringCarpet,Ceramic Tile,Hardwood
AppliancesBar 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
Interior FeaturesBidet,Bookcases,Breakfast Bar,Built-in Features,Ceiling Fan(s),Central Vacuum,Chandelier,Closet Organizers,Double Vanity,Elevator,Granite Counters,High Ceilings,Kitchen Island,No Animal Home,No Smoking Home,Open Floorplan,Pantry,Recessed Lighting,Sauna,Separate Entrance,Skylight(s),Soaking Tub,Storage,Track Lighting,Tray Ceiling(s),Vaulted Ceiling(s),Vinyl Windows,Walk-In Closet(s),Wired for Sound
BasementFull
Basement DevelopmentFinished
Basement FeaturesSeparate/Exterior Entry,Walk Out
RoofRubber
ConstructionCement Fiber Board,Stone,Wood Frame
FoundationPoured Concrete
Exterior FeaturesBalcony,BBQ gas line,Fire Pit,Lighting,Playground,Private Yard,Rain Gutters,Storage
FencingFenced
Lot FeaturesBack Yard,Farm,Front Yard,Fruit Trees/Shrub(s),Garden,Gazebo,Landscaped,Lawn,Many Trees,Pasture,Views
Water SourceWell
SewerSeptic Field,Septic System,Septic Tank
UtilitiesElectricity Connected,Natural Gas Connected
Price / Sq Ft$1,238.73
Annual Taxes$17,222 (2026)
Tax Assessment$2,599,360
ZoningA
PossessionNegotiable
Occupant TypeOwner
Title / LandFee Simple
Inclusions8 Garage Openers, Garage Remotes, Tv Wall Mounts, 3 Central Air Conditioners, 2 Washers, 2 Dryers, 4 Refrigerators, 1 Commercial Refrigerators, 2 Electric Stoves, 3 Microwaves, 3 Hood Fans, 3 Dishwashers, Projector, Projector Screen, Wall Speakers in Theatre Room, Roll Down Blinds, Alarm System, Security Cameras, Pressure Washer in Barn, 8 Stalls in Barn, 500 Gallon Diesel Tank, 300 Gallon Gas Tank and Stands, Massage/Pedicure Chair, Ceiling Speakers, Outdoor Speakers, Remote Control Blinds, Horse wash bay, 6 ceiling fans, Starlink
Days on Market18
ListedMay 29, 2026
NeighbourhoodNONE
MLS NumberA2314878
The Location

NONE

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

Schools Nearby
mapOpen in Maps
Your Luxury Real Estate Specialist

Inquiries & Private Showings

Spencer Rivers

Calgary luxury real estate specialist. Whether you are looking to buy, sell, or simply want more information about this property, I am here to help.

Listing courtesy of RE/MAX House of Real Estate.

Listing Information

What are the annual property taxes?expand_more
The property taxes for 2026 are $17,222. Contact Spencer Rivers for the most recent assessment documents.
Is a private viewing available?expand_more
Yes, private viewings are available by appointment. Contact Spencer Rivers at 403-966-9237 or visit our contact page to schedule a showing.
What is the listing status?expand_more
This property is currently Active. MLS A2314878. Listed May 29, 2026. Listed by RE/MAX House of Real Estate.

Ask About This Property

Get in touch with Spencer Rivers for a private showing, detailed floor plans, or more information about this listing.

The data included on this website is deemed to be reliable, but is not guaranteed to be accurate by the Calgary Real Estate Board (CREB). The trademarks MLS, Multiple Listing Service and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. Data last updated: June 29, 2026.