A derelict convenience store which has blighted a village for almost a decade could be transformed into new homes.