@Anita Zuniga if your end goal is to eventually move to San Diego then I think this would be a smart plan. 

You are right that some section 8 tenants may not take care of the property...but I have had both non-section 8 and section 8 tenants and I think sometimes those are just gross generalizations.

However, I think it is better for him to transfer it to you directly and have the loan be between you and your father.

Some of the higher demand points seem to be in more notable developments, but I do think people are trending towards wanting more space.

Quote from @Gregory Wilson: No matter what you put in the lease, if you know people are living in the space you have to comply with the City and Ohio landlord laws.If you are permitting mixed use, I would start with a residential lease tailored to the City of Cincinnati and add the permissions and restrictions on commercial use.I think you're addressing the case where I rent as an office and then they start living there.

I'm not knowledgeable on any of this but typically you have to buy the lot cash(I think).

Do you think it'll continue on an upward trend or do you think pricing and values are going to give a little and maybe plateau? 

Let me know if you think a situation like this is possible or if you can think of another scenario to handle this

Arina, I think you're on the right track, but I have a few thoughts.

Again, I think of it the same way.