SEARCHOPERTIES


Picture of 1-8, 4504 56A Avenue , Lloydminster Real Estate Listing
1-8, 4504 56A Avenue , Lloydminster || $949,900

This 8-suite apartment rental building is just the opportunity you have been looking for. There are 5 (2 bedroom) units and 3 (1 bedroom) unit in the building. This building has been well maintained over the years with improvements and upgrades to the heating system, added insulation in attic space, PVC windows, metal roofing- three suites have been renovated over the last few years, with one suite undergoing an entire makeover in the last 2 years. The building has two units that have been rented as Airbnb short term rentals with the balance of the units rented on monthly rental agreement. This is a well-managed building with great potential.

Listing Brokerage: MUSGRAVE AGENCIES
Picture of 4704 Marbury Place NE, Calgary Real Estate Listing
4704 Marbury Place NE, Calgary || $648,000

Welcome to this truly unique detached 5-LEVEL SPLIT HOME with just under 3000sqft of living space, located in the established community of Marlborough, set on an impressive 9117 sq ft pie-shaped lot—a rare find in the area! This property features two developed lower levels offering exceptional fully usable space; no crawl space here! With 6 bedrooms in total, the layout is ideal for large families, multi-generational living, or rental potential, featuring 3 spacious bedrooms and a 5-piece bathroom with dual vanities on the top level, an additional main-floor bedroom that was converted from the former attached garage, is the perfect spot for a home office, gym, or children’s playroom, and two more bedrooms across the lower levels. The main floor boasts an updated kitchen with granite countertops, stainless steel appliances, a spacious corner pantry, and ample cabinetry, opening to a large breakfast nook and flowing into a cozy living and dining room, perfect for everyday living and hosting gatherings. The second level offers a bright, sun-filled great room with expansive windows, creating an inviting space to relax. Outside, enjoy the massive backyard complete with an oversized insulated detached garage with 220V wiring, ideal for a workshop or hobbyist, plus added peace of mind with central air conditioning, newer furnace and hot water tank—making this standout property a must-see! Living in Marlborough offers the perfect balance of convenience and community in Calgary’s northeast. This well-established neighborhood is known for its mature trees, large lots, and family-friendly atmosphere, with excellent access to schools, parks, shopping, public transit, and major roadways including Memorial Drive and Stoney Trail. Residents enjoy nearby amenities such as Marlborough Mall, local shops, recreation centres, and green spaces, making daily errands and commuting easy while still benefiting from the charm of a long-standing, welcoming community!

Listing Brokerage: eXp Realty
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