MLS PROPERTIES FOR SALE

Picture of 1908 47 Street , Calgary Real Estate Listing
1908 47 Street , Calgary || $4,500

River Glass — Where Business Meets Elevated Living.
Experience the ultimate integration of career and lifestyle in this brand-new live-work residence at River Glass, a striking architectural landmark on the corner of Bowness Road and 47 Street NW. Designed for professionals and entrepreneurs, this unique unit offers exceptional street exposure paired with modern residential luxury.
The bright, street-facing commercial space features approximately 292 sq. ft. of storefront, enhanced by expansive floor-to-ceiling glass for outstanding visibility along Bowness Road. Ideal for retail, office, studio, or professional services, the space includes a dedicated private entrance—allowing you to welcome clients while maintaining separation from your home.
Upstairs, the thoughtfully designed residence offers 3 bedrooms and 3.5 bathrooms, blending comfort with contemporary style. The open-concept main floor features 9-foot ceilings, a chef-inspired kitchen with quartz countertops, premium appliances, and a gas range—perfect for entertaining or everyday living.

Unwind in the spacious primary suite with a spa-like ensuite, or step outside to your private rooftop patio with stunning views of the Bow River and Canada Olympic Park—an ideal setting for relaxing or hosting guests.
Additional features include a single indoor garage with electric car plug-in, 200-amp electrical service, outdoor bike rack, modern finishes with ceramic tile and laminate flooring, forced air heating, and separate commercial and residential entrances for maximum flexibility.
Located close to Market Mall, Shouldice Park, river pathways, restaurants, and more, this is a rare opportunity to truly live, work, and thrive in one of Calgary’s most dynamic new developments.

Listing Brokerage: ComFree
Picture of 104, 540 18 Avenue SW, Calgary Real Estate Listing
104, 540 18 Avenue SW, Calgary || $275,000

Experience the ultimate urban vibe at Cambridge Square North! Perfectly positioned in the vibrant Beltline community of Cliff Bungalow just one block from the iconic 17th Avenue, this updated 2-bedroom main floor condo is your launchpad to Calgary\'s premier nightlife, trendy pubs, and top-tier restaurants. After soaking in the energy of the city core just minutes away, retreat to your own private terrace that boasts downtown views and uniquely backs onto a serene green space, a rare and tranquil escape for downtown living. Inside, the bright and spacious living room features newer carpets and flows effortlessly into a separate dining area and a crisp, galley-style kitchen outfitted with white appliances. Both generous bedrooms offer excellent closet space, with the primary suite boasting a convenient walk-through closet leading directly into the full bathroom. Designed for everyday convenience, this unit includes a large in-suite storage room, in-suite laundry with a stacked washer and dryer, and an assigned parking stall in the heated underground parkade. Complete with access to the residents\' exercise room, this dynamite condo offers unbeatable value, easy transit access, and unmatched walkability for the hip downtown lifestyle you’ve been dreaming of!

Listing Brokerage: Gravity Realty Group
Picture of 6405, 304 Mackenzie Way SW, Airdrie Real Estate Listing
6405, 304 Mackenzie Way SW, Airdrie || $234,900

This top-floor residence offers a relaxed lifestyle paired with impressive mountain scenery and the rare advantage of no neighbors behind, ensuring a quiet and peaceful atmosphere. Spanning 844 sqft, this modern condo is finished with resilient vinyl plank floors and updated light fixtures, creating a bright, clean environment throughout. Thanks to its south-facing orientation, the home is flooded with a ton of natural light, making the entire space feel warm and inviting all day long. At the heart of the home, an open-concept living area features a cozy corner gas fireplace—the perfect spot to unwind or host friends. The kitchen is built for practicality, featuring a raised counter that doubles as a handy breakfast bar for morning coffee. The layout is intentionally designed for privacy, with the two bedrooms located on opposite ends of the unit. The primary suite serves as a true sanctuary, featuring a walk-through closet that leads to a private ensuite, while the second bedroom is generously sized with easy access to the main four-piece bathroom. Rare for condo living, this home includes two parking spots and monthly fees that are all-inclusive of heat, water, and electricity. You’ll also find the convenience of in-suite laundry and dedicated extra storage space. Step out onto your private, sunny south-facing covered balcony to enjoy a personal outdoor retreat with views of the sunset over Iron Horse Park and the distant peaks. Beyond the building, the neighborhood is incredibly walkable; Sobeys, local gyms, and diverse dining options are all reachable in just a few minutes. Move-in ready, sun-drenched, and grounded in both style and convenience, this property is a rare find. Don’t miss out—book your showing today!

