Explore details about location Mermaid Avenue. Mermaid Avenue is a location situated within the Kings County alongside other areas such as Pitkin Avenue, Crooke Avenue, Brooklyn-Queens Expressway.