MLS PROPERTIES FOR SALE

Picture of 4812 47 Street , Consort Real Estate Listing
4812 47 Street , Consort || $3,250,000

An exceptional investment opportunity in the heart of Consort! Positioned along the high-traffic Highway 12 corridor, this turn-key ESSO gas station features an established convenience store and a fully built-out liquor store — offering three potential diversified income streams in one location. Extensively renovated with over $400,000 in upgrades since 2013, including: Double-wall fiberglass underground fuel tanks, Upgraded fuel pumps & POS system, Energy-efficient LED lighting, Surveillance system & modern roofing, Convenience store & public washrooms remodel (2019), Newly constructed liquor store with walk-in beer cooler (2020). The gas bar is branded with ESSO’s Synergy fuel, and the interior showcases a bright, organized layout designed for maximum customer flow and product exposure. A separate, professional office space supports daily operations. This is a fully modernized, owner-operated business primed for both local traffic and highway travelers. Whether you’re an investor seeking passive income or an entrepreneur ready to be hands-on, this commercial property offers long-term growth in a growing region of Alberta. Strategic highway exposure, fully upgraded and operational, multi-income stream: fuel, C-store & liquor potential. A rare chance to secure a branded fuel franchise with full ownership of land and building.

Listing Brokerage: Grassroots Realty Group
Picture of 14 Pinehurst Drive , Heritage Pointe Real Estate Listing
14 Pinehurst Drive , Heritage Pointe || $3,199,000

Welcome to this stunning executive bungalow located on one of the most coveted streets in Pinehurst, just south of Calgary and backing the Heritage Pointe Golf Course wooded area. Completely renovated from top to bottom, this exceptional residence offers over 6,200 sq. ft. of luxurious developed living space designed for both comfort and entertaining. Set on a private .86-acre treed lot, the home features an incredible outdoor oasis complete with a three-season room, accessible by acordian doors, a swim spa, and multiple spaces to relax or host gatherings surrounded by nature. Inside, the open-concept design showcases high-end finishes, soaring vaulted ceilings, and expansive windows that fill the home with natural light and frame stunning views of the professionally landscaped grounds. The chef-inspired kitchen is equipped with premium appliances, perfect for culinary enthusiasts, while the full bar on the main floor makes entertaining effortless, including a wood burning pizza oven. The walkout basement extends the living space with additional areas for recreation, wet bar, added storage, fitness, or relaxation. Also offering an oversized heated triple garage, underground sprinklers, fenced dog run, and every convenience you could ask for. Every detail has been thoughtfully crafted, creating an elegant, modern retreat that perfectly balances sophistication, warmth, and functionality—an absolute entertainer’s dream in one of the most prestigious communities south of Calgary.

Listing Brokerage: RE/MAX Landan Real Estate
Picture of 22 Royal Birch Way NW, Calgary Real Estate Listing
22 Royal Birch Way NW, Calgary || $768,000

Location, Location, Location. Welcome to this Fantastic Family Friendly home which has over 2841 square feet of Developed living space! This 4 Bedroom 3 and half Bathroom Home is the perfect home you have been searching for! The Main Floor has an Open to above entry, Open concept design, Spacious Kitchen, Living Room and dining space that looks out onto the yard where kids and pets are right at home with both green space and custom color and stamped 400 square feet concrete patio with rounded edges and exposed aggregate. It also has Stunning Herring bone Engineered Hardwood which gives this home a Luxurious feel. The Upper floor has 3 Bedrooms and 2 Full bathrooms This home also has a Developed Basement with Another Bedroom and Bathroom as well as another Family Room which is great for hosting guests. This home comes with Air-Conditioning and Humidifier and Large Hexagonal greenhouse Walking distance one minute to Royal Oak School (K-4) and walk 5 minutes to William D. Pratt School (5-9) and Tennis court, easy access to Hwy 1A, Stoney Trail, and public transit, this home combines convenience with a family friendly atmosphere. This beautifully updated a vinyl floor on basement and second floor (2025) New Samsung washer /New Samsung Dryer /New Bosch dishwasher on 2025 . The garage has been customized with extra storage space to hold more boxes and items. **BE SURE TO CHECK OUT THE 3D VIRTUAL OPEN HOUSE TOUR for a better look! Quick Possession! THIS ONE WON’T LAST LONG!**Click on the media link and schedule your private showing today!

