It sounds like I'm out-of-luck on this one, but I'll dig deeper into suggested links. 

Both ideas are intended to help veterans get the physical, mental, and emotional support they need to help them return to civilian life as happy and productive contributing member of society. 

Take all the emotions out of this and then tie that will the tenants you had previously and why they left.

as far as the lying, yep she claimed to have one small service dog on the lease but when I went over there there were two hyper dogs, one a lab, the other a lab mix, no way service dogs and no way small. then I started to dig deeper and found out the references were on her FB page - boy did I feel dumb, but then again I expect that my realtor knows these things since that is what I pay her for.

So, like I said, if you've found your "forever home" and want to lock in interest, have someone else pay down the majority of your mortgage, etc. then I think it's a viable strategy.Just realize you're buying for "want" and "emotion" and you'll be fine. 

Their emotions are a result of the previous owners of the property but mentally anchored to the real estate.

Keep emotions out of it as much as possible (easier said than done, I know).If you feel uncomfortable saying you are not the owner (when in fact you are) consider putting your properties in an entity, ie; corporation, LLC, trust, etc. 

Can anyone please provide a deeper insight into this and how to get around it?

Take the emotions out of the decision and really think on if it makes sense.

I know we can get some market research like state-wise from the Realtors association (like this one https://www.njrealtor.com/research/), but if I want to go deeper and understand the market in a county or even in a specific city, where should I go?