MLS PROPERTIES FOR SALE

Picture of 2190, 151 SKYVIEW Bay , Calgary Real Estate Listing
2190, 151 SKYVIEW Bay , Calgary || $249,900

Exceptional opportunity to own a fully equipped, around 1000 sqft with less monthly expenses, turnkey restaurant offering a diverse and high-demand menu including Pizza, Indian cuisine, Hakka Chinese, and Rolled Ice Cream—all under one roof. Located in a brand-new building, this business benefits from outstanding exposure directly across from two schools and a daycare, ensuring consistent foot traffic and strong community presence.
Surrounded by eight multifamily residential buildings, this prime location provides a built-in customer base with excellent growth potential. The space features a modern setup with brand-new kitchen equipment, allowing for seamless operations from day one.
Ideal for entrepreneurs looking to start their own venture or investors seeking a profitable, multi-concept food business in a rapidly growing area. Don’t miss this rare opportunity to own a versatile and well-positioned establishment.

Listing Brokerage: Prep Realty Inc.
Picture of 546 Sherwood Boulevard NW, Calgary Real Estate Listing
546 Sherwood Boulevard NW, Calgary || $1,139,000

Welcome to this stunning, meticulously maintained home in Sherwood offering nearly 4,000 sq ft of beautifully developed living space, perfectly designed for modern family living. Situated on a desirable corner lot with views of the pond and greenspace, this home blends elegance, functionality, and comfort.
The open-concept main floor showcases rich hardwood and tile flooring, a grand front entrance, and impressive floor-to-ceiling windows that flood the space with natural light. The chef-inspired kitchen features stainless steel appliances, a gas cooktop, an oversized island (56” x 87”), and a custom-built pantry. A thoughtfully designed mudroom/laundry area, stylish 2-piece powder room, and a private den with sliding French doors complete the main level. The dining area is enhanced with a built-in coffee and wine bar, while the living room offers a striking floor-to-ceiling tiled accent wall with gas fireplace and TV.
A dramatic open-to-below staircase leads to the upper level, where you’ll find a spacious bonus room with vaulted ceilings, wet bar, and Lexan glass safety guard—ideal for families with young children. The luxurious primary suite features a custom walk-through closet and spa-inspired 5-piece ensuite with soaker tub, dual vanities, and a walk-in shower. Two additional generously sized bedrooms, both with walk-in closets, and a full 4-piece bath complete the upper floor.
The fully finished basement offers even more living space with a large recreation room and wet bar, a fourth bedroom, 3-piece bathroom, and a versatile flex room.
Enjoy outdoor living in the fully landscaped and fenced yard with a large deck, perfect for entertaining. This home is pet and family-friendly and located steps from scenic pathways and greenspace.
Recent upgrades include new shingles, siding, and eavestroughs (2025), new appliances (2023), and luxurious wool carpet (2023). Complete with a double attached garage, this exceptional home truly has it all.

Listing Brokerage: Real Estate Professionals Inc.
Picture of 149 Hidden Ranch Road NW, Calgary Real Estate Listing
149 Hidden Ranch Road NW, Calgary || $569,900

Welcome to this well kept bi-level home located at a nice quiet street , and has a beautiful curb appeal. This home features 3 bedrooms, 3 bathrooms, an open concept kitchen, a dinning area, a bright living room, and a walk out basement. It also has easy access to Stony trail, Shaganappi trail, and 14 Street NW. Last but not least it is in walking distance to Hidden Valley School and the play ground nearby. Come to see this beautiful home!

Listing Brokerage: Grand Realty
Picture of 3430 50 Avenue , Red Deer Real Estate Listing
3430 50 Avenue , Red Deer || $25

High-visibility retail opportunity on Gaetz Avenue, just north of the Red Deer Resort & Casino—one of Red Deer’s busiest commercial corridors. Excellent exposure, strong traffic counts, and ample on-site parking. Features large front display windows for maximum signage and natural light. T-bar ceiling and recessed fluorescent lighting throughout. Open floor plan offers flexibility for a wide range of retail or professional uses. NNN is $11.50/sqft

Listing Brokerage: Century 21 Maximum
Picture of 274 Kingsbury View SE, Airdrie Real Estate Listing
274 Kingsbury View SE, Airdrie || $689,900

Impressively large and fully finished 2-storey offering a double attached garage, 4 bedrooms, 3 bathrooms and an excellent location—backing onto a greenspace & path, just a short walk to both Heloise Lorimer School and École des Hautes-Plaines schools. From the moment you walk in, you’re welcomed by a bright, open foyer with impressive 10-foot ceilings and a modern-looking floating staircase. The well-lit main living space is warm and inviting, featuring a fireplace and large, upgraded window package that fill the home with natural light. You’ll also notice the attention to detail throughout including bullnose granite countertops, beautiful architecture with arches, several built-ins, floor to ceiling tiled fireplace and custom crown molding & baseboards.

The kitchen is designed for both everyday living and entertaining, complete with a massive centre island layout and a convenient walkthrough pantry.

Step outside and you’ll find a backyard that truly stands out. With over $40,000 in upgrades, it features a stamped concrete patio, custom deck, mature trees, and low-maintenance astroturf. Backing onto greenspace with neighbours set far back, it’s a private setting with plenty of room to relax or host.

Upstairs, the primary bedroom offers a peaceful retreat with vaulted ceilings, a spacious 5-piece ensuite with double vanity, and a walk-in closet. You’ll also find two additional bedrooms and a large bonus room—perfect for a growing family. A bright and big laundry room with room for a sink complete the upper floor (Owner has converted this room into a salon, but could easily be converted back to a laundry room).

The fully finished basement adds even more living space with a large fourth bedroom (bedroom window may not be egress), a versatile rec room, a full bathroom and lots of storage.

Recent updates include a tankless hot water system (2023) and newer appliances (fridge, stove, and washer in 2022), giving you peace of mind.

All of this is located on a quiet street, close to shopping, restaurants, and with easy access to major routes.

This is a great opportunity to get into a move-in-ready home in one of Airdrie’s most popular communities. Reach out to your favorite Realtor to book your showing.

Listing Brokerage: RE/MAX House of 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