I dont know much about  the supply and demand there but the demographics look good to me

One of my old landlords was a full time police officer, and he owned 6 properties that he self-manged.

This is what he said “Our office has a different take on the agency.

I am the Business Development Officer for Exeter 1031 Exchange Services and cover the Midwest.

yes that will most likely disqualify it from VA. you should just remove it. call a local contractor to see how, if they don't want to do it they may be kind enough to tell you how to. since its not popcorn ceiling the chances of it hurting you are almost 0. once it's removed, get your home tested for air quality and provide that to the VA loan officer and you should be good to go

The purpose of this section is to establish regulations governing accessory dwelling units, in compliance with California Government Code Section 65852.2, and to provide standards for the development of accessory dwelling units (ADUs) so as to increase the supply of smaller and affordable housing while ensuring that such units remain compatible with existing neighborhoods.B.

She then stated that a code enforcement officer will call me next week to set up a time to come out. 

Specifically, 2 office studios on one meter. 

There's plenty of demand for houses $500k and below in town and not enough supply.  

I live in Atlanta, but we have an office in Greenville and I visit twice per month.