CONTACT

Foothill County Communities, Calgary

Forgot password Extend Verify Contact

154029 264 Street W
NONE Rural Foothills County T0L 1W0

$4,995,000
Residential beds: 7 baths: 6.0 4,750 sq. ft. built: 2007

Main Photo: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 1: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 2: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 3: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 4: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 5: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 6: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 7: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 8: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 9: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 10: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 11: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 12: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 13: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 14: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 15: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 16: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 17: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 18: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 19: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 20: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 21: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 22: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 23: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 24: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 25: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 26: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 27: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 28: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 29: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 30: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 31: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 32: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 33: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 34: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 35: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 36: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 37: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 38: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 39: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 40: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 41: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 42: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 43: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 44: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 45: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 46: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 47: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 48: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 49: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Photo 50: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
Status:
Active
Prop. Type:
Residential
MLS® Num:
A2149719
Bedrooms:
7
Bathrooms:
6
Year Built:
2007
STONEWOOD RANCH - This is the opportunity to build your family legacy nestled in the world renowned Alberta Foothills. This property is centrally located between Calgary, Priddis and Bragg Creek only 10 minutes to the city limits or 25 minutes to downtown Calgary. This magnificent estate features 153 Acres of gorgeous land with a masterfully built custom home and outbuildings including a second garage plus a ~40x60 Double Volume Oversized Heated Shop. An equestrian paradise, this property is fully fenced and cross fenced and features a gated driveway that leads you through the forest to the home with striking curb appeal including natural stone and timber detailing. With mountain craftsman style, this house boasts over 8300SF of space including 7 Bedrooms & 5 ½ Baths. Upon entry be captivated with timeless and exquisite craftsmanship from stone detailing to millwork accents. The gourmet kitchen is equipped with top-of-the-line appliances, copper sink, limestone counters & island with custom cabinetry, Rundle Stone encases a 6 burner Viking range, making it perfect for culinary adventures and entertaining guests. Adjacent to the kitchen, the great room features a beautiful fireplace, creating a warm and inviting atmosphere for all to gather. A large bedroom and den/office offer convenience on this level. The master suite is a true sanctuary, offering a spacious bedroom with large windows and balcony that overlook the serene landscape, a luxurious ensuite bathroom with a soaking tub, stone shower and a walk-in closet. Additional bedrooms are generously sized and well-appointed, providing comfort and privacy for family and guests. For those who love to entertain, the lower level of the home offers a fantastic recreation area complete with a kitchen, family room with fireplace, and multipurpose room with expansive ceilings with a putting green and room for any activity imaginable. The three lower level bedrooms are large with walk-in closets. Equally as impressive as the fit & finish is the structure and mechanical of this home including details like boilers, high velocity fancoils, spray foam and so much more. Book your private tour today to experience Stonewood Ranch and visualize your future lifestyle.
Property Type:
Residential
Property Sub Type:
Detached
Condo Type:
Not a Condo
Transaction Type:
For Sale
Possession:
Possession Date:
Suite:
No
Home Style:
2 Storey, Acreage with Residence
Total Living Area:
4,750 sq. ft.
Main Level Finished Area:
2,583 sq. ft.
Upper Level Finished Area:
2,166 sq. ft.
Lower Level Finished Area:
Above Grade Finished Area:
Below Grade Finished Area:
3,576 sq. ft.
Taxes:
Tax Assessed Value:
HOA Fee Includes:
Lot Area:
153.78 acre(s)
Acres Cleared:
Acres Cultivated:
Acres Irrigated:
Acres Leasehold:
Acres Not Cultivated:
Acres Freehold:
Acres Seeded:
Acres Tame Hay:
Acres Treed:
Acres Waste:
Acres Water Rights:
Front Exposure:
Southeast
Reg. Size:
Reg. Size Includes:
Levels:
Two
Total Rooms Above Grade:
10
Year built:
2007 (Age: 17)
Bedrooms:
7 (Above Grd: 4)
Bedrooms Above Grade:
4
Bedrooms Below Grade:
3
Bathrooms:
6.0 (Full:5, Half:1)
Plan:
0513416
Heating:
In Floor, Forced Air, Natural Gas
Basement:
Finished, Full, Walk-Out To Grade
Foundation:
Poured Concrete
New Constr.:
No
Construction Material:
Cedar, Stone, Wood Frame
Structure Type:
House
Roof:
Metal
Ensuite:
Yes
Flooring:
Ceramic Tile, Hardwood, Stone
Cooling:
Central Air
Fireplaces:
4
Fireplace Details:
Bedroom, Family Room, Gas, Great Room, Living Room, Mantle, Stone, Wood Burning
Water Supply:
Well
Sewer:
Septic Field, Septic Tank
Garage:
1
Garage Spaces:
9
Parking:
Additional Parking, Heated Garage, Oversized, RV Access/Parking, Triple Garage Attached, Triple Garage Detached
Parking Places:
12.0
Parking Total/Covered:
12 / -
Laundry Features:
Laundry Room, Lower Level, Upper Level
NONE
Built-In Range, Central Air Conditioner, Dishwasher, Garage Control(s), Microwave, Range Hood, Refrigerator, Stove(s), Washer/Dryer
2nd Refrigerator, 2nd Washer/Dryer, 2nd Dishwasher, 3rd Refrigerator
Easement Registered On Title, Utility Right Of Way
Floor
Type
Size
Other
Main Floor
Foyer
13'7" × 11'6"
Main Floor
Den
13'10" × 13'
Main Floor
Living Room
27'6" × 19'8"
Main Floor
Kitchen
18'9" × 17'2"
Main Floor
Dining Room
17' × 12'
Main Floor
Pantry
7'3" × 6'4"
Main Floor
Mud Room
10'6" × 10'3"
Main Floor
Bedroom
20'3" × 11'11"
Upper Level
Bedroom - Primary
21'8" × 19'7"
Upper Level
Walk-In Closet
17'2" × 11'6"
Upper Level
Bedroom
17'11" × 13'1"
Upper Level
Bedroom
22'6" × 18'
Upper Level
Laundry
7'11" × 5'
Upper Level
Other
11' × 10'1"
Lower Level
Family Room
22'9" × 20'11"
Lower Level
Kitchen
19'5" × 12'10"
Lower Level
Game Room
27'4" × 27'2"
Lower Level
Bedroom
20'1" × 17'9"
Lower Level
Bedroom
15'11" × 14'2"
Lower Level
Bedroom
15'4" × 13'
Lower Level
Laundry
7'10" × 6'2"
Lower Level
Storage
16'6" × 8'5"
Lower Level
Furnace/Utility Room
13' × 12'5"
Lower Level
Furnace/Utility Room
12'7" × 5'4"
Floor
Ensuite
Pieces
Other
Main Floor
No
2
7'9" x 10'
Main Floor
No
3
12'2" x 10'
Upper Level
Yes
5
15'4" x 24'9"
Upper Level
No
4
4'11" x 8'11"
Lower Level
No
3
9' x 9'5"
Lower Level
No
5
9'8" x 15'4"
Title to Land:
Fee Simple
Community Features:
Golf, Walking/Bike Paths
Interior Features:
Bar, Beamed Ceilings, Bookcases, Breakfast Bar, Built-in Features, Ceiling Fan(s), Chandelier, Closet Organizers, Crown Molding, Double Vanity, High Ceilings, Kitchen Island, Open Floorplan, Pantry, Recessed Lighting, Soaking Tub, Stone Counters, Storage, Vaulted Ceiling(s), Walk-In Closet(s)
Exterior Features:
Balcony, Dog Run, Fire Pit, Garden, Private Yard, RV Hookup, Uncovered Courtyard
Patio And Porch Features:
Balcony(s), Deck, Front Porch
Lot Features:
Back Yard, Front Yard, Lawn, Garden, Landscaped, Treed, Views
Num. of Parcels:
0
Outbuildings:
Shed, Greenhouse, Workshop
Fencing:
Cross Fenced, Fenced
Nearest Town:
Calgary
Region:
Foothills County
Zoning:
AG
Listed Date:
Jul 18, 2024
Days on Mkt:
  • Photo 1: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 1 of 50
  • Photo 2: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 2 of 50
  • Photo 3: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 3 of 50
  • Photo 4: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 4 of 50
  • Photo 5: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 5 of 50
  • Photo 6: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 6 of 50
  • Photo 7: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 7 of 50
  • Photo 8: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 8 of 50
  • Photo 9: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 9 of 50
  • Photo 10: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 10 of 50
  • Photo 11: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 11 of 50
  • Photo 12: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 12 of 50
  • Photo 13: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 13 of 50
  • Photo 14: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 14 of 50
  • Photo 15: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 15 of 50
  • Photo 16: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 16 of 50
  • Photo 17: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 17 of 50
  • Photo 18: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 18 of 50
  • Photo 19: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 19 of 50
  • Photo 20: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 20 of 50
  • Photo 21: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 21 of 50
  • Photo 22: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 22 of 50
  • Photo 23: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 23 of 50
  • Photo 24: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 24 of 50
  • Photo 25: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 25 of 50
  • Photo 26: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 26 of 50
  • Photo 27: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 27 of 50
  • Photo 28: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 28 of 50
  • Photo 29: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 29 of 50
  • Photo 30: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 30 of 50
  • Photo 31: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 31 of 50
  • Photo 32: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 32 of 50
  • Photo 33: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 33 of 50
  • Photo 34: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 34 of 50
  • Photo 35: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 35 of 50
  • Photo 36: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 36 of 50
  • Photo 37: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 37 of 50
  • Photo 38: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 38 of 50
  • Photo 39: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 39 of 50
  • Photo 40: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 40 of 50
  • Photo 41: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 41 of 50
  • Photo 42: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 42 of 50
  • Photo 43: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 43 of 50
  • Photo 44: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 44 of 50
  • Photo 45: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 45 of 50
  • Photo 46: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 46 of 50
  • Photo 47: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 47 of 50
  • Photo 48: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 48 of 50
  • Photo 49: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 49 of 50
  • Photo 50: 154029 264 Street W: Rural Foothills County Detached for sale : MLS®# A2149719
    Photo 50 of 50

Virtual Tour

Virtual Tour

Listed by eXp Realty
Data was last updated September 19, 2024 at 06:05 AM (UTC)
Area Statistics
Listings on market:
108
Avg list price:
$1,799,400
Min list price:
$310,000
Max list price:
$19,500,000
Avg days on market:
63
Min days on market:
1
Max days on market:
502
Avg price per sq.ft.:
$729.57
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.
996REALTY
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.