Listing Brokerage: CIR Realty
Picture of 1904 47 Street , Calgary Real Estate Listing
1904 47 Street , Calgary || $4,500

River Glass — Where Business Meets Elevated Living.
Experience the ultimate integration of career and lifestyle in this brand-new live-work residence at River Glass, a striking architectural landmark on the corner of Bowness Road and 47 Street NW. Designed for professionals and entrepreneurs, this unique unit offers exceptional street exposure paired with modern residential luxury.
The bright, street-facing commercial space features approximately 292 sq. ft. of storefront, enhanced by expansive floor-to-ceiling glass for outstanding visibility along Bowness Road. Ideal for retail, office, studio, or professional services, the space includes a dedicated private entrance—allowing you to welcome clients while maintaining separation from your home.
Upstairs, the thoughtfully designed residence offers 3 bedrooms and 3.5 bathrooms, blending comfort with contemporary style. The open-concept main floor features 9-foot ceilings, a chef-inspired kitchen with quartz countertops, premium appliances, and a gas range—perfect for entertaining or everyday living.
Unwind in the spacious primary suite with a spa-like ensuite, or step outside to your private rooftop patio with stunning views of the Bow River and Canada Olympic Park—an ideal setting for relaxing or hosting guests.
Additional features include a single indoor garage with electric car plug-in, 200-amp electrical service, outdoor bike rack, modern finishes with ceramic tile and laminate flooring, forced air heating, and separate commercial and residential entrances for maximum flexibility.
Located close to Market Mall, Shouldice Park, river pathways, restaurants, and more, this is a rare opportunity to truly live, work, and thrive in one of Calgary’s most dynamic new developments.

Listing Brokerage: ComFree
Picture of 35, 810 56 Street , Edson Real Estate Listing
35, 810 56 Street , Edson || $37,000

Welcome to this beautifully maintained mobile home located in Edson’s sought-after Sunset Mobile Home Park, where comfort meets convenience in a welcoming community setting. Situated on the west end of town, this home offers easy access to schools, shopping, walking trails, and recreation, making it an ideal option for families, first-time buyers, or those looking to downsize.

Step inside to discover a bright and functional open-concept layout that seamlessly connects the living, kitchen, and dining areas. The kitchen offers ample cabinetry and counter space, perfect for everyday living and entertaining. With three bedrooms and two full bathrooms, including a spacious primary retreat complete with a generous ensuite featuring a jetted tub and separate shower, this home provides both comfort and practicality. Outside, enjoy a large fully fenced yard that backs onto a peaceful greenbelt, offering added privacy and no rear neighbors. The outdoor space is ideal for families, pets, or simply relaxing, and includes a deck area, 2 storage sheds, and plenty of room for additional storage. Recent updates throughout the home add value and peace of mind, while features like off-street parking and a spacious laundry/storage area enhance everyday convenience.
Located in a quiet park with on-site management, playgrounds, and nearby amenities, Sunset Mobile Home Park is known for its community feel and accessibility to everything Edson has to offer. An affordable opportunity to own a move-in-ready home in a great location, this one is not to be missed!

Listing Brokerage: ROYAL LEPAGE EDSON REAL ESTATE
Listing data is deemed reliable but is not guaranteed accurate by CREB®. Last updated: today at 3:00 a.m.

© 2026 CENTURY 21 Real Estate Foothills. CENTURY 21® is a registered trademark licensed to Century 21 Real Estate LLC. Equal Housing Opportunity. Each office is independently owned and operated.

Find Real Estate Foothills on Facebook Find Real Estate Foothills on Twitter