64146 274 Avenue W, Rural Foothills County photo 1 of 15

1 / 15

DetachedActiveNew build

NONE · Rural Foothills County

64146 274 Avenue W, Rural Foothills County

$3,500,000

NONE, Rural Foothills County, Alberta T1S3B6 · MLS® A2355085

5
Bedrooms: 3.5
Bathrooms: 2,796
Sq ft above grade: $1,252
Per sq ft

About This Property

*Subdivision has received municipal approval. Land Titles are currently pending registration. This listing represents the proposed 32.54 acre parcel. Completion of sale is structurally subject to and conditional upon the final registration of the subdivision plan and issuance of individual title at Alberta Land Titles* Boasting spectacular 360-degree views of the Rocky Mountains, the rolling foothills and the Alberta prairies, this ‘Modern Country’ farmhouse offers 32.54-acres of land, nearly 5,000 square feet of finished living area, five bedrooms, a walk-out basement, 10 and 12-foot ceilings, heated floors, 8-foot doors, custom millwork, designer lighting and numerous oversized windows. Lovingly designed and custom built, no detail was overlooked in the creation of this incredible property. The open floorplan home features classic white shaker cabinets and custom oak details for a touch of warmth. ‘White oak’ laminate and designer tile flooring flow through both levels and granite countertops adorn the kitchen and bathrooms. Black and brass elements are found in the curated lighting and hardware. Beyond the exquisite design, is the quality build, which includes exterior walls with an extra 1.5-inch Styrofoam envelope and triple pane low argon glazed windows to maximize the home’s efficiency. Central air conditioning, a home security system, Wi-Fi capable fireplaces and a home audio system add a touch of comfort to round off this ideal living experience. For the outdoor enthusiast, an electric gate provides access to a fully paved driveway lined by dozens of evergreen and deciduous trees that lead to a four-car attached garage and a home office that can be converted into a fifth garage bay. The 40’x60 shop is finished to look like the house and includes two overhead doors, a high efficiency wood stove and wash bays for pets and vehicles. The expansive yard includes a fully fenced pasture with a horse shelter and a heated automatic waterer. Located within minutes of both Calgary and Okotoks, this majestic property is truly one-of-a kind. Adjacent 7.62 acre parcel is also for sale. MLS# A2355020.

Property Details

Interior

Bedrooms: 5
Bathrooms: 3 full · 1 half
Ensuite bathrooms: 1
Rooms above grade: 8
Above grade: 2,796 sq ft
Main level: 2,796 sq ft
Finished below grade: 2,112 sq ft
Total finished: 4,908 sq ft
Basement: Full · Finished
Fireplaces: 2 fireplaces
Laundry: Main Level, Sink

Interior features

Bookcases
Breakfast Bar
Built-in Features
Central Vacuum
Chandelier
Closet Organizers
Double Vanity
French Door
Granite Counters
High Ceilings
Kitchen Island
Natural Woodwork
No Smoking Home
Open Floorplan
Pantry
Soaking Tub
Sump Pump(s)
Walk-In Closet(s)
Wet Bar
Wired for Sound

Flooring

Laminate
Tile

Fireplace

Gas
Great Room
Mantle
Primary Bedroom
Stone

Building

Property type: Detached
Structure: House
Style: Acreage with Residence, Bungalow
Levels: One
Year built: 2025
New construction: Yes
Builder: Eric's Homes
Front exposure: E

Construction

Cement Fiber Board
Stone
Wood Frame

Roof

Asphalt Shingle

Foundation

Poured Concrete

Heating, cooling & services

Heating: Boiler, In Floor, Forced Air, Natural Gas
Cooling: Central Air
Water: Well
Sewer / septic: Septic System

Parking

Garage: Concrete Driveway, Driveway, Electric Gate, Garage Door Opener, Garage Faces Side, Heated Garage, Insulated, Oversized, Quad or More Attached · 4 spaces
Garage size: 39`3" x 30`0"
Total parking: 8 spaces

Lot & outdoors

Lot size: 1,417,442 sq ft
Acreage: 32.54 acres
Fencing: Partial

Lot features

Back Yard
Front Yard
Gentle Sloping
Landscaped
Lawn
Many Trees
No Neighbours Behind
Pasture
Paved
Private
Views

Outdoor living

Balcony(s)
Front Porch
Patio

Exterior features

Balcony
BBQ gas line
Private Yard

Outbuildings

Shop

In the community

Schools Nearby
Shopping Nearby

Costs & ownership

Annual property tax: $11,093 (2026)
Title: Fee Simple
Ownership: Private
Zoning: A
Restrictions: Subject To Final Subdivision Approval, Utility Right Of Way

Listing & availability

MLS® number: A2355085
Listed: Oct 31, 2026
Days on market: 2
Possession: Negotiable
Listing office: Coldwell Banker Mountain Central

Included in the sale

Appliances: Bar Fridge, Built-In Freezer, Built-In Refrigerator, Central Air Conditioner, Dishwasher, Double Oven, Dryer, Garage Control(s), Garburator, Gas Cooktop, Range Hood, Washer, Window Coverings, Wine Refrigerator

Other inclusions: Bar fridge in the office, hot tub, horse shelter, automatic waterer, wood stove in shop, security system with cameras, cabinets and workbench in the attached garage

Inclusions are as advertised by the listing brokerage and are confirmed in the purchase contract, not here.

Selling to buy?

Need to sell your current home to buy this one? Stephen will prepare a free evaluation of your current home.

Request a free evaluation

Estimated Monthly Cost

$16,406.10/mo

Mortgage: $15,481.68
Property tax: $924.42

20% down · 4.49% · 25-yr amortization · estimate only. Excludes insurance, utilities and closing costs.

Contact me for bookings or more information

Questions about this listing, or ready to view it? Stephen will follow up shortly.

Prefer to talk? (403) 827-4943

Listed by Coldwell Banker Mountain Central

Data provided under license by Pillar 9™.

Listing data updated Nov 2, 2026, 8:35 a.m. MT.

Selling

Thinking of listing your home?

Need to sell to buy this one, or just want a real number? Stephen prepares a free evaluation that accounts for lot, finishes, and current activity in your community.

Request a free evaluation