RESIDENTIAL
RURAL
OPEN HOUSE on Saturday, September 19 between 1-4pm! Welcome to this brand new luxury infill in the highly desirable community of Cambrian Heights, offering over 3,250 sqft of living space including a fully finished 2 bedroom LEGAL basement suite. Situated on an OVERSIZED 33-foot-wide lot facing green space, this home stands apart from the typical narrow infills and offers a noticeably wider, more functional layout. The main floor showcases impressive 10-foot ceilings, wide-plank hardwood flooring throughout the main and upper levels, feature wall panelling, and a thoughtfully designed open-concept layout ideal for modern living. At the heart of the home is a stunning two-tone kitchen featuring a premium Bosch appliance package, extensive cabinetry, tons of storage space, and a dedicated coffee bar area. The spacious dining and living areas create an ideal setting for entertaining, while the main floor office with sleek glass wall detailing provides the perfect work-from-home space filled with natural light. Upstairs, the home continues to impress with spacious bedrooms, elegant finishes, and a functional family-friendly layout. The primary retreat offers a luxurious atmosphere with generous proportions and spa-inspired design elements, while the additional bedrooms provide flexibility for growing families or guests. The fully finished legal basement suite adds exceptional versatility and value, complete with luxury vinyl plank flooring, two additional bedrooms, a full kitchen, separate living space, and excellent income potential or multi-generational living options. Outside, the detached double garage is insulated and drywalled, and the oversized lot provides enhanced curb appeal and outdoor space rarely found with newer infill homes. Facing green space and ideally located close to schools, parks, Confederation Park, transit, downtown, and major amenities, this is a rare opportunity to own a brand new upscale home in one of Calgary’s most established inner-city communities.
Listing Brokerage: RE/MAX Complete Realty
TOP FLOOR END-CORNER LIVING IN SOUGHT-AFTER BRIDGELAND/RIVERSIDE WITH 2 BEDROOMS, SOUTH-FACING BALCONY, AND INCREDIBLE INNER-CITY CONVENIENCE! Unbeatable location just minutes to downtown, the Bow River pathways, parks, trendy cafes, restaurants, boutique shopping, transit, and the Bridgeland LRT station, offering the ultimate urban lifestyle and walkability. Bright and inviting, this 836 SQFT open-concept condo offers beautiful hardwood floors, abundant natural light, in-suite laundry, and an airy layout enhanced by its top-floor end-unit positioning. The spacious living and dining areas flow seamlessly, creating an ideal setting for everyday living or entertaining. The functional kitchen opens to the main living space, while the sunny south-facing balcony is the perfect place to relax and soak up the light. Both bedrooms are well-sized and serviced by a full 4PC bath. Includes an assigned parking stall plus a separate storage locker for added convenience. Added value awaits with upcoming building security and landscaping enhancements, including private fenced exterior access, a secured parking lot with an electric fob entry system, and upgraded sustainable landscaping designed to reduce future maintenance costs. Best of all, the special assessment for these improvements will be paid in full prior to new ownership. Perfect for a first-time buyer looking to break into the market or an investor seeking a well-located inner-city opportunity.
Listing Brokerage: Century 21 All Stars Realty Ltd.
Stop scrolling! This is the one you have been waiting for! Absolutely stunning, bright, modern, open concept semi-detached home with 4 bedrooms and 3.5 bath, all for under $550k! Welcome to 59 Howse Rise NE located in the heart of Livingston. This sleek and functional home welcomes you even before you set into the house. With a well planned out layout you have tons of sunlight pouring through your west facing rear windows and door! As you enter through the front door you are greeted by 9" ceilings and a nice spacious living area perfect for hosting guests when they come over. To your right is a cute little corner where you can set up your own home library or even a home office if you need. Further down the hall there’s yet another nook in the middle of the wide staircase where you can set up yet another office area, or decorate with a large cabinet if required. Once you step into the kitchen you will find a large island which doubles as a breakfast bar as well. Complete with a gas range and dedicated pantry you can spend your evening catching up and cooking dinner at the same time. In the back you have your own little deck with a dedicated gas line to spend you summer nights on the grill, a decent sized, fenced yard and a large gate which opens up for parking your cars, boats or RV’s! Let’s take a tour upstairs first – oh wait did I forget to mention the bonus room? Surprise! Yes, that’s right - along with 3 bedrooms (two with walk-in closets, 2 full washrooms and a laundry room you still have a cozy bonus room in the middle of it all. This is perfect for spending time as a family to enjoy movies, set up study tables so you don’t have the clutter the rooms. Imagine being able to be steps away from the kids while they are asleep and enjoying your favorite TV shows. Having the laundry on this floor is not only convenient it is a blessing! Your master retreat is at the front of the house complete with its own 3-piece ensuite and walk in closet. You have to see the toilet to fully appreciate the high ceilings and large window! Downstairs you have yet another rec area waiting for your finishing touches, another bedroom and yet another 3-piece washroom. There is tons of storage under the stairs and in the corner of this floor. Also, there is potential to convert this into a suite "subject to approval and permitting by the city/municipality". Some points to be made here - even in the basement the ceiling is 8", the whole house comes equipped with in built sprinkler systems, central air ventilation and a high efficiency furnace. The bedroom and bathroom in the basement have been developed with City permits and up to Legal Suite Code with sound proofing. The roof and siding were changed in 2025. The community hub is walking distance complete with parks, tennis courts, water parks, etc. There are bus stops nearby and the new Livingston retail space is opening with plenty of stores in a few months! All in all, this is a great unit and is waiting for viewing today!
Listing Brokerage: Golden Keys Realty
A Premier Waterfront Resort Community Investment on Buffalo Lake
Established in 2024, BARW Resort represents one of Alberta's newest and most significant recreational real estate investment opportunities. Situated on the south shore of Buffalo Lake, the resort encompasses approximately 1 kilometre of beautiful waterfront and has been thoughtfully developed as a large-scale seasonal leased-lot community designed to serve Alberta's growing demand for premium recreational ownership.
Strategically located in Central Alberta, BARW Resort is located approximately two hours from Calgary, two hours from Edmonton, and 45 minutes from Red Deer, providing convenient access to Alberta's largest population centres. The nearby Town of Stettler offers a full range of shopping, dining, healthcare, and professional services, providing year-round convenience for residents and visitors alike.
Unlike traditional campgrounds or short-term hospitality properties, BARW Resort operates as a seasonal leased-lot community, creating a recurring revenue model supported by long-term customer relationships. Families establish seasonal homes at the resort, returning year after year to enjoy lakeside living and outdoor recreation while creating lasting memories with future generations.
The resort currently features 300 developed RV sites for lease, providing substantial near-term lease-up potential. Complementing this opportunity is the potential to develop approximately 250+/- additional sites, offering investors a clearly defined pathway for future expansion and revenue growth.
From an investment perspective, BARW Resort offers a compelling combination of newly developed infrastructure, available inventory for immediate lease-up, recurring revenue potential, waterfront scarcity, and meaningful future expansion opportunities. In addition to its existing development, the property includes approximately 40 acres of undeveloped land with the potential to accommodate an estimated 200 to 300 additional RV sites, providing a substantial land bank for future growth. Few recreational real estate assets in Alberta can offer this combination of scale, location, amenities, expansion capacity, and long-term value creation.
BARW Resort is distinguished by its exceptional infrastructure and extensive amenity offering. Residents enjoy access to a comprehensive resort experience that includes:
Heated swimming pool
Waterslide
Splash park and wading pool
Pickleball court
Mini golf course
Children's playgrounds
Resort convenience store
Laundry facilities
Support and maintenance buildings
Full utility services, including city water and underground sewer infrastructure
These improvements represent a significant capital investment and create a level of quality and scale that would be difficult and expensive to replicate in today's development environment.
Buffalo Lake is one of Alberta's premier recreational destinations, offering boating, fishing, swimming and more!
Cute curb appeal, a large yard and plenty of potential! This approximately 1,000 sq. ft. home offers 3 bedrooms, a full bathroom, plus an additional office/flex room that could suit a variety of needs. The functional layout provides a great starting point for a first-time buyer, investor, or someone looking for an affordable home they can update and make their own. Outside, you’ll appreciate the generous yard with plenty of room to enjoy, along with a storage shed and convenient back alley access. Recent improvements include a new electrical panel and hot water tank. The home could benefit from some maintenance and updating, which has been reflected in the asking price, providing a great opportunity to add value and make it your own. Located in the welcoming community of Three Hills, with schools, shopping, parks, recreation facilities, an indoor pool, hospital and other amenities nearby. Whether you’re looking to get into home ownership, add to your investment portfolio, or take on a project with potential, this affordable property is worth a look!
Listing Brokerage: First Place Realty
Foothills land for sale can come in many forms, with different types of listings popping up on the market daily. While
There's a reason Okotoks real estate is in such high demand — having great communities, employing exceptional home builders and being
© 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.
