This dress can be further customized. My maid-of-honor ordered it with extra material in order to make a scarf for covering her hair. She used the extra material and a narrow, silver, crocheted scarf to create a gorgeous head covering. The dress is technically a v-neck, but the lapels easily fold to make it tznua, as my maid of honor also did. And the skirt is actually a-line. You'd need to alter it to make it mermaid as shown in the picture. Since the dress is two pieces, the top can be worn with a different skirt and the skirt can be worn with a different top so it doesn't look "bridesmaidy" after one's a bridesmaid.
This dress is also available in white, so it could even be worn as a bridal dress. And, since the dress is two pieces, the top could be reworn with other skirts to other functions!
This dress probably currently retails for about $300. My bridesmaids paid $260 minus 10% six years ago.