A truly exceptional and one-of-a-kind estate offering approximately 7,900 sq. ft. of developed living space on 12.5 acres approx within Calgary city limits. This rare property seamlessly blends the convenience of urban living with the tranquility and privacy of a country lifestyle. Thoughtfully designed for multi-generational living, the home features two distinct living quarters, each complete with its own kitchen, living areas, bedrooms, bathrooms, and laundry facilities, providing both independence and flexibility for extended families.
Enjoy spectacular mountain views from the expansive rear deck and upper-level balcony, creating the perfect setting for relaxation and entertaining. Additional highlights include a massive bonus room, an oversized quad garage, and abundant outdoor space with endless possibilities for recreation, hobby farming, or future enhancements. This is a rare opportunity to own a landmark estate offering space, versatility, and breathtaking surroundings, all within minutes of city amenities. Property is being sold as-is, where-is. All room dimensions, measurements, and property information are based on previous listing data and are deemed reliable but not guaranteed; buyers are advised to verify all information independently.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$1,900,000 (CAD)
Calgary Area Residential
Active
2828 24 Street NW Calgary, AB T2M 3Z3
5 Bed
4 Baths
1972 sqft
MLS® A2320968
Welcome to this beautifully crafted luxury 2-storey home in the sought-after community of Banff Trail. Ideally located near the University of Calgary, Confederation Park, schools, shopping, transit, and major roadways, this home offers exceptional convenience and lifestyle.
The bright open-concept main floor features soaring ceilings, hardwood flooring, a spacious living room with a gas fireplace, a family room, and a chef-inspired kitchen with premium finishes and a large island. Upstairs you'll find 3 generous bedrooms, including a luxurious primary suite with a spa-like 5-piece ensuite, a central bonus room, and convenient upper-floor laundry.
Adding incredible value is the fully legal 2-bedroom basement suite with a separate side entrance, family room, and private laundry—perfect for extended family or rental income. Complete with a double detached garage, this exceptional property combines luxury, functionality, and investment potential in one of Calgary's most desirable inner-city neighbourhoods. All measurement are from previous listing and buyer to verify. Price is for the both side by side units. No access to the property.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$1,100,000 (CAD)
Rural Red Deer County Area Lot/Land
Active
408 Lantern Street Rural Red Deer County, AB T4E 0A5
Bed
0 Baths
sqft
MLS® A2349556
Exceptional Land Assembly Opportunity in Red Deer! Located at 408 Lantern Street, this property presents a rare development opportunity in a growing and well-established area of Red Deer. Offered as part of a potential land assembly, the site provides excellent future redevelopment potential for investors, builders, and developers seeking to capitalize on the area's continued growth and demand. Strategically positioned with convenient access to major roadways, public transit, schools, parks, shopping, and other amenities, this property offers strong long-term value. Purchasers are advised to conduct their own due diligence regarding zoning, development potential, and municipal approvals. An outstanding opportunity to secure a key piece of a larger development project in a desirable location.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$1,099,000 (CAD)
Calgary Area Residential
Active
2302 6 Street NE Calgary, AB T2E 3Z1
5 Bed
4 Baths
2148 sqft
MLS® A2352410
Welcome to this exceptional semi-detached home offering almost 3,100 sq. ft. of total living space with approximately 2,150 sq. ft. above grade plus a beautifully developed 921 sq. ft. legal two-bedroom basement suite. The home makes an impressive first impression with its striking brick and modern stucco elevation, large black-framed windows, steep rooflines and fully landscaped yard. Inside, the main floor offers a bright and spacious open-concept design with wide-plank hardwood flooring, high ceilings and abundant natural light. The chef-inspired kitchen is finished with custom cabinetry, quartz countertops, a large island and some of the highest-end DECOR appliances. The spacious dining and living areas are perfect for entertaining and feature a beautiful fireplace and large windows. A custom mudroom with built-in cabinetry and bench seating adds both style and function. Upstairs offers generous bedrooms, a beautiful primary retreat and a luxurious ensuite with heated tile flooring along with convenient upper-level laundry. The legal two-bedroom basement suite is exceptionally well designed with quality finishes, high-end appliances and a layout that feels bright, comfortable and far removed from the typical basement suite experience. The property is fully landscaped and includes a double detached garage. A truly impressive home offering exceptional curb appeal, high-end finishes, a legal suite and nearly 3,100 sq. ft. of beautifully designed living space.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Andy Bhalla, Coldwell Banker Yad Realty
$1,099,000 (CAD)
Calgary Area Residential
Active
2300 6 Street NE Calgary, AB T2E 3Z1
5 Bed
4 Baths
2172 sqft
MLS® A2352425
STUNNING MODERN INFILL | OVER 3,100 SQ. FT. TOTAL | 5 BEDROOMS | 2-BEDROOM LEGAL BASEMENT SUITE | DOUBLE DETACHED GARAGE | DACOR APPLIANCES
Welcome to this beautifully designed modern infill offering approximately 2,172 sq. ft. above grade and over 3,100 sq. ft. of total developed space across three levels. With sophisticated finishes, thoughtful design and exceptional functionality, this home offers an impressive combination of style and space.
The main level features a bright open-concept layout with wide-plank hardwood flooring, oversized windows and an abundance of natural light. The spacious living room is highlighted by a stunning fireplace with custom built-ins and elegant architectural details.
The chef-inspired kitchen is the centrepiece of the home, featuring extensive custom cabinetry, premium stainless-steel DACOR appliances, quartz countertops and a large island with seating for four. The main floor also offers a dedicated home office, spacious dining area and a beautifully designed mudroom with custom built-ins.
Upstairs, the generous primary retreat features a large walk-in closet and a beautifully finished ensuite. Two additional bedrooms, another full bathroom, a laundry room and additional walk-in closets provide excellent functionality for a growing family.
The fully developed basement adds approximately 931 sq. ft. and features a spacious recreation room, full kitchen, two bedrooms, a full bathroom, laundry and utility space. The two-bedroom basement suite provides excellent flexibility for extended family, guests or rental income potential.
Additional highlights include custom millwork, designer lighting, extensive pot lights, elegant archways, built-in shelving, modern finishes throughout and a double detached garage.
A rare opportunity to own a beautifully finished inner-city home offering over 3,100 sq. ft. of total space, five bedrooms, multiple living areas and a two-bedroom basement suite.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Andy Bhalla, Coldwell Banker Yad Realty
$649,900 (CAD)
Airdrie Area Residential
Active
1321 Bayview Point SW Airdrie, AB T4B 5K1
3 Bed
3 Baths
1979 sqft
MLS® A2348114
Welcome to this beautifully upgraded 3-bedroom, 3-bathroom home in the highly sought-after community of Bayview, Airdrie. Offering over $40,000 in premium upgrades, this move-in-ready home combines thoughtful design, quality finishes, and an exceptional family-friendly location.
The main floor features a grand foyer, double attached garage, 2-piece powder room, and convenient walk-in pantry. The chef-inspired kitchen showcases ceiling-height cabinetry, brass hardware and fixtures, built-in microwave, gas range, and premium stainless steel appliances. The bright open-concept layout flows seamlessly into the dining area and spacious living room, complete with a cozy upgraded fireplace—ideal for both everyday living and entertaining.
Upstairs, a large bonus room provides additional living space and is filled with natural light from its extra windows. Three generously sized bedrooms each feature their own walk-in closet. The primary retreat offers a luxurious 5-piece ensuite with a standing shower and deep soaker tub, while the additional bedrooms are served by a well-appointed 4-piece bathroom. An upgraded laundry room with high-end washer and dryer, built-in shelving, and ample storage adds everyday convenience.
The unfinished basement offers endless potential for future development, whether you envision a home theatre, gym, recreation room, or additional living space.
Enjoy a traditional lot directly facing a soccer field and the future school site—an ideal setting for families. Bayview offers scenic canals, charming cul-de-sacs, over 100 km of interconnected paved pathways, seasonal community events, and no HOA fees. Conveniently located just minutes from Yankee Boulevard, 24th Street, Genesis Place, Bayside Plaza, Costco, CrossIron Mills, and Airdrie Transit, with easy commuter access to Calgary.
A rare opportunity to own a thoughtfully upgraded home in one of Airdrie's most desirable family communities. Nothing to do but move in and enjoy!
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$649,000 (CAD)
Airdrie Area Residential
Active
174 Morningside Circle SW Airdrie, AB T4B 0X4
4 Bed
4 Baths
1918 sqft
MLS® A2336439
Welcome to this beautiful family home in Morningside, located on a quiet street and close to schools, walking paths and shopping. With almost 2,600 SF of developed living space and a south-facing backyard, this home has plenty of room for the whole family.
Freshly painted and professionally cleaned, this home is move-in ready.
The main floor features a spacious foyer with a beautiful hardwood staircase, a bright living room with large windows and a gas fireplace and a functional kitchen with a breakfast bar and walk-through pantry. The dining area opens onto a full-width deck with plenty of natural light.
Upstairs you’ll find a large primary bedroom with enough space for a king-size bed and a 5-piece ensuite with double sinks, a soaker tub, separate shower and private toilet. There are also two additional bedrooms, a full bathroom, a bonus room with large windows and an upper-floor laundry room.
The basement has an illegal suite with a separate entrance, kitchen, bedroom, 3-piece bathroom and additional living space.
The large backyard is fully fenced and features a full-width deck with privacy screens. Walking paths, ponds, tennis courts and playgrounds are all nearby.
The home also offers easy access to Main Street commercial developments and QE2, making commuting convenient.
Recent upgrades include a new dishwasher (2024) and hot water tank (2025).
Listing Courtesy of PILLAR 9 - IDX / Listed By: Andy Bhalla, Coldwell Banker Yad Realty
$642,500 (CAD)
Calgary Area Residential
Active
389 Cornerbrook Road NE Calgary, AB T3N 2E4
5 Bed
4 Baths
1803 sqft
MLS® A2341774
Stunning Family Home with Legal Basement Suite | 2,550+ Sq. Ft. | Fully Landscaped
Welcome to this beautiful and upgraded family home offering over 2,550 sq. ft. of developed living space, including a builder-built legal 2-bedroom basement suite currently rented for $1,200/month.
The main floor features a full bedroom and full bathroom, perfect for guests, extended family or a home office. Hardwood flooring runs throughout the main level along with upgraded appliances and a bright open-concept layout.
Upstairs offers over 1,800 sq. ft. of comfortable living space with spacious bedrooms, a bonus room and carpet flooring.
The legal 2-bedroom basement suite features its own separate entrance and private laundry, making it an excellent mortgage helper or a great option for extended family.
Outside, the property is fully landscaped and ready to enjoy with a beautifully finished yard and easy-care outdoor space.
The location is excellent with ponds, parks, green space and walking paths just steps away. Shopping, restaurants and everyday amenities are all close by with Chalo FreshCo only 3 minutes away. A future school is nearby and the future Gurdwara Sahib is expected to be within 5 minutes.
With quick access to Stoney Trail, commuting around the city is easy and convenient.
A fantastic opportunity to own a spacious upgraded family home with a legal basement suite, rental income and fully landscaped yard in a growing community.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Andy Bhalla, Coldwell Banker Yad Realty
$619,900 (CAD)
Calgary Area Residential
Active
75 Evansdale Way NW Calgary, AB T3P 0C1
5 Bed
2 Baths
1058 sqft
MLS® A2350396
Over 2,000 sq. ft. of total developed living space, including approximately 1,057 sq. ft. on the main floor and 977 sq. ft. in the basement, **plus both side and back decks for additional outdoor living space.**
Welcome to this beautifully maintained and updated 5-bedroom bi-level on a desirable corner lot in Evanston NW. Situated on a generous 4,746.88 sq. ft. lot, this home features a massive side yard, spacious backyard and RV parking. The side deck is a special bonus of this corner-lot property, offering additional outdoor space to relax and entertain. Built in 2008, this move-in-ready home offers plenty of room for a growing family.
The main floor features a bright living room, dining area, functional kitchen, 3 bedrooms and a 4-piece bathroom. The basement offers a large recreation room, 2 additional bedrooms, a 4-piece bathroom, laundry and ample storage.
Recent updates include new siding and roof. Another great benefit of this corner lot is **no sidewalk along the side of the property, meaning less snow shovelling and exterior maintenance**. Conveniently located close to schools, shopping, parks and major routes, with easy access to Stoney Trail.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Andy Bhalla, Coldwell Banker Yad Realty
$295,000 (CAD)
Calgary Area Residential
Active
7210 80 Avenue NE 423 Calgary, AB T3J 0A6
2 Bed
2 Baths
767 sqft
MLS® A2348972
Discover a tranquil haven within Calgary’s vibrant Saddle Ridge community, where convenience and comfort converge. Situated in a beautifully maintained low-rise apartment building, this newly renovated 2 bedroom, 2 bathroom unit offers a seamless blend of modern living and accessible amenities. Inside, spanning 767 square feet, you’ll find an open floorplan accentuated by vinyl plank flooring, creating a bright and airy atmosphere. Granite counters elevate the kitchen, complemented by a practical kitchen island and pantry for ample storage. Enjoy the ease of an elevator and vinyl windows throughout, alongside an invaluable laundry suite within your home. Step onto your private balcony for moments to unwind, while the building provides bicycle storage, visitor parking, and convenient garbage chute access. With bus routes 59, 61, 80 and 159 readily available, your commute becomes effortless, and proximity to Saddletown LRT station allows easy access to other parts of Calgary. Furthermore, shopping centres and schools nearby provide added convenience, while walking/bike paths and sidewalk invite outdoor enjoyment. Fully furnished, this exceptional apartment represents a rare opportunity for comfortable living within a sought-after neighbourhood—a place where everyday life is both convenient and serene.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Kanwal Bhangu, Coldwell Banker Yad Realty
$14,500 (CAD)
Calgary Area Lot/Land
Active
10740 36 Street NE Calgary, AB T3N 2H9
Bed
0 Baths
sqft
MLS® A2347112
**2.5 ACRES OF DC-ZONED LAND FOR LEASE | JACKSONPORT | 36 STREET NE**
Approximately 2.5 acres of DC-zoned land available for lease in the highly desirable Jacksonport area on 36 Street NE.
Excellent exposure with **two access points** providing easy entry, exit and circulation. The property is well suited for businesses requiring a large outdoor site.
**Potential uses include:**
• **Dealership overflow parking**
• **Truck and trailer parking**
• Commercial vehicle and fleet parking
• Equipment and heavy machinery storage
• Construction and contractor yards
• Landscaping and snow removal equipment storage
• Logistics and transportation operations
• Outdoor storage
• Building supply and trade contractor yards
• Container storage
• Other DC-permitted uses
Approximately **1.25 acres** may also be available for lease. Ideal for businesses that do not require the full site.
**Full 2.5 acres:** $14,500/month + operating costs
**1.25 acres:** Rent to be adjusted proportionately
Located in a growing commercial area with convenient access to major routes and surrounding businesses.
**A rare opportunity for dealership overflow, truck and trailer parking or businesses needing secure outdoor commercial space.**
Listing Courtesy of PILLAR 9 - IDX / Listed By: Andy Bhalla, Coldwell Banker Yad Realty
Enjoy spectacular mountain views from the expansive rear deck and upper-level balcony, creating the perfect setting for relaxation and entertaining. Additional highlights include a massive bonus room, an oversized quad garage, and abundant outdoor space with endless possibilities for recreation, hobby farming, or future enhancements. This is a rare opportunity to own a landmark estate offering space, versatility, and breathtaking surroundings, all within minutes of city amenities. Property is being sold as-is, where-is. All room dimensions, measurements, and property information are based on previous listing data and are deemed reliable but not guaranteed; buyers are advised to verify all information independently.