MLS PROPERTIES FOR SALE

Picture of 1651 St Andrews Place NW, Calgary Real Estate Listing
1651 St Andrews Place NW, Calgary || $2,399,900

Here it is, a once in a lifetime opportunity to own a ~2,400 sqft bungalow that exemplifies the pinnacle of luxury living—flawlessly designed and masterfully built. Located in coveted St. Andrews Height situated on a large lot with stunning views of downtown Calgary, this home defines luxury while encapsulating timeless elegance, making it an absolute masterpiece. The luxurious presence of this home is instantly exemplified by the stunning curb appeal, with a truly unique modern farmhouse look, featuring stone and wood accents, all highlighted by an exposed concrete pathway leading to your grand entryway. Upon entering, your eyes are drawn to the jaw dropping 12-feet ceilings on the main level, featuring a grand 16-foot vault. The large living area is complete with an elegant venetian plastered gas fireplace and a large window showcasing your stunning downtown views! The main level of this grand residence is filled with natural light with no outdoor noise, thanks to the TRIPLE PANE ‘Tilt and Turn’ European windows. The designer kitchen encapsulates this house as an entertainer\'s dream with its stunning cabinetry featuring REAL oak cabinets, glass cabinetry, 14-foot island, and stunning paneled JennAir appliance package, perfect for any chef! Next to the kitchen you have a large dining area that features a stunning European style patio slider that provides an abundance of light and leads directly to the deck and rooftop patio, encouraging a seamless indoor/outdoor lifestyle. Stepping back inside, you have a large mudroom and a dedicated pantry room ensuring no shortage of storage. The main floor continues to wow with a central staircase, featuring a glass railing and custom oak paneling acting as the true centerpiece of this home. This level also features a dedicated laundry room and a stunning 3-piece common bathroom with a custom shower. Down the hall you are welcomed to one of TWO primary bedrooms. The first primary bedroom features a large closet and a 3-piece bathroom with a custom-built shower and heated flooring. Moving to the second primary bedroom the wow factor continues with a custom walk-in closet, a stunning 5-piece bathroom, with dual vanities, a free-standing tub, heated flooring, a large custom shower, and a stunning chandelier over the tub. This room also includes a lookout patio – perfect for that morning coffee! The main level is complete with a third bedroom, making this home perfect for families of all sizes. Like the main floor, the basement of this home is an entertainer\'s dream! Starting with the open Rec Room featuring a large entertainment unit and a large wet bar. The lower level is complete with 2 additional bedrooms and a 4-piece bathroom. The fully finished triple car garage features a roof top patio, transforming the backyard into an oasis, perfect for hosting. This home had no item overlooked and comes with new home warranty to put your mind at ease. Luxury, Functionality, Location and Unbeatable Value!

Listing Brokerage: The Real Estate District
Picture of 105, 20 Sage Hill Walk NW, Calgary Real Estate Listing
105, 20 Sage Hill Walk NW, Calgary || $279,000

HUGE PRICE REDUCTION FOR QUICK SALE. LOCATION! LOCATION! LOCATION + 2 PARKING STALLS FOR HE AND SHE. There is also a large storage in the parkade to store your winter or summer tires. Look no further....this is the best deal and an excellent value for the price. Loads of upgrades. There are 2 bedrooms with luxury vinyl plank throughout. No more carpets to clean, say goodbye to carpet cleaning. Bright and open floorplan featuring modern finishes throughout. White kitchen cabinetry, chimney hoodfan with quartz countertops in both the kitchen and bathroom with luxury walk-in shower and upgraded tiles. Conveniently located within walking distance to all the major shops in Sage Hill, including T&T Supermarket, Walmart, restaurants and walking/bike paths. Immediate possession is available for investors or for first time homebuyers.

Listing Brokerage: Grand Realty
Picture of 2, 2660 22 Street , Red Deer Real Estate Listing
2, 2660 22 Street , Red Deer || $3,800,000

