Yes, that is exactly what it looks like. Someone didn’t turn the water off at the street, and so their entire basement got full of water. Then since the house was unoccupied, and had no heat, that water froze. You have to admit, that looks pretty sick. Right out of a videogame if you ask me, the block walls really help give it the perfect videogame vibe, (which is kinda what the top comment on the reddit thread is saying) It’s a shame that the home is now condemned though. Luckily, no one is currently living in it, so no one is homeless.
There’s a couple more photos on this imgur album, but they don’t nearly convey the coolness of the above.