SEARCHOPERTIES


Picture of 148, 315 24 Avenue SW, Calgary Real Estate Listing
148, 315 24 Avenue SW, Calgary || $300,000

Discover urban living at its finest in the heart of Mission. This bright 1-bedroom, 1.5-bathroom apartment with street level access offers a functional, multi-level layout that feels more like a townhome. The TWO TITLED PARKING STALLS are a huge perk in this neighbourhood, eliminating the biggest headache of inner-city living (finding parking!). Both the open floor plan and a 2pc powder room on the main floor make the layout incredibly convenient for daily life, it\'s also the perfect separation of public/private space in your home for hosting guests. Coming home to a gas fireplace in the living room on a cold evening adds a wonderful touch of comfort! The den upstairs is a game-changer—whether you need a dedicated home office, a cozy reading nook, or extra storage, this space is waiting for you to put your stamp on it. This condo complex is pet friendly, offering a functional home perfect for both you AND your furred family members.

All you have to do is step out your door to find some of the best cafes, restaurants, and shops in town (plus a grocery store only steps away!), or you can escape from the concrete jungle to the Elbow pathways and enjoy a dog walk/bike ride/run - it\'s the best of urban convenience paired with access to the outdoors! With two parking stalls, in-suite laundry, additional storage, low-maintenance finishings, pet friendly condo policies, and an individual street access entrance for your own unit, here is everything you need to move in and enjoy the convenience of condo living with the feel of a private home.

Listing Brokerage: Knag Real Estate & Property Management Ltd.
Picture of 2248 9 Avenue SE, Calgary Real Estate Listing
2248 9 Avenue SE, Calgary || $2,888,888

Welcome to a stunning 7,000+ SF custom residence originally inspired by the iconic Banff Springs Hotel. Perfectly situated on a spacious 11,000sf double lot (zoned M-CG) at the very end of 9 Avenue SE and surrounded by nothing except the serene Bow River, the picturesque Inglewood wildlands & bird sanctuary, lush parks, and scenic walking/riding trails. This private and exclusive location is one of a kind! As you approach this magnificent estate, you’ll be captivated by the exquisite stone and woodwork that grace both the exterior and interior, showcasing exceptional craftsmanship. The grand entrance invites you into a world of elegance and warmth, where no detail has been overlooked. The home offers four spacious bedrooms and four and a half bathrooms, this residence combines comfort and functionality. Step into the awe-inspiring great room, where towering ceilings soar above, creating an airy and inviting atmosphere. The impressive floor-to-ceiling window package floods the space with natural light, seamlessly connecting the indoors with the stunning outdoor beauty. Whether hosting gatherings or enjoying quiet evenings, this room is perfect for both entertaining and relaxation. Adjacent to the great room, a beautifully appointed custom kitchen. Featuring top-of-the-line appliances including an 8 burner gas range, it\'s a chef’s dream. Expansive countertops including a huge island with sit up bar and ample cabinetry provide both functionality and elegance, making it a perfect place to create culinary masterpieces and entertain. For wellness enthusiasts, the private indoor saltwater pool invites you to unwind and enjoy a refreshing swim year-round. The tranquil setting is perfect for relaxation or hours of fun with family and friends. Upstairs you’ll find 3 beds including a large bonus/den space. The large primary bedroom overlooks the wetlands and includes a luxurious 6 piece ensuite bathroom and chic gas fireplace. The lower level continues the same level of finishing as the rest of the home. Large rec/games room including pool table. Additional family room space and a full sized gym offers a dedicated space for maintaining an active lifestyle. Entertainment takes center stage in the dedicated theatre room, designed for memorable movie nights with family and friends. Cozy up on custom seating and immerse yourself in cinematic experiences from the comfort of your own home. The outdoor space is equally impressive, large private deck featuring a luxurious hot tub surrounded by beautifully landscaped grounds. This serene setting is perfect for evening relaxation under the stars or hosting outdoor gatherings. As you explore this amazing location, you’ll appreciate the privacy and tranquility it provides. Easy access to trails, parks, tennis courts, the Bow River, shops, restaurants, schools, Inglewood Golf & Country and much more! Immediate possession available!

Listing Brokerage: Charles
Picture of 2, 200 Sandstone Drive NW, Calgary Real Estate Listing
2, 200 Sandstone Drive NW, Calgary || $469,900

