SHANNON HOUSING, L.P. AMENDED AND RESTATED AGREEMENT AND CERTIFICATE OF LIMITED PARTNERSHIP