For Sale: 290190 240 Street W, Foothills County, AB - REW
Boost your listing
Listing featured. Your listing will be featured on REW.
View featured placement
$2,650,000
3 bd • 5 ba • 4093 sf • House
290190 240 Street W
Street ViewDirections
$2,650,000
Get pre-approved

290190 240th Street WFoothills County, AB, T1S 2Z4

  • 3 Bed
  • 5 Bath
  • 4093 Sqft
  • House

About this home

Welcome to a truly exceptional handcrafted log home, nestled on 7 private acres in the heart of the Foothills. Thoughtfully positioned to capture breathtaking mountain views, this one-of-a-kind property offers complete privacy without sacrificing convenience, located on a paved road just minutes from Millarville, Priddis, and Diamond Valley. The owner, a licensed architect, designed and built this custom log home offering 7331 square feet of fully developed living space, graceful functionality, beauty and design throughout. Inside, the soaring timber ceilings and impressive wood-burning fireplace create a warm, inviting atmosphere that's both grand and comfortable. The kitchen is designed for those who love to cook and entertain, featuring generous prep space, quality finishes, and room to gather with family and friends. Whether you're hosting a holiday dinner or enjoying a quiet morning coffee, it's a space you'll never want to leave. The entire upper level is dedicated to an incredible primary retreat. Wake up to mountain views, unwind in the luxurious six-piece spa-inspired ensuite, and enjoy the peace and privacy that makes this suite feel like a boutique mountain lodge. Downstairs, the possibilities are endless. The expansive lower level features two massive areas that could become the ultimate workshop, a professional woodworking space, an artist's studio, a yoga retreat, home gym, collector's garage, or the perfect place to build your dream race car. Two additional bedrooms, each complete with their own private ensuite, provide exceptional accommodations for family or guests. If you've been searching for a property that offers outstanding craftsmanship, unmatched privacy, spectacular views, and the flexibility to pursue your passions, this Foothills estate is unlike anything else on the market. You'll enjoy the best of country living with everyday amenities close at hand.
Listed by: Terry Allwarden, RE/MAX First

Home facts and features

Price details
List Price
$2,650,000
Get Pre-Approved
Home facts
Bedrooms
3
Full Bathrooms
3
Partial Bathrooms
2
Property Type
House
Lot Size
8 ft²
Year Built
Built in 2022 (4 yrs old)
Style
1 and Half Storey,Acreage with Residence
Heating Type
Boiler,In Floor,Forced Air,Geothermal
Cooling
Other
Basement Details
Full
Features
Fishing, Gas Starter, High Ceilings, Kitchen Island, Lower Level, Other, Schools Nearby, Secluded, Sloped, Treed, Views, Wood Burning
Amenities
Golf Course
Appliances
Built-in Oven, Dishwasher, Dryer, Freezer, Gas Cooktop, Microwave, Range Hood, Washer
Agent details
Primary Agent
Primary Broker
RE/MAX First
Secondary Agent
Secondary Broker
RE/MAX First
Listing details
Days on REW
48 Days
Property Views
34
MLS® Number
A2324039
Source
Pillar 9
Board
Calgary Real Estate Board
Is this your listing? Help it to stand out.

Mortgage Calculator

Estimated Payments
Purchase Price
Mortgage Total
Down Payment
Amortization
25 Years
Interest Rate
3.99%

Connect with our mortgage partner

Aamir Khalique

Aamir Khalique

Dominion Lending

Found a home you love? Let's get you pre-approved and mortgage-ready so you can shop with confidence and make stronger offers.

Connect with a mortgage expert

Connect to a mortgage specialist

Aamir Khalique
Dominion Lending

They will connect with you to understand where you are in your journey and how they can best guide you.

  • %
Name*
Email*
Phone*
Purchase City*
What best describes your current situation?
Loan Details
Amortization
Years
Mortgage Amount
Down Payment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

Property Insights

Glenmore Christian Academy Junior High
  • n/a
  • -
  • In Catchment
Glenmore Christian Academy
  • n/a
  • -
  • In Catchment
Bridlewood School
  • n/a
  • -
  • In Catchment
Ron Southern School
  • n/a
  • -
  • In Catchment
Our Lady Of The Evergreens Catholic School
  • n/a
  • -
  • In Catchment
Monsignor J. J. O'Brien
  • n/a
  • -
  • In Catchment
Marshall Springs School
  • n/a
  • -
  • In Catchment
Holy Child School
  • n/a
  • -
  • In Catchment
Somerset School
  • n/a
  • -
  • In Catchment
Evergreen School
  • n/a
  • -
  • In Catchment
School catchments and distances are intended to be used as reference only. To verify enrolment eligibility for a property, contact the school directly.Report Incorrect Info
Report Incorrect Info
Full Name*
Email*
Select School
Reason

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.
Thank You!
We really appreciate your help improving our home search experience. Our team will look into this issue as soon as possible.
Close

Cities near Foothills County

Neighborhoods near Foothills County

Listing data is subject to copyright, disclaimer, and additional requirements from the data provider. See our Terms of Use for terms applicable to this listing. Listing data was last updated on 2026-08-12.
Call Agent
Terry Allwarden
Phone:
(403) 278-2900
Office:
403-278-2900
Robert O'Callaghan
Phone:
Yippee Your Orde
Office:
403-278-2900
Share this Property
Text Message
Share this Property
Recipient Email Address*
Your Name
Your Email Address*

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.
We use cookies and other technologies for functionality, security, and to provide you with a personalized experience on our online services. By continuing to use our online services, you agree to our Privacy Policy and Terms of Use. For information on how to adjust your privacy settings, visit our Cookie Policy.
Dismiss