Unfortunately, with no current income, and a lower credit score, even having a good down payment and no debts is not going to make you appear to be a good risk from an underwriting standpoint. There are a coupe of programs for 1st time buyers, and FHA is stlil the least expensive option as far as down payments go, but your husband really needs to find employment in his field. Even with a short time off, as long as he has at least 2 years employment in the current auto repair field, is pretty much a necessity. A job change to something totally new would start the clock over.
You didn't mention if you are first time homebuyers, or haven't had a home for at least 3 years. That info would help.
Contact a qualified realtor for the McKinney area and see what he or she says. I am not very familiar with that area, working in west Frisco mostly, but there should be answers from others who could advise you.
Randy Spain, Realtor
Dont think you should be buying a home considering he is unemployed and you do not work. You won't get a loan anyways, but that mentality is not a smart one.
Also you want to focus on raising your credit score so you can get a better rate.