MLS PROPERTIES FOR SALE

Picture of Unit 2, 7003 199 Street NW, Edmonton Real Estate Listing
Unit 2, 7003 199 Street NW, Edmonton || $2,475,000

HUGE OPPORTUNITY to build and own an ideally-sized commercial building on a high-visibility location supported by an upscale local draw area. PLUS REALIZE HUGE SAVINGS in construction and long-term operational costs! ONLY THREE PARCELS in this rare 2-acre bare land commercial condominium project, featuring a huge 1.1 acre common area with enough parking, green space and waste locations to fulfill any DP requirements. The small self-governed condo structure makes for huge savings in land acquisition, construction, and maintenance costs PLUS saves on management expenses while ensuring hands-on control. YOUR PURCHASE IS NOT JUST THE TITLED LAND - you also become 1/3 owner of the entire condo corp including the common property AND all related assets! Perfect for small / mid- scale developers & built-to-suit owners. BUILD OUT POTENTIAL - This parcel fits an 11,000+ sq.ft floor plate, and height allowance of 16m making the build-out potential huge! Build-out of 42,500 to 55,000 sq.ft over 4-5 floors. Buildable footprint is perfect for professional / medical firms, service centres, childcare, pharmacy, health centre & more. Potential for at-grade local retail due to build area size & shape (with zoning). The lot has another 4,200 sq.ft of outdoor space for amenities. THE VALUE IS HUGE - An equivalent standalone infill site would need an acre and a quarter of land plus the cost of demolition, parking, access, and waste mgmt. NOT REQUIRED HERE! With 70 existing stalls plus area area for 30 more, AND major property setbacks largely in the huge common area, this is a turn-key build-out site with huge capital investment savings. THE LOCATION IS VERY RARE - located between Anthony Henday and 199th ST in west Edmonton\'s fully developed & semi-affluent Glastonbury area, there are 40,000 high-income people within 2km - and limited commercial to support them. This makes STRONG LOCAL DEMAND. Public transit is adjacent with a major ETS transportation hub nearby. Current zoning is UF with 16m height allowance which aligns closely to BE (Business Employment) and CG (Commercial General) in height / location requirements making for great development flexibility. ONLY 2 PARCELS AVAILABLE, the 3rd already occupied by a church building. THIS LISTING - Unit 2: Effective size of 1.25 acres (see below info). ALSO AVAILABLE: MLS A2313155 - Effective size of 0.47 acres (see below info) and build- out potential for 9,500 to 12,800 sq.ft. CAPTURE UNPARALLELED ROI - Take advantage of a build-site specifically designed to optimize building footprint and maximize investment / operational value! MORE MATERIALS AVAILABLE ON REQUEST. PLEASE DO NOT VISIT THE PROJECT WITHOUT AGENT PRE-APPROVAL. NOTE: Unscheduled site visits may result in a security response. Lot area note: Title area 0.14 acres + ownership in 1.1 acre common. As instructed by CREB, total lot size includes parcel plus typical parking /related common area to support 4 stories of commercial.

Listing Brokerage: CIR Realty
Picture of 704 Stonehaven Drive , Carstairs Real Estate Listing
704 Stonehaven Drive , Carstairs || $589,000

Welcome to this beautifully maintained home backing onto the 17th fairway of the Carstairs Golf Course, with picturesque pond views and a fountain right out front. Built by the reputable Gold Seal Homes, this property features thoughtful custom details that set it apart from typical cookie-cutter homes.
Pride of ownership is evident throughout, and the home shows like new thanks to the exceptional care it has received.
The covered front deck provides the perfect place to relax and enjoy the peaceful pond view. Step inside to a bright and spacious open-concept main floor designed for comfortable everyday living and entertaining.
The inviting living room features large windows and a cozy gas fireplace, creating a warm atmosphere for cooler evenings. The dining area flows seamlessly into the kitchen, which boasts upgraded appliances including a gas range, built-in microwave, and additional modern finishes.
From the kitchen and dining area, step out onto the back deck overlooking the fenced backyard and golf course, an ideal space for outdoor dining and relaxing while taking in the beautiful surroundings.
A clever walk-through mudroom with powder room connects the kitchen to the garage, offering practical storage and functionality, while an additional garage entry is conveniently located off the front foyer. The extended-length and heated garage provides extra space for a workshop or storage area.
Upstairs, the spacious primary bedroom retreat features a well-appointed ensuite with separate vanities, a full bathtub, and a large tiled shower. Enjoy that barrel ceiling which makes the room unique. To the left of the staircase is a bright bonus room with golf course views and vaulted ceiling, perfect for a family room, office, or play area.
This level also offers three additional generously sized bedrooms, a full bathroom, and convenient upstairs laundry.
The unfinished basement is already framed for a future bedroom and bathroom, giving you the opportunity to easily expand the living space to suit your needs.
Located in a quiet neighborhood in the fast-growing town of Carstairs, this lovely home offers scenic views, thoughtful design, and exceptional value. You’ll definitely want to see this one in person.

Listing Brokerage: Quest Realty
Picture of 105 Cunningham Crescent , Red Deer Real Estate Listing
105 Cunningham Crescent , Red Deer || $499,900

