The Opportunity

Overview

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:61970)

Investment highlights

01Agriculture

Property details

Property type: Agriculture
Transaction: For sale
Site area: 122.12 acres
Listing brokerage: RE/MAX House of Real Estate
Listing representative: Simon D. Hunt
Board / association: Calgary

Financial information

Asking price$5,995,000

Request the complete source listing package and independently verify all financial information before relying on it.

Location intelligence

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

Open supplied address in mapsThe map search uses the supplied address. Confirm the exact parcel, entrance, access rights and permitted use independently.Explore the Foothills County market

Documents

ASKAsk about the property packageConfirm available documents

From interest to a decision

Start with the right questions.

Listing facts begin the conversation. These Alberta resources help you prepare—not certify this property or replace professional advice. Preparation links open in a new tab, keeping this property and your inquiry open.

01Prepare for the property tour

Set your essential criteria and compare this property with the same evidence checklist.

Open resource 02Organize the document request

Identify the records to ask for. Availability and access must be confirmed for this offering.

Open resource 03Plan property due diligence

Coordinate title, condition, approvals and professional review for any real estate being acquired.

Open resource

Property diligence resources

Listing content supports property discovery and should be independently reconciled to current legal and professional records before a transaction decision.

Explore the complete property resource library

Acquisition criteria workpaperDefine required, preferred and flexible mandate criteria →Property tour and comparison scorecardCompare this opportunity against the real requirement →Phase I environmental site assessmentHistory, records, observations and professional findings →Environmental records and contaminated sitesERV, AER records, certificates and search limitations →Commercial property due diligenceCoordinate every acquisition workstream →Commercial buyer representationAcquisition scope, agency, conflicts, information, compensation and exit →Commercial real estate appraisalPurpose, scope, evidence, reliance and report review →Assessment and property taxesAssessment dates, methods, tax allocation and review →Due diligence document requestTitle, permits, environment, leases and operations →Permit and occupancy recordsApplications, inspections, completion and use →Selling commercial propertyOwner objectives, evidence, marketing, offers and closing →Commercial pricing and positioningProperty interest, buyer audience, evidence and launch strategy →Commercial offering memorandumSource control, analysis, privacy, attribution and corrections →Public vs. confidential marketingReach, disclosure, qualification and reporting controls →Buying tenant-occupied commercial propertyLease, rent roll, tenant evidence and closing continuity →Triple net lease investmentsExpense allocation, tenant covenant, remaining term and owner exposure →Commercial lease rollover riskExpiries, renewal uncertainty, downtime and leasing capital →Commercial tenant covenant reviewLegal obligors, payment evidence, financial capacity and privacy →Lease security and letters of creditAmount, custody, expiry, draw and closing transfer →Insurance due diligenceProperty facts, loss history, limits and closing →Replacement cost and loss historyReconstruction assumptions, claims and repairs →Building condition assessmentSystems, records and physical findings →Capital expenditure planTiming, cost basis and scenarios →Inspection accessAuthority, testing and deadlines →Alberta title searchParcels, ownership and registrations →Registered interestsCaveats, easements and rights →Survey plans and boundariesPlans, access and occupation →

Source Record

Current listing facts, with attribution intact.

Source: REALTOR.ca DDF®
Listing status: active
Source ID: 29824976
Last supplied (UTC): October 23, 2026
Listing brokerage: RE/MAX House of Real Estate
Listing representative: Simon D. Hunt
Board / association: Calgary

Commercially preserves the source listing’s brokerage attribution and links back to its REALTOR.ca record. Request information to confirm availability, documents, showing protocol and any facts not present in the supplied record.

Listing brokerage: RE/MAX House of Real Estate · Listing representative: Simon D. Hunt · Board/association: Calgary · Updated (UTC): Oct 23, 2026

Listing content is supplied through REALTOR.ca DDF®. Information is deemed reliable but is not guaranteed and should be independently verified. Commercially is not the listing brokerage unless expressly stated.