MLS PROPERTIES FOR SALE

Picture of 18 Sylvaire Close , Sylvan Lake Real Estate Listing
18 Sylvaire Close , Sylvan Lake || $12

Welcome to an opportunity to lease this 5,000 SF commercial property! Located in a prime location just off HWY 20 and HWY 11A, your business will be positioned in Sylvan Lake’s prime industrial zone. The 5,000 SF property includes main and upper level office spaces, kitchenettes and additional flex use space. The property is situated on 1.73 acres, the gated rear yard storage and six oversized overhead doors supports material handling and other industrial uses. Wash bay included, 16ft doors, 3 bays are 75ft length and . Lease option available. Trades accepted. NNN TBD. No storage in front.

Listing Brokerage: Maxwell Real Estate Solutions Ltd.
Picture of 229 33 Street NE, Calgary Real Estate Listing
229 33 Street NE, Calgary || $3,995

Central NE fenced storage yard available for lease that is 0.58 Acres (25,400 SF) in size. Yard dimensions are 100 feet wide by 254 deep. The yard rental is $3,995.00 gross rent per month in year 1 with annual inflation escalations. 3-5 year lease term negotiable. Site is located behind the RGO Warehouse just off Memorial drive at 229-33rd Street NE, Calgary, AB.

Listing Brokerage: CDN Global Advisors Ltd.
Picture of 5 Hummingbird Lane , Half Moon Bay Real Estate Listing
5 Hummingbird Lane , Half Moon Bay || $459,000

Exceptional Opportunity in the Highly Coveted Summer Village of Half Moon Bay, Sylvan Lake! Welcome to a rare chance to secure the last remaining lot in the serene and sought-after community of Half Moon Bay. This beautiful 65’ x 150’ parcel offers a mix of mature leafy and evergreen trees (providing year round greenery) that create natural privacy and an ideal backdrop for building your dream year-round or seasonal lakeside retreat. A pre-existing concrete pad provides added value—perfect for boats, RVs, or future development. The Summer Village of Half Moon Bay is known for its quiet, protected bay on Sylvan Lake, offering excellent conditions for water sports, boating, and endless year round enjoyment. This exceptional community features forested walking trails, easy access to the bays shoreline, permitted boat launch, and brand-new basketball and pickleball courts. Residents also enjoy a private communal beach complete with a fire pit and picnic area, along with a variety of community-run events and activities throughout the year. Conveniently located near surrounding towns, Half Moon Bay offers a peaceful, welcoming lifestyle without sacrificing accessibility. And best of all—no HOA or association fees. Seize this opportunity to build the lake life you’ve always imagined in one of Sylvan Lake’s most charming and exclusive communities. Please note cabin offer no value.

Listing Brokerage: Coldwell Banker OnTrack Realty
Picture of 9503 112 Avenue , Clairmont Real Estate Listing
9503 112 Avenue , Clairmont || $3,590,000

This cash-flowing 16-unit apartment complex generates $28,850 in gross monthly income and features eight 3-bedroom, 2.5-bath upper suites and eight 2-bedroom, 1-bath lower suites, offering a total of 15,096 sq. ft. of finished living space including the basement suites. Built in 2017, the property includes separate power meters for each unit and a common boiler providing heat and hot water for the entire complex. Ideally located just two blocks from the Lakeview Seniors Home, it offers strong potential for workforce housing in a high-demand area. The site provides 32 parking stalls in a central lot and sits adjacent to a large park and greenspace. Situated only 10 minutes north of Grande Prairie in Clairmont, the community offers a K-8 school, extensive paved trails, a skate park, splash park, and proximity to the Clairmont Industrial Park, home to hundreds of major industry service companies including Finning, Kenworth, Precision Well, Brandt, and Cummings. The complex is offered below its 2024 appraised value, and a CMHC broker has confirmed that an 85% loan-to-value mortgage may be achievable for qualified buyers with strong credit and a net worth of $750,000 or more. Seller financing is not available. A financial pro forma is available with a signed NDA, and showings will be arranged for qualified buyers! The property is fully occupied with no vacancy, and 3D tours for both upper and lower suites are included in the listing.

Listing Brokerage: Sutton Group Grande Prairie Professionals
Picture of 11 Ridgebrook Drive SW, Airdrie Real Estate Listing
11 Ridgebrook Drive SW, Airdrie || $405,000

Location, Lifestyle & Potential in the Heart of Airdrie

Welcome to this charming bungalow tucked into the established community of Ridgebrook, one of Airdrie’s most walkable neighbourhoods. Just over 1,000 sq ft, this 3-bedroom, 2-bathroom home offers a solid footprint, a finished basement, and endless potential for the buyer ready to make it their own.

The true star here is the location. Step outside and enjoy being minutes from the brand-new Airdrie Public Library, the energy of downtown/Main Street, and all the parades, festivals, and community events that make this area so special. Morning strolls, evening bike rides, or weekend picnics are effortless with Nose Creek Park just a short walk away—one of Airdrie’s most loved green spaces.

Inside, the classic bungalow layout offers comfortable main-floor living with three bedrooms and a full bath, while the finished basement provides additional living space, a second bathroom, and flexibility for a family room, home office, or guest area. The home is ready for updates and personal touches, making it an ideal opportunity for renovators, investors, or buyers looking to build equity in a prime central location.

Whether you’re dreaming of restoring its charm or re-imagining it entirely, this Ridgebrook home is your chance to live close to everything that makes Airdrie feel like 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.

© 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