MLS PROPERTIES FOR SALE

174 Windstone Avenue SW, Airdrie || $519,000

This stunning 3-bedroom home truly has it all—style, comfort, and an unbeatable location! Backing onto a massive green space, you’ll love the peaceful backyard with a beautiful gazebo—perfect for summer BBQs or relaxing in the shade. And inside? Stay cool all summer with your very own AIR CONDITIONING & keep your home clean with central vacuum.

Step inside to a bright and inviting main floor, where the living room offers flexible furniture layouts, anchored by a cozy gas fireplace & mantle. The kitchen is both stylish and functional—ideal for cooking together during family meals or holidays. The island seats two, pot lights make prep a breeze, and the highlight? A Smart Oven that lets you cook two dishes at different temperatures at once! Plus, you’ll enjoy a walk-in pantry, rear entry closet, and a convenient single garage for parking or storage.

Upstairs, your spacious primary retreat easily fits a king-sized bed and overlooks the park. The ensuite bath features a deep tub/shower combo and serene views. Two bright kids’ bedrooms, a full bathroom with extra counter space, and a well-designed laundry room with folding counter & cabinets complete this level.

The fully finished basement adds even more living space has an indoor playset for families with children—perfect as a playroom, home office, or guest suite.

Prime Location:

Just 1 minute to 40th Ave & Deerfoot—easy Calgary commute

Windsong Heights K-8 School right behind the home (kids can walk home for lunch!)

Chinook Winds Park nearby with splash park, sports fields & pump track

Walkable to Save-On-Foods, Shoppers, Dairy Queen, Balzac Brewing & more

Transit routes close by

This is more than just a home—it’s a lifestyle! Don’t miss your chance to own this incredible property in one of Airdrie’s most family-friendly communities.
Book your showing today!

Listing Brokerage: LPT Realty
35 Lewisburg Manor NE, Calgary || $569,900

Welcome to the Midtown 2 — a 1,634 sq. ft. semi-detached home in North Calgary\'s new community of Lewisburg. This 3-bed, 2.5-bath home features an upgraded kitchen, designer bathrooms, and a versatile upper-floor loft — perfect as a home office, playroom, or reading nook. Light-filled living spaces and a functional open layout make everyday living effortless. Photos are representative of previously built model.

Listing Brokerage: Bode Platform Inc.
305, 19 Terrace View NE, Medicine Hat || $289,000

Welcome to easy, maintenance-free living at #305–19 Terrace View NE! This well-appointed third-floor condo offers 2 bedrooms and 2 full bathrooms, making it an excellent option for first-time buyers, downsizers, or investors alike. The bright and inviting open-concept layout features a spacious living room with access to your private covered deck, a generous dining area, and a well-equipped kitchen complete with stainless steel appliances and plenty of cabinetry for storage and functionality. The primary bedroom includes a walk-through closet and a private 4-piece ensuite, while a second bedroom and additional 4-piece bathroom provide flexibility for guests, family members, or a home office. Additional features include convenient in-suite laundry, a covered deck perfect for enjoying your morning coffee or relaxing at the end of the day, plus one underground parking stall with a dedicated storage unit.

This pet-friendly building (with restrictions) has no age restrictions and offers exceptional value with condo fees of just $450/month, covering all utilities and maintenance, including electricity, heat, water, sewer, garbage collection, snow removal, groundskeeping, parking, and reserve fund contributions. A fantastic opportunity to own a comfortable, affordable, and worry-free home in a great location!

Listing Brokerage: RE/MAX MEDALTA REAL ESTATE
18 Cougarstone Bay SW, Calgary || $799,900

*** OPEN HOUSE SATURDAY JUNE 27TH & SUNDAY JUNE 28TH 2:00 PM - 4:00 PM **** Nestled on a premium, low-maintenance pie lot within a quiet Cougar Ridge cul-de-sac, this immaculate 2,307 sq ft two-story residence blends classic architectural charm with a bright, welcoming interior. The journey begins in a grand cathedral foyer, where soaring ceilings establish a sense of scale and openness. Just off the entrance sits a versatile flex room, a sunlit space ideally suited for a home office, a quiet reading retreat, or a formal sitting area. The main level transitions into a beautifully integrated, open-concept living space designed for daily life and effortless entertaining. The inviting living room serves as a central gathering point, anchored by a handsome stone-faced corner gas fireplace that radiates warmth throughout the main floor. This space connects smoothly to a chef-friendly kitchen, thoughtfully equipped with expansive cabinetry, a generous walk-through pantry, and a casual breakfast nook. Positioned adjacent to the formal dining room, the layout ensures that hosting dinner parties or family holiday meals is always a seamless experience. Rounding out the main floor’s practical design is a discreet two-piece powder room for guests, alongside a highly functional mudroom and laundry area that makes coming and going organized and simple. The upper level is conceived as a private sanctuary tailored for rest and relaxation. It opens to a massive bonus room with a striking vaulted ceiling and a second gas fireplace, creating an enviable environment for movie nights, a children\'s play area, or a secondary family room. The primary suite offers a peaceful escape, featuring an expansive walk-in closet and a spa-like five-piece ensuite complete with a deep corner soaking tub and a separate walk-in shower. Two additional bright bedrooms, each offering ample closet storage, share a pristine four-piece main bathroom, ensuring plenty of space and privacy for family members or overnight visitors. Downstairs, the unfinished basement presents an incredible opportunity for future equity and customization. Standing as a blank canvas, this massive lower level is ready to be transformed into whatever fits your lifestyle, whether that means additional bedrooms, a home theater, or a fitness studio. The outdoor living space is just as impressive as the interior. Step outside onto the rear deck to look over a massive, fully fenced backyard. Because it sits on a sought-after pie lot, the yard offers an abundance of green space paired with low-maintenance landscaping and an easy-to-maintain 5-zone irrigation system, making it a haven for children and pets to play. For parking, the property features a double front-attached garage with a driveway that comfortably accommodates two additional vehicles. Featuring a new furnace (2024) and AC (2025), this exceptional home pairs sophisticated style with functional living near top amenities. Book your Showing Today!

Listing Brokerage: The Real Estate District
4932 48 Street , Hardisty || $165,000

Move right in and enjoy the peace of mind that comes with this beautifully renovated 3-bedroom, 1.5-bath home. Taken right down to the studs and thoughtfully rebuilt, this property combines modern finishes with solid upgrades throughout. The bright and inviting interior features stunning white shaker cabinetry, creating a light, airy feel in the kitchen and living spaces. Every detail has been carefully updated, making this home feel fresh, stylish, and functional. Outside, you\'ll find an existing 23\' x 23\' detached garage, offering plenty of room for vehicles, storage, or a workshop.
Whether you\'re a first-time buyer, downsizing, or looking for a turnkey investment property, this fully renovated home is ready for its next owner. Some photo\'s are AI generated to show the potential of this property.

Listing Brokerage: Clear Choice 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