This is the former mansion of one of the Book brothers, early Detroit developers who transformed downtown's Washington Blvd. It housed law offices until a few years ago. Now it has been scrapped and sits vacant. I've heard rumors that it's in foreclosure and can be had for as little as $90,000 (it has a river view and a big carriage house in back, too).
Note also that this is in a really, really nice neighborhood.