I have been tested for all STD's and fortunately I have none. He supposedly wore a condom on all of his occasions, 5 total (that I know of)
You need to get retested for AIDS in 6 months just to be sure. And I wouldn't sleep with him again until you see his test results too (don't just take his word for it). The odds that he faithfully used condoms every time are probably slim; people who engage in such risky behaviors usually aren't thinking about safety at the same time, or they wouldn't be there in the first place.
That's great that he signed the house over to you. Think carefully before you sell it; if you sell it now, will any equity from it become a shared marital asset? Might be better to sell it after a separation agreement is in place, so that all the money will be sure to go to you. Get legal advice.
Could it be temporary insanity? Maybe. Is this really out of character for him, or were here signs all along that he wasn't the most honest family guy? Did he always flirt with other women? Were there previous affairs? Is there a family history of clinical depression or bipolar disorder?
But I think temporary or not, your actions need to be the same. You need to be very clear on what it would take for him to win you back, and not settle for anything less. DO NOT take him back unless he is getting treatment for his problems, totally owning that HE screwed this up, dealing with his gambling issue, showing true remorse, and giving you complete and utter transparency (phone records access, etc.). This is for HIS own good - if you take him back without requiring those things he'll never get the help he so obviously needs.