We had one, but returned it within the 90 day limit because it started to break. Ours didn't come from Costco, and I can't pull up the picture because my net sucks.
The fabric started to peel off in places - like from the sun - and in other places, it faded majorly. In ours, the hose attached, and water sprayed over 2 separate slides, and in the middle, in the pool area... The middle spout worked just fine, but the 2 over the slides were both broken, one of them within the 1st week.
It was really ridiculous. We spent over $300 on it, and expected it to last more than one summer.
It would need to be moved frequently so that it didn't damage the grass. The grass would get extremely soggy after one use.
I don't know that I'd want to use it on concrete, only because my kids would get out, run and get something and then run back, and the concrete would be soaked - slipping hazard.
But it would definitely need to be moved frequently on grass.