most bay area properties appreciate at higher than 2% annually which is how much the property tax can increase annually which reduces the number of properties that would have an overpriced assessment so i would say that kind of service won't last long in business around the bay areaAfter the financial crash in 2008 resulting in property depreciation, many people appealed the property assessment and there were services back then offering to appeal but i gotta say i haven't seen those lately

My realtor negotiated the deal to keep it off market and we were able to come to terms that worked for myself and the seller.

If you're into long term buy and hold to target appreciation, Columbus is another market you can check out. 

It's always effective, no matter what the market, as long as you have a tight hold on values. 

Our 5 bedroom home would likley rent for ~$2k as a traditional long term rental, but we get $3750/month by renting by the room!

So you would have to get a commercial loan if going straight to the LLC - which usually has worse terms (shorter rate lock period, shorter amortization schedule).USUALLY, you can borrow personally and then deed it to the LLC after the fact and as long as the LLC is owned by the borrower you won’t trigger a due on sales clause.  

Unless you have short term rentals where I imagine the volume would be higher, you should be able to keep your own books.

We were curious if anyone here had guidance on the market in terms of zip codes on the rise/or key areas developments we should take a look into?

Will only cause issues in the long run.

would love to help, we are doing long-term rentals in southern DFW and have seen a lot of success - we now have over 150 units.