A plea for a council to buy a property so that it cannot be used to house asylum seekers has been rejected - because a previous attempt to buy it has already fallen through.