MLS PROPERTIES FOR SALE

Picture of 517A North Railway Street SE, Medicine Hat Real Estate Listing
517A North Railway Street SE, Medicine Hat || $355,000

CLEAN PHASE 2 ENVIRONMENTAL JUST COMPLETED! Unique mixed-use brick building zoned Commercial/Residential with strong live/work or income potential. Updated 2-bedroom apartment upstairs (approx. 1212 sq ft) plus a wide-open main floor (approx. 1212 sq ft) currently suited for retail/commercial—or an easy conversion opportunity for additional residential space on the main. Full basement (approx. 1168 sq ft) adds excellent storage/workshop potential.

Upper suite features 9’ ceilings, tall windows for great natural light, spacious kitchen with full appliance package, 4-piece bath, in-suite laundry, updated windows, and newer skylight. Main floor offers impressive 12’ tin ceilings and an open layout ideal for a storefront, office, studio, or future residential reconfiguration (subject to approvals). Outside you’ll find a large two-tier deck and rear off-street parking for multiple vehicles plus RV. Recent updates include resurfaced roof, modernized wiring, and plumbing. Move-in ready with flexible options: live upstairs and run a business below, rent one or both spaces, or renovate to maximize residential use.

Listing Brokerage: GRASSROOTS REALTY GROUP
Picture of 308 25 Avenue SW, Calgary Real Estate Listing
308 25 Avenue SW, Calgary || $3,650,000

Prime land assembly opportunity in sought-after Mission! Properties 306, 308, 310, and 312 – 25th Avenue SW must be purchased together, offering 100 feet of total frontage across four parcels.

Mission perfectly blends casual vibes, an uptown social scene, and outdoor living. As one of Calgary’s premier inner-city communities, it consistently attracts young professionals and families seeking a vibrant, walkable lifestyle.

Key Features:

Prime Location: Minutes from downtown along 4th Street SW, featuring local cafes, top-tier dining, boutique fitness studios, and unique shops.

Outdoor Lifestyle: Nestled along the Elbow River with direct access to Calgary’s extensive walking and cycling path network.

Builder Potential: A rare multi-parcel footprint ideal for high-density inner-city redevelopment.


Listing Brokerage: Century 21 Bamber Realty LTD.
Picture of 19, 80 Piper Drive , Red Deer Real Estate Listing
19, 80 Piper Drive , Red Deer || $204,900

Experience comfort and convenience in this inviting 3-bedroom, 2-storey end-unit condo offering over 1,200 sq ft of developed living space. Turn key easy operation with BRAND NEW furnace and hot water tank, as well as carpet and flooring in the basement bedrooms and bathrooms and some fresh flooring on the main level! Ideally located near shopping and backing onto a beautiful green space, this home blends modern upgrades with a tranquil setting. The kitchen features a spacious walk-in pantry and newer appliances, while updated flooring adds a fresh touch throughout. Relax by the cozy wood-burning fireplace in the living room or step out to your private balcony with views of mature trees. Upstairs, three generous bedrooms provide plenty of space for family or guests, complemented by a 4-piece bath and two additional half baths for busy mornings. With two powered parking stalls included, this property is an excellent choice for first-time buyers or investors seeking strong rental potential.

Listing Brokerage: Real Broker
Picture of Okotoks Real Estate Listing
Okotoks || $225,000

Big Beaver Brewing! Priced for immediate sale, Asset sale, perfect for on-site owners to increase sales, add product lines or can their own beer. Exceptional opportunity to own a fully renovated, turn-key brewery and tavern located in the heart of Okotoks. This free-standing building features a welcoming taproom, upgraded kitchen and bar, and an inviting outdoor patio—perfect for both locals and visitors alike. Recently completed renovations include interior upgrades, mechanical systems, finishes, washrooms, and patio improvements. The result is a modern, stylish space ready for immediate operation—ideal for an owner/operator or hospitality investor. Prime central Okotoks location surrounded by established retail, restaurants, and residential neighborhoods. Turn-key business with loyal clientele and strong community reputation. Excellent opportunity to expand events, food service, and retail distribution. This is a rare opportunity to acquire a complete brewery and restaurant operation with lease option. All the hard work has been done—step in and continue building on its success. Financials, equipment list, and lease/building details available to qualified buyers upon execution of a confidentiality agreement.

Listing Brokerage: Century 21 Bravo Realty
Picture of 1715 31 Avenue SW, Calgary Real Estate Listing
1715 31 Avenue SW, Calgary || $1,350,000

Click brochure link for more information. With incredible resale potential, this exceptionally located property in the sought-after Marda Loop area in Calgary is fully project-ready. With approved development permits and architectural drawings available, this 6,253 sq ft. lot has countless options including investment holding, building a custom high-end home, or renovation. With the necessities to build custom luxury, semi-detached homes, this home has great crowd-potential. Already alongside numerous other new luxury constructions, this lot already positions itself for a premium infill value. The approved plans feature 3-storey residences with approximately 2,979 sq.ft of living space above grade with a walkout basement and pneumatic elevator. The pre-designed homes include open-concept layouts, 2 large balconies, 2 offices, floor-to-ceiling windows, and detached 2-car garages. Properties like this are hidden gems in infill-rich inner-city market. Such a sizeable lot produces endless architectural potential in Mardaloop's reputation for high appreciation and upscale lifestyle amenities. Ideally positioned minutes from downtown Calgary, bus transit, schools, parks, shopping hubs, diverse cuisines, transit, and Crowchild Trait, this is a rare opportunity to secure an upscale package in a premium South Calgary community. Such a home possesses long-term value and extraordinary versatility that makes development even more effortless.

Listing Brokerage: Honestdoor Inc.
Listing data is deemed reliable but is not guaranteed accurate by CREB®. Last updated: today at 1: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