SEARCHOPERTIES


Picture of 5119 49 Street , Consort Real Estate Listing
5119 49 Street , Consort || $74,900

Welcome to this well-maintained mobile home on a massive 8,600 sq ft lot in the quiet community of Consort, AB. This property is move-in ready with many recent upgrades, including a brand new metal roof and stylish interior updates throughout. Enjoy summer evenings on the spacious front porch or entertain guests on the rear deck. The added front mudroom offers extra convenience and storage. A large shed in the backyard provides plenty of room for your tools and outdoor gear. Best of all, you own the land—no lot rent or condo fees! Whether you\'re looking for a first home, investment property, or affordable living with space to grow, this one is a must-see.

Listing Brokerage: Real Broker
Picture of G9, 5550 45 Street W, Red Deer Real Estate Listing
G9, 5550 45 Street W, Red Deer || $495,000

NOW is the Time to Own your own Condo Unit to SHOWCASE your BUSINESS in the Vibrant Capstone Area with new businesses and a New Condo Apartment complex opening soon.~ This is the Sale of Condo Unit #9 in building \"G\" located in the Cronquist Business Park ( Capstone at Riverlands ) .The exterior fascia of Building G recently updated. This bay features a Customer Reception Area ( Air Conditioned ) ., a large warehouse area with a 10\' x 12 \' Overhead Door. There are 2 Designated Customer parking spots and other guest parking at the front along with staff parking at rear of building. . Now is the time to Own your your own Condo unit to showcase your business, or to purchase as an Investment property. 2,538 square feet of Space plus a Mezzanine for storage of 360 sq.ft ( 23\'3\"\' x 15\'6\") .

Listing Brokerage: Maxwell Real Estate Solutions Ltd.
Picture of 1661 St Andrews Place NW, Calgary Real Estate Listing
1661 St Andrews Place NW, Calgary || $2,850,000

This stunning inner-city bungalow, situated on a 0.26-acre lot at the top of a hill, was designed by Hallett Architects. The property is surrounded by parks and green spaces, offering unparalleled privacy and breathtaking views. The current owner has invested significant time and money in improvements and transformations, resulting in one of the best curb appeals in the community.
Two major improvements were made in 2016 and 2017, which are highlighted below:
In 2016, the house underwent a complete redesign and upgrade. Exterior enhancements included a remodeled triple garage, stone siding, a high-end wooden front door, and repainted Hardy board siding. Inside, the floor plan and layout were reimagined, featuring a new kitchen with high-end stainless steel appliances, luxury wooden cabinets, a large island, a natural stone fireplace wall, and brand-new, high-end lighting fixtures. The entire basement was finished, adding a wine room, tea room, en-suite bedrooms, and a karaoke room with a bar.
In 2017, the property was further enhanced with new landscaping and the addition of an extraordinary pavilion made of timber and stone, designed for year-round use. The front yard was redeveloped with low-maintenance stone and a powder-coated aluminum fence, giving the home a stylish and impressive appearance in the neighborhood.
There are many more details to explore on-site. Please schedule a showing today to see this exceptional property for yourself.

Listing Brokerage: CIR Realty
Picture of 533 Baywater Manor SW, Airdrie Real Estate Listing
533 Baywater Manor SW, Airdrie || $728,900

Welcome to the Jordan by Genesis Builder Group, a beautifully crafted single-family home nestled in the vibrant Bayside community. This thoughtfully designed residence offers 3 spacious bedrooms and 2.5 bathrooms. The home features a striking Craftsman elevation and a side entry that enhances its curb appeal. Inside, you’ll find a loaded kitchen with high cabinets and a walk-in pantry, ideal for culinary enthusiasts, while the cozy fireplace in the great room creates a warm and inviting atmosphere. Architectural highlights include tray ceilings in the master bedroom and in the loft, adding character and dimension to the living spaces. Two walk-in closets offer ample storage, and a 12’ x 10’ deck provides the perfect spot for outdoor dining or relaxation. Additional features such as elegant railings, gas line connections, and a spacious garage make this home as practical as it is beautiful. The Jordan is designed to meet your every need with comfort and style. Photos are representative.

Listing Brokerage: Bode Platform Inc.
Picture of 432 Whiteland Drive NE, Calgary Real Estate Listing
432 Whiteland Drive NE, Calgary || $629,900

Welcome to 432 Whiteland Drive NE, a fully renovated gem where modern elegance meets classic charm in a sought-after neighborhood. Situated on a spacious north-facing lot with back alley access, this home offers both style and convenience. Step into a bright and inviting living room featuring a stunning feature wall with an electric fireplace, complemented by luxury vinyl plank flooring and sleek pot lights throughout. The main level boasts a beautifully designed U-shaped High gloss kitchen with quartz countertops and brand-new stainless steel appliances which are on order, offering both functionality and sophistication. The spacious dining area is perfect for gatherings, while three generously sized bedrooms with new vinyl windows provide ample natural light and comfort, and a full bathroom with a standing shower. A separate entrance leads to a two-bedroom illegal basement suite, complete with its Separate kitchen, living area, full bathroom with standing shower, and separate laundry. New Hot water tank, New vinyl windows. Enjoy a private south-facing backyard, a deck perfect for outdoor entertaining, and a double detached garage with convenient back alley access. Located in a prime area, this home is just minutes from shopping centers, schools, playgrounds, and public transit services, ensuring easy commuting and access to everyday essentials. Don’t miss out on this incredible opportunity—schedule your viewing today!

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