There's no such camera that has been invented. If you want the long zoom then you'll have to give up the "works well in low light conditions" and "has low noise". You could get those, but you'd have to get a camera with little amounts of zoom.
Looking to buy a new camera that will:
*have a long zoom
*work well in low light conditions
*have low noise
*costs under $500