SEARCHOPERTIES


Picture of 31 Harvard Street NW, Calgary Real Estate Listing
31 Harvard Street NW, Calgary || $1,150,000

Stunning custom-built detached infill in the highly sought-after community of Highwood! Built recently in 2024 and offering over 2,800 sq ft of thoughtfully designed living space, this immaculate 2-storey home blends modern luxury with exceptional investment potential. Currently operating as a successful, fully furnished Airbnb for the past several months, this turnkey property offers a rare opportunity for investors to step into a thriving short-term rental business, complete with two separate licenses for the upper level and the legal basement suite. Its prime inner city location makes it especially attractive, with strong and consistent demand from guests seeking close proximity to downtown. For those not looking to continue with Airbnb, the home is fully furnished and move-in ready, making it an ideal option for a family wanting a seamless transition into a beautifully finished property. Inside, you are welcomed by a bright, expansive foyer that opens into a sun-filled main floor featuring soaring 9’ ceilings, large windows, elegant hardwood flooring, and refined contemporary finishes throughout. The gourmet kitchen is a chef’s dream with quartz countertops, premium stainless steel appliances, extensive cabinetry, and a stunning waterfall island with seating. The formal dining area connects effortlessly to the inviting living room, highlighted by a cozy gas fireplace, while a stylish powder room and access to the backyard and double detached garage complete the main level. Upstairs, the luxurious primary retreat offers a spacious walk-in closet and spa-inspired ensuite with dual vanities and a freestanding soaking tub, along with a private front balcony with sleek glass railing. Two additional generously sized bedrooms, a beautifully appointed full bathroom, and convenient upper-level laundry add both comfort and practicality. The fully approved legal basement suite features its own private entrance, full kitchen, spacious living area, two large bedrooms with walk-in closets, and a full bathroom, making it perfect for additional rental income or extended family. Custom-built closet organizers in the bedrooms, ample storage space, and ceramic tile finishes in bathrooms and laundry areas further enhance the home’s quality and functionality. Located on a quiet, tree-lined street just minutes from downtown, schools, shopping centers, and picturesque parks, this property offers the perfect combination of style, comfort, convenience, and income potential. Book your private showing today!

Listing Brokerage: PREP Realty
Picture of 511 Main Street , Maidstone Real Estate Listing
511 Main Street , Maidstone || $229,900

Spacious family home in the heart of Maidstone! Offering an impressive 1,640 sq ft of living space, this home includes 1,352 sq ft plus a 288 sq ft enclosed breezeway that has been converted into a large foyer—perfect for kids, pets, and everyday life. Situated on a 52’ x 198’ corner lot, this property provides plenty of outdoor space while being conveniently located close to schools and downtown amenities.
Despite being located on Main Street, the home is set within a residential area, offering both accessibility and neighborhood appeal. Inside, you’ll find a rare six-bedroom layout, ideal for large families or those needing extra space for a home office or guests. The double attached garage adds convenience and year-round comfort.
The basement is currently in the process of being fully finished, with new flooring, paint, trim, fixtures, and a renovated bathroom, and is expected to be completed by the end of February, at which time updated photos will be available. Metal roof was installed in 2023, new windows in 2024.
If you’re looking for size, functionality, and value, you’ll be hard-pressed to find a bigger home at this price point in Maidstone. A fantastic opportunity for families or investors alike!

Listing Brokerage: eXp Realty (Lloyd)
Picture of 208, 1010 Railway Street , Crossfield Real Estate Listing
208, 1010 Railway Street , Crossfield || $155,000

Welcome to this bright and move-in ready 1-bedroom, 1-bathroom condo in the welcoming community of Crossfield! Featuring brand new carpet and low condo fees of just $295.48/month—an exceptional value—this home delivers comfort, convenience, and affordability in one attractive package.
Perfectly situated for commuters, you’re only 10 minutes from Airdrie and 25 minutes from Calgary with quick access to Highway 2A. Enjoy the convenience of nearby shops, restaurants, and everyday amenities just minutes away.
An ideal option for first-time buyers, downsizers, or investors, this low-maintenance property presents an excellent opportunity in a friendly community. Schedule your viewing today!

Listing Brokerage: REMAX ACA Realty
Picture of 1607, 1122 3 Street SE, Calgary Real Estate Listing
1607, 1122 3 Street SE, Calgary || $420,000

CITY & MOUNTAIN VIEWS from this stunning southwest corner unit! This bright and welcoming open-concept home is filled with natural light and offers 2 bedrooms, 2 full bathrooms, tandem titled parking for two vehicles, and a large balcony with breathtaking views you’ll enjoy every day. The modern kitchen features sleek cabinetry, stainless steel appliances including panelled refrigeration, quartz countertops, and plenty of storage. The primary bedroom easily fits a king-size bed and includes a walk-through closet with custom built-ins leading to a contemporary ensuite. The second bedroom is conveniently located next to a full 3-piece bathroom—perfect for guests, roommates, or a home office. Enjoy the perks of this executive concrete building, which offers concierge service, a fitness centre, party room, rooftop terrace, workshop, air conditioning, high-speed elevators, visitor parking, and a separate assigned storage locker. Impeccably maintained by its original owners, this move-in-ready home is also pet friendly (with board approval) and ideally located—just steps from Pixel Park, river pathways, the LRT, Stampede Grounds, Central Library, restaurants, cafes, shops, and groceries. Floor plans and a 3D tour are readily available, providing a glimpse into this stylish condo!

Listing Brokerage: CIR Realty
Picture of 123 Anystreet  , Calgary Real Estate Listing
123 Anystreet , Calgary || $599,900

Well-established and profitable liquor store generates strong annual sales. Same owners for the last 27 years who are now retiring. The business benefits from a low monthly rent keeping overhead costs down and margins healthy. Strategically located along a high-traffic corridor, in the NE the store enjoys excellent visibility and steady footfall from both surrounding residential neighborhoods and nearby commercial hubs. With consistent profitability, a loyal customer base, and a prime location, this is an outstanding opportunity for entrepreneurs or investors seeking a thriving and proven retail business in a growing market.

Listing Brokerage: Real Broker
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