Rare opportunity in the highly sought-after Old North End! Ideally located near downtown, shopping, dining, parks, schools, and everyday amenities, this beautifully updated 4-bedroom, 3-bathroom R-2 zoned property offers exceptional versatility on a large lot with a private electronic gate. Whether you are seeking multi-generational living, flexible living arrangements, or potential income opportunities, this property offers endless possibilities. The main level features warm and inviting living spaces filled with character and tasteful updates, along with a beautiful partially covered front porch perfect for enjoying the charm of the neighborhood. An apartment-style living area on the main level includes its own exterior entrance, kitchenette, and full bathroom, creating an ideal setup for guests, extended family, or private living quarters. Upstairs, you will find a spacious 2-bedroom apartment-style space featuring a living area, kitchen, and full bathroom, offering comfortable independent living with added versatility. The partially finished basement includes its own private entrance, providing additional space for storage, expansion, or other flexible uses. Outside, the expansive lot also includes a workshop and an additional detached rear structure offering excellent potential to be finished for guest accommodations, creative space, hobbies, workspace, or other supplemental use. Thoughtfully updated throughout, this property blends historic Old North End charm with major improvements including new furnace with air conditioning, roof, and electrical completed in 2016, plus new Pella windows installed just last year. Rarely does a property offer this much flexibility, character, and opportunity in such a prime location. This home truly has it all-you have to see it to believe it! DON'T MISS THE VIDEO AND VIRTUAL TOUR! Buyer to verify zoning, permitted uses, utilities, and future use possibilities.