I talked about this in my blog post US Cities for Turnkey InvestmentI would consider cities that have grown or stayed stable at least, to avoid pressure stock of vacant houses hanging on that rental market.

There is some time pressure, for me and for the lien holder, because the home is currently in foreclosure.My Questions:How can I go about getting these liens removed?

I am not able to get the water turned on for my own inspection so I was wanting to see if other investors would Plumbing: "water lines tested and would not hold pressure, the main line from the tank is malfunctioning and allow air to escape."

He also understands that I am an investor and not a "typical " agent which keeps any pressure off of me to bring in sales on a regular basis.

My friend's concern, however, is that the landlord may be trying to formalize their relations so that he may eventually evict them, as many of the legacy tenants in this apartment building have been evicted or "pressured" to vacate for frivolous reasons so that the landlord can renovate and convert their units to Airbnb in order to receive a higher return for each unit.

The demand for a corporate rental is a different conversation which is subject to local business, but two things here:1)  If the property is located in an area where only a handful of businesses would likely require its use, you are a lot more sensitive to local market pressures/economics compared to a place that is close, proximity wise, to not only multiples businesses which could demand your property but also multiple industries (Ie: tech, hospitals, finance, etc). 

This is for a 3 family.I understand you have to a pressurize contraption to you main line for it to work properly.Any comments or tips appreciated.

Peace of mind and having been through the process a time or two with an expert will ease your mind and show you exactly how it's done.Best of luck!

It puts a lot of pressure on reality that a good deal in a good location will cost more up front than overtime.

Although sometimes the upward pressure on prices in gentrifying areas can be greater than the downward pressure of a bad economy.