Multi-use riverfront property opportunity, but no experience

[Nathan Mailly]

A family member of mine owns this property at 20 Forbes Ave, Rensselaer NY, 12144. The property is full of potential being about 8 acres right on the water. There is an old mill (green shading) that is structurally sound and really could be converted into almost anything. There is also a portion of land (blue shading) that I think would be ideal for a commercial apartment complex, but before this can happen I think the mill, which is an eye sore, needs to be taken care of, or does it?

This is one of the only and best waterfront properies in the area. My family wants to make the most of this opportunity, but we want to do it right. We know people with money, but we want to find someone who has done this before.

Any help would be much appreciated!

Thanks