Thanks all all the help. The solenoid worked! I tested the v out and it reads around 24. The solenoid makes 1 click and than the water is flowing now! I do have one problem.... The solenoid itself gets pretty warm after 15 of running. The ac adapter and diodes does not get warm at all. Normal for the solenoid to get warm?
I will keep on searching for a 24vdc adapter around
until then... This will do the trick!