If a property goes into foreclosure on a second, as Ken said you will either be buying it subject to the first mortgage - meaning it's your mortgage now - or the first has to be satisfied to take possession of the property - or the owner of the first is going to be there bidding what they are owed, so you would need to outbid them to get the property and then you are the person paying off the first mortgage. 

Point noted about not being able to underwrite without seeing things in person.

Other CPAs and firms have quoted me 5k-10k+ but are no where near as responsive and personable as my current CPA and accountant.

Quote from @Zach Howard: I think it's probably better to hold real estate in an LLC than in my personal name.

Spreadsheet sounds like my own personal hell.

When I encounter this type of client, I do everything I can to convert them into one of the previous clients.First thing I have them do is run all their income and expenses through a separate account instead of their personal account. 

Because personal growth and financial stability sounded like a better combo than Netflix and takeout.

I personally had two encounters with Zach.

I've personally done just about every rehab scenario, properties I've lived in, properties bought as investments and even properties bought at auction.You've gotten good advice from folks on this list.

You can find something in Durham and parts of Raleigh, specifically zips 27610, 27603, and parts of 27604 that would meet your criteria, however generally speaking most of the inventory that would fit what you are looking for in Raleigh or Durham would likely be in neighborhoods that I personally wouldn't want to invest in, C- to D type neighborhoods.