I live in a neighborhood that has a couple of "upscale" supermarkets nearby. So we get our perishables there, and any last-minute need, by bike.

Every few weeks, we load up the car with all of the non-perishables, at a huge discount supermarket that's a few miles away.

Seems like an OK compromise.