I look at things from two perspectives, personal finance and investment.
1. Personal Finance: This is a holistic view looking at someone's life. How steady is your income? Are you single or do you have others depending on you financially? Do you have debt? Do you have an emergency fund? Have you done your tax planning with a good accountant? Do you have a spouse or partner that needs to be involved in decisions? What kind of investment portfolio do you want to have? Stocks? Bonds? Real Estate? What percentages of each?
2. Investment: I've answered my PF questions and I know I want X risk and X return. I know how much I can invest in each category. Now I am deciding which specific property to buy. Which market? What type of property? Etc.
It is hard to give someone advice if you don't know the answers to the personal finance questions. A lot of these answers are very personal and should never be shared on a public internet forum. Do you need long term growth or income? You could find a great property for income but if you aren't looking for income then it doesn't matter. You will need a good accountant that loves tax strategy. Find someone that thinks tax strategy is more fun then Monopoly. Vet them and make sure they share how aggressive a tax strategy is. ( Aggressive tax strategy can be a red flag to the IRS.)
Assuming you have these pieces down ..... I'm selling at least one property. With out the locations, I can't say which one. Why ? San Francisco is one of the toughest markets in the country. Folks with 40 years experience are puzzled by the rent laws, taxes, population exodus?.... vs. Is it now an international city? Meaning that there will always be buyers of financial means that want to live there due to weather, beauty of the city etc etc The great news is that it is a market you know. The bad news is that it is not beginner friendly. For that reason, I would not have multiple properties. Buy a house to live in. Maybe one rental. Follow the market. Reevaluate if/when interest rates drop, more local issues get resolved etc. I would look at Washington County, OR. ( Portland. One hour flight.) Two new chip fabs sched to be built and opened in the next four years due to CHIPS money and Nividia wants to build a third with out CHIPS money. The Intel plant alone is projected to bring in additional 35,000 people and there is already a housing shortage. Classic path of progress stuff in a close-ish market.
The other option ( which could be very unpopular) is to sell both and preserve the down payment funds. Put that in a high yield savings account at 5%. In two years you have aprox one million dollars and you pay cash for a house to live in.