I have never used a sand filter on an aquarium but I do have one on my swimming pool (18" Hayward sand filter with a 1.5hp pump). After having worked with a swimming pool DE filter on my aquarium I will be changing my swimming pool filter over to a DE filter. The DE filters do a much better job and filter out much smaller particles. Sand filters require constant back washing to keep them flowing. During the summer I have to back wash my sand filter every day or two. I would estimate that every back wash takes about 30 to 40 gallons of water.
I love the Hayward EC40 DE swimming pool filter that I use on my aquarium. My tank water is always perfectly clear and it is the lowest maintenance aquarium filter I have ever used. The EC40 is also very affordable (There is a link to the amozon vendor I bought mine from in my signature). My EC40 started on my crowded 110g tank. That tank sprang a slow leak so now I am using it on my little 35 hex tank.
When I had the EC40 on my 110 I used a good quality efficient 1/8hp mag drive external pump. This gave me all the flow I could ever need for my 110g. On my 35 I use the EC40 with a little QuietOne 3000 pump. The EC40 was designed to be used with a 1hp - 2hp pool pump. My biggest concern was that it would not work properly with a small pump. It does work very well with a small pump. Even the QuietOne 3000 has plenty of flow to coat the filter screens in the EC40 with the DE powder (DE powder is very fine).
The sand pool you linked to looks like it uses a pretty cheap 1/4hp direct drive pump. The impeller shaft seal on direct drive pumps are usually a source of leakage problems. When the pump is outside running on a swimming pool a little leakage doesn't hurt anything. I would also fear the efficiency of that pump. Cheap motors in cheap pumps suck a lot of electricity.
Here is a picture of the EC40 on my temporary 35g hex setup.

The horizontal handle on the top of the filter is to knock the DE powder off of the internal filter screens to regenerate it. About once a week a shut off the pump, pump this handle a couple of times then plug the pump back in. I am now over a year on the initial charge of the DE powder.
The QuietOne 3000 is submersed in the sump. Since you don't want a sump you could easily run an external pump and go directly from the tank to the pump then through the EC40 and back into the tank. I ran this configuration for a few months on my 110g and it worked very well. You will need some sort of in tank prefilter to keep the fish from being sucked into the filter. This one was cheap and available at home depot in their pond department:
There is a link to my build thread in my signature.
