1-7/7
  • 100 274256 272 Street W, Rural Foothills County

    100 274256 272 Street W Rural Foothills County T0K 1K0
    Main Photo: 100 274256 272 Street W, Rural Foothills County
    $5,995,000
    Agri-Business
    Status:
    Active
    MLS® Num:
    A2314878
    Bedrooms:
    6
    Bathrooms:
    6
    Floor Area:
    4,840 sq. ft.
    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!!! 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 w/STUNNING pond + fountain, a COVERED Front Porch incl/a VERANDA, HARDY BOARD siding, RUBBER ROOF + a 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 has a PRIVATE OFFICE w/CUSTOM BOOKCASE, a SPIRAL staircase to the PRIVATE STUDIO LOFT, + the LIVING ROOM incl/GAS FIREPLACE. The CHEF-INSPIRED KITCHEN has White Cabinets, GRANITE countertops + SS appliances + LARGE PANTRY, a PRIVATE FITNESS ROOM + 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 has 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!!! More details
    Listed by RE/MAX House of Real Estate
  • 51328 Range Road 231, Sherwood Park

    51328 Range Road 231 Sherwood Park T8B 1K7
    Main Photo: 51328 Range Road 231, Sherwood Park
    $2,799,000
    Agri-Business
    Status:
    Active
    MLS® Num:
    A2326937
    Bedrooms:
    5
    Bathrooms:
    3
    Floor Area:
    1,591 sq. ft.
    Welcome to an exceptional turnkey equine agri-business set on 107.24 beautiful acres. Designed for both comfortable country living & a thriving horse operation, this impressive property offers outstanding facilities, scenic natural surroundings & incredible income potential. The inviting bungalow features a bright, open floor plan w/ vaulted ceilings, 5 bedrooms (3 on the main level plus 2 downstairs) and 3 full bathrooms, including a spacious primary ensuite with jetted tub. Enjoy cozy evenings by the gas fireplace upstairs or the electric fireplace in the fully finished basement, c/w durable vinyl plank flooring and sauna included. A large main-floor laundry room incl sink & garden window, while the oversized attached double garage provides ample storage. Additional upgrades incl composite front decking & a new roof 2013. Step outside to your own private oasis featuring a beautifully landscaped yard, charming gazebo, tranquil pond, fenced dog yard w/ convenient dog ramp & welcoming firepit area perfect for time with family & friends. A clean, well-maintained county-permitted mobile home w/ 2 bedrooms - ideal for staff, family or rental income. The impressive clubhouse entrance to the barn creates a warm & inviting space for clients, boarders, clinics or social events. Complete with electric fireplace, trophy shelves, wet bar/coffee station w/ mini-fridge & microwave, bathroom w/ shower & bedroom/office, this versatile space adds tremendous value to the operation. The 36'x180' barn has been thoughtfully designed, offering exceptional ventilation, radiant heaters (rarely needed), 26 spacious 10'x12' box stalls, plus 5 additional 10'x10' stalls located in the arena. Features include a utility room servicing the house, barn & outdoor waterers, furnace for the clubhouse & tack room, 12'x20' tack room w/ dual entrances for easy future division, feed room, & wash bay with hot/cold. The water system is configured for individual fill taps at each stall. Train year-round in the attached 60'x180' insulated & heated indoor arena (heater has never been used). You can also enjoy the expansive 100'x200' outdoor arena. A large silo for hay cubes included. The property is ideally set up for easy horse management w/ front paddocks featuring automatic waterers, five side paddocks w/ shelters & auto waterers, pipe & cable fencing & metal gates. Nature lovers will appreciate the trails winding through the treed acreage, perfect for walking, trail riding & enjoying abundant wildlife. The property is adjacent to 21.79 acres of Environmental Reserve, and three Enviro Reserve Easements on property (2.69, 2.27 and 3.06 acres), preserving the natural beauty & enhancing privacy. Infrastructure includes 2 septic systems & fields, along with a strong-producing well. Whether you're expanding an established equine business, operating a boarding/training facility or simply searching for an extraordinary country estate with first-class horse amenities, this property is ready for you! More details
    Listed by Real Broker
  • 31170 Range Road 42 Range, Rural Mountain View County

    31170 Range Road 42 Range Rural Mountain View County T0M 0R0
    Main Photo: 31170 Range Road 42 Range, Rural Mountain View County
    $1,590,000
    Agri-Business
    Status:
    Active
    MLS® Num:
    A2330756
    Bedrooms:
    5
    Bathrooms:
    3
    Floor Area:
    1,441 sq. ft.
    Freedom property away from the city or perfect addition to your operation. This 129+ acre property with beautifully finished family home is the perfect spot. With over 2900 developed square feet, this quality built home provides five beds/3 full bath, as well as plenty of room for hobbies and family gatherings. The land holds a large percentage of cleared cropland with small bits of trees to break up the landscape. Nothing says welcome home like the Mountain View from the home. Spanning nearly 180°, the sunsets are second to none. With larger parcels of land, becoming more and more rare, this Ranchette just might be your opportunity. The Calgary airport is less than 60 minutes drive, you’ll find it plenty of neighbors commute to downtown or if you’d prefer the small town life, Cremona, Cochrane and Sundre are close by. A second set of services and building site brings even more possibilities. Don’t forget the Water Valley Saloon and golf course. Local farms, attractions, camps, campsites, and access to the west country and multiple creeks make this larger land parcel extremely attractive. Imagine the memories you’ll make. More details
    Listed by Real Broker
  • 281141 TOWNSHIP ROAD 274, Rural Rocky View County

    281141 TOWNSHIP ROAD 274 Rural Rocky View County T4A 2S3
    Main Photo: 281141 TOWNSHIP ROAD 274, Rural Rocky View County
    $1,249,900
    Agri-Business
    Status:
    Active
    MLS® Num:
    A2286844
    Bedrooms:
    5
    Bathrooms:
    4
    Floor Area:
    3,005 sq. ft.
    PRIME OPPORTUNITY to own 69.93 ACRES of PRIME AGRICULTURAL LAND w/3,988 SQ FT of DEVELOPED SPACE, just MINUTES from AIRDRIE + CALGARY!!! This FENCED + PRIVATE A-GEN ZONED PARCEL offers the ideal blend of RESIDENTIAL LIVING, AGRICULTURAL USE + INCOME POTENTIAL. Built on a SOLID FOUNDATION, this home is perfect for a family ready make it their own, + create their DREAM HOME in an unbeatable location. With ROOM TO GROW, SPACE TO WORK + ENDLESS POTENTIAL, this versatile acreage is ideal for hobby farmers, investors, or anyone looking for MORE SPACE + FREEDOM w/HIGH sweat equity potential!!! Enjoy ANNUAL INCOME from a Power Line Easement (approx $8,000/year) $$$, PLUS added REVENUE from leasing the land for Grazing or Crop Cultivation $$$. The land is currently leased for grazing but has previously been used for crop production, offering FLEXIBLE INCOME POTENTIAL!! The home BOASTS 3,988 SQ FT of Total Developed Living Space, w/5 BEDS, 4 BATHS, multiple FLEX SPACES + an INCREDIBLE ROOFTOP PATIO w/EXPANSIVE COUNTRY VIEWS!! INSIDE THE HOME, you’ll find plenty of ORIGINAL CHARM awaiting your personal touch. Just off the front foyer is a dedicated HOME OFFICE complete w/built-in shelving-ideal for today’s work-from-home lifestyle. The LIVING ROOM is designed for entertaining, showcasing a 360-degree fireplace that also warms the DINING ROOM - large enough to host the entire family for holiday gatherings. The SPACIOUS KITCHEN offers AMPLE CABINET SPACE w/a CENTRAL ISLAND, PENINSULA + MASSIVE WALK-IN PANTRY. Completing the main level is a mudroom w/dual closets + a 3-pc bathroom for added convenience. The UPPER LEVEL has a spacious + UNIQUE Primary Bedroom w/a WALK-IN closet, 3-pc EN-SUITE + direct access to a sunroom that opens onto the impressive 31’ x 26’ ROOFTOP PATIO- a perfect setting for morning coffee or relaxing summer evenings. Additionally, the upper level includes 3 generously sized bedrooms, a 5-pc main bathroom + a 2nd laundry room. The DEVELOPED BASEMENT includes a HUGE FAMILY ROOM, 5th bedroom w/walk-in closet, 3-pc bathroom, flex area + an extra-large utility/laundry room. There’s even a cooling cellar for storage. Recent Upgrades: Upstairs has Fresh paint + Newer Windows and is prepped + ready for new flooring. The home is asbestos-free. Mechanical updates include a new 50-gallon hot water tank, new pressure pump, and a fully operational radiant heating system. OUTSIDE, enjoy a 29’ x 23’ OVERSIZED ATTACHED GARAGE, plus a 13’5” x 9’6” shed and a 54’2” x 8’8” workspace with a stall, offering ample space for animals, equipment, or hobby use. To the right of the home, you'll find a fenced pheasant pen with a small roofed roosting structure, ideal for birds and easily repurposed for chickens or small livestock. Located ONLY 10 minutes east of Airdrie and 20 minutes from Calgary, this is a dream location for those who want the peace of country living without giving up proximity to the city. Book your showing NOW!!! More details
    Listed by RE/MAX House of Real Estate
  • 61016 897 Highway, Rural Bonnyville No. 87, M.D. of

    61016 897 Highway Rural Bonnyville No. 87, M.D. of T9M 1P3
    Main Photo: 61016 897 Highway, Rural Bonnyville No. 87, M.D. of
    $999,000
    Agri-Business
    Status:
    Active
    MLS® Num:
    A2311487
    Bedrooms:
    6
    Bathrooms:
    4
    Floor Area:
    2,633 sq. ft.
    Escape to a property where breathtaking natural beauty, exceptional equestrian amenities, and peaceful country living come together in one unforgettable setting. This exceptional country estate is set on +118 acres of rolling grassland, mature trees, and scenic water features, offering the perfect blend of privacy, recreation, and functionality. Ideally located with excellent access directly off Highway 897 between Bonnyville and Cold Lake, it delivers the convenience of town amenities while maintaining the serenity of rural living. Featuring a truly turn-key horse setup and endless room to live, ride, and entertain, this is far more than an acreage—it’s a complete lifestyle property and a rare opportunity that simply cannot be replicated. This impressive custom-built 2007 home offers over 4,800 sq. ft. of thoughtfully designed living space, perfectly suited for both family living and entertaining. Rich tile, engineered hardwood, and plank flooring create warmth and timeless appeal throughout. The chef-inspired kitchen features a gas range, abundant workspace, and opens seamlessly into the expansive dining and living areas—ideal for gathering with family and friends. The main level offers three spacious bedrooms, including an impressive primary retreat with a walk-in closet and 4-piece ensuite. A unique bonus loft area provides the perfect space for a teen hangout, games room, office, or creative retreat. Downstairs, the fully developed lower level is built for entertaining with a massive recreation space, a show-stopping wet bar, two additional bedrooms, a full bath, and a cozy wood stove for the perfect movie-night atmosphere. Outside, equestrian enthusiasts will appreciate the remarkable 14,000 sq. ft. equine center, designed with both functionality and performance in mind. Featuring a 70' x 150' indoor riding arena and 70’ x 50’ heated barn - 8 box stalls, wash stall, feed storage, tack room, personal lockers, and a mezzanine-level spectator lounge overlooking the arena, the setup is truly exceptional. Designed with both functionality and lifestyle in mind, the property features multiple fenced paddocks, 6 water bowls, 3 hydrants, an outdoor wash bay, and a separate outdoor riding arena, creating an efficient and versatile equestrian setup. Extensive parking accommodations make hosting clinics, competitions, arena events, and large gatherings effortless. Completing the package is a beautifully manicured yard enhanced by massive rock landscaping features, creating stunning curb appeal and an unforgettable first impression. Oil and gas revenue is generated on a portion of this property. Properties of this caliber rarely come to market—offering an unmatched combination of space, functionality, equestrian excellence, and country living at its finest. Ideally located with easy access to both Bonnyville and Cold Lake Regional airports for added convenience. More details
    Listed by Real Broker
  • NW; 14; 22; 27; W4M, Rural Rocky View County

    NW; 14; 22; 27; W4M Rural Rocky View County T1X 2B6
    Main Photo: NW; 14; 22; 27; W4M, Rural Rocky View County
    $714,900
    Agri-Business
    Status:
    Active
    MLS® Num:
    A2319557
    43.84 ACRES OF HIGH-POTENTIAL FARMLAND JUST NEXT TO DALEMEAD — offering an exceptional combination of PRODUCTIVE AGRICULTURAL LAND, LONG-TERM INVESTMENT APPEAL + SEAMLESS ACCESS TO THE CITY. Whether you're looking to EXPAND YOUR FARMING OPERATION, secure a LAND-BANKING OPPORTUNITY, build a FUTURE COUNTRY ESTATE, or add a tangible hard asset to your portfolio, this remarkable parcel delivers the SPACE, FLEXIBILITY + FUTURE UPSIDE that today's buyers are searching for. Just 8 MINUTES TO LANGDON + ONLY 15 MINUTES TO CALGARY'S STONEY TRAIL — enjoy the perfect balance of RURAL FREEDOM + URBAN CONVENIENCE. This highly accessible location places you within easy reach of Langdon, Calgary, Chestermere, schools, shopping, dining, recreation, golf courses + major transportation corridors while offering the privacy, open landscapes + endless possibilities that only a large acreage can provide. W/direct municipal road access + excellent regional connectivity, this is the ideal setting for those looking to invest in land without sacrificing accessibility. Currently LEASED FOR CROP CULTIVATION, the property offers productive agricultural use today while preserving tremendous flexibility for the future. Continue farming, expand your land holdings, establish a future homesite, or simply hold as a long-term investment as growth continues to move east of Calgary. Surrounded by productive farmland + ongoing development throughout the region, this is the type of property that delivers both IMMEDIATE VALUE + LONG-TERM POTENTIAL. Adding even greater appeal is the POTENTIAL TO SUBDIVIDE — Subject to Municipal approval — creating exciting possibilities for investors, landowners + forward-thinking buyers looking to unlock additional value over time. Large parcels in locations this accessible are becoming increasingly difficult to find, especially those offering the unique combination of CURRENT AGRICULTURAL USE, FUTURE DEVELOPMENT POTENTIAL + PROXIMITY TO CALGARY. FARM IT. HOLD IT. INVEST IN IT. BUILD YOUR VISION ON IT. — AN INCREDIBLE OPPORTUNITY TO SECURE NEARLY 44 ACRES IN A PRIME ROCKY VIEW COUNTY LOCATION just minutes from Langdon, 15 minutes from Stoney Trail + next to the growing community of Dalemead. More details
    Listed by RE/MAX House of Real Estate
  • 254063 480 Township, Millet

    254063 480 Township Millet Millet T0C 1Z0
    Main Photo: 254063 480 Township, Millet
    $575,000
    Agri-Business
    Status:
    Active
    MLS® Num:
    A2325569
    Bedrooms:
    4
    Bathrooms:
    2
    Floor Area:
    1,170 sq. ft.
    After a day spent tending the property or exploring the outdoors, gather around the firepit and enjoy peaceful evenings beneath the stars, where the only sounds are the crackling fire and the quiet of country living. Escape to the peace and privacy of this beautifully treed 8.9-acre acreage just 11 km from Millet, 18 km to Leduc, and only 25 km to Edmonton International Airport. Whether you're dreaming of a hobby farm, a country retreat, or a property with room to grow, this acreage offers an incredible opportunity. The 4-bedroom bungalow features approximately 2338 sq. ft. of total living space. The main level offers two bedrooms, while the lower level includes two additional bedrooms, a spacious recreation room, and a 3-piece bathroom. While the kitchen reflects the home's vintage, it provides a practical workspace and endless potential for a modern makeover. The home is comfortable and functional, providing the perfect opportunity to renovate and add your own personal touch over time. Outside is where this property truly shines. A classic hip-roof barn with a massive hay loft provides excellent space for livestock, feed storage, or future hobby farm operations. Two water wells, a brand-new septic system, mature trees, and exceptional privacy create the ideal rural setting. Several additional outbuildings are also located on the property and are being sold as-is. If you've been searching for an affordable country property with character, usable land, and outstanding potential, this could be the one. Bring your animals, your ideas, and your vision—and create the rural lifestyle you've always wanted. More details
    Listed by Real Broker
1-7/7
Data was last updated September 4, 2026 at 10:05 AM (UTC)
Data is supplied by Pillar 9™ MLS® System. Pillar 9™ is the owner of the copyright in its MLS®System. Data is deemed reliable but is not guaranteed accurate by Pillar 9™.
The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.