Pied-à-terre

small living unit, e.g., apartment or condominium, often located in a large city and not used as an individual’s primary residence

Of course there’s a French word for this.