The Mermaid Inn
Upscale-casual seafood spot with a Cape Cod vibe known for its lobster rolls and cheap oyster deal.
Sources & updates
How this name was decided
the site's published name — stated on themermaidnyc.com, data.ny.gov
Names weighed and not chosen
- Also declared in the site's markup: Mermaid Oyster Bar </br> Greenwich Village — themermaidnyc.com
- Also declared in the site's markup: Mermaid Oyster Bar </br> Midtown — themermaidnyc.com
- Also declared in the site's markup: The Mermaid Inn </br> Chelsea — themermaidnyc.com
- Also declared in the site's markup: The Mermaid Inn </br> Upper West Side — themermaidnyc.com
Profile sources
- Facebookdeclared on themermaidnyc.com
- Instagramdeclared on themermaidnyc.com
- Last observed
- Oct 23, 2026, 11:44 AM UTCRecent
- Record last changed
- Oct 23, 2026, 11:44 AM UTC
- Observations
- 595
- Sources read
- 27 of 27
Legal Entities & Relationships
335 COLUMBUS LLCLicensed operator of 1 of its locations
data.ny.gov
Legal entities
335 COLUMBUS LLC Licensed operator of 1 of its locations · NY · NY DOS 6648890
- Type
- DOMESTIC LIMITED LIABILITY COMPANY
- Filed
- Nov 21, 2022
- Premises
- 1 licensed premises of this record
Parties as filed
- C/O GOLENBOCK EISEMAN ASSOR BELL & PESKOE LLP (DOS PROCESS)
The authority's own record of the operating entity, reached by searching its register for the licence-proven operator's exact legal name and keeping only the same registration; owners and titles are as filed, not a current cap table.
View registration recordPublished by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://data.ny.gov/resource/n9v6-gdp6.json?%24limit=100&%24offset=0&%24order=initial_dos_filing_date+DESC%2C%3Aid&%24where=UPPER%28current_entity_name%29+IN+%28%27335+COLUMBUS+LLC%27%2C%27335+COLUMBUS%2C+LLC%27%2C%27335+COLUMBUS+L.L.C.%27%2C%27335+COLUMBUS%2C+L.L.C.%27%2C%27335+COLUMBUS+LIMITED+LIABILITY+COMPANY%27%2C%27335+COLUMBUS%2C+LIMITED+LIABILITY+COMPANY%27%2C%27335+COLUMBUS+LIMITED+LIABILITY+CO%27%2C%27335+COLUMBUS%2C+LIMITED+LIABILITY+CO%27%29 → licence-proven operator 335 COLUMBUS LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+UPPER+WEST+SIDE%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27335+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27335-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-335+%25%27%29+AND+UPPER%28actualaddressofpremises%29+LIKE+%27%25COLUMBUS%25%27%29%29+AND+%28UPPER%28city%29%3D%27NY%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710023%25%27%29
- About
- 335 COLUMBUS LLC, the licensed operator of its premises
- Read from
- https://data.ny.gov
- Interpreted by rule
- legal-entities/1
- Evidence ID
- legal-entity:44d038f383e35569c763008b
All published fields
- Scope
- The authority's own record of the operating entity, reached by searching its register for the licence-proven operator's exact legal name and keeping only the same registration; owners and titles are as filed, not a current cap table.
- Reached
- legal_name_search
- Premises
- 86527fb7afd6733c2ba4e1f89878e1bcc76438b513189dd0a62d7d46934e4e51
- Legal Name
- 335 COLUMBUS LLC
- Jurisdiction
- NY
- Registration
- Kind
- business_license
- Type
- DOMESTIC LIMITED LIABILITY COMPANY
- Number
- 6648890
- Parties
- Name
- C/O GOLENBOCK EISEMAN ASSOR BELL & PESKOE LLP
- Role
- DOS PROCESS
- Licensee
- 335 COLUMBUS LLC
- Authority
- NY_DOS
- Source id
- ny_dos_business
- Issued date
- 2022-11-21
- Observed at
- 2026-10-23T11:44:12.516790409Z
- Jurisdiction
- NY
MERMAID CHELSEA LLCLicensed operator of 1 of its locations
data.ny.gov
Legal entities
MERMAID CHELSEA, LLC Licensed operator of 1 of its locations · NY · NY DOS 5296392
- Type
- DOMESTIC LIMITED LIABILITY COMPANY
- Filed
- Mar 2, 2018
- Premises
- 1 licensed premises of this record
Parties as filed
- MERMAID CHELSEA, LLC (DOS PROCESS)
The authority's own record of the operating entity, reached by searching its register for the licence-proven operator's exact legal name and keeping only the same registration; owners and titles are as filed, not a current cap table.
View registration recordPublished by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://data.ny.gov/resource/n9v6-gdp6.json?%24limit=100&%24offset=0&%24order=initial_dos_filing_date+DESC%2C%3Aid&%24where=UPPER%28current_entity_name%29+IN+%28%27MERMAID+CHELSEA+LLC%27%2C%27MERMAID+CHELSEA%2C+LLC%27%2C%27MERMAID+CHELSEA+L.L.C.%27%2C%27MERMAID+CHELSEA%2C+L.L.C.%27%2C%27MERMAID+CHELSEA+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+CHELSEA%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+CHELSEA+LIMITED+LIABILITY+CO%27%2C%27MERMAID+CHELSEA%2C+LIMITED+LIABILITY+CO%27%29 → licence-proven operator MERMAID CHELSEA LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29
- About
- MERMAID CHELSEA LLC, the licensed operator of its premises
- Read from
- https://data.ny.gov
- Interpreted by rule
- legal-entities/1
- Evidence ID
- legal-entity:daea98e76aee530e2108e5f8
All published fields
- Scope
- The authority's own record of the operating entity, reached by searching its register for the licence-proven operator's exact legal name and keeping only the same registration; owners and titles are as filed, not a current cap table.
- Reached
- legal_name_search
- Premises
- 6cea044663f02e133f924f10674dd849f290b23301e59e5ba4b44444d21e8719
- Legal Name
- MERMAID CHELSEA, LLC
- Jurisdiction
- NY
- Registration
- Kind
- business_license
- Type
- DOMESTIC LIMITED LIABILITY COMPANY
- Number
- 5296392
- Parties
- Name
- MERMAID CHELSEA, LLC
- Role
- DOS PROCESS
- Licensee
- MERMAID CHELSEA, LLC
- Authority
- NY_DOS
- Source id
- ny_dos_business
- Issued date
- 2018-03-02
- Observed at
- 2026-10-23T11:44:12.328526717Z
- Jurisdiction
- NY
Federal Awards
Award collection evidence
USAspending loans, grants and direct payments since FY2008. Contracts and subawards excluded. Reported loan value, subsidy, award amount and outlays are distinct; no original principal, forgiveness or current debt is inferred.
searched under licence-proven operator MERMAID TIMES SQUARE LLC: none; searched under licence-proven operator MERMAID CHELSEA LLC: 3 found; searched under licence-proven operator 335 COLUMBUS LLC: none
MERMAID CHELSEA, LLC Recipient · NEW YORK, NY
- Address
- 227 TENTH AVENUE · NEW YORK, NY, 10011 · USA
- Business types
- category business, small business
- Recipient ID
- b6f4702b-d91d-31f7-9c7a-f9535b695978-R
- Recipient level
- R
Published by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://api.usaspending.gov/api/v2/recipient/b6f4702b-d91d-31f7-9c7a-f9535b695978-R/ → licence-proven operator MERMAID CHELSEA LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29 → https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29
- About
- MERMAID CHELSEA LLC, the licensed operator of its premises
- Read from
- https://api.usaspending.gov
- Interpreted by rule
- federal-awards-v2
- Evidence ID
- usaspending-recipient:42c5b8c12fc22283adf78ad0
All published fields
- Name
- MERMAID CHELSEA, LLC
- Address
- City
- NEW YORK
- State
- NY
- Country
- USA
- Postal Code
- 10011
- Address Line1
- 227 TENTH AVENUE
- Address Line2
- 227 TENTH AVENUE
- Recipient ID
- b6f4702b-d91d-31f7-9c7a-f9535b695978-R
- Business Types
- category_business, small_business
- Recipient Level
- R
MERMAID CHELSEA, LLC Guaranteed/insured loan$201,000 loan value
- Agency
- Small Business Administration
- Award ID
- 3960727206
- Assistance listing
- 59.073
- Searched name
- MERMAID CHELSEA LLC
- Reported loan value (USD)
- $201,000
- Reported subsidy cost (USD)
- $204,457.20
TO AID SMALL BUSINESSES IN MAINTAINING WORK FORCE DURING COVID-19 PANDEMIC.
View federal awardPublished by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://api.usaspending.gov/api/v2/search/spending_by_award/ → licence-proven operator MERMAID CHELSEA LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29 → https://api.usaspending.gov/api/v2/recipient/b6f4702b-d91d-31f7-9c7a-f9535b695978-R/ → https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29
- About
- MERMAID CHELSEA LLC, the licensed operator of its premises
- Read from
- https://api.usaspending.gov
- Interpreted by rule
- federal-awards-v2
- Evidence ID
- usaspending:4e9b38a71da700d2e1b7d352
All published fields
- Group
- loans
- Award ID
- 3960727206
- Award Type
- GUARANTEED/INSURED LOAN (F)
- Description
- TO AID SMALL BUSINESSES IN MAINTAINING WORK FORCE DURING COVID-19 PANDEMIC.
- Recipient ID
- b6f4702b-d91d-31f7-9c7a-f9535b695978-R
- Recipient Name
- MERMAID CHELSEA, LLC
- Awarding Agency
- Small Business Administration
- Generated award ID
- ASST_NON_3960727206_073
- Queried Legal Name
- MERMAID CHELSEA LLC
- Awarding Sub Agency
- Small Business Administration
- Reported loan value (USD)
- 201,000
- Reported subsidy cost (USD)
- 204,457.2
- Assistance listing
- 59.073
MERMAID CHELSEA LLC Recipient · NEW YORK, NY
- Address
- 227 10TH AVE · NEW YORK, NY, 10011 · USA
- Business types
- category business, small business
- Recipient ID
- a9924cfd-34f0-f201-6ac3-024b9cb2be90-R
- Recipient level
- R
Published by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://api.usaspending.gov/api/v2/recipient/a9924cfd-34f0-f201-6ac3-024b9cb2be90-R/ → licence-proven operator MERMAID CHELSEA LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29 → https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29
- About
- MERMAID CHELSEA LLC, the licensed operator of its premises
- Read from
- https://api.usaspending.gov
- Interpreted by rule
- federal-awards-v2
- Evidence ID
- usaspending-recipient:276fe2097674af4a73fdfb53
All published fields
- Name
- MERMAID CHELSEA LLC
- Address
- City
- NEW YORK
- State
- NY
- Country
- USA
- Postal Code
- 10011
- Address Line1
- 227 10TH AVE
- Address Line2
- 227 10TH AVE
- Recipient ID
- a9924cfd-34f0-f201-6ac3-024b9cb2be90-R
- Business Types
- category_business, small_business
- Recipient Level
- R
MERMAID CHELSEA LLC Guaranteed/insured loan$31,010 loan value
- Agency
- Small Business Administration
- Award ID
- 4051718708
- Assistance listing
- 59.073
- Searched name
- MERMAID CHELSEA LLC
- Reported loan value (USD)
- $31,010
- Reported subsidy cost (USD)
- $32,157.37
TO AID SMALL BUSINESSES IN MAINTAINING WORK FORCE DURING COVID-19 PANDEMIC.
View federal awardPublished by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://api.usaspending.gov/api/v2/search/spending_by_award/ → licence-proven operator MERMAID CHELSEA LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29 → https://api.usaspending.gov/api/v2/recipient/a9924cfd-34f0-f201-6ac3-024b9cb2be90-R/ → https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29
- About
- MERMAID CHELSEA LLC, the licensed operator of its premises
- Read from
- https://api.usaspending.gov
- Interpreted by rule
- federal-awards-v2
- Evidence ID
- usaspending:777fcebeb16a46a932f4a538
All published fields
- Group
- loans
- Award ID
- 4051718708
- Award Type
- GUARANTEED/INSURED LOAN (F)
- Description
- TO AID SMALL BUSINESSES IN MAINTAINING WORK FORCE DURING COVID-19 PANDEMIC.
- Recipient ID
- a9924cfd-34f0-f201-6ac3-024b9cb2be90-R
- Recipient Name
- MERMAID CHELSEA LLC
- Awarding Agency
- Small Business Administration
- Generated award ID
- ASST_NON_4051718708_073
- Queried Legal Name
- MERMAID CHELSEA LLC
- Awarding Sub Agency
- Small Business Administration
- Reported loan value (USD)
- 31,010
- Reported subsidy cost (USD)
- 32,157.37
- Assistance listing
- 59.073
MERMAID CHELSEA LLC Direct payment for specified use$89,584 award
- Agency
- Small Business Administration
- Award ID
- 9992289003
- Assistance listing
- 59.078
- Searched name
- MERMAID CHELSEA LLC
- Reported award amount (USD)
- $89,584
- Reported total outlays (USD)
- $89,584
RESTAURANT REVITALIZATION FUND
View federal awardPublished by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://api.usaspending.gov/api/v2/search/spending_by_award/ → licence-proven operator MERMAID CHELSEA LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29 → https://api.usaspending.gov/api/v2/recipient/a9924cfd-34f0-f201-6ac3-024b9cb2be90-R/ → https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29
- About
- MERMAID CHELSEA LLC, the licensed operator of its premises
- Read from
- https://api.usaspending.gov
- Interpreted by rule
- federal-awards-v2
- Evidence ID
- usaspending:b282156d777d62f22c3d0556
All published fields
- Group
- direct_payments
- Award ID
- 9992289003
- Award Type
- DIRECT PAYMENT FOR SPECIFIED USE, AS A SUBSIDY OR OTHER NON-REIMBURSABLE DIRECT FINANCIAL AID (C)
- Description
- RESTAURANT REVITALIZATION FUND
- Recipient ID
- a9924cfd-34f0-f201-6ac3-024b9cb2be90-R
- Recipient Name
- MERMAID CHELSEA LLC
- Awarding Agency
- Small Business Administration
- Generated award ID
- ASST_NON_9992289003_073
- Queried Legal Name
- MERMAID CHELSEA LLC
- Awarding Sub Agency
- Small Business Administration
- Reported award amount (USD)
- 89,584
- Assistance listing
- 59.078
- Reported total outlays (USD)
- 89,584
Litigation
Sostre v. Mermaid Chelsea, LLC District Court, S.D. New York · Filed Oct 16, 2024
- Docket
- 1:24-cv-07867
- Filed
- Oct 16, 2024
- Terminated
- Jan 27, 2025
- Matched party
- Mermaid Chelsea, LLC
- Searched name
- MERMAID CHELSEA LLC
Nature Of Suit
Civil Rights: Other
Cause
42:2000e-2e Job Discrimination (Unlawful Employment Practices)
Exact party-name match in CourtListener; not an independently resolved legal identity, finding of wrongdoing or litigation outcome.
View court docketPublished by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://www.courtlistener.com/api/rest/v4/search/?order_by=dateFiled+desc&q=party%3A%22MERMAID+CHELSEA+LLC%22&type=d → licence-proven operator MERMAID CHELSEA LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27THE+MERMAID+INN+CHELSEA%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27227+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27227-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-227+%25%27%29+AND+%28UPPER%28actualaddressofpremises%29+LIKE+%27%2510%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25TENTH%25%27%29%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710011%25%27%29
- About
- MERMAID CHELSEA LLC, the licensed operator of its premises
- Read from
- https://www.courtlistener.com
- Interpreted by rule
- court-dockets-v2
- Evidence ID
- courtlistener:795f6680aa03c325efa3cb5e
All published fields
- Cause
- 42:2000e-2e Job Discrimination (Unlawful Employment Practices)
- Court
- District Court, S.D. New York
- Court ID
- nysd
- Case Name
- Sostre v. Mermaid Chelsea, LLC
- Docket ID
- 69270346
- Date Filed
- 2024-10-16
- Match scope
- Exact party-name match in CourtListener; not an independently resolved legal identity, finding of wrongdoing or litigation outcome.
- Docket number
- 1:24-cv-07867
- Nature Of Suit
- Civil Rights: Other
- Other Parties
- Sostre
- Date Terminated
- 2025-01-27
- Matched Party Name
- Mermaid Chelsea, LLC
- Queried Legal Name
- MERMAID CHELSEA LLC
- Other Parties Scope
- Each is a party to the case, as the docket search names it: no side is stated for any party, no relation to this company is inferred, and none was searched in turn.
MERMAID TIMES SQUARE LLCLicensed operator of 1 of its locations
data.ny.gov
Legal entities
MERMAID TIMES SQUARE LLC Licensed operator of 1 of its locations · NY · NY DOS 6262077
- Type
- DOMESTIC LIMITED LIABILITY COMPANY
- Filed
- Aug 18, 2021
- Premises
- 1 licensed premises of this record
Parties as filed
- golenbock eiseman assor bell & peskoe llp (DOS PROCESS)
The authority's own record of the operating entity, reached by searching its register for the licence-proven operator's exact legal name and keeping only the same registration; owners and titles are as filed, not a current cap table.
View registration recordPublished by a third-party source · confirmed Oct 23, 2026, 11:44 AM UTC
- Observed via
- https://data.ny.gov/resource/n9v6-gdp6.json?%24limit=100&%24offset=0&%24order=initial_dos_filing_date+DESC%2C%3Aid&%24where=UPPER%28current_entity_name%29+IN+%28%27MERMAID+TIMES+SQUARE+LLC%27%2C%27MERMAID+TIMES+SQUARE%2C+LLC%27%2C%27MERMAID+TIMES+SQUARE+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE%2C+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+CO%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+CO%27%29 → licence-proven operator MERMAID TIMES SQUARE LLC on https://data.ny.gov/resource/9s3h-dpkz.json?%24limit=100&%24offset=0&%24order=expirationdate+DESC%2C%3Aid&%24where=%28UPPER%28dba%29%3D%27MERMAID+OYSTER+BAR+TIMES+SQUARE%27+OR+%28%28UPPER%28actualaddressofpremises%29+LIKE+%27127+%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27127-%25%27+OR+UPPER%28actualaddressofpremises%29+LIKE+%27%25-127+%25%27%29+AND+UPPER%28actualaddressofpremises%29+LIKE+%27%2543%25%27%29%29+AND+%28UPPER%28city%29%3D%27NEW+YORK%27+OR+UPPER%28zipcode%3A%3Atext%29+LIKE+%2710036%25%27%29
- About
- MERMAID TIMES SQUARE LLC, the licensed operator of its premises
- Read from
- https://data.ny.gov
- Interpreted by rule
- legal-entities/1
- Evidence ID
- legal-entity:082e8c0f7f60955cedcbc01f
All published fields
- Scope
- The authority's own record of the operating entity, reached by searching its register for the licence-proven operator's exact legal name and keeping only the same registration; owners and titles are as filed, not a current cap table.
- Reached
- legal_name_search
- Premises
- 1c12c4ae264bbde589d94d35bdc6690fc5d18ba58707d592b54399f70791d909
- Legal Name
- MERMAID TIMES SQUARE LLC
- Jurisdiction
- NY
- Registration
- Kind
- business_license
- Type
- DOMESTIC LIMITED LIABILITY COMPANY
- Number
- 6262077
- Parties
- Name
- golenbock eiseman assor bell & peskoe llp
- Role
- DOS PROCESS
- Licensee
- MERMAID TIMES SQUARE LLC
- Authority
- NY_DOS
- Source id
- ny_dos_business
- Issued date
- 2021-08-18
- Observed at
- 2026-10-23T11:44:12.122523724Z
- Jurisdiction
- NY
Relationship evidence
Identity revision 1, last changed
- a declared affiliated site is a relationship the publisher states, not common ownership
- a declared provider account (gift cards, hiring, ordering) is a service relationship, not an affiliation
- a register party at the business's premises is a candidate operator until the Place and legal resolvers bind it
- a licensed operator of the business's premises operates those locations; it is not thereby the brand's owner
- an employer a job board names on the openings posts them; it is not thereby the owner or the operator
- an app's store seller or developer publishes the app; neither is thereby the restaurant's owner
- a menu that names a producer names it; it is not a supply contract, a volume or an exclusivity
- a mail or DMARC service domain in DNS is a technical service relationship, not an affiliation
- a group the site says it is part of is a public affiliation; the equity chain and buying rights are separate questions
- an organization that posts the openings, sells the app or holds a program account shares services with the business; that is not affiliation or ownership
- a supplier or charitable partner the site's own page names and links is the publisher's statement; it is not a contract, a volume, an exclusivity or a gift amount
- Published nameThe Mermaid Inn
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/ → declared Organization name
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
- Published descriptionUpscale-casual seafood spot with a Cape Cod vibe known for its lobster rolls and cheap oyster deal.
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
- Declared languageen-US
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
- Canonical URLhttps://www.themermaidnyc.com/
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
- The Mermaid Inn
The Mermaid Inn
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
- Logo
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/ → declared Organization logo → declared asset on another registrable domain (getbento.com) — not the subject's own host
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
What legal entity is associated with The Mermaid Inn's app?
The Mermaid Holding Company is identified as the seller of Oysterpedia's official iOS application.
The Mermaid Inn Employees & Ownership
Michael CressottiChef
Stated by 1 source
- https://www.themermaidnyc.com/press/ · Published person (named with a role or their own mailbox on the site) · Chef
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- First observed
- Oct 23, 2026, 11:41 AM UTC
5 people not confirmed
The latest people collection is incomplete. Previously confirmed people remain available with their original dates.
golenbock eiseman assor bell & peskoe llp
DOS PROCESS · filed_party
register_party_kind_unstated
Source not recorded · confirmed Oct 23, 2026, 11:44 AM UTC- Observed via
- https://data.ny.gov/resource/n9v6-gdp6.json?%24limit=100&%24offset=0&%24order=initial_dos_filing_date+DESC%2C%3Aid&%24where=UPPER%28current_entity_name%29+IN+%28%27MERMAID+TIMES+SQUARE+LLC%27%2C%27MERMAID+TIMES+SQUARE%2C+LLC%27%2C%27MERMAID+TIMES+SQUARE+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE%2C+L.L.C.%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+TIMES+SQUARE+LIMITED+LIABILITY+CO%27%2C%27MERMAID+TIMES+SQUARE%2C+LIMITED+LIABILITY+CO%27%29 → Filed party of unstated kind on the authority's record of the operating entity, in the role it files
MERMAID CHELSEA, LLC
DOS PROCESS · filed_party
register_party_kind_unstated
Source not recorded · confirmed Oct 23, 2026, 11:44 AM UTC- Observed via
- https://data.ny.gov/resource/n9v6-gdp6.json?%24limit=100&%24offset=0&%24order=initial_dos_filing_date+DESC%2C%3Aid&%24where=UPPER%28current_entity_name%29+IN+%28%27MERMAID+CHELSEA+LLC%27%2C%27MERMAID+CHELSEA%2C+LLC%27%2C%27MERMAID+CHELSEA+L.L.C.%27%2C%27MERMAID+CHELSEA%2C+L.L.C.%27%2C%27MERMAID+CHELSEA+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+CHELSEA%2C+LIMITED+LIABILITY+COMPANY%27%2C%27MERMAID+CHELSEA+LIMITED+LIABILITY+CO%27%2C%27MERMAID+CHELSEA%2C+LIMITED+LIABILITY+CO%27%29 → Filed party of unstated kind on the authority's record of the operating entity, in the role it files
Kale Salad
chef dave's caesar, parmesan, garlic croutons & old bay chickpeas
names_a_menu_item: the reading is the menu reader's object: its name an item read on the same page, its title that page's menu structure
Source not recorded · confirmed Oct 23, 2026, 11:41 AM UTC- Observed via
- https://www.themermaidnyc.com/the-mermaid-inn-upper-west-side-menus/ → Published person (name and role labels)
Kale Salad
chef dave's caesar, parmesan, garlic croutons & old bay chickpeas
names_a_menu_item: the reading is the menu reader's object: its name an item read on the same page, its title that page's menu structure
Source not recorded · confirmed Oct 23, 2026, 11:41 AM UTC- Observed via
- https://www.themermaidnyc.com/mermaid-oyster-bar-menus/ → Published person (name and role labels)
C/O GOLENBOCK EISEMAN ASSOR BELL & PESKOE LLP
DOS PROCESS · filed_party
register_party_kind_unstated
Source not recorded · confirmed Oct 23, 2026, 11:44 AM UTC- Observed via
- https://data.ny.gov/resource/n9v6-gdp6.json?%24limit=100&%24offset=0&%24order=initial_dos_filing_date+DESC%2C%3Aid&%24where=UPPER%28current_entity_name%29+IN+%28%27335+COLUMBUS+LLC%27%2C%27335+COLUMBUS%2C+LLC%27%2C%27335+COLUMBUS+L.L.C.%27%2C%27335+COLUMBUS%2C+L.L.C.%27%2C%27335+COLUMBUS+LIMITED+LIABILITY+COMPANY%27%2C%27335+COLUMBUS%2C+LIMITED+LIABILITY+COMPANY%27%2C%27335+COLUMBUS+LIMITED+LIABILITY+CO%27%2C%27335+COLUMBUS%2C+LIMITED+LIABILITY+CO%27%29 → Filed party of unstated kind on the authority's record of the operating entity, in the role it files
Job Postings
No open roles listed.
- Careers page
- themermaidnyc.com/jobs · application form
Hiring evidence
- Careers page publishedhttps://www.themermaidnyc.com/jobs/
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/jobs/ → read — no schema.org JobPosting declared on it, and no ATS board observed in this run
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
- Accepting applicationsPlease, enter a valid name Name - Required, Please, enter a valid email Email - Required, Please, enter a valid phone number Phone Number - Required, Please, enter a valid cover letter Cover Letter - Required, Resumé - Required
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/jobs/ → application form published on the careers page — the fields it asks for, not a list of openings
- First observed
- Oct 23, 2026, 11:41 AM UTC
- Read from
- https://www.themermaidnyc.com
- Hiring statusno open role: careers page read, no roles listed; an application form is published; LinkedIn Jobs not searched: the site links no LinkedIn company of its own to read postings by; Indeed and ZipRecruiter not searched
Derived from observations
- Observed via
- https://www.themermaidnyc.com/jobs/
- Read from
- https://www.themermaidnyc.com
Contact Information
Phones
(917)-914-7037
(917)-914-7037
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/mermaid-mexicana-greenwich-village/ → printed in page text, not marked up
- First observed
- Oct 23, 2026, 11:41 AM UTC
2124008800
Published by the company · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/mermaid-mexicana-greenwich-village/
- First observed
- Oct 23, 2026, 11:41 AM UTC
Contact forms
https://www.themermaidnyc.com/macdougal-event-inquiries/
Directly observed · confirmed Oct 23, 2026, 11:42 AM UTC
- Observed via
- https://www.themermaidnyc.com/macdougal-event-inquiries/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/macdougal-event-inquiries/ → purpose: events_inquiry (its page names it)
- First observed
- Oct 23, 2026, 11:42 AM UTC
https://www.themermaidnyc.com/uws-event-inquiries/
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/uws-event-inquiries/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/uws-event-inquiries/ → purpose: events_inquiry (its page names it)
- First observed
- Oct 23, 2026, 11:41 AM UTC
https://www.themermaidnyc.com/
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/ → form headed "Email Signup" → submits to https://www.themermaidnyc.com/ → purpose: contact (a field to write or be reached through) → https://www.themermaidnyc.com/chelsea-and-macdougal-event-inquiries/ → https://www.themermaidnyc.com/contact/ → https://www.themermaidnyc.com/macdougal-event-inquiries/ → https://www.themermaidnyc.com/uws-event-inquiries/ → https://www.themermaidnyc.com/about-us-1/ → https://www.themermaidnyc.com/about-us/ → https://www.themermaidnyc.com/events-5/ → https://www.themermaidnyc.com/gift-cards/ → https://www.themermaidnyc.com/jobs/ → https://www.themermaidnyc.com/mermaid-mexicana-greenwich-village/ → https://www.themermaidnyc.com/mermaid-oyster-bar-greenwich-village/ → https://www.themermaidnyc.com/mermaid-oyster-bar-menus/ → https://www.themermaidnyc.com/mermaid-oyster-bar-times-square/ → https://www.themermaidnyc.com/press/ → https://www.themermaidnyc.com/press/?p=1 → https://www.themermaidnyc.com/press/?p=2 → https://www.themermaidnyc.com/the-mermaid-inn-chelsea-menus/ → https://www.themermaidnyc.com/the-mermaid-inn-chelsea/ → https://www.themermaidnyc.com/the-mermaid-inn-upper-west-side-menus/ → https://www.themermaidnyc.com/the-mermaid-inn-upper-west-side/
- First observed
- Oct 23, 2026, 11:41 AM UTC
https://www.themermaidnyc.com/chelsea-and-macdougal-event-inquiries/
Directly observed · confirmed Oct 23, 2026, 11:43 AM UTC
- Observed via
- https://www.themermaidnyc.com/chelsea-and-macdougal-event-inquiries/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/chelsea-and-macdougal-event-inquiries/ → purpose: events_inquiry (its page names it)
- First observed
- Oct 23, 2026, 11:43 AM UTC
https://www.themermaidnyc.com/chelsea-and-macdougal-event-inquiries/
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/chelsea-and-macdougal-event-inquiries/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/chelsea-and-macdougal-event-inquiries/ → purpose: events_inquiry (its page names it)
- First observed
- Oct 23, 2026, 11:41 AM UTC
https://www.themermaidnyc.com/jobs/
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/jobs/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/jobs/ → purpose: hiring (a file input or a resume field)
- First observed
- Oct 23, 2026, 11:41 AM UTC
https://www.themermaidnyc.com/contact/
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/contact/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/contact/ → purpose: contact (a way to reply and a free-text field)
- First observed
- Oct 23, 2026, 11:41 AM UTC
https://www.themermaidnyc.com/uws-event-inquiries/
Directly observed · confirmed Oct 23, 2026, 11:43 AM UTC
- Observed via
- https://www.themermaidnyc.com/uws-event-inquiries/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/uws-event-inquiries/ → purpose: events_inquiry (its page names it)
- First observed
- Oct 23, 2026, 11:43 AM UTC
https://www.themermaidnyc.com/macdougal-event-inquiries/
Directly observed · confirmed Oct 23, 2026, 11:41 AM UTC
- Observed via
- https://www.themermaidnyc.com/macdougal-event-inquiries/ → form headed "Inquiry Received" → submits to https://www.themermaidnyc.com/macdougal-event-inquiries/ → purpose: events_inquiry (its page names it)
- First observed
- Oct 23, 2026, 11:41 AM UTC
Locations
How many locations does The Mermaid Inn have?
4 known locations
Mermaid Oyster Bar Greenwich Village89 MacDougal Street, NY, NY, 10012, US
Mermaid Oyster Bar Times Square127 West 43rd Street, New York, NY, 10036, US
The Mermaid Inn Chelsea227 10th Ave, New York, NY, 10011, US
The Mermaid Inn Upper West Side335 Columbus Ave, NY, NY, 10023, US
Restaurant details
What cuisine does The Mermaid Inn serve?
Cuisine: Seafood Restaurant and Seafood, Contemporary American, Oyster Bar.
Apps, Loyalty & Guest Technology
Oysterpedia
Does The Mermaid Inn have a mobile app?
Official apps on iOS. Store updates: iOS: July 9, 2026.
View apps, provider accounts and technical evidence
Menus evidence
Menus evidence
Channel pricing evidence
Channel pricing evidence
Website & Digital Technology
What powers The Mermaid Inn's website?
Appears to use React.
Who manages The Mermaid Inn's domain and DNS?
themermaidnyc.com was first registered on April 4, 2003. Its registrar is Domain.com - Network Solutions, LLC.
What web infrastructure does The Mermaid Inn use?
Protocols: TLS 1.3 and HTTP/2.
How is The Mermaid Inn's website secured?
HTTPS certificate: Let's Encrypt, expires December 25, 2026.
Does The Mermaid Inn use DNSSEC?
DNSSEC was not enabled when observed.
What marketing and analytics tools does The Mermaid Inn's website use?
Google Analytics 4 (GA4; website analytics) and Google Tag Manager (tag management).
View technology, DNS, network and security evidence
More website details
More website details
View mail records and evidence
Publisher files
Nothing observed in this category.
Feeds
Nothing observed in this category.
GitHub
Nothing observed in this category.
Additional site intelligence
Useful site-graph evidence is available on demand instead of being pre-rendered into every company profile.