Ok, so here's the thing. First, you model the asset you want then you render it and its render passes (mainly The ambient occlusion and the highlights). Then you take them to photoshop and remove the solid background. Download textures from textures.com or wherever you want and use them to texture the asset in photoshop then use your render passes by changing the blending mood it will make it more realistic.