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,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
$749,900 (CAD)
Calgary Area Residential
Active
100 Redstone Parade NE Calgary, AB T3N 0J8
4 Bed
4 Baths
2499 sqft
MLS® A2310112
Welcome to this exceptional, executive two-storey home by Jayman, ideally situated on a desirable corner lot backing onto green space in Redstone. Meticulously maintained, this impressive residence offers over 3,400 sq. ft. of developed living space, featuring 5 bedrooms, 3.5 bathrooms, and 25 windows dressed with Hunter Douglas coverings, providing abundant natural light throughout. Recent upgrades include new shingles, eavestroughs, and garage door paint within the past year. The open-concept main floor showcases 9’ ceilings, ceramic tile, and designer laminate flooring with cork underlay. The inviting living room is anchored by a tile-surround gas fireplace and includes a mounted TV. The well-appointed kitchen is a chef’s dream, complete with quartz countertops, stainless steel appliances including built-in oven, microwave, and cooktop, a mosaic tile backsplash, ample cabinetry, a central island with breakfast bar and pendant lighting, and a convenient walk-through pantry with dual pocket doors. The dining area opens to a beautifully landscaped backyard backing onto green space, featuring a large deck, patio with gazebo and fire feature, LED garden lighting (front and back), water features, and ample space for outdoor enjoyment. All exterior furniture and plants are included. The main level is completed by a 2-piece bathroom and a functional mudroom. Upstairs, the spacious primary suite offers dual walk-in closets, an updated light fixture with built-in ceiling fan, and a luxurious 5-piece ensuite with double vanities, soaker tub, separate shower, and tile flooring. The upper level also includes three additional generously sized bedrooms, a 4-piece bathroom, a large bonus room, and a convenient laundry room with cabinetry, countertop, and a bright south-facing window. The fully finished basement (with permits) extends the living space with a fifth bedroom, family room, home office area, and a stylish 3-piece bathroom featuring a marble vanity, tiled shower with tempered glass, and quality finishes throughout. Additional features include keyless entry (front and back), Nest smart thermostat, central alarm system with dual displays, doorbell camera, carbon monoxide detection, basement water sensor, and a central vacuum system servicing all three levels. The double attached garage is insulated and drywalled. Ideally located close to schools, parks, public transit, shopping, and all amenities, this outstanding property offers the perfect blend of comfort, style, and functionality.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$719,900 (CAD)
Calgary Area Residential
Active
39 Taravista Drive NE Calgary, AB T3J 4S6
6 Bed
4 Baths
2238 sqft
MLS® A2322836
LOCATION, SPACE & VIEWS! Welcome to this beautifully maintained and extensively updated two-storey NORTH FACING walkout home in the heart of Taradale, offering over 3 levels of over 3000 SQFT functional living space with 6 bedrooms plus a den and 3.5 bathrooms.
The main floor features soaring open-to-above ceilings, a spacious front den/office, formal dining area, convenient main-floor laundry, and a bright family room with a cozy gas fireplace and hardwood flooring throughout. The upgraded kitchen is designed for both everyday living and entertaining, showcasing raised-panel oak cabinetry, quartz countertops, tiled backsplash, stainless steel appliances, a gas stove, and a large pantry.
Step outside to the expansive deck and enjoy stunning pond views, creating the perfect setting for relaxation and outdoor gatherings.
Upstairs, the spacious primary retreat offers a luxurious 5-piece ensuite, while three additional bedrooms, a generous loft, and a full bathroom complete the upper level.
The fully finished walkout basement features an illegal suite with 2 bedrooms, a full bathroom, separate laundry, a full kitchen, and a large living area, providing excellent flexibility for extended family living.
Additional highlights include a double attached garage and ample street parking.
Ideally located just minutes from schools, shopping, public transit, Saddletowne LRT Station, the Genesis Centre, and numerous amenities. This exceptional property combines space, comfort, and an unbeatable location with picturesque pond views. A fantastic opportunity for families seeking room to grow.
Listing Courtesy of PILLAR 9 - IDX / Listed By: Coldwell Banker Yad Realty
$674,900 (CAD)
Airdrie Area Residential
Active
174 Morningside Circle SW Airdrie, AB T4B 0X4
4 Bed
4 Baths
1892 sqft
MLS® A2318615
Welcome to this beautiful family home on a quiet street in Morningside, offering almost 2,600 SF of developed living space and located just steps from schools, pathways and shopping. The south-facing backyard is fully fenced and perfect for enjoying sun all year.
Fresh paint and professionally cleaned, this home is move-in ready.
The main floor features a spacious foyer with a stunning 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 for easy access from the garage. The dining area opens to a full-width deck, bringing in great natural light.
Upstairs offers a spacious primary bedroom with room for a king bed, along with a 5-piece ensuite featuring double sinks, soaker tub, separate shower and private toilet. You’ll also find two additional bedrooms, a full bathroom, a bonus room with big windows and a convenient upper laundry room.
The basement includes an illegal suite with a separate entrance, kitchen, bedroom, 3-piece bath and flexible living space.
Enjoy a large backyard with a full-width deck and privacy screens. Walking paths, ponds, tennis courts and playgrounds are all close by.
Easy access to Main Street commercial developments and QE2 makes commuting simple and convenient.
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
$578,900 (CAD)
Calgary Area Residential
Active
10 Lucas Close NW Calgary, AB T3P 1Z5
3 Bed
3 Baths
1504 sqft
MLS® A2314331
Immaculate 3-bedroom, 2.5-bathroom home situated on a spacious corner lot in the highly sought-after community of Livingston NW. Showcasing exceptional curb appeal and thoughtful upgrades throughout, this move-in-ready property offers the perfect balance of style, comfort, and functionality.
Step inside to a bright and open-concept layout featuring quartz countertops, stainless steel appliances, and a beautifully appointed modern kitchen designed for both everyday living and entertaining. The main floor offers a clean, contemporary design, while central air conditioning provides year-round comfort.
Upstairs, you’ll find three generously sized bedrooms, including a tranquil primary retreat complete with a private ensuite bath. The basement features a separate side entrance, offering excellent potential for future development or a possible legal suite (subject to city approval).
Recent exterior upgrades include new siding and roof shingles, adding both value and peace of mind. Conveniently located near parks, future schools, shopping, and major commuter routes, this exceptionally well-maintained home is an outstanding opportunity in one of Calgary’s fastest-growing family communities.
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.