MLS PROPERTIES FOR SALE

Picture of 272256 Dickson Stevenson Trail NE, Airdrie Real Estate Listing
272256 Dickson Stevenson Trail NE, Airdrie || $16,905,000

147 Acres of Prime Airdrie land for Sale. QEII frontage, highway exposure. Very accessible from highway 2, Dickson Stevenson Trail or Range Rd 10 NE. Directly adjacent to residential communities and commercial retail hub. This rare offering is one of the few remaining land development opportunities on a major highway within the City of Airdrie. Discretional Interim land uses identified by the City of Airdrie.

Listing Brokerage: LB Hubbard Realty Group
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
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