Skip to Content

Real estate on your terms®


Property 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!!! (id:53430)

Building

Year Built:
2009
Stories:
1.5
Bedrooms:
6
Bathrooms (total):
7.0 (2 half)
Basement:
Finished, Full, Separate entrance, Walk out

Finished Areas

Interior Size (Total):
4840 square feet
Above Grade:
4840 square feet

Interior

Flooring:
Hardwood, Carpeted, Ceramic Tile
Appliances:
Washer, Refrigerator, Cooktop - Gas, Dishwasher, Stove, Oven, Dryer, Microwave, Freezer, Microwave Range Hood Combo, Hood Fan, Hot Water Instant, Garage door opener

Parking

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

Lot / Land

Lot Size:
122.12 acres
Lot Features:
Paved lane, Elevator, PVC window, Closet Organizers, No Animal Home, No Smoking Home, Gazebo, Sauna, Gas BBQ Hookup

Exterior

Exterior Features:
Stone
Construction:
Wood frame
Foundation:
Poured Concrete
Fencing:
Fence

Utilities & Mechanical

Heating:
In Floor Heating, Natural gas, Other
Cooling:
Central air conditioning
Utilities:
Natural Gas, Electricity
Water Source:
Well

Views & Waterfront

View:
View

Comfort & Security

Security:
Smoke Detectors

Fees & Dates

Property Taxes:
$17,222
Tax Year:
2026
Last Modified:
08/16/2026 04:55:03 AM
Status Change:
08/16/2026 04:46:44 AM

Association / Ownership

Common Interest:
Freehold

Room Dimensions

RoomLevelSize
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

Location

Click and drag to explore the area
Listing offered by: RE/MAX House of Real Estate

Data is supplied by Pillar 9 MLS® System. Pillar 9 is the owner of the copyright in its MLS® System. Data is deemed reliable but is not guaranteed accurate by Pillar 9.

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. Used under license.