After a couple of years of treading the path to frugality to build this financial runway, I've networked with the greatest people who made this all happen, of course, it took the strength, determination, time, etc to place myself where I am today but, without the mentorship of my two great mentors whom I wish used BiggerPockets so I can mention, I don't believe I would have made it thus far relying on some whimsical dream that this will all pan out accordingly, thank you for everything Greg and Lashawn.In addition, I would like to thank Bigger Pockets for connecting me with the greatest realtor @Stephen Schmitt Who took my dreams and aspirations to the core when we first connected and spoke about my future goals to replace my W2 job for financial freedom. within three months of me deciding to pull the trigger and get pre-approved, we found this killer cash-cow that apprised over purchase price!!! 

However, as Zane mentioned in his response, another option is to consult with a lawyer who specializes in appealing property taxes.

Not to mention the very long list of the horrors that density of housing combined with poverty has brought all but 100% of the time over history. 

You will be waiting a long time - that as mentioned was a black swan event just like when they went to like 18%.Historically speaking expect rates to be between 5-8%. my recommendation to anyone buying real estate today is if you buy, expect to hold it for atleast 5 years 

When you mentioned you did your homework on the turnkey property, if that were the case you would have had a really good idea what the property was worth before you offered on it (of course sparing the occasional rogue appraiser, which may be what happened to you... idk) and certainly before the appraisal.

@Kody SmithYou mentioned syndication.  

I've never gone through the zoning change process that you mention although I've heard it can be very profitable.  

I will mention that a hot tub could really increase the frequency of bookings. 

A good friend of mine recently managed to pick up a modest duplex outside Phoenix that looked risky at first glance.. low rents, older neighborhood.. but with a few smart upgrades, it became a steady earner in under a year.You mentioned your worries about remote investing and the challenges of managing properties from afar.

Of the things you mentioned, seller finance is one to focus on if capital is low.