A former supermarket building in the heart of Blackwood, Caerphilly borough, could be transformed into flats and shops after being sold at auction