Have you ever dreamed of owning a CASTLE? Here is your chance! A true masterpiece property located in the beautiful foothills just West of sought after Millarville. There are at LEAST 10 REASONS why you should buy this gorgeous estate: 1) The house – over 5100 sq.ft. of developed space on all 3 level…this home will blow you away. The outside is finished with stucco and stone. The inside you have 10′ ceilings on the main floor with a huge open to above area featuring a beautiful chandelier. The upper floor and the basement come with 9′ ceilings. 2) The views – enjoy the views of the Rockies from ALL 3 LEVELS! Absolutely stunning vista of the mountains and the foothills. 3) The Kitchen – this is a true kitchen with a ton of cabinet space, JennAir and Thermador appliances, gigantic island for all the family and friends to gather around, quality granite countertops and access to a large deck. 4) The Main Floor – this is where you spend most of the time, and let me assure you: you will enjoy spending your time here….custom made staircase, natural wood burning fireplace, engineered acacia hardwood flooring throughout (main floor and upstairs), formal dining room, 2 half bathrooms, state of the art office with custom made shelves, the list goes on and on! 5) The Upper level – featuring an amazing master bedroom that comes with its own balcony, fireplace, incredible 5PC ensuite with heated floor, a standalone bathtub and a true walk in closet (the closet is a size of a small bedroom!). There are 2 more large bedrooms, a bonus room (can be converted into a bedroom if needed) with its own balcony, a 4PC bathroom with a skylight and the upstairs laundry room for your convenience, 6) The Basement – comes with in-floor heating, a huge entertainment area with a wet bar, gym, SAUNA with its own relaxation/tea room and a shower, a large bedroom and a 2PC bathroom. Access to a covered patio. 2 storage rooms. 7) The 3 car oversized heated garage. 36’11 x 24’1. 8) The bonuses – granite on all of the countertops throughout the house, central vacuum system, water filtration system, 51′ deck with glass railing, 9) The lot – massive 8.82 acre lot…with lots of trees. Watch deer or an occasional moose. Go for a hike up the hill in the summer and snow shoe, ski in the winter. Let the kids run around and have fun on this truly amazing property. The WATER WELL produces 15 GPM. 10) The Location – located just 25 minutes southwest of Calgary, a very short distance to Millarville (with its unique K-8 school with IB program), Priddis, Turner Valley, Black Diamond and Bragg Creek. Enjoy the quietness of nature yet be very close to all the amenities of the city…the Costco, the ring road, the South Hospital, shopping plazas, Ctrain, etc. This is a super property! You will not find another quite like it. Book your private showing NOW!!!
Property Details
Price:
$1,499,900
MLS #:
A1099609
Status:
Active
Beds:
4
Baths:
6
Type:
Single Family
Subtype:
Detached
Listed Date:
Dec 16, 2025
Finished Sq Ft:
3,402
Lot Size:
384,199 sqft / 8.82 acres (approx)
Year Built:
2018
Finished,walk-outSee Remarks
Ask a Question
See this Listing
Schools
Interior
Appliances
Built- In Oven, Dishwasher, Dryer, Gas Cooktop, Gas Stove, Microwave, Refrigerator, See Remarks, Washer, Wine Refrigerator
290102 240 Street W Rural Foothills County AB is a Single Family for sale in Rural Foothills County, AB, T1S 2Z4. It is listed for $1,499,900 and features 4 beds, 6 baths, and has approximately 3,402 square feet of living space, and was originally constructed in 2018. The current price per square foot is $441. The average price per square foot for Single Family listings in Rural Foothills County is $655. The average listing price for Single Family in Rural Foothills County is $1,575,835. To schedule a showing of MLS#a1099609 at 290102 240 Street W in Rural Foothills County, AB, contact your Harry Z Levy | Real Broker agent at 403-681-5389.
Courtesy of RE/MAX FIRST. Disclaimer: All data relating to real estate for sale on this page comes from the Broker Reciprocity (BR) of the Calgary AB. Detailed information about real estate listings held by brokerage firms other than Harry Z Levy | Real Broker include the name of the listing broker. Neither the listing company nor Harry Z Levy | Real Broker shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. The Broker providing this data believes it to be correct, but advises interested parties to confirm any item before relying on it in a purchase decision. Copyright 2025. Calgary AB. All rights reserved.
Have you ever dreamed of owning a CASTLE? Here is your chance! A true masterpiece property located in the beautiful foothills just West of sought after Millarville. There are at LEAST 10 REASONS why you should buy this gorgeous estate: 1) The house – over 5100 sq.ft. of developed space on all 3 level…this home will blow you away. The outside is finished with stucco and stone. The inside you have 10′ ceilings on the main floor with a huge open to above area featuring a beautiful chandelier. The upper floor and the basement come with 9′ ceilings. 2) The views – enjoy the views of the Rockies from ALL 3 LEVELS! Absolutely stunning vista of the mountains and the foothills. 3) The Kitchen – this is a true kitchen with a ton of cabinet space, JennAir and Thermador appliances, gigantic island for all the family and friends to gather around, quality granite countertops and access to a large deck. 4) The Main Floor – this is where you spend most of the time, and let me assure you: you will enjoy spending your time here….custom made staircase, natural wood burning fireplace, engineered acacia hardwood flooring throughout (main floor and upstairs), formal dining room, 2 half bathrooms, state of the art office with custom made shelves, the list goes on and on! 5) The Upper level – featuring an amazing master bedroom that comes with its own balcony, fireplace, incredible 5PC ensuite with heated floor, a standalone bathtub and a true walk in closet (the closet is a size of a small bedroom!). There are 2 more large bedrooms, a bonus room (can be converted into a bedroom if needed) with its own balcony, a 4PC bathroom with a skylight and the upstairs laundry room for your convenience, 6) The Basement – comes with in-floor heating, a huge entertainment area with a wet bar, gym, SAUNA with its own relaxation/tea room and a shower, a large bedroom and a 2PC bathroom. Access to a covered patio. 2 storage rooms. 7) The 3 car oversized heated garage. 36’11 x 24’1. 8) The bonuses – granite on all of the countertops throughout the house, central vacuum system, water filtration system, 51′ deck with glass railing, 9) The lot – massive 8.82 acre lot…with lots of trees. Watch deer or an occasional moose. Go for a hike up the hill in the summer and snow shoe, ski in the winter. Let the kids run around and have fun on this truly amazing property. The WATER WELL produces 15 GPM. 10) The Location – located just 25 minutes southwest of Calgary, a very short distance to Millarville (with its unique K-8 school with IB program), Priddis, Turner Valley, Black Diamond and Bragg Creek. Enjoy the quietness of nature yet be very close to all the amenities of the city…the Costco, the ring road, the South Hospital, shopping plazas, Ctrain, etc. This is a super property! You will not find another quite like it. Book your private showing NOW!!!
Property Details
Price:
$1,999,900
MLS #:
A2043329
Status:
Active
Beds:
4
Baths:
5
Type:
Single Family
Subtype:
Detached
Listed Date:
Dec 15, 2025
Finished Sq Ft:
3,402
Lot Size:
384,199 sqft / 8.82 acres (approx)
Year Built:
2018
Finished,walk-outSee Remarks
Ask a Question
See this Listing
Schools
Interior
Appliances
Built- In Oven, Dishwasher, Dryer, Gas Cooktop, Gas Stove, Microwave, Refrigerator, See Remarks, Washer, Wine Refrigerator
290102 240 Street W Rural Foothills County AB is a Single Family for sale in Rural Foothills County, AB, T1S 2Z4. It is listed for $1,999,900 and features 4 beds, 5 baths, and has approximately 3,402 square feet of living space, and was originally constructed in 2018. The current price per square foot is $588. The average price per square foot for Single Family listings in Rural Foothills County is $655. The average listing price for Single Family in Rural Foothills County is $1,575,835. To schedule a showing of MLS#a2043329 at 290102 240 Street W in Rural Foothills County, AB, contact your Harry Z Levy | Real Broker agent at 403-681-5389.
Have you ever dreamed of owning a CASTLE? Here is your chance! A true masterpiece property located in the beautiful foothills just West of sought after Millarville. There are at LEAST 10 REASONS why you should buy this gorgeous estate: 1) The house – over 5100 sq.ft. of developed space on all 3 level…this home will blow you away. The outside is finished with stucco and stone. The inside you have 10′ ceilings on the main floor with a huge open to above area featuring a beautiful chandelier. The upper floor and the basement come with 9′ ceilings. 2) The views – enjoy the views of the Rockies from ALL 3 LEVELS! Absolutely stunning vista of the mountains and the foothills. 3) The Kitchen – this is a true kitchen with a ton of cabinet space, JennAir and Thermador appliances, gigantic island for all the family and friends to gather around, quality granite countertops and access to a large deck. 4) The Main Floor – this is where you spend most of the time, and let me assure you: you will enjoy spending your time here….custom made staircase, natural wood burning fireplace, engineered acacia hardwood flooring throughout (main floor and upstairs), formal dining room, 2 half bathrooms, state of the art office with custom made shelves, the list goes on and on! 5) The Upper level – featuring an amazing master bedroom that comes with its own balcony, fireplace, incredible 5PC ensuite with heated floor, a standalone bathtub and a true walk in closet (the closet is a size of a small bedroom!). There are 2 more large bedrooms, a bonus room (can be converted into a bedroom if needed) with its own balcony, a 4PC bathroom with a skylight and the upstairs laundry room for your convenience, 6) The Basement – comes with in-floor heating, a huge entertainment area with a wet bar, gym, SAUNA with its own relaxation/tea room and a shower, a large bedroom and a 2PC bathroom. Access to a covered patio. 2 storage rooms. 7) The 3 car oversized heated garage. 36’11 x 24’1. 8) The bonuses – granite on all of the countertops throughout the house, central vacuum system, water filtration system, 51′ deck with glass railing, 9) The lot – massive 8.82 acre lot…with lots of trees. Watch deer or an occasional moose. Go for a hike up the hill in the summer and snow shoe, ski in the winter. Let the kids run around and have fun on this truly amazing property. The WATER WELL produces 15 GPM. 10) The Location – located just 25 minutes southwest of Calgary, a very short distance to Millarville (with its unique K-8 school with IB program), Priddis, Turner Valley, Black Diamond and Bragg Creek. Enjoy the quietness of nature yet be very close to all the amenities of the city…the Costco, the ring road, the South Hospital, shopping plazas, Ctrain, etc. This is a super property! You will not find another quite like it. Book your private showing NOW!!!
Property Details
Price:
$1,699,900
MLS #:
A2131050
Status:
Active
Beds:
4
Baths:
5
Type:
Single Family
Subtype:
Detached
Listed Date:
Dec 15, 2025
Finished Sq Ft:
3,402
Lot Size:
384,199 sqft / 8.82 acres (approx)
Year Built:
2018
Finished,walk-outSee Remarks
Ask a Question
See this Listing
Schools
Interior
Appliances
Built- In Oven, Dishwasher, Dryer, Gas Cooktop, Gas Stove, Microwave, Refrigerator, See Remarks, Washer, Wine Refrigerator
290102 240 Street W Rural Foothills County AB is a Single Family for sale in Rural Foothills County, AB, T1S 2Z4. It is listed for $1,699,900 and features 4 beds, 5 baths, and has approximately 3,402 square feet of living space, and was originally constructed in 2018. The current price per square foot is $500. The average price per square foot for Single Family listings in Rural Foothills County is $655. The average listing price for Single Family in Rural Foothills County is $1,575,835. To schedule a showing of MLS#a2131050 at 290102 240 Street W in Rural Foothills County, AB, contact your Harry Z Levy | Real Broker agent at 403-681-5389.
Have you ever dreamed of owning a CASTLE? Here is your chance! A true masterpiece property located in the beautiful foothills just West of sought after Millarville. There are at LEAST 10 REASONS why you should buy this gorgeous estate: 1) The house – over 5100 sq.ft. of developed space on all 3 level…this home will blow you away. The outside is finished with stucco and stone. The inside you have 10′ ceilings on the main floor with a huge open to above area featuring a beautiful chandelier. The upper floor and the basement come with 9′ ceilings. 2) The views – enjoy the views of the Rockies from ALL 3 LEVELS! Absolutely stunning vista of the mountains and the foothills. 3) The Kitchen – this is a true kitchen with a ton of cabinet space, JennAir and Thermador appliances, gigantic island for all the family and friends to gather around, quality granite countertops and access to a large deck. 4) The Main Floor – this is where you spend most of the time, and let me assure you: you will enjoy spending your time here….custom made staircase, natural wood burning fireplace, engineered acacia hardwood flooring throughout (main floor and upstairs), formal dining room, 2 half bathrooms, state of the art office with custom made shelves, the list goes on and on! 5) The Upper level – featuring an amazing master bedroom that comes with its own balcony, fireplace, incredible 5PC ensuite with heated floor, a standalone bathtub and a true walk in closet (the closet is a size of a small bedroom!). There are 2 more large bedrooms, a bonus room (can be converted into a bedroom if needed) with its own balcony, a 4PC bathroom with a skylight and the upstairs laundry room for your convenience, 6) The Basement – comes with in-floor heating, a huge entertainment area with a wet bar, gym, SAUNA with its own relaxation/tea room and a shower, a large bedroom and a 2PC bathroom. Access to a covered patio. 2 storage rooms. 7) The 3 car oversized heated garage. 36’11 x 24’1. 8) The bonuses – granite on all of the countertops throughout the house, central vacuum system, water filtration system, 51′ deck with glass railing, 9) The lot – massive 8.82 acre lot…with lots of trees. Watch deer or an occasional moose. Go for a hike up the hill in the summer and snow shoe, ski in the winter. Let the kids run around and have fun on this truly amazing property. The WATER WELL produces 15 GPM. 10) The Location – located just 25 minutes southwest of Calgary, a very short distance to Millarville (with its unique K-8 school with IB program), Priddis, Turner Valley, Black Diamond and Bragg Creek. Enjoy the quietness of nature yet be very close to all the amenities of the city…the Costco, the ring road, the South Hospital, shopping plazas, Ctrain, etc. This is a super property! You will not find another quite like it. Book your private showing NOW!!!
Property Details
Price:
$1,630,000
MLS #:
A2186257
Status:
Pending
Beds:
4
Baths:
5
Type:
Single Family
Subtype:
Detached
Listed Date:
Dec 15, 2025
Finished Sq Ft:
3,402
Lot Size:
384,199 sqft / 8.82 acres (approx)
Year Built:
2018
Finished,walk-outSee Remarks
Ask a Question
See this Listing
Schools
Interior
Appliances
Built- In Oven, Dishwasher, Dryer, Gas Cooktop, Gas Stove, Microwave, Refrigerator, See Remarks, Washer, Wine Refrigerator
290102 240 Street W Rural Foothills County AB is a Single Family for sale in Rural Foothills County, AB, T1S 2Z4. It is listed for $1,630,000 and features 4 beds, 5 baths, and has approximately 3,402 square feet of living space, and was originally constructed in 2018. The current price per square foot is $479. The average price per square foot for Single Family listings in Rural Foothills County is $655. The average listing price for Single Family in Rural Foothills County is $1,575,835. To schedule a showing of MLS#a2186257 at 290102 240 Street W in Rural Foothills County, AB, contact your Harry Z Levy | Real Broker agent at 403-681-5389.