Bedford council has apologised to a resident and is paying her £250 for the distress caused after overlooking her for social housing properties.