Excellent redevelopment opportunity purchased by owner-occupier to end four generations of ownership