Apron front sinks are not often specified in modern looking kitchens.
They usually end up in a more traditional setting. They have often been known as Farm Sinks. They come in a variety of materials (i.e. granite, soapstone, porcelain, stainless) Unless you really like the look and want to see the façade of the sink, you can eliminate this style.