Your problem is not the usual one - no windows working at the local switch. Remove the door panel and see if you have voltage at the switch. If so, make sure the voltage gets to the motor. If it does, make sure the motor is grounded. You'll likely find a broken wire in the boot at the door hinge.

 

Well apparently the problems likes in the wire loom for the driver side rear door, because I did the ol'wiggle test and it worked like a charm..so I guess I will tear into that sometime, but at least the headache of it is gone now.