Oh yes. First off, what are the values of the houses in the area? You might be better off new construction. I cannot tell what we mean by foundation??? Putting up some pillars could be actually inexpensive to someone that knows what they are doing to being something that would cost a lot of money and effort. Structure of the house cannot be compromised. If it can be fixed, great... If not, just start fresh.
Small houses sell too. So think small house with that type budget.
If the house is structurally sound, $50,000 is a nice budget for a gut of a small house around 1,000 sqft. Ultimately you have to run some costs and see what needs to be done.
I picked up a 941sqft house for $4,000 that had brick walls. We had to completely gut the entire inside... from new roof, electrical, plumbing, subfloor, windows, half the house in joist, but the walls were in good shape, and foundation was solid. That was $35,000 for us to do. So yes it can be done.
Did I mention it hard work???? LOL
I hope this helps