This is marked as 'for parts or not working' because the second half of the power cord is missing. I'm not sure what type of cord it is, but it looks fairly common and I'm sure it could be easily found.

There's some signs of wear on the underside of where the water comes out, other than that it is in great physical condition.

I do not know if it works, I'm not able to test it because I don't have the second half of the cord that plugs into the wall. It looks like the parts to the water pump are there.

This is a desktop light up fountain/waterfall decor art piece.