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 Private Tour
Adam Baddoo would happily provide a private viewing if you would like to schedule a tour.
Match your Lifestyle with your Home
Contact Adam Baddoo, who specializes in Ottawa real estate, on how to match your lifestyle with your ideal home.
Get Started Now
Lifestyle Matchmaker
Let Adam Baddoo find a property to match your lifestyle.
Rooms
| Level | Type | Dimensions |
|---|---|---|
| Office | Second level | 3.18 m x 3.68 m |
| Living room | Second level | 3.25 m x 4.12 m |
| Kitchen | Second level | 3.18 m x 3.94 m |
| Bedroom 2 | Third level | 3.53 m x 3.51 m |
| Bedroom 2 | Third level | 0.99 m x 1.6 m |
| Bathroom | Third level | 1.73 m x 2.31 m |
| Primary Bedroom | Third level | 5.44 m x 4.09 m |
| Primary Bedroom | Third level | 0.99 m x 4.09 m |
| Recreational, Games room | Main level | 4.8 m x 2.72 m |
| Kitchen | Main level | 1.63 m x 2.69 m |
| Laundry room | Main level | 1.55 m x 1.83 m |
| Bathroom | Main level | 2.46 m x 2.62 m |
| Bedroom 3 | Main level | 3.2 m x 4.47 m |
Details
- Amenities Nearby: Place of Worship, Schools, Park, Public Transit
- Community Features: Community Centre
- Ownership: Freehold
- Parking Spaces: 10
- Structure: Deck
- Transaction: For sale
- Zoning Description: N1E
Building
- Appliances: Dishwasher, Dryer, Two stoves, Washer, Two Refrigerators
- BasementType: Full (Finished)
- Basement Development: Finished
- Bedrooms Main Level: 3
- Construction Style Attachment: Detached
- Cooling: Central air conditioning
- Exterior Finish: Vinyl siding
- Fireplace Present: False
- Foundation: Block
- Bathrooms (Total): 2
- Heating: Forced air
- Heating Fuel: Natural gas
- Size Interior: 1100 - 1500 sqft
- Stories Total: 3
- Type: House
- Utility Water: Municipal water
Land
- Amenities: Place of Worship, Schools, Park, Public Transit
- Sewer: Sanitary sewer
- Size Frontage: 88 ft ,6 in
- Size Irregular: 88.5 x 216 FT
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 Adam Baddoo to schedule a viewing or to discover other Ottawa homes for sale.