I would say a recommendation to not do something, if there is a 99.5% chance that thing will result in losing a lot of time, money and possibly being sued, is a good recommendation.With the address, there is a fair amount of online info that can be had with an address.

In my OP I've wrote "For a fee", let's say a percentage of house closing, maybe 3% or so.

These are all markets I would love to already be owning a property, but when buildings are trading for say a 5 cap its not a great cash flow property in my eyes.

I'm a GP myself and am pretty familiar with these documents.I'm sorry to say, as long as the syndicator used a reputable attorney to put the documents together, there is very little you can do and surplus funds are 99.9% chance going to the lender.The only path's I'm aware of would involve you proving the GP knowingly engaged in fraud (e.g: lied about something) OR they misappropriated funds (e.g: they bought a private jet with the money instead of real estate)Outside of those scenarios, my strong guess is no money will be recaptured.I'm sorry to be the bearer of bad news here.

So you can take what I say as bias or not. 

Trying to find a small multi family in one of the desirable areas like NE, uptown, etc would be akin to trying to do that in the Bay Area, which is to say a near impossibility. 

So if it's pure core or core plus, you need one type of investors versus let's say a heavy value add. 

I look forward to reading what other have to say as well.

If it was vacant, I'd probably need to replace the whole carpet.But, if somebody came in now and saw it with the current tenant living there, they probably wouldn't notice a thing with the tenant's furniture and rugs covering up those patches.Let's say a prospective tenant checks the place while the current tenant is still living there, doesn't see any problems with the carpet and likes it enough to sign a lease.What happens when the new tenant moves when its vacant and notices the problems with the carpet?

Has anyone had recent success finding good multi-family deals in areas that already have a strong rental market (say a mile radius of Prospect Park, and further north in Bushwick/Williamsburg/Greenpoint)?