The kitchen would have to come upstairs and be a mini-bar like kitchen.

Cincinnati has tons of neighborhoods and is perhaps one of the most difficult cities to navigate because it really is not set up on a grid - more like roads winding around the hills and valleys. 

If you're using the Purchase contract As-is or FAR BAR, theres is a section in the contract that explains this, the section is called "Force Majeure".

We were able to navigate around the flooded areas to the two properties that didn't flood and I talked to the neighbors who said there was no flooding on that street.  

Just be cautious of Columbus, as the homes are very street-by-street and can be difficult to navigate in the beginning.  

I could possibly get by with four separate two-unit dwellings, but again the setback and zoning regulations would affect that too.I would recommend if this is something you are seriously considering to move forward on, hire someone to navigate all of these zoning and building regulations for you to determine what ultimately can and cannot be built on the site.

Many houses now have "snack kitchens" in their family rooms -- a small kitchen with a smaller refrigerator, a bar sink and a microwave.  

Can anyone can offer advice on how to navigate this difficult scenario so we can have a plan in place.

I appreciate the responses and they are very helpful, want to navigate in forum better before I continue

It has 4 luxury cabanas a suite, restaurant, bar, swimming pool with jacuzzi and swim up bar.