Plans have been revealed for the construction of a small housing development on the site of a former cash and carry destroyed by ... affordable and sustainable homes in its place.