Yes, it needs some a lot of help, but it's the kind of place I'd LOVE to help . I'd turn it back to a SFH and fix the floors & walls, probably put in central air (space pack system or something like it).
The wood trim, leaded glass windows are great but the 9' first floor ceilings were it for me