Homes are unique, and costs will vary house/house.   

So if there is a fix & flip LLC, and a rental LLC for multiple properties with each property on its own LLC, rather than filling out multiple unique LLC information on a return, it would all just be lumped together on schedule E as one source of personal income?

When I bought my current house, I was looking at Millbrae as a stretch, but settled on south city because it was realistic.

A unique script has to be written, for each county, to iterate through ALL of the accounts, and compiling the data in a database, which can then be queried for accounts which match your criteria.Iterating through all of the accounts requires exploiting the county's online property tax search.

Ideally, I'm looking for duplexes or triplexes within the Oakland area, but willing to stretch out to San Pablo or down to Hayward (i.e. 20mi radius).I'll be occupying one of the units and would prefer something that isn't turnkey.Thanks in advance. 

We have 2 units that take longer to rent, but that's partly because they are unique. 

There has been a dramatic increase in listings, but if you keep your rental nice and kind of unique/stylish, it's likely not a bad investment idea.The city/region has a major issue right now regarding hotel/short-term rental availability.

When I first started doing lending in Detroit.. this was an issue ... my client a big time flipper rehabber always had retired cops there with a clip board to check in the workers.. it was determined early on that much of the theft came from the exact guys that put the stuff in during the day.. they had the codes they knew what was there they would come in at night and steal it .the day cop and clip board put that to bed.So I agree with @Bryan Bannach  hire a retired policemen have him there during construction hours its the cost of owing property in the hood.. nothing unique about this.or just sell the property and buy something else.. but I think your looking to assemble so I know you probably don't want to sell.so just as stated hire security and I really like the idea of the @Patrick Liska  Cinder block fence I would for sure do that.. then put broken bottles in the concrete on top..

I have a military relocation professional designation so I am comfortable dealing with unique military situations. 

If A/C and roof are good, it sounds like the rehab wouldn't be huge by any stretch assuming no structural issues.