100 274256 272 Street W in Rural Foothills County: Agriculture for sale : MLS®# A2314878

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

Documents & Links:

Additional Images

Map Service

General Info:

Property Type:: Agri-Business

Property Sub Type:: Agriculture

Transaction Type:: For Sale

Suite:: No

Num Legal Suites:: 0

Num Illegal Suites:: 0

Home Style:: 1 and Half Storey

Current Use:: Agricultural, Cattle, Grazing, Horses, Livestock, Pasture

Major Use Description:: Beef, Equestrian

Total Living Area:: 4,839.65 sq. ft.450 m2

Lot Area:: 122 acre(s)49.4 hectare(s)

Levels:: One and One Half

Total Rooms Above Grade:: 12

Year built:: 2009 (Age: 17)

Bedrooms:: 6 (Above Grd: 2)

Bedrooms Above Grade:: 2

Bedrooms Below Grade:: 4

Bathrooms:: 6.0 (Full:4, Half:2)

Additional Info:

Heating:: Boiler, In Floor, Fireplace(s), Natural Gas

Basement:: Full, Finished, Separate/Exterior Entry, Walk Out

Foundation:: Poured Concrete

New Constr.:: No

Construction Material:: Cement Fiber Board, Stone, Wood Frame

Structure Type:: House

Roof:: Rubber

Ensuite:: Yes

Flooring:: Carpet, Ceramic Tile, Hardwood

Cooling:: Central Air

Water Supply:: Well

Sewer:: Septic Field, Septic System, Septic Tank

Utilities:: Electricity Connected, Natural Gas Connected

Garage:: Yes

Garage Spaces:: 4

Parking:: Additional 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

Appliances:

Bar 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

Inclusions:

8 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

Restrictions:

Easement Registered On Title, Road Access Agreement, See Remarks, Utility Right Of Way

Room Information:

Floor
Type
Size
Other

Main Floor

Living Room

19'10" × 19'10"

Main Floor

Kitchen

16'8" × 15'3"

Main Floor

Dining Room

16' × 9'

Main Floor

Sunroom/Solarium

19'1" × 11'6"

Main Floor

Pantry

11'10" × 5'7"

Main Floor

Bedroom - Primary

22'2" × 14'1"

Main Floor

Walk-In Closet

8'11" × 8'10"

Main Floor

Bedroom

20'1" × 17'3"

Main Floor

Walk-In Closet

6'7" × 4'7"

Main Floor

Foyer

15'6" × 9'8"

Main Floor

Office

16' × 16'

Main Floor

Laundry

10' × 8'4"

Main Floor

Exercise Room

18'4" × 17'5"

Main Floor

Mud Room

25'10" × 10'7"

Main Floor

Other

5'1" × 3'1"

2nd Floor

Other

19'5" × 19'5"

2nd Floor

Storage

7'5" × 4'9"

2nd Floor

Loft

14' × 14'

Basement

Family Room

20'1" × 19'9"

Basement

Media Room

22'3" × 15'3"

Basement

Bedroom

15'5" × 11'9"

Basement

Walk-In Closet

6'9" × 4'7"

Basement

Bedroom

14'7" × 12'10"

Basement

Walk-In Closet

8'9" × 4'5"

Basement

Game Room

20'1" × 12'4"

Basement

Wine Cellar

8'3" × 4'

Basement

Kitchen

15'7" × 9'6"

Basement

Play Room

13'9" × 8'3"

Basement

Bedroom

17'11" × 11'1"

Basement

Walk-In Closet

7'7" × 4'5"

Basement

Bedroom

21'7" × 11'9"

Basement

Mud Room

13'11" × 9'11"

Basement

Laundry

8'8" × 5'3"

Basement

Furnace/Utility Room

18'2" × 14'6"

Bathrooms:

Floor
Ensuite
Pieces
Other

Main Floor

Yes

15'10" x 21'9"

Main Floor

Yes

8'1" x 9'1"

Main Floor

5'6" x 6'

Basement

7'10" x 11'3"

Basement

5'7" x 10'4"

Basement

5'7" x 5'10"

Land Info:

Title to Land:: Fee Simple

Community Features:: Schools Nearby

Interior Features:: Bidet, 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