
A rare opportunity where luxury living meets limitless potential. Located in one of Didsbury's most unique residential–industrial cul-de-sacs. This executive home and fully equipped shop offer a lifestyle that is almost impossible to replicate. From the moment you arrive, the dual iron gates, stamped concrete driveway, and meticulously landscaped grounds set the tone. The property feels like a private retreat, complete with an irrigation system, low-maintenance rock landscaping, a custom river feature with waterfalls, in-water lighting, a pond, walk-over bridges, mature trees, sitting areas, and streetlamp lighting that creates an incredible evening ambiance. The covered deck with stone archways adds a courtyard feel - ideal for hosting family, friends, or business guests.Inside the residence, a grand floor-to-ceiling fireplace anchors the great room, which flows into a chef’s kitchen with granite counters, stainless steel appliances, a pull-out pantry, four-seat eating bar, and adjoining dining area. The main floor also features a home office with gas fireplace, laundry room, 3-piece bath, and a dedicated hot tub/sauna room. Upstairs, the primary suite offers a private sitting area with fireplace, access to the upper deck, a large walk-in closet, and a spa-inspired ensuite with soaker tub and tiled shower. A second bedroom, full bath, wet bar, family room with gas fireplace, and a dramatic open-to-below catwalk complete the upper level. The home includes in-floor heating on both levels, instant hot water, and air conditioning.The heated shop is a dream for business owners, hobbyists, or vehicle enthusiasts, featuring in-floor heat, new oversized overhead doors, new professional floor coating, LED lighting, 300-amp power, RV hookups, washroom, storage rooms, utility room, and mezzanine office. Ample parking and turnaround areas allow for equipment, RV, or fleet storage.Live in comfort with space for your business and toys, or explore multiple income possibilities : bed and breakfast, storage facility, microbrewery, automotive/custom shop, oilfield services, or private event venue (subject to approvals). Quick access to QEII Highway adds convenience and value.This property must be seen in person to be fully appreciated. Call today for a private viewing. (id:25325)
| MLS® Number | A2267926 |
| Property Type | Single Family |
| Amenities Near By | Golf Course, Park, Playground, Recreation Nearby, Schools, Shopping |
| Community Features | Golf Course Development |
| Features | Cul-de-sac, No Neighbours Behind, Closet Organizers, No Animal Home, No Smoking Home, Level, Sauna, Gas Bbq Hookup |
| Parking Space Total | 20 |
| Plan | 9912249 |
| Bathroom Total | 4 |
| Bedrooms Above Ground | 2 |
| Bedrooms Total | 2 |
| Appliances | Washer, Refrigerator, Cooktop - Gas, Dishwasher, Dryer, Microwave, Freezer, Oven - Built-in, Window Coverings, Garage Door Opener |
| Basement Type | None |
| Constructed Date | 2006 |
| Construction Material | Poured Concrete, Wood Frame, Steel Frame |
| Construction Style Attachment | Detached |
| Cooling Type | Central Air Conditioning |
| Exterior Finish | Concrete, Metal, Stone, Stucco |
| Fireplace Present | Yes |
| Fireplace Total | 4 |
| Flooring Type | Carpeted, Ceramic Tile, Hardwood |
| Foundation Type | Poured Concrete, Slab |
| Half Bath Total | 1 |
| Heating Fuel | Natural Gas |
| Heating Type | In Floor Heating |
| Stories Total | 2 |
| Size Interior | 3,436 Ft2 |
| Total Finished Area | 3435.9 Sqft |
| Type | House |
| Concrete | |
| Garage | |
| Gravel | |
| Heated Garage | |
| Oversize | |
| Parking Pad | |
| Garage | |
| Attached Garage | |
| R V | |
| Tandem |
| Acreage | No |
| Fence Type | Fence |
| Land Amenities | Golf Course, Park, Playground, Recreation Nearby, Schools, Shopping |
| Landscape Features | Landscaped, Lawn |
| Size Depth | 70.8 M |
| Size Frontage | 36 M |
| Size Irregular | 0.58 |
| Size Total | 0.58 Ac|21,780 - 32,669 Sqft (1/2 - 3/4 Ac) |
| Size Total Text | 0.58 Ac|21,780 - 32,669 Sqft (1/2 - 3/4 Ac) |
| Zoning Description | I-1 |
| Level | Type | Length | Width | Dimensions |
|---|---|---|---|---|
| Second Level | Loft | 23.25 Ft x 16.83 Ft | ||
| Second Level | Primary Bedroom | 12.42 Ft x 29.58 Ft | ||
| Second Level | Other | 12.33 Ft x 8.17 Ft | ||
| Second Level | Bedroom | 14.17 Ft x 9.92 Ft | ||
| Second Level | 4pc Bathroom | 14.67 Ft x 12.67 Ft | ||
| Second Level | 4pc Bathroom | 5.92 Ft x 12.58 Ft | ||
| Second Level | Den | 7.67 Ft x 12.67 Ft | ||
| Second Level | Other | 13.50 Ft x 5.67 Ft | ||
| Main Level | Foyer | 12.33 Ft x 11.17 Ft | ||
| Main Level | Family Room | 11.50 Ft x 27.08 Ft | ||
| Main Level | Kitchen | 9.08 Ft x 21.33 Ft | ||
| Main Level | Living Room | 17.50 Ft x 21.42 Ft | ||
| Main Level | Office | 11.08 Ft x 15.42 Ft | ||
| Main Level | Other | 4.25 Ft x 9.58 Ft | ||
| Main Level | 3pc Bathroom | 6.17 Ft x 10.58 Ft | ||
| Main Level | 2pc Bathroom | 6.58 Ft x 4.67 Ft | ||
| Main Level | Laundry Room | 5.42 Ft x 10.58 Ft | ||
| Main Level | Storage | 11.50 Ft x 21.75 Ft | ||
| Main Level | Storage | 10.50 Ft x 10.58 Ft | ||
| Main Level | Workshop | 11.25 Ft x 46.08 Ft | ||
| Main Level | Workshop | 15.33 Ft x 10.83 Ft | ||
| Main Level | Furnace | 7.83 Ft x 10.83 Ft |
https://www.realtor.ca/real-estate/29096783/1628-25-avenue-didsbury
No Favourites Found
The trademarks REALTOR®, REALTORS®, and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. 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. The trademark DDF® is owned by The Canadian Real Estate Association (CREA) and identifies CREA's Data Distribution Facility (DDF®)

The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. Used under license. 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.