Not sure I can offer any help, but if you need advice or direction, I'm happy to help if I can.

I'd go on ABnB and see what your competition is doing that you can copy.Maybe a Firepit out front (as long as it's not a fire hazard), maybe a cornhole set?

I offered to buy the property from the $28B foreign company which kept them from having to tear down the buildings to mitigate the vagrant problem and also from their obligation to pay the rail road for the long term lease.

Local banks typically offer lower interest rates but might require a solid track record and detailed financials.

Assuming the Oakland rental market continues to remain stagnant/competitive with newer buildings going up, is property appreciation the only way to increasing wealth with my building?

I couldn’t tell you what rates are today but I assume they are competitive.

They don't all offer the same servicers (default management, document services, tracking of taxes and insurance, escrows, etc.), but I am with you that communication and competency are key.

Keep in mind local zoning laws and market conditions in Portland versus Salem—Portland might offer higher rents but stricter regulations, while Salem could provide better cash flow opportunities.Your design approach has proven successful, so continue focusing on appealing upgrades like kitchens and bathrooms, but prioritize cost-effective and durable materials for rentals.

You could offer 6 months of guidance and help to the new owners if they are noobs to STR.

I’d recommend starting by researching markets that align with your strategy, especially areas that offer good cash flow.