MLS PROPERTIES FOR SALE

Picture of 57 Blue Heron Bay , Lake Newell Resort Real Estate Listing
57 Blue Heron Bay , Lake Newell Resort || $759,999

AAAH the LAKE LIFE....Imagine being only steps away from the lake as well as the tennis/basketball court and playground! This handsome home features 2495 sq ft fully developed living space complete with a walk out basement with in floor heat...wonderful for those cool fall & winter evenings. Enjoy beautiful sunsets and great barbeques on the spacious maintenance free upper deck while viewing the boating activity on Lake Newell. Make your imagination come to fruition at 57 Blue Heron Bay! This executive 2 story home offers modern design and comfortable elegance with all the bells and whistles from rich dark hardwood floors, modern white kitchen cabinets in the chef kitchen, large 4 person island, granite counter tops, high end stainless appliances, pantry and lake views all while enjoying your dinner! Large windows throughout this home gift you exceptional views of the beautiful lake from kitchen, dining area and living room. A large maintenance free deck on the South side features plenty of space for large outdoor furniture, natural gas outlet for bbq, AND a stunning view of Lake Newell. A private hot tub sits just the upper level deck. An abundance of windows offer lake views from the upper level primary bedroom which hosts a luxurious 4 piece ensuite, & walk in closet. Two additional bedrooms highlite the upper level as well as a fabulous bonus room with a natural gas fireplace with a stunning mantel, tv projector, complete with viewing screen. Additional 4 piece bathroom services the 2nd floor bedrooms as well as the bonus room. With 4 bedrooms, 3.5 bathrooms a bonus room on the second floor AND fully developed walkout basement there is more than enough room to host family and visitors! Seller's recently had a concrete patio added on ground level for an additional entertainment space to enjoy bbq's and additional access to the lake. Additional features for 57 Blue Heron Bay are: exterior "Gemstone" led lights, hot water on demand, high efficiency furnace & high efficiency 75 gallon hot water tank, exposed concrete aggregate driveway & RV parking, in-floor heat in basement & garage, sump pump back up alarm, dual controls for heat & air conditioning, underground sprinklers, home backs onto green space! Lake Newell has sooo much to offer home owners! Lake Newell Resort has one of the largest man made lakes in Alberta offering sportsmen and visitors a marina, fishing, sailing, waterskiing , boating, ice fishing, hiking and soooo much more. Located approximately 10 kms south of Brooks with school bus service to Brooks this community is ideal for full time living! Don't miss out on this ideally located property!

Listing Brokerage: MaxWell Capital Realty - Brooks
Picture of 44 Ravenslea Crescent SE, Airdrie Real Estate Listing
44 Ravenslea Crescent SE, Airdrie || $499,900

Welcome to the family-friendly community of Ravenswood, where comfort, style, and convenience come together in this inviting 3-bedroom, 2-bathroom bungalow. Whether you're purchasing your first home, downsizing, or simply looking for easy, functional living, this home is sure to check all the boxes. Step inside to a bright, open-concept main floor highlighted by a spectacular vaulted ceiling, beautiful ash hardwood flooring, and a cozy gas fireplace that creates a warm and welcoming atmosphere. The thoughtfully designed kitchen offers abundant cabinetry and counter space, a pantry, and a stainless steel/black appliances, making it equally suited for everyday living and entertaining. The main level also features a spacious primary bedroom complete with a walk-in closet and convenient cheater access to the main bathroom, along with a second bedroom that would make an ideal guest room, nursery, or home office. The partially finished basement extends your living space with a recreation area, a third bedroom, a 3-piece bathroom, a dedicated storage and laundry areas and a utility room—offering plenty of flexibility for family, guests, hobbies, or a home gym. Outside, you'll appreciate the home's charming curb appeal, beginning with the spacious covered front porch—the perfect place to enjoy your morning coffee and watch the sunrise. The backyard features an 11'2" x 9'9" deck for relaxing or entertaining, while the double detached garage provides ample room for parking and storage. Located in one of Ravenswood's most welcoming communities, this move-in-ready bungalow offers the perfect combination of thoughtful design, comfortable living, and everyday convenience. The kids can walk to either of the schools just around the corner, the Heloise Lorimer School (K-6) or the Ecole des Hautes-Plaines/ Airdrie Francophone School (K-12). Hurry to book your private showing and see everything it has to offer.

