Just did a search for snake charmer tune and got this page.

"The song was introduced to the collective consciousness of the American public over a century ago by Sol Bloom, a show business promoter who later became a U.S. Congressman. Bloom was the entertainment director of the Chicago World's Columbian Exposition of 1893, which was celebrating the 400th anniversary of Christopher Columbus' discovery of the New World. One of its attractions, called A Street In Cairo, included snake charmers, camel rides, the infamous dancers that later spawned the legend of Little Egypt, and other exciting things to entertain turn-of-the-century fair-goers. In his prestigious role, he made more money than the President of the United States – $1,000 a week.

In his autobiography, Bloom claimed that he improvised the melody on the piano at a press briefing in 1893 to introduce Little Egypt."

There's a lot more there, including the original lyrics to Streets of Cairo:

Streets Of Cairo or The Poor Little Country Maid (words by James Thornton)

Verse 1

I will sing you a song,
And it won't be very long,
'Bout a maiden sweet,
And she never would do wrong,
Ev'ryone said she was pretty,
She was not long in the city,
All alone, oh, what a pity,
Poor little maid.
Chorus

She never saw the streets of Cairo,
On the Midway she had never strayed,
She never saw the kutchy, kutchy,
Poor little country maid.
Verse 2

She went out one night,
Did this innocent divine,
With a nice young man,
Who invited her to dine,
Now he's sorry that he met her,
And he never will forget her,
In the future he'll know better,
Poor little maid.
Chorus

She never saw the streets of Cairo,
On the Midway she had never strayed,
She never saw the kutchy, kutchy,
Poor little country maid.
        Streets of Cairo Sheet Music Cover
Verse 3

She was engaged,
As a picture for to pose,
To appear each night,
In abbreviated clothes,
All the dudes were in a flurry,
For to catch her they did hurry,
One who caught her now is sorry,
Poor little maid.
Chorus

She was much fairer far than Trilby,
Lots of more men sorry will be,
If they don't try to keep way from this
Poor little country maid.