'Hozelock' Cascade 700 submersible pond pump - see Hozelock product details here for applicable uses - https://www.hozelock.com/product/cascade-2/
Mains supply (11 metres of cable) but it doesn't have the fountain stem, but this can be ordered as a spare part.
Can be delivered by arrangement in the Craven Arms, Ludlow, Wigmore, Leintwardine & Bucknell areas.
Submersible pond aeration / fountain pump (Bucknell SY7)
This offer has been gifted to someone and is no longer available.