But the location is very desirable, a quiet street with many nice homes all as old walking distance to the town center, which brings in a lot of tourists. 

With covid, cities are loosening STR regulations to make more options available to tourists.

That is highly illegal, pay your taxes, if you do short term rentals make sure you include what is called tourist tax in you rent and you set up your unit with the state and county.

Any agents or property managers in tourist areas I can connect with?

There are a lot of tourist attractions and the beaches there are incredible.

The pros and cons of are pretty well known and pretty simple in my mind:ProsShort-term furnished rentals, in my experience and in the experience of people I consult with, are more profitable if -- and that is a big IF:You're in a great location where tourists want to stay; andYour property is actively managedactively monitoring market prices and adjusting to ensure high occupancycommitting to a high user experience (i.e. fast responses, impeccable cleaning, etcIf done right, they can bring in 2-3x revenue.ConsIt's a lot of work.

The tourist love to visit and snowbirds love stay throughout vacation.

I figured I could rent this storage unit to students or AirBnB tourists on a 1st come 1st served basis.To my huge disappointment, when I called the Malden city clerk building operations and asked to get a permit to introduce electricity/water to the unit to make it habitable, I more-or-less got this answer:- In this single family house location.

Still, could be more if it were turned into a nightly tourist rental (like an AirBnB) or rented by the week like a lot of places do in this area. 

, I read on HUD's website that it must be your primary residence for a minimum of 90 days, yes I do plan on making one of the units my primary residence while renting the other, I do also plan on getting the 203k loan to have at the very least the kitchens renovated, I will not be able to afford a fancy home by no means, I want to buy withing my price range. there is an up and coming neighborhood in Queens NY with LOTS of development happening, also has one of the main transit HUBS connecting millions of New Yorker's and tourist to Midtown Manhattan.