I suspect there could be some truth behind Melanies claims based on that thread..

I currently work remotely as a Manufacturing and Quality Manager for an AI infrastructure company based out of the Bay Area. 

But from what I've observed (and I'm sure you've seen too), only a few new investors, who are more analytical in nature, do this.One of the issues that I've seen again and again is new investors putting together a "spreadsheet" based on their limited understanding, that produces inaccurate or misleading numbers.

Does anyone have any tips/ advice to help make sure my property will appraise for what I planned on based on my rehab?

Spending on expensive upgrades is not the answer to improve your tenant base in this type of area.Keep the homes habitable, clean, and safe. 

I am based out of the Santa Rosa Century 21 Office but I cover all of Sonoma County and beyond.My very first purchase was a Duplex where I lived in one unit and rented out the other for rental income.

Based on our 1031 and commercial loan, we are trying to figure out how to separate out some of the duds.

Also offers contingency based collection but price was not obvious. - AOA Debt Reporting Service: letter sent w 120 days to pay (with credit bureau reporting) after which it rolls over contingency plan with collection agency getting 38%.I know I would not want the task for what they charge.  

These loans are short-term, asset-based, and designed for situations like yours.

How to Price the Condos: Do a reverse amortization schedule for a 30-year mortgage based on Room Rental Prices in the Area.