64146 274 Ave. W | Rural Foothills County | Rural Foothills County

New

New

64146 274 Avenue | Rural Foothills County

Beds
3 2
Baths
3.5
Sqft
2,796
Lot Sqft
1,417,442 (32.5ac)
Year Built
2025
Days Listed
0
Type
Detached
Status
Active
Garage
Yes
Foundation
Concrete
Condo Fee
No
Price Change
None

*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.

MLS ® #: A2355085
Listing Office: Coldwell Banker Mountain Central
Date Listed: October 31, 2026 - 1 days on site
Last Updated: Oct 31, 2026 07:05am MST

$3,500,000

Details

Style:
acreage with residence, bungalow

Garage Size:
4

Interior:
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

Exterior:
balcony, bbq gas line, private yard

Lot:
back yard, front yard, gentle sloping, landscaped, lawn, many trees, no neighbours behind, pasture, paved, private, views

Parking/Garage:
concrete driveway, driveway, electric gate, garage door opener, garage faces side, heated garage, insulated, oversized, quad or more attached

Even More Details

Taxes:
$0

Foundation:
poured concrete,see remarks

Construction:
cement fiber board,stone,wood frame

Flooring:
laminate,tile

Roof:
asphalt shingle

Heating:
boiler,in floor,forced air,natural gas

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

Room Sizes

Kitchen

17`6" x 14`1"

Living Room

19`9" x 14`9"

Dining Room

15`11" x 12`8"

Bedroom - Primary

15`1" x 15`1"

5pc Ensuite bath

17`1" x 9`1"

Walk-In Closet

15`5" x 5`6"

Bedroom

13`3" x 10`5"

Bedroom

11`3" x 9`0"

4pc Bathroom

11`1" x 5`5"

Office

29`0" x 20`9"

2pc Bathroom

7`6" x 2`11"

Foyer

10`8" x 9`8"

Mud Room

21`8" x 10`4"

Pantry

7`4" x 5`9"

Family Room

24`0" x 19`2"

Game Room

10`6" x 9`3"

Bedroom

17`11" x 16`4"

Bedroom

15`3" x 13`7"

Workshop

17`3" x 8`8"

Cold Room/Cellar

28`9" x 8`3"

3pc Bathroom

10`1" x 9`9"

Furnace/Utility Room

20`1" x 16`3"

Thoughtful | Loyal | Effective

Loving this home?

Breanna will call to discuss.

"They really make you feel like a part of their family" - Kim Mitchell

Similar Properties

Pending

530 Crescent Road

Rosedale 4 Bed 4.5 Bath 3214sqft

Diamond Realty & Associates Ltd

217 Windhorse Court

Windhorse Manor 5 Bed 6.5 Bath 3904sqft

Real Broker

New

Open House

240 Eagle Ridge Drive

Eagle Ridge 4 Bed 4 Bath 3344sqft

Real Estate Professionals Inc.

Pending

2917 Lindstrom Drive

Lakeview 5 Bed 4.5 Bath 3558sqft

RE/MAX Realty Professionals

15300 104 St.

Hotchkiss 7 Bed 5 Bath 4676sqft

Coldwell Banker YAD Realty

33 Longeway Place

NONE 6 Bed 5.5 Bath 5011sqft

eXp Realty

New

111 Morning Vista Green

Springbank 6 Bed 6 Bath 3710sqft

Real Broker

32030 Kodiak Springs Road

Bearspaw Country Estates 7 Bed 7.5 Bath 5324sqft

Century 21 Bamber Realty LTD.

66 Mary Dover Drive

Currie Barracks 5 Bed 4.5 Bath 4021sqft

Sotheby's International Realty Canada

“[Breanna] told me with 100% confidence and certainty she could get the job done and that’s exactly what happened.”.
 
- Channing Pass
“(Breanna) really did exactly what she promised to do. Thank you The A-Team for all your hard work and for making selling a home easy. ”.
 
- Rafal Wrobel
“I think what sets Breanna apart is her genuine care for her clients.”.
 
- Shaun & Robyn Vey

Breanna
Albrecht