A guy helped me out paying me to clean his house. I ended up saying that when I come over I feel its more a work level, not social. He says since I don't find it social no need for me to paint. You really know how to kill a vibe. I was being honest. HELP?

He may have been offended by your downgrading your arrangement especially  if you had a social 'relationship' before hand.  Even though he was helping you out by paying you for your services .. He (by the sound of his comments) was enjoying having the company, and was offended by you making a  point to remove any level of social connection.

Was he being inappropriate at the time  when you felt compelled put him in his place .. By being so honest?  I am confused why that would even come to a point where you would feel the need to deflate him.

Nothing wrong with having a balance social/professional arrangement for such a part time endeavor.  You are not a formal employee .. You could plausibly just be two friends helping each other out.

Were you painting his house too?

It might be that right now he considers your lack of job more important than socially hanging out with you. If you were to say to him that you're had several leads and things look promising, then he might believe that things are turning around for you.

You could simply ask him if you guys could hang out together without a project to complete.