For Sale: 29 Herron Mews NE, Calgary, AB - REW
Boost your listing
Listing featured. Your listing will be featured on REW.
View featured placement
$659,000
4 bd • 4 ba • 1571 sf • Duplex
29 Herron Mews NE
Virtual TourStreet ViewDirections
$659,000
Get pre-approved

29 Herron Mews NECalgary, AB, T3P 1Y1

Livingston
  • 4 Bed
  • 4 Bath
  • 1571 Sqft
  • Duplex

About this home

INVESTOR ALERT | TURNKEY CASH-FLOW OPPORTUNITY IN LIVINGSTON! Legal Suite + Double Garage. Welcome to this exceptional income-producing semi-detached home with a LEGAL basement suite and double detached garage, perfectly located fronting a park in the highly desirable community of Livingston! Offering over 2,200 SQ.FT. of beautifully finished living space, this modern property is the perfect opportunity for investors or savvy buyers looking to offset their mortgage with strong rental income potential. Even better — tenants are willing to stay in BOTH the main home and basement suite, providing immediate cash flow from possession day and making this a true turnkey investment opportunity! The main level showcases upscale finishes throughout, featuring 9-ft ceilings, expansive windows, and a bright open-concept layout designed for modern living. The chef-inspired kitchen is loaded with premium upgrades including built-in appliances, stainless steel finishes, chimney hood fan, oversized island, crown-molded cabinetry, and a walk-in pantry — seamlessly flowing into the spacious dining and living areas. Upstairs, enjoy a luxurious primary retreat complete with a walk-in closet and spa-inspired ensuite featuring double vanities and a sleek glass shower. Two additional bedrooms, a full bathroom, bonus room, and convenient upper-floor laundry complete the upper level. The fully finished LEGAL basement suite is a major value-add, featuring its own private entrance, full kitchen, bedroom, bathroom, separate laundry, and dedicated living area — ideal for long-term tenants, extended family, or additional passive income. Located in one of Calgary’s fastest-growing communities with parks, pathways, schools, shopping, and future amenities nearby, this property offers the perfect combination of luxury, functionality, and investment performance. Turnkey. Stylish. Income-Producing. Opportunities like this are rare — book your private showing today before it’s gone
Listed by: Emmanuel Ajayi, CIR Realty

Home facts and features

Price details
List Price
$659,000
Get Pre-Approved
Home facts
Bedrooms
4
Full Bathrooms
3
Partial Bathrooms
1
Parking Spaces
2
Property Type
Duplex
Lot Size
2614 ft²
Frontage
22.15 ft
Year Built
Built in 2022 (4 yrs old)
Style
2 Storey,Attached-Side by Side
Heating Type
Forced Air
Basement Details
Full
Features
Back Lane, Back Yard, Balcony, Built-in Features, Crown Molding, In Basement, Kitchen Island, Laundry Room, Lighting, Lower Level, Open Floorplan, Pantry, Quartz Counters, Separate Entrance, Sidewalks, Street Lights, Upper Level, Walk-in Closet(s)
Amenities
Playground, Shopping Nearby
Appliances
Built-in Oven, Dishwasher, Electric Cooktop, Electric Range, Microwave Hood Fan, Refrigerator, Stove, Washer/Dryer, Washer/dryer Stacked, Window Coverings
Community
Agent details
Primary Agent
Primary Broker
CIR Realty
Listing details
Days on REW
97 Days
Property Views
12
MLS® Number
A2287895
Source
Pillar 9
Board
Calgary Real Estate Board
Is this your listing? Help it to stand out.

Mortgage Calculator

Estimated Payments
Purchase Price
Mortgage Total
Down Payment
Amortization
25 Years
Interest Rate
3.99%

Connect with our mortgage partner

Glenn Jorgensen

Glenn Jorgensen

EBS Modern Mortgage Group

No Fees, Great Rates - 15 minutes with us, could save you thousands.

Connect with a mortgage expert

Connect to a mortgage specialist

Glenn Jorgensen
EBS Modern Mortgage Group

They will connect with you to understand where you are in your journey and how they can best guide you.

  • %
Name*
Email*
Phone*
Purchase City*
What best describes your current situation?
Loan Details
Amortization
Years
Mortgage Amount
Down Payment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

The displayed rates are provided as guidance only, are not guaranteed, or are to be considered an approval of credit. Approval will be based solely on your personal situation. You are encouraged to speak with a Mortgage Professional for the most accurate information and to determine your eligibility.

Property Insights

St. Martin De Porres High School
  • n/a
  • -
  • In Catchment
Bearspaw Christian School
  • n/a
  • -
  • In Catchment
Nose Creek Elementary School
  • n/a
  • -
  • In Catchment
A. E. Bowers Elementary School
  • n/a
  • -
  • In Catchment
Muriel Clayton Middle School
  • n/a
  • -
  • In Catchment
C.W. Perry School
  • n/a
  • -
  • In Catchment
Ralph McCall School
  • n/a
  • -
  • In Catchment
Airdrie Learning Connection
  • n/a
  • -
  • In Catchment
Our Lady Queen Of Peace Elementary School
  • n/a
  • -
  • In Catchment
Atlas Learning Academy
  • n/a
  • -
  • In Catchment
School catchments and distances are intended to be used as reference only. To verify enrolment eligibility for a property, contact the school directly.Report Incorrect Info
Report Incorrect Info
Full Name*
Email*
Select School
Reason

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.
Thank You!
We really appreciate your help improving our home search experience. Our team will look into this issue as soon as possible.
Close

Cities near Livingston

Neighborhoods near Livingston

Listing data is subject to copyright, disclaimer, and additional requirements from the data provider. See our Terms of Use for terms applicable to this listing. Listing data was last updated on 2026-06-07.
Call Agent
Emmanuel Ajayi
Phone:
(403) 808-5886
Office:
403-294-1500
Share this Property
Text Message
Share this Property
Recipient Email Address*
Your Name
Your Email Address*

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

By proceeding, you consent to receive communications using the methods provided, from REW.ca and our partners about your inquiry and other home-related matters to assist you in your search, but not as a condition of any purchase.