Listing Brokerage: CIR Realty
Picture of 51 Aspen Meadows Green SW, Calgary Real Estate Listing
51 Aspen Meadows Green SW, Calgary || $999,000

Situated in the heart of Aspen’s prestigious estate area, this beautifully appointed Brownstone offers the perfect blend of sophistication and comfort for executives and growing families. The home features a thoughtfully designed floor plan beginning with a newly enclosed, bright, and private office off the main entrance, complete with a gas fireplace.
A spacious formal dining room showcases coffered ceilings and upgraded built-ins. The open-concept kitchen provides abundant storage, a large island with seating, granite countertops, and seamless connection to the sun-filled living room with gas fireplace. The adjacent eating nook opens onto the deck overlooking the sunny south-facing yard.
Upstairs, you’ll find three bedrooms, a full bathroom, and a luxurious primary suite with lofted ceilings, a massive walk-in closet with custom built-ins, entertainment cabinetry with an additional gas fireplace, and a bright ensuite enhanced by a skylight.
The walkout lower level remains unspoiled and ready for your future development. This property is one of the few in the cul-de-sac offering access to a large side yard — ideal for children to play soccer, add a trampoline, or install a playset.

Listing Brokerage: Joyous Realty Inc.
Picture of 409 28 Avenue NW, Calgary Real Estate Listing
409 28 Avenue NW, Calgary || $1,249,900

Welcome to 409 28 Avenue NW, a brand-new luxury detached home located on one of Mount Pleasant's most picturesque streets, where a stunning canopy of mature oak trees creates an unforgettable first impression. Offering nearly 2,700 sq. ft. of beautifully designed living space, this move-in ready home combines timeless architecture with exceptional craftsmanship, featuring 4 bedrooms, 3.5 bathrooms, a fully finished basement with a recreation room, wet bar, home gym, and fourth bedroom, plus a double detached garage.

The bright, open-concept main floor showcases 10-foot ceilings, wide-plank engineered hardwood flooring, oversized windows, custom millwork, and designer finishes throughout. The chef-inspired kitchen features premium built-in appliances, ceiling-height cabinetry, quartz countertops and backsplash, and a striking fluted island. The spacious dining area flows effortlessly into the inviting living room, highlighted by a sleek gas fireplace and oversized patio doors leading to the expansive rear deck and sunny south-facing backyard—perfect for extending your living and entertaining space throughout the summer months.

Upstairs, the luxurious primary retreat boasts vaulted ceilings and a spa-inspired ensuite complete with heated tile floors, a freestanding soaker tub, dual vanities, a steam-ready shower, and a spacious walk-in closet. Two additional bedrooms, each with walk-in closets, a beautifully finished full bathroom, and a convenient upper-level laundry room complete this level.

The fully finished basement is thoughtfully designed for both entertaining and everyday living, featuring a spacious recreation room with a wet bar, a dedicated home gym, a fourth bedroom, and a full bathroom.

Ideally located just 3 blocks from Confederation Park, schools, SAIT, the University of Calgary, Foothills Medical Centre, downtown, and countless parks, cafés, and amenities, this exceptional home offers the perfect blend of luxury, comfort, and inner-city convenience in one of Calgary's most desirable neighborhoods.

Listing Brokerage: Real Broker
Picture of #5 24 Street SE, High River Real Estate Listing
#5 24 Street SE, High River || $928,800

Fabulous location with easy access & visibility from Hwy 2. 3.44 Acre lot in High River's Industrial Park. Zoning is SED - Service & Employment District. Street number will be assigned by the Town Of High River

Listing Brokerage: Century 21 Foothills Real Estate
Listing data is deemed reliable but is not guaranteed accurate by CREB®. Last updated: today at 1: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