Elton will make an appearance at Carlisle United's Brunton Park on Sunday, June 3.
Fifteen thousand tickets go on sale on Tuesday with demand certain to be unprecedented for any gig ever staged in Cumbria.
Uniteds sales and marketing manager Tom Johnstone said: People cannot believe it. They feel this is a tremendous coup for the club and city. The reaction has been great. The telephones have been on meltdown.
Marshall Arts (the concert promoters) have been delighted by the reaction. It has all been very positive.
Negotiations to bring Sir Elton to Carlisle were started by United director Dick Young two years ago after he realised Brunton Parks potential to hold not just football games.
Elton a keen football fan and life president of Premiership side Watford will also play Home Park, Plymouth Argyles ground, on Saturday, May 26.
Johnstone added: Elton is in great demand. He only does a certain number of shows every year and a lot of people want him. He loves playing to football crowds and in football stadiums.
Tickets, priced £60, £40 and £30, for the all-seated show will go on general sale by telephone from 9 a.m. Tuesday, limited to six per person. They will also be available from the Sands Centre in Carlisle, with personal and telephone applications accepted.
Although no tickets will be available from Brunton Park, a priority scheme will enable Carlisle United season-ticket holders and members of the Blues Lottery, Premier Club, supporters club and its London branch to buy tickets until Monday.
About 10,000 seats will be installed on the pitch, with other spectators in the two stands. The stage will be towards the Petteril End of the stadium. The show, which will also feature the singer's band, is expected to last more than two hours.
The Brunton Park gig will offer United the chance to cash in on lucrative hospitality and catering packages. A limited number of premium tickets will also be available.
The concert is subject to a licence being approved by Carlisle City Council, which has been involved in negotiations.