274256 272 ST W #100, Rural Foothills County, AB T0K1K0
274256 272 ST W #100, Rural Foothills County, AB T0K1K0
274256 272 ST W #100, Rural Foothills County, AB T0K1K0
274256 272 ST W #100, Rural Foothills County, AB T0K1K0
274256 272 ST W #100, Rural Foothills County, AB T0K1K0
274256 272 ST W #100, Rural Foothills County, AB T0K1K0
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
$ 5,995,000
Est. payment | /mo

6 Beds

6 Baths

4,839 SqFt


Save
$ 5,995,000
Est. payment | /mo
Save

6 Beds

6 Baths

4,839 SqFt

Key Details

Property Type Commercial

Sub Type Agriculture

Listing Status Active

Purchase Type For Sale

Approx. Sqft 4839.65

Square Footage 4,839 sqft

Price per Sqft $1,238

MLS Listing ID A2314878

Style 1 and Half Storey

Bedrooms 6

Full Baths 4

Half Baths 2

Year Built 2009

Lot Size 122.120 Acres

Acres 122.12

Property Sub-Type Agriculture

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

Location

Province AB

Community Schools Nearby

Zoning A

Direction W

Rooms

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

Interior

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

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

Cooling Central Air

Flooring Carpet, Ceramic Tile, Hardwood

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

Fireplace No

Appliance 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

Exterior

Exterior Feature Balcony, BBQ gas line, Fire Pit, Lighting, Playground, Private Yard, Rain Gutters, Storage

Parking Features 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

Garage Spaces 4.0

Fence Fenced

Community Features Schools Nearby

Utilities Available Electricity Connected, Natural Gas Connected

Waterfront Description Pond,Stream

Water Access Desc Well

Roof Type Rubber

Present Use Agricultural,Cattle,Grazing,Horses,Livestock,Pasture

Accessibility Accessible Bedroom, Accessible Doors, Accessible Elevator Installed, Accessible Full Bath, Bathroom Grab Bars

Garage Yes

Building

Lot Description Back Yard, Farm, Front Yard, Fruit Trees/Shrub(s), Garden, Gazebo, Landscaped, Lawn, Many Trees, Pasture, Views

Dwelling Type House

Story One and One Half

Foundation Poured Concrete

Sewer Septic Field, Septic System, Septic Tank

Water Well

Architectural Style 1 and Half Storey

Level or Stories One and One Half

New Construction No

Others

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

Listed by RE/MAX House of Real Estate

LOCATION AND NEARBY PROPERTIES

Go tour this home

274256 272 ST W #100

GET MORE INFORMATION

Justin Newman

Justin Newman

Agent | License ID: 00540392

+1(403) 668-1272

Name
Phone*
Message

REVIEWS

https://cdn.chime.me/image/fs/sitebuild/2022815/3/original_4f84e7d0-9456-495c-a45d-02ade0b6fb37.png

Justin was prompt with his responses and clear with expectation for the process. It was a smooth and enjoyable selling experience with him. I have worked with couple other realtors before and I can say with confident Justin would be who I will use for any of my future transaction.

https://lh3.googleusercontent.com/a-/ALV-UjWbncOcnTFQQfh4M9UJKwsb_VAhaiwJAF6tu6GklaFJj7m5IG1L=s120-c-rp-mo-ba3-br100 Gyann Yiu

};