OK...here is the problem. The LON and LAT values were switched. I got that corrected but then still had the same problem.
Then I found out what is causing this. The Canadian postal codes are 6 characters. The classifieds only allows 5 characters. When I enter the 6 character code, the classifieds software truncates it and deletes the last character. I changed one of the Canadian codes to a 5 character code by simply deleting the final character and then it works correctly. Mileage was displayed in the listing. The database field IS a 6 character string.
So my question is WHERE to I change the Classifieds software so that it allows 6 characters for the postal code. I found values of 5 for zipcode length in the uploadproduct template and the editproduct templates. I changed both of those to 6 but it is still changing it to 5 characters when I submit an ad. So where do I change it?