SEARCHOPERTIES


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 || $430,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
Picture of 10121, 109 Ave Street N, Grande Prairie Real Estate Listing
10121, 109 Ave Street N, Grande Prairie || $184,900

Perfect for first-time buyers, those looking to downsize, or investors seeking a smart opportunity, this charming tiny home maximizes every inch of space. it features a comfortable living area, a practical kitchen, and 2 private bedroom. The backyard provides an outdoor retreat, and its prime location puts it close to shopping and amenities—making it ideal for rental income or future redevelopment.

Listing Brokerage: Royal LePage - The Realty Group
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