Welcome to one of Orléans' most versatile properties - a fully updated multigenerational home on an exceptional 89' x 206' lot (over 18,000 sq. ft.), offering flexible living, rental income potential, and a rare home business opportunity. The main unit features two bedrooms plus a dedicated main floor office, an updated 2025 kitchen with quartz countertops and ample cabinetry, a full bathroom, and access to a new deck (23'4" x 10'6") with aluminum railings. The completely self-contained lower suite includes one bedroom, a full bathroom, in-suite laundry, and a private entrance. Ideal as an in-law suite, rental unit, or home business space, clients can access it without passing through your living area. Under N1E zoning, a variety of home-based businesses are permitted, including professional offices and personal services. An internal passage with lock-off capability keeps both units connected or separate as needed.Major updates include the kitchen, insulation, exterior doors, main floor windows and vinyl siding (2025), natural gas furnace (2023), and central air conditioning and humidifier (2018). Over 200 feet deep and fully private, the backyard features a 10' x 10' powered shed/workshop, second 10' x 10' storage shed, and heavy-duty vinyl dome garage (15' x 28') for an RV, boat, contractor vehicles, or workshop use. The yard also offers potential for a third dwelling unit, subject to applicable zoning, permits, and servicing requirements. Two natural gas quick-connects and dual generator hookups add convenience. Ample parking for residents and clients alike. Minutes from Highway 174, Trim LRT Station, and St. Joseph Boulevard's shops and services. With significant development planned along the Trim LRT corridor, this exceptional lot offers compelling long-term investment appeal.A truly adaptable property offering family living, income, business, and future development potential. (id:25961)
Schedule a Tour
Schedule an In-house Tour
Stéphane Chevalier would happily provide a private viewing if you would like to schedule a tour.
Match your Lifestyle with your Home
Contact Stéphane Chevalier, who specializes in Ottawa real estate, on how to match your lifestyle with your ideal home.
Get Started Now
Lifestyle Matchmaker
Let Stéphane Chevalier find a property to match your lifestyle.
Listing provided by EXP REALTY
MLS®, REALTOR®, and the associated logos are trademarks of the Canadian Real Estate Association.
This REALTOR.ca listing content is owned and licensed by REALTOR® members of the Canadian Real Estate Association. This property for sale is located at 3460 ST JOSEPH BOULEVARD in Ottawa Ontario. It was last modified on September 1st, 2026. Contact Stéphane Chevalier to schedule a viewing or to discover other Ottawa homes for sale.

















































