I'd also recommend these two books by Avery CarlSmarter Short-Term RentalsShort-Term Rentals, Long-Term WealthI've been doing a lot of the BiggerPockets books as audio books while I drive instead of just my usual podcasts when I really want to drill down and learn a specific topic and I'm loving it so far.

Excellent tenant.1926 Howard Ave - Single Family Home with studio apartment behind the house Unit A - Main House 3 bed 2 bath - occupied by same tenant since 2021.

We moved into our studio ADU and lived there for two years before we moved into the main house.

I only have Long Term Rentals - for me it would be way too much work to do STR with a W2 job, unless I pay a property manager but I'm considering doing an MTR if add an ADU to my LTR (downstairs could be a studio apartment if add a kitchenette), haven't gotten any estimates yet. 

@Maciej Girek  So it is essentially a studio with two means of egress , the window and the door.

However, the inspector mentioned that the 2nd and 3rd floors are labeled as "Artist Dwellings," though he wasn’t sure what that fully entails.He suggested applying for a special permit to present the space as artist studios or dwellings, with the hope of eventually converting them into long-term rental (LTR) apartments under that designation.

yeah you are likely looking at art studio/content creation type spaces or maybe some startup that needs a bit of storage or warehousing while they get going. 

They do have some options for building up (see three story image below) but we created an apartment that consists of studios units, in the standard 16x74 foot modular home rectangle.

Two of the books that have helped me when I was in your position are Start with Strategy - https://store.biggerpockets.com/products/start-with-strategyThe Book on Estimating Rehab costs - https://store.biggerpockets.com/products/the-book-on-estimat...Since you like the podcasts - these are available as audio books and broken into audio chapters so you can listen just like podcasts!

Mean unit prices in the metro are as follows: studios $1,687, one bedrooms $2,168, two bedrooms $2,730, and three bedrooms $3,384.