Can someone please explain this for me?
What could possibly cause the price for this property to drop so much, so recently? Does demolishing the house and leaving vacant land cause this kind of drop?
No one will be able to tell you without more information. There could be any number of reasons including the one you have postulated. Give the agent a ring and ask them.