Selling a home with a low interest rate in order to purchase a home in cash?

Purchased home in Southern California with an interest rate of 2.875%. Home is now valued at ~ $840,000, could realistically walk away with high 300’s to low 400’s if I were to sell thanks to a large downpayment + appreciation. Mortgage + HOA is ~$3100. Market rent for this area would be ~$3750-$4000 a month.

Recently a job opportunity came up (same company, same role, same pay, benefits etc.) in a city that would put me much closer to home. (1 hour vs 9 hours). The cost of living and housing in general is also much lower than Southern California. For reference, most homes (new & older) in this city are selling between the low 400’s to low 600’s.

I’ve been pondering the idea of selling my home in Southern California in order to purchase a home outright in cash in this new city. The thought of no longer having a mortgage payment (or a very small one) sounds amazing. However, knowing that I will also probably never see a mortgage rate of 2.875, causes me to reconsider that idea. Any thoughts?