Brush Park features in a lot of those photos (just up from Ford Field and Comerica Park).
There are beautiful historic buildings with great swaths of vacant land. It's a designated historical district, so the city is making it tough for a layperson to buy a lot. For example, all available tax foreclosed lots in the area were removed from the treasurer's auction.
I suppose they're trying to prevent ugly condos being built, but then you get a situation like this where an area very close to downtown is so sparse.