Assuming I do get access to a list of properties in probate, how do I determine which properties actually need to be sold in order to settle the case?

Providence and surrounding neighborhoods don't have positive inflation-adjusted growth over the long-term (shocking) so to make money in this city you need to i) invest cyclically and ii) have access to good deal flow.

Will any nice real estate agent let me have access to their MLS?

If you have any questions, or have interest in getting access to this additional data, please feel free to get in touch.

Because there is no zoning in the city, and land for miles in each direction, New Development is less restrictive than other cities.Additionally, almost 100,000 residences were flooded in 2017 and a lot of SF homes you’ll look at (all over town) are rehabbed flood homes with potentially higher insurance costs and possibly less appreciation over the next few years due to market stigma.  

Hearing depends on how busy the court is, mine was in 2 weeks.Off course, you have to have all your ducks in the row: lease signed, 30 days non payment proof, whatever else your lawyer asks.In few days after the access to the property granted, the tenant might leave without any fighting (was my case) or the attorney will schedule the forceable entry. 

is there a restriction on getting Heloc on condo or SFH ?

You can't be sure who had access to that gun (beyond just the previous owner that left them behind) or if they were  used in a known or unknown crime. 

I took this rate because it was most accessible (not so realistic i know)  Besides if it would take a more realistic rate (couldn't find one so quickly) the 0.5% would only be lower so this is even best case scenario on the mortgage and it's still no 1% or near it.Property tax is 0,0838% of the marketprice here.

A syndication is very unlikely to have no debt).On the other hand, syndications allow most investors to access and diversify into asset classes that they would not be able to own on their own because the entry point is too high (ie, offices, mobile home parks, self storage facilities, larger multifamily etc.).