A 0.75-acre parcel serving as the foundation for a visionary development project in Morganton.

Align Foundation Repair and MCR Foundation both should be able to quote you under $200 per pier. 

How much value goes down for a house with foundation issues, found a house for FixNFlip, they mentioned it has foundation issues and they got them fixed, but whats the value reduction from market price , How safe it is to purchase house like these 

As far as title companies go, I would recommend Foundation Title & Escrow.

Looks like a rubble type foundation wall.

It will not cover foundation issues

If you are good at saving and have a strong foundation you can be riskier, leverage more. 

If you have the money and a financial foundation to do that then that seems ideal.

I do know it needs P/B foundation repair, new tile, and plumbing updates.

The main issue with rental basement is water if it has water issue usually it is a simple fix .Clean gutters ,discharge gutter  water away 10" away from foundation, make sure you foundation soil is slopped away from it .If you need to buy soil get a clay mix .Cut back any tree too close to the foundation look at the drip line that's how far the limbs are out from the tree .If all that is done still has water buy a sump pump  carry the water to day light away from foundation 10" to 15" .