Over the years, I have gotten work from Deviantart [way back] and from here on the Guild.
I can't say I have gotten any work from the social media sites, per se, though I have connected with a lot of people in the industry from being on them.
The best results I have had are from artstation.
I'm still on twitter, but there are a lot of people who claim they are leaving any day now.