I am interested what any experienced people have to say about how I can achieve my goal or any other comments/advice! 

How can I find the balance between deducting expenses and remain lendable?

Some additional context:- I'm interested in neighborhoods that offer a good balance of affordability and potential for appreciation.- I'm particularly keen on areas where there's a high demand for single-family homes.- Any insights on recent market trends or upcoming developments in Pittsburgh would be greatly appreciated.Thanks in advance for your help!

I’d aim to strike a balance between headcount and guest comfort.

To address your points;1) I do not see the problem with 'ill-liquidity' assuming that the rest of your assets balance out to your needs.

Confirm that the Debt Service Company used, will provide you with easy access to:      - monthly/quarterly/annual statements of your pymt history    - ideally, easy user login web or app access     - 1098 or annual (interest payment) tax documentation mailed, emailed, or pdf download-able     - alerts, notifications, and pymt scheduling options for: pymt due, pymt applied/received, outstanding balance, etc.3.

In that respect, you will have achieved a higher basis for depreciation and exclude the gain.

You mean 2nd position to cover balance of down payment or a bridge ?

That tool really sounds ideal...I think in most major markets now that are either saturated or balanced in terms of supply/demand now more than ever amenity rich properties are a must. 

I put some numbers below into this Rent or Sell calculator.https://www.narpm.org/members/resources/rent-vs-sell-calculator/ESTIMATES ON ROI (15 year time frame)at 5% Appreciation would profit $100K if SELL nowat 6% Appreciation would have $3,500K more if KEEP and sell after 15 yearsat 7% Appreciation would profit 122K if KEEP and sell after 15 years(Assuming a conservative 6% ROI on money invested from sale.)NOTE: The property appreciated 10% in the last year so I’m thinking 7% over the next 10-15 is reasonable.DETAILSSale Value: $520,000 (Best guess)Paid: $437,000Original Mortgage: $415,000Mortgage Balance: $380,000Interest: 3.375%Monthly mortgage: $2,899Mortgage Difference: $1064Annual Taxes, Insurance, HOA etc**: $20,345**$13,865 (Non Homestead tax) $4,680 (HOA) $1,800 (Landlord Insurance)Monthly Rental Charge $3,500*Appreciation 7%Years to Hold: 15More assumptions used in ROI Estimates Above90% occupancy,15% capital gains charge6% selling feeRate of return on gains if selling now instead 6%Annual maintenance 1%Annual rent increase 4%$3,500 is slightly aggressive. unlikely I could get more.Thanks in advance for any constructive thoughts and comments!!!!