Property Details

100, 274256 272 Street W
Rural Foothills County (A2314878)

$5,995,000
6
4+2
4,840 ft²
Loading Listing...

Loan Term
Interest Rate
Loan Amount
Annual Tax
Ann. Insurance

* Amounts are estimates only. Final payment amounts may vary.

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

Property details

Basic Info

MLS® #
A2314878
Property Type:
Agri-Business
Subtype:
Agriculture
Subdivision:
NONE
Price
$5,995,000
Sale/Lease:
For Sale
Size:
4,840 sq.ft.
Bedrooms:
6
Bathrooms:
4 full / 2 half
Year Built:
2009 (17 years old)

Building Info

Structure Type:
House
Building Style:
1 and Half Storey
Garage:
Yes
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
Fence:
Fenced
Basement:
Full
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
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
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
Exterior Features:
Balcony, BBQ gas line, Fire Pit, Lighting, Playground, Private Yard, Rain Gutters, Storage
Outbuildings:
Shed, Barn, Workshop
Outbuilding Notes:
Barn Features: 8 total stalls equipped with water + sponge flooring, Gas furnace heating, Dehumidifier, Wash bay, Storage room, Supply/tack room with sink, Large open-concept entertaining space w/Wet bar with fridge, Two 2-piece bathrooms, WEST-facing deck, EAST-facing terrace, Starlink internet, Instant hot water, Two furnaces for year-round comfort. Massive multi-purpose shop + workspace Two oversized 14’0” x 12’0” overhead doors, Bright, clean + professionally finished interior, Expansive open-concept floor plan, In-floor heating throughout the shop. RV dump pump for added convenience, Pressure washer setup + dedicated utility room, Shared septic system with the barn, 500 G diesel tank + 300 G fuel tank, Huge upper loft offering exceptional storage space, Full 3 PC bathroom, Functional kitchen/lunch room, Fridge, stove, microwave and commercial fridge included, Excellent setup for staff, Flexible space for commercial, personal, or recreational use

Neighborhood Info

Nearby Amenities:
Schools Nearby

Acreage/Farm Info

Nearest Town:
Millarville
Farm Major Use:
Beef,Equestrian
Farm Current Use:
Agricultural,Cattle,Grazing,Horses,Livestock,Pasture

Lot / Land Info

Lot Size:
122 acres
Lot Features:
Back Yard, Farm, Front Yard, Fruit Trees/Shrub(s), Garden, Gazebo, Landscaped, Lawn, Many Trees, Pasture, Views
Legal Land Desc:
20-21-3-W5
Water:
Well
Sewer:
Septic Field, Septic System, Septic Tank
Utilities:
Electricity Connected, Natural Gas Connected
Zoning:
A

Materials & Systems

Roof:
Rubber
Exterior:
Cement Fiber Board,Stone,Wood Frame
Floors:
Carpet, Ceramic Tile, Hardwood
Foundation:
Poured Concrete
Heating:
Boiler, In Floor, Fireplace(s), Natural Gas
Cooling:
Central Air
Amenities:
Schools Nearby

Listing Info

Possession:
Negotiable
Days on Market:
29
Media & Video
Your Realtor
  • Yuri Smith

    Grassroots Realty Group Ltd.
    587-777-7276

    Email

    Ask a question
    • This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
    Share This Listing
    Share Button
    Related Properties
    Apply Online