I've reported these limitations to developers at Wolfram, so that they can be addressed:

• The provinces are actually interpreted as cities with SemanticImport (Ontario, California and Quebec City)
• The geo positions are not correct

Here is a solution which should overcome the limitation of SemanticImport you are running into. First Import the file as CSV:

csv = Import["out.csv"]

Convert it to a Dataset:

dataset = Dataset[Map[AssociationThread[StringTrim /@ First[csv], #] &, Rest[csv]]]

Define handlers for each column type:

handler["City", assoc_] := (Interpreter["City"][assoc["City"]]);
handler["Amount", assoc_] := assoc["Amount"];
handler["Sold", assoc_] := (Interpreter["Date"][assoc["Sold"]]);
handler["Province", assoc_] := (Interpreter["AdministrativeDivision"][assoc["Province"]]);
handler["Loc", assoc_] := Module[{loc = assoc["Loc"], lat, long},
  {lat, long} = StringSplit[loc];
  lat = StringReplace[lat, {"N" -> "+", "S" -> "-"}];
  long = StringReplace[long, {"W" -> "-", "E" -> "+"}];
  GeoPosition[ToExpression /@ {lat, long}]
  ];
handler["Dist", assoc_] := (Interpreter["Quantity"][assoc["Dist"]]);

Call the dataset with the handlers (and renaming "Loc" to "Location" and "Dist" to "Distance"):

dataset[All, Association[{
  "City" -> handler["City", #],
  "Amount" -> handler["Amount", #],
  "Sold" -> handler["Sold", #],
  "Province" -> handler["Province", #],
  "Location" -> handler["Loc", #],
  "Distance" -> handler["Dist", #]
  }] &]

Correct, or almost: there are spaces between N45 and W108, 8 and meters, and so on.

But how did you preserve the carriage returns in your posting? I tried to copy your post and past it into my current reply, and once again, "Community" stripped my carriage returns so all your text appeared on one line.

So this is the sample input?

City,Amount,Sold,Province,Loc,Dist 
Toronto,2000.00,27?Mar?2014,Ontario,N45 W108,8 meters
Montreal,5000.00,18-Apr-2014,Quebec,N46.6 W103.5,12 meters