I have analyzed 10 deals a day, and have viewed every single house in the market with my zip code 39056. 

Other examples of niche lists to check out include : code violation, driving for dollars, and senior lists.

@Lake Ingle you say it's move-in ready so the following may not apply, but during a condo purchase a couple years ago I got permission from the owner to fix a minor code violation and clean just before closing. 

You can find the code the they are infringing and serve them with a notice to either cure the issues or vacate. 

Our group uses color coded name tags.

You have to have the RHIP forms on file (completed by a certified RHIP person) showing that you are doing annual inspections and keeping the properties up.See:https://code-enforcement.saccounty.net/Programs/Pages/RHIP.aspx

There are a lot of suburbs of Columbus that are good markets (many listed zip codes above).

Read the Tx Property Code. 

Am confused because according to the Texas property code section 52.006 Except as provided in subsection(b) a judgement lien continues for 10 years following date of recording, ECEPT if judgement becomes dormant during that period, the lien ceases to exist.It has already been 11 years since judgement was rendered, it has not been renewed.

My first property I looked at with my Agent was a house in Westminister, it was a 5 bed 2 bath home, 3 of the bedrooms were in the basement, I thought to myself looking at the property (this would be a great house hack, ill just rent out the basement rooms, not knowing any better about code), my agent informed me that the rooms were not up to code and didn't have any egress windows / wells installed, and that it would be an expensive cost to have them brought up to code, and that this particular house wouldn't be a great house hacking investment, so I passed.