Mortgage for commercially designated property

We’re thinking of putting an offer on a commercially designated property which has been used as a residence for several decades. Does anyone have any experience with something like this? Our limited information is that either the current owner has to change the designation or else we get a commercial mortgage for our possible home but I’m wondering if there is another way.