And on the other side, I've seen some vacation rentals that are otherwise nothing special but they put in a cool wall of bold wallpaper, pay for nice furnishings and develop a vibe and they outperform their competition. 

In addition to checking out local crime statistics via county and city websites, you may want to check out this website: https://crimegrade.org/. 

Statistics available from BizBuySell state that 80% of businesses for sale never sell.  

You can see how this gets complex quick.On Building Big Infrastructure in the USAAnd, if I may be so bold, a note on larger infrastructure that obviously affects the real estate economy: What about large infrastructure project that get bogged down in litigation?

On the upside, the potential for significant cash flow, leveraging your $800k equity, appreciation in Oakland's booming market, and the benefits of a 1031 exchange make it a bold move.

GO TO REDFIN,  SEARCH YOUR FAVORITE ZIP CODELOOK UP WHATEVER PROPERTY TYPE YOU WANT AND GO TO "SOLD" PROPERTIES WITHIN THE PAST 3 MONTHS ONLY OR EARLIER GO DOWN THE PAGE AND CLICK "DOWNLOAD ALL"IT WILL THEN PROMPT YOU TO OPEN AN EXCEL DOC- OPEN IT-FROM THERE FILTER THE PROPERTY PRICE LARGEST TO SMALLESTFIND THE AVERAGE PRICE BY HIGHLIGHTING THE ENTIRE "LIST PRICE" COLUMN OF THE SOLD PROPERTY SPREADSHEETAFTER CLICKING THE "AVERAGE" FUNCTION, YOU WILL BE GIVEN A DOLLAR AMOUNT- (BOLD THAT FIGURE) THEN GO TO THE SQUARE FEET COLUMN  AND DO THE SAME- FIND THE AVERAGE SQUARE FOOTAGE - THEN CLICK "AVERAGE" HIGHLIGHT THAT FIGURE TOODIVIDE THE AVERAGE DOLLAR AMOUNT OF ALL THE PROPERTIES SOLD WITHIN MAX 3 MONTHS FROM THE AVERAGE FIGURED SQUARE FOOTAGE TO GET YOUR MEDIAN PRICE PER SQUARE FOOTYOU WILL USE THIS FIGURE TO DETERMINE IF A PROPERTY WITHIN YOUR PREFERRED AREA CODE IS DEEPLY DISCOUNTEDTHEN, YOU WILL GO BACK TO REDFIN AND CHANGE THE SOLD TO ACTIVE AND DO ALL THE FILTERS PER YOUR PREFERENCE- "PUT IN KEYWORD AREA- "TLC" "CASH PURCHASE" , "NO FHA" AND "UNINSURED" AS WELL AS HAD A PRICE REDUCTION - EITHER MUTLTIPLE OR AT SOME POINT WHILE IT WAS LISTED HAS A REDUCTION (THIS USUALLY MEANS SELLER HAD HIS LISTING AGENT REDUCE PRICE BECAUSE HE WANTS TO SELL QUICKLY- ) SO IF A PROPERTY YOU FIND (AND THERE ARE A LOT) HAVE HAD 3 REDUCTIONS IN PRICE AND HAS BEEN LISTED FOR AWHILE...

I welcome any insights and guidance from this forum of experts as I take this bold move towards an ultimate financial freedom.

Even if a criminal trial orders restitution, the statistics are that less than 1% (one percent) ever receive money.

I haven't read any of the posted responses, I just know the statistics.

I understand there are many other criteria to analyze a property and market, and I will use all available statistics.