Small business real estate loan, sole proprietor...?

My husband wants to invest some of his business profits in real estate. If he's a sole proprietor, what type of loan? Will everything be in his name or the business' name? Any info on this? I am confused. Thanks