$1,699,900
FOR SALE

Detached

Bedrooms: 3+1Bathrooms: 5

290102 240 Street W
Rural Foothills County, AB T1S 2Z4

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. (id:47421)
Share
Listed By RE/MAX First
Data Provided By Calgary Real Estate Board
MLS® Listing Number A2131050
Last Updated Aug 28, 2024
Property Summary
Property Type Detached

More like this:
Price History

Interested in obtaining the full price history for this property?
Contact us!Contact us! Our real estate professionals would be happy to provide a complete listing history with historical sold prices and dates.

Detailed Information
Bedrooms 3+1
Bathrooms 5
Features See remarks, French door, Sauna
Listing Contract Date 2024-05-10
Municipal ID 0026868380
Ownership Type Freehold
# of Parking Spaces 6
Plan 9612210
Property Type Single Family
Structures Deck
Transaction Type For sale
Zoning Description CR
Building
Appliances Washer, Refrigerator, Gas stove(s), Dishwasher, Dryer, Microwave, Oven - Built-In
Basement Development Finished
Basement Features Walk out
Basement Type Full (Finished)
Constructed Date 2018
Construction Style (Attachment) Detached
Cooling Type None
Exterior Finish Stone, Stucco
Fireplace Present Yes
# of Fireplaces 2
Flooring Type Carpeted, Concrete, Laminate
Foundation Type Poured Concrete
# of Half Bathrooms 3
Heating Fuel Natural gas
Heating Type Forced air
Stories Total 2
Total Finished Area 3402.3 sqft
Type House
Utility Water Well
Rooms
Room Level Dimensions Notes
Primary BedroomSecond level5.16 M x 4.44 M
BedroomSecond level3.53 M x 3.63 M
BedroomSecond level3.94 M x 2.90 M
Bonus RoomSecond level4.70 M x 3.00 M
Laundry roomSecond level2.64 M x 1.68 M
4pc BathroomSecond levelMeasurements not available
5pc BathroomSecond levelMeasurements not available
BedroomBasement3.76 M x 4.55 M
Recreational, Games roomBasement6.65 M x 10.31 M
OtherBasement2.49 M x 2.59 M
Exercise roomBasement3.41 M x 2.59 M
SaunaBasement4.80 M x 3.05 M
FurnaceBasement3.05 M x 3.58 M
2pc BathroomBasementMeasurements not available
KitchenMain level5.05 M x 4.98 M
Dining roomMain level3.33 M x 3.33 M
Living roomMain level4.52 M x 5.08 M
OfficeMain level3.43 M x 3.56 M
OtherMain level3.91 M x 3.28 M
2pc BathroomMain levelMeasurements not available
2pc BathroomMain levelMeasurements not available
Parking Spaces
Name Spaces
Garage
Heated Garage
Attached Garage3
Land
Total Size 8.82 acres
Acreage Yes
Fence Type Fence
Sewer Septic Field, Septic tank
Size of Irregular Land 8.82

The information contained on this site is based in whole or in part on information that is provided under copyright by the Toronto Regional Real Estate Board (TRREB) or by members of The Canadian Real Estate Association (CREA), who are responsible for its accuracy. TRREB and CREA reproduce and distribute this information as a service for their members and assume no responsibility for its accuracy. All information displayed is believed to be accurate but is not guaranteed and should be independently verified. No warranties or representations of any kind are made with respect to the accuracy of such information.
The information provided herein must only be used by consumers that have a bona fide interest in the purchase, sale, or lease of real estate and may not be used for any commercial purpose or any other purpose.

FREE ESTIMATES ARE COMING

Reserve Your Spot To Be Notified
or

Coming soon to select cities
in North America

(We'll never share your details)