**The site is permit-ready for the development of 77 townhomes with full construction plans and a development permit in place** Multifamily Development Land! 4.35 acres (3.91 net developable) zoned R2 (med. density), this is a prime location in the City of Red Deer! The Red Deer market is in need of two things; affordable housing and new rental accommodation, this site can serve one or both of these categories. Well located in S.E. Red Deer in a new growth area that provides all essential services, schools, shopping, trail systems, and the largest recreation center in Red Deer. This is an area where people prefer to live.

Listing Brokerage: Royal Lepage Network Realty Corp.
Picture of 8305 18 Avenue , Coleman Real Estate Listing
8305 18 Avenue , Coleman || $749,000

EXCEPTIONAL new mountain home under construction in Crowsnest Pass with an approved secondary suite. 3 bedrooms and 2.5 bathrooms above, as well as 1 bedroom/one bathroom in the lower-level apartment. Open floor plan with high ceiling in the living areas to take advantage of big windows and majestic mountain views. Very high-quality construction with impeccable attention to detail throughout the entire building process. Modern kitchen with quartz counters. This home is finished top to bottom. Two laundry areas. Each floor has its own heating/cooling controls. Outstanding appliance package. The purchase price includes GST. Crowsnest Pass is a vibrant, active community close to Castle Mountain and Fernie Ski resorts, incredible Nordic ski facilities, and hundreds of miles of backcountry adventures.

Listing Brokerage: ROYAL LEPAGE SOUTH COUNTRY - Crowsnest Pass
Picture of 40507 Range Road 12  , Bentley Real Estate Listing
40507 Range Road 12 , Bentley || $4,400,000

139.34 Acres of prime farmland with Custom Log Home & Versatile (Potato) Farm Site

This 139.34-acre property combines 120 acres of prime cultivated land with an exceptionally well-built custom log home and a fully equipped farm site. A private, tree-lined paved driveway leads to the impressive 3,291 sq. ft. log home, designed with character.

The home features 7 bedrooms and 3.5 bathrooms across two spacious levels. The living room is a standout feature, with a striking central (gas)fireplace, and expansive windows that flood the space with natural light while offering beautiful views of the property. The kitchen is well designed with large amounts of counter space, custom cabinetry, and a large pantry. The attached dining area is perfect for large gatherings.

The primary bedroom includes a walk-in closet and a large ensuite bathroom with a shower, (jacuzzi) tub and more views of the incredible property. The home’s lower level is fully developed, with a large family room, 4 additional bedrooms, ample storage, and another (gas)fireplace, creating a cozy atmosphere. A semi wrap-around deck with a hot tub, a fire pit area, and a children’s play center complete the outdoor living space, making it ideal for relaxation and entertaining.

Additional structures include an oversized double attached garage and a 48\' x 28\' triple detached garage with workspace and a spacious loft, with lots of room for vehicles, equipment, and storage.

A separate sewer and water system from a previous mobile home setup allows for guest or employee accommodations, with space for a large trailer.

Farm Infrastructure
The farm site was historically used for seed potato production but adaptable for fertilizer storage/distribution, oil field services, or trucking operations, just to name a few. With a completely separate entrance from the residence, the site includes:

6,000 tons of potato storage facility (160\' x 275\') with office space, staff room, washroom, and a semi-trailer loading dock (~28,000 sq. ft.)
62\' x 120\' heated and insulated workshop with three overhead doors
120\' x 76\' fully metal-clad pole barn with a dirt/gravel floor
Grain storage: One 20,000-bushel bin, two 4,000-bushel bins, two 5,000-bushel bins, and two 5,500-bushel bins, all on hopper bottoms
20,000-gallon water storage tank
This is a reat opportunity to own a well-established and fully equipped farm operation while enjoying the comfort of a custom-built log home. Whether you’re looking to expand your agricultural business or establish a versatile rural operation, this property offers endless possibilities.

Legal land description: SW-35-40-1-W5

Listing Brokerage: Real Estate Centre - Coaldale
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