MLS PROPERTIES FOR SALE

Picture of 21 Erlam Street , McLennan Real Estate Listing
21 Erlam Street , McLennan || $215,000

Welcome to this beautiful 5-bedroom, 2.5-bathroom home set on 4.58 acres in the charming town of McLennan, Alberta. Offering the perfect balance of small-town convenience and the peacefulness of acreage living. Step inside to a bright, modern, and inviting open-concept design where the kitchen and living room flow seamlessly together, creating an ideal space for entertaining or simply enjoying time with family. The kitchen is a chef’s dream, featuring abundant cabinetry, generous countertop space, stainless steel appliances, and a corner pantry. Meanwhile, sliding patio doors from the living area open onto the deck, allowing for effortless indoor-outdoor living. The main floor features three comfortable bedrooms, a luxury 4-piece bathroom with a large walk-in tiled shower and deep soaker tub, a convenient laundry room, and a 2-piece guest bath. Downstairs, a spacious rec room provides endless possibilities for relaxation or recreation, along with two additional bedrooms and another full 4-piece bathroom. A large mudroom keeps everything organized, and a wheelchair ramp ensures accessibility for all. The double attached garage offers secure parking and storage, while the maintenance-free metal roof delivers lasting durability and peace of mind. Outside, the sprawling 4.58-acre property is a private haven, perfect for gardening, kids to play, or simply soaking in the beauty of nature. This is a rare opportunity to experience the best of both worlds. Book your viewing today and make this beautiful acreage your forever home!

Listing Brokerage: Sutton Group Grande Prairie Professionals
Picture of 2824 Parkdale Boulevard NW, Calgary Real Estate Listing
2824 Parkdale Boulevard NW, Calgary || $740,000

Exceptional Riverfront Property in West Hillhurst – Endless Potential! Location, Location, Location! This rare gem offers over 100 feet of prime riverfront frontage when purchased together with 2820 Parkdale Blvd. Boasting the newly approved R-CG zoning, the development possibilities are truly limitless! Situated in the highly coveted inner-city community of West Hillhurst, this property is perfectly positioned to maximize both convenience and lifestyle. Just minutes from downtown Calgary, you\'ll have easy access to the vibrant shops and restaurants of Kensington, Foothills Hospital, the University of Calgary, and the stunning Bow River pathway – ideal for biking, walking, or simply enjoying nature. The charming home currently features three spacious bedrooms and two full bath, making it a perfect investment property until you\'re ready to bring your development vision to life. Don\'t miss this incredible opportunity to own a piece of Calgary\'s future! Act fast – properties like this don\'t come around often!

Listing Brokerage: RE/MAX Real Estate (Mountain View)
Picture of 664 29 Avenue NW, Calgary Real Estate Listing
664 29 Avenue NW, Calgary || $2,150,000

Unprecedented location siding & backing onto picturesque Confederation Park! This gracious 3+1 bedroom home with FULLY DEVELOPED WALK-OUT BASEMENT underwent a “to the studs” renovation in 2015 & exudes elegance. The open & airy main level is adorned with hardwood floors, showcasing a living room with beamed vaulted ceiling with skylights & feature fireplace. The spacious dining area with brick feature wall & built-in Sub-Zero wine fridge has ample space to host friends & family. The kitchen is discerningly finished with granite counter tops, island/eating bar, plenty of storage space & top of the line stainless steel appliances. A bright private office with built-ins is tucked away just off the foyer & a 2 piece powder room & convenient mudroom complete the main level. The second level with hardwood floors hosts 3 generously sized bedrooms, a 4 piece bath & laundry room equipped with sink & storage. The primary retreat boasts a walk-in closet with in-floor heat & private 4 piece ensuite also with heated floors, dual sinks & oversized shower. The walk-out basement with in-floor heat has access to the patio & is the perfect space for game or movie night, featuring a huge family room with home theatre system plus a games/recreation area complete with pool table & bar area with Kegerator & wine fridge. A fourth bedroom & 4 piece bath with relaxing steam shower are the finishing touches to the basement. Other notable features include dual central air conditioning units, dual high efficiency furnaces (2022), 2 hot water heaters, wired for sound/video, Hunter Douglas blinds throughout & 2 open to below features from second to main level. Outside, enjoy the tranquil Duradeck covered main floor deck with beautiful views of the park & lower patio with paving stones surrounded by Kayu Batu fencing. Parking is a breeze with a double attached garage with heated floor. The premier location can’t be beat, steps from the park with access to walking/biking paths, a ball diamond, tennis courts, golf course & also close to schools, shopping & public transit.

Listing Brokerage: RE/MAX First
Picture of 30 Cranbrook Villas SE, Calgary Real Estate Listing
30 Cranbrook Villas SE, Calgary || $609,000

Discover Your Dream Home with a Million-Dollar View in Cranston\'s Riverstone

This stunning single-level, open-concept townhouse offers unparalleled luxury living. Boasting 3 spacious bedrooms and 2 beautifully upgraded bathrooms—complete with premium, newly installed toilets. This home provides both comfort and style.

With a double attached garage, versatile flex space, and a massive private balcony, you\'ll be captivated by the panoramic views that stretch across the landscape, offering a truly breathtaking experience. Whether you’re enjoying the sunrise with your morning coffee or unwinding in the evening, the views are sure to impress.

Equipped with air conditioning—essential for Calgary’s summer months—this home provides year-round comfort. Just minutes from the Bow River, enjoy world-class trout fishing, scenic trails, and direct access to Fish Creek Park, perfect for outdoor enthusiasts.

Set in the exclusive Riverstone community, this is a place where luxury meets convenience. A true lock-and-leave lifestyle, offering peace of mind without lifting a finger. Enjoy the serenity and tranquility of rural living, all while being just minutes from the city. Plus, with an abundance of wildlife to observe, every day here feels like a retreat.

Come see why Riverstone in Cranston is the perfect place to call home.

Listing Brokerage: Real Broker
Picture of 2820 Parkdale Boulevard NW, Calgary Real Estate Listing
2820 Parkdale Boulevard NW, Calgary || $740,000

Exceptional Riverfront Property in West Hillhurst – Endless Potential! Location, Location, Location! This rare gem offers over 100 feet of prime riverfront frontage when purchased together with 2824 Parkdale Blvd. Boasting the newly approved R-CG zoning, the development possibilities are truly limitless! Situated in the highly coveted inner-city community of West Hillhurst, this property is perfectly positioned to maximize both convenience and lifestyle. Just minutes from downtown Calgary, you\'ll have easy access to the vibrant shops and restaurants of Kensington, Foothills Hospital, the University of Calgary, and the stunning Bow River pathway – ideal for biking, walking, or simply enjoying nature. The charming home currently features two spacious bedrooms and a full bath, making it a perfect investment property until you\'re ready to bring your development vision to life. Don\'t miss this incredible opportunity to own a piece of Calgary\'s future! Act fast – properties like this don\'t come around often!

Listing Brokerage: RE/MAX Real Estate (Mountain View)
Listing data is deemed reliable but is not guaranteed accurate by CREB®. Last updated: today at 3:00 a.m.

© 2025 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