I know I mentioned this lens somewhere else on the forum, but now that I have it, I really can't recommend it enough! It's the Nikkor 50mm f1.8. I tell you, it kicks butt for low light situations, and it cost me under $130. For twice the price, you can get the 50mm f1.4.
There's no zoom, but that does not bother me any. I just move myself.
I put the camera on shutter priority, and set it fast enough that I don't have to worry about blur, but so that it is still getting enough light. I can take handheld photos with available/low light and it's great. It also gives you that nice soft background.
Also, it has nearly no distortion, and I have found it reproduces the colors in my paintings very well. Of course, I have the D80.
Here's a review of the lens:
http://www.photozone.de/8Reviews/len..._ais/index.htm
Here are 2 pics I took the first day I got the lens, handheld, with available light from one small, north-facing window. I could've gone even faster here.