This project turned out really well and this home will be around another 50+ years What made you interested in investing in this type of deal?

You are going to pay much more for any type of work done (not including all the headaches associated with it) so in my opinion it's better to buy something that's already turnkey. 

What type of loan and lender would allow that ?

Quote from @Saint Kyle: Here's an examplelooking for rehab funding on a triplex in youngstown, oharv $130k rehab $70kdo you know of a bank that's willing to loan on a product like this?

These type of investments are illiquid, long-term and completely out of your control. 

I told them though I would be willing to put as much money down to make the deal work because I believe this is a once in a lifetime type of deal. 

What made you interested in investing in this type of deal?

No matter which format you plan to read you'll get all of the bonus content abovePre-order now to get the bonus offer: https://store.biggerpockets.com/products/the-house-flipping-...Photo of James with a copy of the book, text saying "Last chance to pre-order" and a "buy now" button

Are vacant properties in Texas a better investment compared to other property types, considering factors like acquisition costs, demand, potential appreciation, and holding expenses?

If you plan on selling the property always try to leave at least one unit vacant this way you allow for more types of buyers like house hackers or investors.