SEARCHOPERTIES


Picture of 1249 25 Street SE, Medicine Hat Real Estate Listing
1249 25 Street SE, Medicine Hat || $674,500

Best Christmas Present Ever — And Just in Time for Next Year\'s Summer Fun!
Welcome to this stunning five-level split, where modern living meets your own private outdoor paradise! The open-concept main floor flows beautifully between the spacious living room, dining area, and stylish kitchen — perfect for everyday living and unforgettable family gatherings.
Step outside into a resort-style backyard oasis featuring a fully renovated swimming pool by Backyard Vacations (2024), an incredible outdoor kitchen setup with a hood fan for all your cooking needs, a sink with hot and cold water and a relaxing hot tub — everything your family needs to make the most of summer. Whether you\'re hosting a BBQ, enjoying a peaceful evening by the cozy fire pit, or unwinding under the stars, this backyard was made for making memories.
Inside, you\'ll find five spacious bedrooms, including a warm and inviting study with a wood-burning fireplace — ideal for quiet reading or working from home. A large family room adds even more space to relax and enjoy.
Fully renovated inside and out, with a new roof, eaves, garage doors and openers, windows, kitchen with stunning quartz countertops, and slide out pantry, bathrooms, flooring, paint, lighting, rubber decking around the pool and hot tub and front steps, govee lights, insulation in attic, grass free yard which makes this easy to maintain. Upstairs and downstairs laundry. This move-in-ready home offers modern comfort, timeless style, and tons of storage. Don’t miss your chance to give your family the best Christmas gift ever — a dream home that’s ready for summer!

Listing Brokerage: RIVER STREET REAL ESTATE
Picture of 2122, 5150 47 Street NE, Calgary Real Estate Listing
2122, 5150 47 Street NE, Calgary || $1,142,190

Prime commercial units available at 5150 47 Street NE, offering between 2,001 – 2,058 SF of well-designed space with excellent visibility and accessibility in a sought-after northeast location. Each unit features four assigned parking stalls. With competitive pricing and strong surrounding amenities, these units present an outstanding opportunity for businesses or investors looking to establish a presence in one of Calgary’s thriving commercial hubs. Contact your favorite REALTOR today to book a private showing.

Listing Brokerage: Keller Williams BOLD Realty
Picture of 1269 Sherwood Boulevard NW, Calgary Real Estate Listing
1269 Sherwood Boulevard NW, Calgary || $979,900

OPEN HOUSE: October 19, 2025 Sunday 12 PM - 2 PM. Stunning and expansive 6-bedroom, 2-storey home in the sought-after community of Sherwood! Perfectly located near all the amenities of Beacon Hill, this home impresses from the moment you enter with soaring vaulted ceilings, modern lighting, beautiful hardwood, and elegant architectural details. The main floor offers a formal living and family room, a large dining area, and a gourmet kitchen with granite counters, euro-island, and high-end SS appliances. Upstairs features two ensuites, including a spa-inspired master retreat with a huge walk-in closet and a bright bonus room. The fully developed basement includes two good-sized bedrooms, a wet bar, gym area with quality flooring, and a separate entrance—ideal for extended family or investors. Additional highlights include two furnaces, five bathrooms, 9-ft ceilings, and stylish stone feature walls. A perfect blend of elegance, comfort, and investment potential!

Listing Brokerage: PropZap Realty
Picture of 2118, 5150 47 Street NE, Calgary Real Estate Listing
2118, 5150 47 Street NE, Calgary || $1,110,555

Prime commercial units available at 5150 47 Street NE, offering between 2,001 – 2,058 SF of well-designed space with excellent visibility and accessibility in a sought-after northeast location. Each unit features four assigned parking stalls. With competitive pricing and strong surrounding amenities, these units present an outstanding opportunity for businesses or investors looking to establish a presence in one of Calgary’s thriving commercial hubs. Contact your favorite REALTOR today to book a private showing.

Listing Brokerage: Keller Williams BOLD Realty
Picture of 2201 24A Street SW, Calgary Real Estate Listing
2201 24A Street SW, Calgary || $859,900

Welcome to this stunning inner-city infill offering over 1,600sf of luxury living space, complete with a FULLY DEVELOPED BASEMENT, 4 bedrooms, and 3.5 bathrooms. Perfectly located on a QUIET STREET near a cul-de-sac with very little traffic, just a 15-minute walk to MARDA LOOP and the BOW RIVER PATHWAYS, and only a 5-minute drive into downtown, this home blends upscale comfort with unmatched convenience.

Step inside and be greeted by an expansive open-concept main floor anchored by a SHOW-STOPPING KITCHEN ISLAND with WATERFALL COUNTERTOP, ideal for both everyday living and entertaining. The kitchen showcases TIMELESS WHITE CABINETRY, premium STAINLESS STEEL APPLIANCES with a GAS RANGE, and flows into a SPACIOUS DINING ROOM overlooking the backyard, perfect for hosting family gatherings or dinner parties. Modern HARDWOOD flooring extends throughout the main floor, enhancing the home’s seamless flow and modern aesthetic. High-end finishings are showcased throughout, including a striking GLASS RAILING that extends from the basement to the upper level. The home is also WIRED FOR SOUND, allowing you to create the perfect atmosphere for any occasion. ARCHITECTURAL LIGHTING, both inside and out, elevates the ambiance while large EAST AND WEST FACING WINDOWS will bring bright mornings and sunny afternoons.

The primary suite is a true retreat, featuring a spa-inspired ensuite with IN-FLOOR HEAT, a JETTED SOAKER TUB, GLASS-ENCLOSED STAND-UP SHOWER, and a large WALK-IN CLOSET. Two additional upstairs bedrooms, and a fourth in the basement provide plenty of flexibility for family, guests, a home office, or gym.

Outdoors, enjoy beautifully LANDSCAPED GARDENS, METICULOUSLY MANICURED GRASS, and MATURE TREES throughout the property, offering both curb appeal and privacy. The WEST-FACING BACKYARD is perfect for relaxing, entertaining, or BBQ\'ing. The DOUBLE DETACHED GARAGE easily accommodates a full-sized truck with room to spare. The exterior garage wall facing the backyard serves as the perfect canvas to add a projector screen, creating your own private outdoor movie nights.

Located just off the corner lot, this home enjoys the benefits of AMPLE STREET PARKING and open exposure while maintaining a quiet residential feel. With SHAGANAPPI C-TRAIN STATION just a 5-minute walk away and QUICK ACCESS TO CROWCHILD TRAIL, commuting anywhere in the city is simple and convenient.

This is more than just a home, it’s a lifestyle. Call your favourite Realtor for a private viewing today.

Listing Brokerage: eXp 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