I never could understand the tax aspect you still have to pay tax as you receive the payments its does not limit your tax liability. 

Again just looking for some insight on what you think the upper limit would be of what I can qualify for a primary residence duplex.

Has leased for 12 years, with limited issues, until now.

Arlington limits them to within a couple miles from the entertainment district. 

Does the HOA still limit rentals to a 2 week minimum?

Analyze your total budget (how much money you will have to actually purchase a property), talk to your banks or other finance institutions - they will tell you your credit limit before handing you out any money.

If you rent out the other rooms on a full-time basis, then it becomes a rental property... or a 2nd house in which you are house-hacking.Your CPA is referring to the passive loss limitations on deducting rental property losses against your ordinary or W-2 income.

Unfortunately, I'll likely have to put 25% down because I can't pick my family up and move, so I know that limits me to an investment loan and way more upfront capital than I'd prefer. 

I recently read the book “Investing in Real Estate with no and low money down” by Brandon Turner and one question I had about syndications is I know the limited partners generally pay for the down payment and different fees but in terms of the loan itself from the bank do the general partners apply for that as a business loan?

Y-o-Y  stats makes limited sense now as it just says things are looking better than last year, not pre-pandemic.