Listing Brokerage: Skyrock
Picture of 4703 40 Avenue SW, Calgary Real Estate Listing
4703 40 Avenue SW, Calgary || $749,000

Welcome to 4703 40th Ave SW!
Perfectly situated for convenience, this home offers quick access anywhere you need to go — whether it’s a short commute to downtown or a weekend escape to the mountains. You’ll also appreciate being minutes from schools, shopping, parks, and Mount Royal University.

Inside, this move-in-ready bungalow has been thoughtfully updated from top to bottom with modern finishes and an open-concept layout. The main floor features freshly painted interiors, rich hardwood flooring, and an all-new kitchen equipped with KitchenAid stainless steel appliances, quartz countertops, ample cabinetry, and a generous island ideal for cooking and entertaining.

The main level offers three spacious bedrooms with upgraded doors. The bathroom has been completely refreshed with imported tile, a drop-in soaker tub, and contemporary designer fixtures.

The fully developed basement is bright and inviting, showcasing new engineered hardwood, fresh trim and doors, and a large family room complete with a cozy fireplace and dry bar — the perfect space for hosting or relaxing. Two additional well-sized bedrooms and a newly finished 3-piece bathroom featuring designer tile, an great sized shower, and a sleek new vanity complete the lower level.

Outside, enjoy a quiet and spacious yard with upgraded vinyl siding and added insulation panels, plus a great-sized patio for outdoor dining and entertaining.

A turnkey home in a prime location — this is the one you’ve been waiting for.

Listing Brokerage: Real Estate Professionals Inc.
Picture of 1489 Bayview Point SW, Airdrie Real Estate Listing
1489 Bayview Point SW, Airdrie || $519,900

3 BEDROOMS | 2.5 BATHROOMS | BONUS ROOM | FRONT ATTACHED GARAGE | GREAT LOCATION CLOSE TO FUTURE SCHOOL | Welcome to this beautiful and well-maintained 3-bedroom, 2.5-bathroom semi-detached home with a bonus room, nestled in the highly sought-after community of Bayview, Airdrie. Perfectly positioned on a quiet street, this modern home offers the ideal combination of comfort, functionality, and convenience — making it a perfect choice for families looking to settle in one of Airdrie’s most desirable areas.
Step inside to discover a bright and inviting open-concept layout designed for today’s lifestyle. The main floor boasts large windows that flood the space with natural light, enhancing the warmth of the modern finishes and fresh paint. The stylish kitchen features stainless steel appliances, quartz countertops, elegant cabinetry, a built-in microwave, and a spacious island — perfect for casual meals and family gatherings. The kitchen seamlessly flows into the dining area and cozy living room, creating a welcoming space for both relaxation and entertaining.
Upstairs, the spacious bonus room provides the perfect spot for a home office, kids’ play area, or family movie nights. The primary bedroom offers a private retreat with a walk-in closet and a beautifully designed 4-piece ensuite featuring dual sinks and a walk-in shower. Two additional bedrooms are ideal for children or guests, complemented by another full bath and a conveniently located laundry area. The unfinished basement, with its large window and open layout, is ready for your personal touch — whether you envision a home gym, recreation room, or additional living space.
Outside, the private backyard offers plenty of room for summer BBQs, kids’ play, or future landscaping ideas, while the front-attached garage adds everyday convenience.
Living in Bayview means enjoying a peaceful, family-oriented community with scenic canals, walking paths, playgrounds, and green spaces all around. This growing neighbourhood is known for its excellent accessibility — just minutes from shopping, dining, schools, and the upcoming new elementary school within walking distance. With quick access to Yankee Valley Boulevard, 8th Street, and the QEII Highway, commuting to Calgary or exploring Airdrie is effortless.
This home truly offers the best of both worlds — modern comfort and a prime location in a community that continues to grow and thrive. Don’t miss your opportunity to make this exceptional property your new home!

Listing Brokerage: Real Broker
Listing data is deemed reliable but is not guaranteed accurate by CREB®. Last updated: today at 3:00 a.m.

© 2025 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