Can a dense part of a city be completely free of privately owned automobiles

What would be the effect on mobility & carbon emissions if a dense part of a city was completely free of privately owned cars? All transport to be done with sharing systems. How could real estate contribute to this concept.