~~A HIGHLY SOUGHT AFTER SOUTH RED DEER LOCATION~ Completely renovated from top to bottom, this stunning home offers a perfect blend of modern style, comfort and functionality for todays family lifestyle. Step inside and be immediately IMPRESSED by the bright OPEN- CONCEPT DESIGN, highlighted by LARGE windows that flood the space with natural light and showcase the sunny west facing back yard. The main floor features gorgeous new laminate flooring throughout, a stunning feature wall in the living room, QUARTZ COUNTERTOPS and a full set of brand-new stainless appliances that elevate the beautifully designed kitchen. The main floor offers three spacious bedrooms, including a lovely primary retreat complete with a private three-piece ensuite and built in cabinetry in the closets for exceptional organization and storage, convenient stackable MAIN FLOOR LAUNDRY and everyday EASE. DOWNSTAIRS the FULLY DEVELOPED BASEMENT provides outstanding additional living space with two generous size bedrooms, a three-piece bathroom, SEPARATE LAUNDRY, and a spacious family room complete with a sink and fridge, as well EAT UP PENINSULA an ideal set up for teenagers or guests. A brand-new HOT WATER TANK AND FURNACE offers added peace of mind for years to come. Outside the IMPRESSIVE backyard is designed for both relaxation and functionality. Enjoy the spacious deck, charming THREE SEASON SUNROOM off the rear entrance, garden shed, and a massive 20x24 HEATED GARAGE perfect for parking, projects or extra storage. EXTRA LONG PAVED DRIVEWAY can accommodate your RV!!!! LOCATED IN ONE OF RED DEERS MOST BEAUTIFUL NEIGHBOURHOOD\'S, this MOVE IN READY 5 BEDROOM HOME combines STYLE, SPACE and VERSATILITY in and EXCEPTIONAL SETTING. A rare opportunity you WON’T WANT TO MISS!

Listing Brokerage: RE/MAX real estate central alberta
Picture of 304 Windrow Crescent SW, Airdrie Real Estate Listing
304 Windrow Crescent SW, Airdrie || $600,000

**OPEN HOUSE Saturday June 13 11-1:30 & Sunday June 14 12-2pm** Welcome to the best location for your family in Airdrie! Just a short walk to the New SW Rec Center that starts construction next year, and an equally short walk to the new K-9 School & High Schools being built in Southwinds! From the outside you\'ll notice the SECOND LEVEL BALCONY, and the GEMSTONE LIGHTING. As you enter you\'ll come to the wide open main level. The SOUTH FACING BACKYARD windows bring in a ton of light into this main level. The living room is very large and able to fit any furniture you have. The kitchen features GRANITE COUNTERTOPS, lots of cabinet space, and stainless steel appliances. Moving upstairs you\'ll find 4 UPPER BEDROOMS. The Master bedroom measures 18\' long! Lots of room in here, plus a walk-in closet and 4 Piece En-Suite Bathroom. Bedrooms 2 & 3 are both great size for kids, rooms, office space, or guests. The 4th bedroom is currently being used as a BONUS ROOM and features the 2nd Level Balcony out the front of the home. On the balcony you\'ll notice the gemstone lights & frosted glass railings for privacy. The basement is unfinished but has some flooring loosely laid down to be more comfortable and is wide open to use as you wish. Out back you\'ll love the South Facing Backyard with full sun at all hours of the day. Back here\'s you\'ll find a stone patio, garden beds lining the fences, and lots of grass space. Book your showing today!

Listing Brokerage: Real Broker
Picture of 6751 34 Avenue NE, Calgary Real Estate Listing
6751 34 Avenue NE, Calgary || $634,900

Beautifully renovated 3-bedroom bungalow located in the welcoming community of Temple, offering Tremendous Value and Potential to be suited (Pending City Permits and Approvals). Lovingly cared for and meticulously maintained over the years, this home showcases true pride of ownership throughout. The fully renovated main floor offers a bright, modern open-concept design highlighted by high-end craftsmanship and thoughtful custom details. The beautifully updated kitchen features quartz countertops, a timeless tile backsplash, stainless steel appliances, premium hardware, under-cabinet lighting, and elegant built-in accents throughout. A standalone island creates both functional workspace and natural separation, making it ideal for everyday living and entertaining alike. The adjoining dining area is enhanced by custom built-in cabinetry with matching countertops, creating a stylish and practical serving space perfect for family gatherings and dinner parties. Large updated vinyl windows fill the home with natural light, creating a warm and inviting atmosphere throughout. The living room serves as a cozy focal point, anchored by a stunning gas-assisted wood-burning fireplace that adds both charm and comfort. The spacious primary bedroom provides a relaxing retreat, complete with its own private 3-piece ensuite featuring a beautifully finished full-tile shower. Two additional main-floor bedrooms are generously sized, bright, and well-suited for family, guests, or home office flexibility. The lower level is where this home truly sets itself apart, offering exceptional versatility and exciting future possibilities. With its private rear access, functional layout, and substantial finished space, the basement presents outstanding potential for multi-generational living or future secondary suite development, subject to municipal approval and permitting. A large walk-behind wet bar already serves as an impressive entertaining feature while also providing an excellent starting point for a future kitchenette conversion. Two sizeable bedrooms are thoughtfully positioned on opposite ends of the basement, including one featuring a brand-new full egress window. A full bathroom, dedicated den or office space, and an expansive recreation room complete the lower level, creating a highly adaptable space ready to suit a variety of needs and lifestyle options. The private rear entrance opens onto a large concrete patio with convenient access to the sidewalk, street, and oversized double detached garage with rear lane access—further enhancing the lower level’s accessibility and long-term flexibility. Ideally located close to parks, schools, shopping, and everyday amenities, this beautifully updated home offers the perfect blend of comfort, craftsmanship, and investment potential in an established family-friendly community.

Listing Brokerage: CIR Realty
Listing data is deemed reliable but is not guaranteed accurate by CREB®. Last updated: today at 3: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