MLS PROPERTIES FOR SALE

Picture of 4806 49 Avenue , Rochester Real Estate Listing
4806 49 Avenue , Rochester || $189,900

Located in the quiet hamlet of Rochester, only 30 minutes south of Athabasca and an hour north of St. Albert, this updated home sits on half an acre, the largest lot in the community, without the demands of rural acreage life. The living room opens to a deck with an unobstructed view of the treed valley. It is the kind of view that makes you stop and just sit for a while. Inside, the kitchen has been thoughtfully updated with quartz countertops, a large island with a breakfast bar and sink, and a commercial stainless steel fridge that stays with the property, ideal for anyone who hunts and likes to process their own meat. Two bedrooms plus a dedicated office, and a full bathroom with a custom walk-in shower. Major systems like windows, furnace, hot water tank, roof insulation and exterior, have all been updated; some within the last 10 years. Crawlspace provides utility access and storage. The half-acre lot (200x120) has a garden area and room to build a garage. Municipal sewer. Cistern water supply. Rochester has a seniors centre and community hall, a lot of heart for such a small community. If you want the feel of country living without the acreage workload, this is worth a look.

Listing Brokerage: Royal LePage Premier Real Estate
Picture of Calgary Real Estate Listing
Calgary || $69,999

Exceptional opportunity to acquire the business assets of an established retail operation in a highly visible, high-traffic location. This approximately 400 sq. ft. retail space has been tastefully renovated with modern finishes and features extensive display shelving, creating an attractive and functional environment for showcasing products and serving customers as the business is currently a Hookah and accessories store.
Located on busy 14 Street SW, the business benefits from excellent exposure to thousands of passing vehicles and pedestrians daily, while being just minutes from the popular 17 Avenue SW entertainment and shopping district. The location is easy to access and well-positioned to attract both local and destination customers.
With affordable occupancy costs of approximately $2,650 per month, including operating costs, this is an ideal opportunity for an owner-operator or entrepreneur seeking a turnkey retail space with minimal overhead. There is also potential to expand product offerings through electronic vape sales, subject to landlord approval and applicable regulations.
A rare opportunity to acquire a well-presented retail space in a sought-after central location with strong visibility and growth potential.

Listing Brokerage: Century 21 Bravo Realty
Picture of 509 2 Avenue N, Vauxhall Real Estate Listing
509 2 Avenue N, Vauxhall || $97,000

Commercial building down town Vauxhall set up for office space including front reception area and 4 individual offices. in the back of the building you will find storage area.

Listing Brokerage: Century 21 Foothills South Real Estate
Picture of 629 Mandalay Link , Carstairs Real Estate Listing
629 Mandalay Link , Carstairs || $729,900

This stunning, brand-new build by MARYGOLD HOMES offers over 2,400 sq. ft. of thoughtfully designed living space & comes complete with an attached TRIPLE-CAR GARAGE. Located in the desirable community of Mandalay Estates, this beautifully crafted 2-storey home is just minutes from the Community Golf Course, Memorial Arena, Hugh Sutherland School, & within walking distance to both SHOPPERS DRUG MART & the LOBLAWS grocery store conveniently located within the subdivision. The durable HARDIE-BOARD exterior provides both exceptional curb appeal & long-lasting quality & inside, you'll appreciate the functional layout designed for everyday living. Convenient garage access is provided through a spacious mudroom with built-in storage, leading directly into the kitchen via a WALK-THROUGH PANTRY. The chef-inspired kitchen is the heart of the home, featuring a large central island with storage on both sides, bar-style seating, STAINLESS STEEL KITCHEN APPLIANCES, soft-close shaker cabinetry with pull-out drawers, quartz countertops, & a custom hood fan canopy. The kitchen flows seamlessly into the dining area, where sliding patio doors lead to the large rear deck, complete with a gas line for effortless outdoor entertaining & summer barbecues. And adjacent to the dining area, the inviting living room is anchored by a beautiful tile-surround gas fireplace, creating a warm & welcoming space for everyday living & gatherings with family & friends. A versatile den/office on the main level provides the perfect space for working from home, studying, or creating a private retreat. Large windows throughout the home fill the space with natural light, while luxury vinyl plank flooring on the main level & plush carpet on the upper level provide the perfect blend of style & comfort. Upstairs, the spacious primary suite offers large windows, a walk-in closet with custom shelving, & a beautiful 5-piece ensuite featuring dual sinks, a separate water closet, & a shower with a built-in bench. Two additional generously sized bedrooms, a full bathroom, & a central bonus room provide plenty of space for the whole family. The layout is thoughtfully designed to keep the primary bedroom nicely separated from the secondary bedrooms, providing added privacy & a quiet retreat. The upper-level laundry room completes the upper-level layout & adds everyday convenience & features built-in cabinetry, a utility sink, & a window that fills the space with natural light. The unfinished basement includes rough-ins for a future bathroom & 9-ft. ceilings, offering excellent potential for future development & the flexibility to customize the space to suit a growing family's needs. Don't miss the opportunity to make this exceptional home your very own! **Photos shown are from similar/previous projects & are for reference only. Exterior rendering is also only for illustrative purposes.**

Listing Brokerage: Quest Realty
Picture of 103 2nd Avenue W, Marsden Real Estate Listing
103 2nd Avenue W, Marsden || $310,000

*New shingles, Deck railing & stairs installed July 2026* Located in the quiet, family-friendly community of Marsden, this spacious 2004 bungalow offers 1,613 sq. ft. of living space per level and a functional open-concept layout. The main floor features a bright front family room, a dedicated dining area, and a well-equipped kitchen with a central island, ample cabinetry, and beautiful stainless steel appliances. Three bedrooms, a 4-piece main bathroom, convenient main-floor laundry with a 2-piece bath, and a primary bedroom with its own ensuite complete this level. The fully finished basement is perfect for entertaining, boasting a large family room with a wet bar, two generous bedrooms, a 3-piece bathroom, and two separate storage rooms, including a cold room. The home also includes a reverse osmosis water filtration system that delivers high-quality water throughout. Offering impressive space, comfort, and value, this Marsden bungalow is truly a must-see!

Listing Brokerage: RE/MAX OF LLOYDMINSTER
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