Are you looking to purchase a 3d application? If so, and your interested in Maya, you can get a fee learning edition from www.autodesk.com. It's called Maya PLE.
Like gster123 hinted at, most users on this forum use Maya for modeling and Photoshop for texturing.
Don't be satisfied with what you can do but rather strive to do the things you can't do!
Exceed Expectations!