I’ve been involved with seeking a special exception as a zoning variance, to allow an equestrian center to continue to function as a business, in that location. Not a problem. My home has a non-conforming use that came with the property.
A couple of things- first, make the purchase contingent on obtaining favorable zoning- be very specific with your language, and second, hire whoever the big gun attorney is who gets it done in that town. Adjust the purchase price accordingly.
It can be done, but be sure that it is really what you want.