This 1,196 sq. ft. bungalow is tucked away in a quiet, friendly cul-de-sac in the sought-after community of Sandstone. The open floor plan features vaulted ceilings that span the living and dining areas, creating an airy feel. Large windows flood the living room with natural light, while the formal dining room boasts charming bay windows overlooking a private side yard. The kitchen offers ample cabinetry and direct access to a 16\' x 5\' southeast-facing deck.
The main floor includes a spacious primary suite with double closets and a 4-piece ensuite, plus a second bedroom and an additional 3-piece bath with integrated laundry. Peace of mind comes standard, as all Poly-B piping has been replaced in 2018, the shingles on roof were replaced in 2025. The undeveloped basement, featuring high ceilings and rough-in plumbing, is a blank canvas for your finishing touches. This home is complete with an insulated double garage and a large lot near transit and shopping.

Listing Brokerage: Grand Realty
Picture of 231 Sage Hill Circle NW, Calgary Real Estate Listing
231 Sage Hill Circle NW, Calgary || $499,900

Welcome to Sage Hill Garden, a beautiful townhouse project in one of the most convenient locations in northwest Calgary. This stunning end-unit townhouse offers two storeys plus a fully finished basement, featuring 4 bedrooms and 3.5 bathrooms. South-facing oversized windows fill the home with natural light throughout every level.

Thoughtfully designed with both style and comfort in mind, this home showcases elegant wood paneling on the TV feature wall and a beautifully finished accent wall in the living room. The kitchen is finished with quartz countertops and stylish two-tone cabinetry, creating a modern and functional space for everyday living.

The fully finished basement adds exceptional versatility, complete with an additional bedroom, a spacious living area with a wet bar, and a full bathroom—perfect for extended family, guests, or extra entertainment space.

Ideal for families seeking both convenience and a luxurious lifestyle, this home is within walking distance to Walmart, T&T Supermarket, and Creekside Shopping Centre, and just 5 minutes from Costco. Located in one of the core hub areas of northwest Calgary, this property offers outstanding access to shopping, dining, and everyday amenities.

Listing Brokerage: Homecare Realty Ltd.
Picture of 21, 137 Fontaine Crescent , Fort McMurray Real Estate Listing
21, 137 Fontaine Crescent , Fort McMurray || $279,900

Over 2,000 sq ft of living space, two primary bedrooms with private ensuites, and four total parking spaces make this townhouse a rare find in today’s Fort McMurray market. Located close to parks, trails, restaurants, shopping, schools, and the Snye waterfront, this stylish home offers space, flexibility, and convenience in one beautifully designed package.

Welcome to Unit 21 at 137 Fontaine Crescent, a beautifully styled boho chic farmhouse inspired townhouse offering over 2,000 sq ft of developed living space in one of Fort McMurray’s most convenient locations. From the moment you step inside, you’ll notice the warm modern farmhouse aesthetic highlighted by new laminate flooring, fresh paint throughout, and abundant natural light that fills the home.

The open concept main floor blends comfort and functionality with a spacious living room featuring a cozy fireplace feature wall, a large dining area ideal for hosting family and friends, and a well appointed kitchen with rich cabinetry, stainless steel appliances, a breakfast bar, and generous counter space for cooking and gathering.

Upstairs you’ll find a rare dual primary bedroom layout with two oversized bedrooms, each featuring private four piece ensuite bathrooms. One primary bedroom includes a walk in closet, while the second primary suite offers the convenience of dual closets for additional storage and organization. Laundry is also conveniently located on the upper level, making everyday routines simple and efficient.

The lower level provides additional living space with a fully finished rec room and access to the tandem heated garage. The garage comfortably accommodates two vehicles and has been upgraded with epoxy flooring, creating a clean and versatile space that is currently set up as a premium man cave. This flexible area can easily function as a workshop, hobby space, hangout area, or additional storage while still allowing room for vehicles. The tandem layout also provides excellent space for storing recreational toys such as quads, side by sides, bikes, or seasonal gear, making it ideal for Fort McMurray’s outdoor lifestyle.

In addition to the garage parking, the driveway offers space for two additional vehicles, bringing the total to four parking spaces, which is rare for townhouse living. Outdoor living is just as impressive with a massive patio space perfect for summer barbecues, relaxing evenings, or enjoying Fort McMurray’s long daylight hours.

Additional highlights include air conditioning, stainless steel appliances, updated laminate flooring, fresh paint throughout (2026), NEW HOT WATER TANK (2026) and both a main level front entry and lower garage level entry for added convenience.

Whether you are a first time buyer, professional, investor, or someone looking for low maintenance living with generous space, this property offers a unique opportunity to enjoy modern comfort, flexible living areas, and rare parking capacity in one of Fort McMurray’s most walkable locations.

Listing Brokerage: People 1st Realty
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