3460 ST JOSEPH Boulevard, Orleans - Cumberland and Area MLS Number: X14095660

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.