Generally speaking, you won't find photorealistic textures for free. They take too much work. If you're willing to spend money, though, there are very realistic textures in the store. For free textures, check out Vali's. Though it's best to check early in the month, before her bandwidth is exceeded.