SWAT was called to remove the man from the crawl space, where he had reportedly been living for weeks, resulting in an hours-long standoff