290102 240 Street W
NONE Rural Foothills County T1S 2Z4

$1,750,000
Residential beds: 4 baths: 5.0 3,402 sq. ft. built: 2018

Main Photo: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 1: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 2: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 3: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 4: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 5: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 6: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 7: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 8: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 9: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 10: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 11: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 12: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 13: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 14: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 15: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 16: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 17: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 18: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 19: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 20: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 21: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 22: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 23: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 24: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 25: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 26: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 27: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 28: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 29: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 30: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 31: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 32: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 33: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 34: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 35: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 36: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 37: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 38: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 39: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 40: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 41: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 42: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 43: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 44: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 45: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 46: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 47: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 48: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Photo 49: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
Status:
Active
Prop. Type:
Residential
MLS® Num:
A2131050
Bedrooms:
4
Bathrooms:
5
Year Built:
2018
Have you ever dreamed of owning a CASTLE? Here is your chance! A true masterpiece located in the beautiful foothills just West of sought after Millarville. There are at LEAST 12 REASONS why you should buy this gorgeous estate property: 1) The House - over 5100 sq.ft. of developed space on all 3 levels...this home will blow you away. The outside is finished with stucco and stone. 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 - a gorgeous space with a TON of cupboards, JennAir and Thermador appliances, a 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 the 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 beautiful COVERED PATIO. 2 storage rooms. PLEASE NOTE: The basement has been used to run an Airbnb operation for the past couple of years and the spiral staircase has been hidden behind temporary polycarbonate walls. They can be easily taken down. 7) The Garage - you will love the 3 car oversized heated garage: 36'11 x 24'1. 8) The Bonuses - granite countertops throughout the house, central vacuum system, water filtration system and a 51' deck with glass railings 9) The lot - massive 8.82 acre lot...with lots of trees, a garden, a barn for chicken and sheep(the animals can be sold with the property), a huge greenhouse, a tool shed, and even an outside cold storage. 10) The Lifestyle - Go for a hike up the hill in the summer and snow shoe, ski in the winter. Enjoy watching deer and an occasional moose come by your home. 11) The rich WATER WELL produces a ton of great quality water. 12) The Location - located just 25 minutes southwest of Calgary, a very short distance to Millarville (K-8 school with IB program), Bragg Creek, the ring road, new Costco, South Campus Hospital, etc.
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Possession:
90 Days / Neg
Suite:
No
Home Style:
2 Storey, Acreage with Residence
Total Living Area:
3,402.3 sq. ft.
Main Level Finished Area:
1,899.3 sq. ft.
Upper Level Finished Area:
1,503 sq. ft.
Below Grade Finished Area:
1,762 sq. ft.
Taxes:
$7,860 / 2023
Tax Assessed Value:
1229780.0
Lot Area:
8.82 acre(s)
Front Exposure:
East
Unit Exposure:
East
Levels:
Two
Total Rooms Above Grade:
8
Year built:
2018 (Age: 6)
Bedrooms:
4 (Above Grd: 3)
Bedrooms Above Grade:
3
Bedrooms Below Grade:
1
Bathrooms:
5.0 (Full:2, Half:3)
Plan:
9612210
Heating:
Forced Air, Natural Gas
Basement:
Finished, Full, Walk-Out To Grade
Foundation:
Poured Concrete
New Constr.:
No
Construction Material:
Stone, Stucco
Structure Type:
House
Roof:
Asphalt Shingle
Ensuite:
Yes
Flooring:
Carpet, Concrete, Laminate
Cooling:
None
Fireplaces:
2
Fireplace Details:
Bedroom, Electric, Living Room, Stone
Water Supply:
Well
Sewer:
Septic Field, Septic Tank
Garage:
1
Garage Spaces:
3
Parking:
Heated Garage, Triple Garage Attached
Parking Places:
6.0
Parking Total/Covered:
6 / -
Laundry Features:
Upper Level
NONE
Built-In Oven, Dishwasher, Dryer, Gas Stove, Microwave, Refrigerator, Washer
Chandelier
None Known
Floor
Type
Size
Other
Main Floor
Kitchen
16'7" × 16'4"
Main Floor
Dining Room
10'11" × 10'11"
Main Floor
Living Room
16'8" × 14'10"
Main Floor
Office
11'8" × 11'3"
Main Floor
Entrance
12'10" × 10'9"
2nd Floor
Bedroom - Primary
16'11" × 14'7"
2nd Floor
Bedroom
11'11" × 11'7"
2nd Floor
Bedroom
12'11" × 9'6"
2nd Floor
Bonus Room
15'5" × 9'10"
2nd Floor
Laundry
8'8" × 5'6"
Basement
Bedroom
14'11" × 12'4"
Basement
Game Room
33'10" × 21'10"
Basement
Other
8'6" × 8'2"
Basement
Exercise Room
11'2" × 8'6"
Basement
Sauna
15'9" × 10'
Basement
Furnace/Utility Room
11'9" × 10'
Floor
Ensuite
Pieces
Other
Main Floor
No
2
Main Floor
No
2
2nd Floor
No
4
2nd Floor
Yes
5
Basement
No
2
Title to Land:
Fee Simple
Community Features:
None
Interior Features:
Bar, Central Vacuum, Chandelier, Double Vanity, French Door, Granite Counters, High Ceilings, Sauna, Soaking Tub
Exterior Features:
Fire Pit
Patio And Porch Features:
Balcony(s), Deck
Lot Features:
See Remarks
Num. of Parcels:
0
Fencing:
Fenced
Nearest Town:
Priddis
Region:
Foothills County
Zoning:
CR
Listed Date:
May 10, 2024
Days on Mkt:
19
  • Photo 1: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 1 of 49
  • Photo 2: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 2 of 49
  • Photo 3: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 3 of 49
  • Photo 4: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 4 of 49
  • Photo 5: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 5 of 49
  • Photo 6: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 6 of 49
  • Photo 7: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 7 of 49
  • Photo 8: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 8 of 49
  • Photo 9: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 9 of 49
  • Photo 10: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 10 of 49
  • Photo 11: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 11 of 49
  • Photo 12: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 12 of 49
  • Photo 13: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 13 of 49
  • Photo 14: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 14 of 49
  • Photo 15: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 15 of 49
  • Photo 16: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 16 of 49
  • Photo 17: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 17 of 49
  • Photo 18: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 18 of 49
  • Photo 19: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 19 of 49
  • Photo 20: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 20 of 49
  • Photo 21: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 21 of 49
  • Photo 22: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 22 of 49
  • Photo 23: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 23 of 49
  • Photo 24: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 24 of 49
  • Photo 25: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 25 of 49
  • Photo 26: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 26 of 49
  • Photo 27: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 27 of 49
  • Photo 28: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 28 of 49
  • Photo 29: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 29 of 49
  • Photo 30: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 30 of 49
  • Photo 31: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 31 of 49
  • Photo 32: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 32 of 49
  • Photo 33: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 33 of 49
  • Photo 34: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 34 of 49
  • Photo 35: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 35 of 49
  • Photo 36: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 36 of 49
  • Photo 37: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 37 of 49
  • Photo 38: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 38 of 49
  • Photo 39: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 39 of 49
  • Photo 40: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 40 of 49
  • Photo 41: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 41 of 49
  • Photo 42: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 42 of 49
  • Photo 43: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 43 of 49
  • Photo 44: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 44 of 49
  • Photo 45: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 45 of 49
  • Photo 46: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 46 of 49
  • Photo 47: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 47 of 49
  • Photo 48: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 48 of 49
  • Photo 49: 290102 240 Street W: Rural Foothills County Detached for sale : MLS®# A2131050
    Photo 49 of 49
Listed by RE/MAX First
Data was last updated May 29, 2024 at 10:05 PM (UTC)
Area Statistics
Listings on market:
93
Avg list price:
$1,650,000
Min list price:
$728,000
Max list price:
$19,500,000
Avg days on market:
41
Min days on market:
1
Max days on market:
1,482
Avg price per sq.ft.:
$608.18
These statistics are generated based on the current listing's property type and located in Rural Foothills County. Average values are derived using median calculations.
Alexey Julanov
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.