Overflow only, like-new condition. Works with a sump or aquaponics system if you have a tank you don't want to drill. You can attach an Aqualifter style pump to make sure the siphon never breaks. These have good reviews and work well as far as I know but for full disclosure I never got around to setting it up.