I was born and raised in Holland, I know exactly what you're talking about. The closest you'll get is to order it from a variety of online stores that sell 'authentic' Dutch grocery items, but even those won't be exactly what you'd get on the street. I really don't know what makes the 'real' mayo so special, I have a feeling that most of that is just the memory of being on the street.
I've personally ordered from http://www.dereuzegourmetmarket.com/, they have a variety of brands to choose from (the Calve mayo in the jar is considered to be the best, the one in the tube is more some sort of mayo-y sauce with herbs, not even close to mayo). Also check out http://www.thedutchstore.com, I'd try the Remia fritesauce in the plastic bottle, that'll be close to the street variety.