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. Property is 70% completed. 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,349,000 (CAD)
Calgary Area Residential
Active
1826 6 Street NE Calgary, AB T2E 3Z1
5 Bed
5 Baths
2469 sqft
MLS® A2335999
Luxury New Build in Winston Heights | 3,550+ SF Total | 2 Primary Suites | Legal 2-Bed Suite | Detached Garage
Welcome to 1826 6 Street NE, a beautiful new home in the heart of Winston Heights-Mountview. Offering over 3,550 SF of total developed space, this home combines modern design, comfort and functionality.
The main floor features an open layout with custom built-ins, designer lighting, a feature fireplace and a beautiful chef’s kitchen with premium Dacor appliances, a large island and custom granite-wrapped hood fan. Built-in speakers are also installed throughout the main and upper floors. The main floor has 10 ft ceilings.
Upstairs, you’ll find two spacious primary bedrooms, each with its own walk-in closet and ensuite. This unique layout is ideal for families, guests or multigenerational living. The upper floor also offers plenty of natural light and a private balcony.
The home includes several upgrades including heated tile floors in the rear foyer and primary ensuite and a high-end automatic toilet with an opening and closing lid in the ensuite.
The fully developed legal 2-bedroom basement suite has a separate living space and is a great option for rental income or extended family.
Outside, the fully landscaped and fenced yard offers private space to relax or entertain. The detached garage provides secure parking and extra storage.
The location is excellent with easy access to downtown, Edmonton Trail, 16 Avenue, major roads, transit, schools, parks, shopping and restaurants. Georges P. Vanier School is about a 4-minute walk away and Winston Heights Park is nearby. Golf lovers will also enjoy having The Winston Golf Club and Fox Hollow Golf Course close by.
A rare opportunity to own a new inner-city home with **two primary suites, a legal 2-bedroom suite, 10 ft main floor ceilings and a detached garage** in one of Calgary’s established communities.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Andy Bhalla, 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® A2321015
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
$649,900 (CAD)
Calgary Area Residential
Active
389 Cornerbrook Road NE Calgary, AB T3N 2E4
5 Bed
4 Baths
1803 sqft
MLS® A2333592
Stunning Family Home with Legal Basement Suite | 2,550+ Sq. Ft. | 2-Bed Legal Suite
Welcome to this beautiful and upgraded family home with over 2,550 sq. ft. of developed living space, including a builder-built legal 2-bedroom basement suite currently rented for $1,200 per month.
The main floor offers a full bedroom and full bathroom, making it a great option for guests or a larger family. Hardwood flooring runs throughout the main level. The home also features upgraded appliances and a bright open-concept layout.
Upstairs offers over 1,800 sq. ft. of living space with spacious bedrooms, a bonus room and comfortable carpet flooring.
The legal 2-bedroom basement suite has its own separate entrance and private laundry. It is a great mortgage helper or can be used for extended family.
The location is excellent with ponds, parks, green space and walking paths just steps away. Shopping, restaurants and everyday amenities are also close by. Chalo FreshCo is 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 great opportunity to own a spacious family home with a legal basement suite and rental income in a growing community.
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® A2339305
OPEN HOUSE SUNDAY AUGUST 23 between 12PM-2PM. 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
$549,900 (CAD)
Airdrie Area Residential
Active
834 Bayview Terrace SW Airdrie, AB T4B 5M5
4 Bed
3 Baths
1746 sqft
MLS® A2331544
OPEN HOUSE SATURDAY-SUNDAY 12-2PM. Welcome to this beautifully designed 1,750 sq. ft. two-storey home in the sought-after community of Bayview, Airdrie. Offering 4 bedrooms, 3 full bathrooms, and immediate possession, this thoughtfully designed home combines modern style, functionality, and comfort.
The inviting main floor features a spacious foyer, a bright front bedroom, and a full bathroom with a walk-in shower—ideal for guests, multi-generational living, or a home office. The open-concept living and dining areas seamlessly connect to the north-facing gourmet kitchen, complete with upgraded stainless steel appliances, quartz countertops, a large central island, a generous walk-in pantry, and ample cabinetry. A practical mudroom with backyard access adds everyday convenience.
Upstairs, the spacious primary suite offers a walk-in closet and a well-appointed 4-piece ensuite featuring dual quartz vanities and a walk-in shower. Two additional bedrooms, a full bathroom, and an upper-level laundry room complete the second floor, providing a functional layout for growing families.
The unfinished basement offers exceptional future potential with a separate side entrance and rough-in plumbing for a future bathroom, making it ideal for additional living space, a recreation area, or the possibility of a secondary suite, subject to municipal approvals and permitting. The rear lane provides convenient access, with plans available for a future double detached garage on a concrete pad.
Additional highlights include a complimentary Smart Home Package, New Home Warranty coverage, and immediate possession. Located just steps from scenic walking pathways, parks, playgrounds, and a tranquil canal, Bayview offers a peaceful setting with easy access to everyday amenities. This is an outstanding opportunity to own a brand-new home in one of Airdrie's most desirable communities.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$399,900 (CAD)
Calgary Area Residential
Active
292 Falshire Way NE Calgary, AB T3J 2B4
4 Bed
2 Baths
817 sqft
MLS® A2328021
FIXER UPPER, HANDYMAN SPECIAL!!! Welcome to this AMAZING bungalow situated on a HUGE pie-shaped lot of over 6,300 sq. ft.! Offering 4 bedrooms and 2 bathrooms, this property is a fantastic opportunity for first-time home buyers, investors, or anyone looking to add their personal touch with some renovations.
The main level features a spacious living room, formal dining area, 4-piece bathroom, two generous bedrooms, and a large functional kitchen. The basement offers an additional large living area, two more bedrooms, a bathroom, and laundry space, providing plenty of room for extended family or future possibilities.
Enjoy the oversized backyard featuring a deck, garage pad, RV parking space, and plenty of extra green space — perfect for outdoor enjoyment. The property is currently rented at a strong rental rate, and the tenants may be willing to stay if permitted.
Conveniently located close to schools, shopping centres, public transportation, and with quick access to major roadways, this home combines location and opportunity. Whether you’re searching for a comfortable place to call home or your next investment property, this bungalow is one you don’t want to miss!
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$290,000 (CAD)
Calgary Area Residential
Active
7210 80 Avenue NE 423 Calgary, AB T3J 0A6
2 Bed
2 Baths
843 sqft
MLS® A2316601
Welcome to this beautifully renovated 2-bedroom, 2-bathroom apartment in the highly sought-after community of Saddle Ridge. Offering modern finishes, a bright and spacious layout, and exceptional convenience, this home is perfect for professionals, small families, or investors. Ideally located within walking distance to the Saddletowne LRT Station and with easy access to Calgary Transit routes 159, 60, and 61, commuting is effortless. Residents will enjoy being just minutes from shopping, restaurants, schools, parks, recreation facilities, and all major amenities. This is a fantastic opportunity to own or invest in a move-in-ready home in one of Northeast Calgary’s most convenient locations. Contact your REALTOR® today to schedule a private viewing.
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® A2315012
Approx. 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 allowing easy access and circulation for various business operations.
Ideal for a variety of uses including truck parking, storage yard, construction yard, equipment storage, logistics and transportation businesses, dealership overflow parking, fleet parking, contractor yard, outdoor storage and other DC permitted uses.
Option available to lease approximately 1.25 acres as well.
Monthly rent of $14,900 is for the full 2.5 acre site. Lease rate for approximately 1.25 acres shall be proportionate accordingly.
Excellent opportunity in a rapidly growing commercial area with convenient access to major routes and surrounding businesses.
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.