We use cookies for basic analytics + follow-up. Privacy
We remember this notice, run basic analytics, and use account activity like saved homes and listing views to provide real-estate follow-up. Privacy.
Buyer alert automation
Get matching homes sent on your schedule. This uses this home's city, style, bedroom count, and price band as the starting filter.
Choose alert settings, then sign in
Rural Foothills County · Single Family · under $2,875,000 · 2+ bed · 4+ bath. Alerts only send when there are new or meaningfully updated matching homes.
Alert speed
Send by
Watch for
Swipe through similar matches — tap the heart to save, or open one for the full read.
290190 240 Street W
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 cedar 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. (id:65958)
Lower level
| Room | Dimensions | Features |
|---|---|---|
| Family room | 24.33 Ft x 23.75 Ft | |
| Laundry room | 9.67 Ft x 6.58 Ft | |
| Workshop | 25.83 Ft x 24.17 Ft | |
| Bedroom | 11.75 Ft x 11.17 Ft | |
| Bedroom | 12.00 Ft x 11.17 Ft | |
| 3pc Bathroom | 4.92 Ft x 7.75 Ft | |
| 3pc Bathroom | 4.92 Ft x 7.75 Ft | |
| 2pc Bathroom | 4.83 Ft x 4.50 Ft | |
| Wine Cellar | 7.00 Ft x 12.17 Ft | |
| Storage | 9.00 Ft x 6.83 Ft | |
| Furnace | 9.67 Ft x 10.17 Ft | |
| Storage | 9.00 Ft x 16.25 Ft |
Main level
| Room | Dimensions | Features |
|---|---|---|
| Kitchen | 9.33 Ft x 24.00 Ft | |
| Dining room | 12.33 Ft x 24.00 Ft | |
| Pantry | 8.00 Ft x 11.42 Ft | |
| Living room | 16.42 Ft x 24.00 Ft | |
| Den | 15.17 Ft x 17.50 Ft | |
| Other | 7.42 Ft x 11.00 Ft | |
| 2pc Bathroom | 7.42 Ft x 6.42 Ft | |
| Other | 16.00 Ft x 12.00 Ft |
Upper Level
| Room | Dimensions | Features |
|---|---|---|
| Exercise room | 11.67 Ft x 15.83 Ft | |
| Primary Bedroom | 24.17 Ft x 24.00 Ft | |
| 6pc Bathroom | 11.67 Ft x 24.17 Ft | |
| Other | 13.83 Ft x 7.50 Ft |
10-item due-diligence checklist. We can pre-flight most of these for you on a CMA call.
Comparable sales
Ask for 3–5 recent solds within ~1 km and the same beds/baths so the list price has context.
Property condition
Roof age, furnace age, hot-water tank age, electrical panel size, windows. Cosmetic vs structural.
Zoning
Confirm zoning matches your intent (single-family vs duplex vs secondary suite vs commercial).
Suite legality / potential
If suited or being marketed as suited: confirm permits, separate entrance, ceiling height, egress windows.
Monthly carrying cost
Mortgage + property tax + insurance + condo fee (if any) + utilities. Compare to your max budget.
Property taxes
Confirm the annual tax amount on the current assessment — and whether a reassessment is pending.
Insurance estimate
Get a same-day quote. Older homes, knob-and-tube wiring, polybutylene plumbing, flood plains all change the number.
Commute
Drive it (or transit it) at the actual time of day you'd commute. Map ETA lies during peak hours.
Deposit and financing conditions
Deposit size, financing condition window, condition removal date, possession date — all negotiable.
Inspection considerations
Budget for a home inspector ($500–700) and any specialty inspections (sewer scope, mould, asbestos for pre-1990 builds).
Cash on cash
-0.55%
Cap rate
4.75%
GRM
13.9
Break-even rent
$16,157
Financing
Operating expenses (monthly)
Save this analysis — go Pro (free)
Approximation only. Actual cash flow depends on financing terms, condition reports, current market rents, property tax assessment, condo fees, and tenant quality. Defaults: 4.5% rate, 30-year amortization, 5% vacancy, 1%/yr maintenance, 0.5%/yr CapEx reserve, $80/mo insurance. Property tax estimated at 0.55%/yr where not provided. Talk to a mortgage broker before relying on these numbers.
Pick a down payment and tap any underlined number to edit. Total updates live. Confirm with a mortgage broker before writing an offer.
Monthly carrying costs (shared)
Approximation only. CMHC default insurance is included when down payment is under 20%. Property tax and condo fees come from MLS when listed and may not reflect the current billing year. Accelerated bi-weekly frequency reduces total interest paid vs. monthly — confirm with a broker. Suite rental income depends on permits, market rent, and vacancy. Always validate with a mortgage broker before writing an offer.
We'll reply by text within a few hours. Comparable sales, condition flags, things worth checking — sent before you book a showing.
Listing brokerage
Listing brokerage on file
Listing data via CREA DDF®. Information is deemed reliable but not guaranteed accurate by CREA. Last updated Jul 3, 2026.
Buyer-fit signals
Derived from listing data and nearby-amenity proximity. Verify anything that matters to your decision — distances are approximate.
Location of this listing. Distances are straight-line.
Full neighbourhood intelligence (schools, halal, mosques, transit) is still building for this address.