The foundation has moved during the recent flood and would need to be replaced. Because the cost more than likely is more than assessed value it would need to be brought to FEMA standards. Would make a nice rental property or a nice lot to build a new home on.
This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

