THE MERMAID INN (License# 2023883) is a business entity licensed with City of New York, Department of Consumer Affairs (DCA). The license creation date is June 4, 2015. The license expiration date is September 15, 2021. The license status is Active.
| Business Name | MERMAID 88 LLC |
| Doing Business As (DBA) Name | THE MERMAID INN |
| License Number | 2023883 |
| Business Address |
570 Amsterdam Ave New York NY 10024 |
| License Category | Sidewalk Cafe |
| License Type | Business |
| License Creation Date | 2015-06-04 |
| License Expiration Date | 2021-09-15 |
| License Status | Active |
| Phone Number | 2127997400 |
| Borough | Manhattan |
| Community Board | 107 |
| Council District | 06 |
| Building Identification Number (BIN) | 1033213 |
| Borough-Block-Lot (BBL) | 1012350034 |
| Neighborhood Tabulation Area (NTA) | MN12 |
| Detail | Sidewalk Cafe Type: Unenclosed, Square Feet: 273, Tables: 15, Chairs: 34 |
| License Number | License Category | License Type | Creation Date | Expiration Date |
|---|---|---|---|---|
| 2023883 | Sidewalk Cafe | Business | 2015-06-04 | 2021-09-15 |
| Application ID / Category | Business Name | Status | Start Date | License Category |
|---|---|---|---|---|
| 26418-2019-RSWC Renewal - Special |
MERMAID 88 LLC | Issued | 2019-09-11 | Sidewalk Cafe |
| 26046-2017-RSWC Renewal - Special |
MERMAID 88 LLC | Issued | 2017-08-29 | Sidewalk Cafe |
| 4150-2015-ASWC Application - Special |
MERMAID 88 LLC | Issued | 2015-04-03 | Sidewalk Cafe |
| Business Name | License Category | Office Address | Creation/Expiration |
|---|---|---|---|
| The Mermaid Inn · Mermaid 88, LLC | Sidewalk Cafe | 568 Amsterdam Ave, New York, NY 10024 | 2007-12-17 ~ 2015-09-15 |
| Borough-Block-Lot (BBL) |
1012350034 Borough: 1 (Manhattan), Block: 1235, Lot: 34 |
| Property Address |
570 Amsterdam Avenue Manhattan New York, NY 10024 |
| Owner | WINEVE REALTY CORP |
| Assessment Year | 2017/18 |
| Estimated Market Value | 2293000 |
| Actual Assessed Total Value |
1031850 (45% of estimated market value) |
| Street Address |
570 AMSTERDAM AVE |
| Borough | Manhattan |
| City | NEW YORK |
| State | NY |
| Zip | 10024 |
| Business Name | License Category | Office Address | Creation/Expiration |
|---|---|---|---|
| Mamajuana Cafe · Rancho Vida LLC | Sidewalk Cafe | 570 Amsterdam Ave, New York, NY 10024 | 2012-02-14 ~ 2014-09-18 |
| Rancho · Rancho West Corporation | Sidewalk Cafe | 570 Amsterdam Ave, New York, NY 10024 | 2005-03-10 ~ 2012-04-15 |
| Business Name | License Category | Office Address | Creation/Expiration |
|---|---|---|---|
| Westside Mini Market Inc | Electronic Cigarette Dealer | 562 Amsterdam Ave, New York, NY 10024 | 2020-05-18 ~ 2021-11-30 |
| 214 West 88th Street Garage LLC | Garage and Parking Lot | 214 W 88th St, New York, NY 10024 | 2019-11-25 ~ 2021-03-31 |
| Make Ready Nyc Corp. | Home Improvement Contractor | 203 W 87th St, New York, NY 10024 | 2018-10-19 ~ 2021-02-28 |
| Green Leaf Deli Inc | Electronic Cigarette Dealer | 574 Amsterdam Ave, New York, NY 10024 | 2018-06-05 ~ 2021-11-30 |
| Oxford Fine Cleaners, Inc. | Laundries | 580 Amsterdam Ave, New York, NY 10024 | 2018-01-08 ~ 2019-12-31 |
| Chinese Laundry Inc. | Laundries | 201 W 87th St, New York, NY 10024 | 2017-12-28 ~ 2021-12-31 |
| May's Laundromat · Liu, Ching May | Laundries | 590 Amsterdam Ave, New York, NY 10024 | 2017-11-02 ~ 2019-12-31 |
| Amelie · La Petit Amelie, LLC | Sidewalk Cafe | 566 Amsterdam Ave, New York, NY 10024 | 2017-08-03 ~ 2020-03-31 |
| Pizzeria Sirenetta · 568 Amsterdam LLC | Sidewalk Cafe | 568 Amsterdam Ave, New York, NY 10024 | 2016-04-19 ~ 2020-07-14 |
| Sp Plus Corporation | Garage and Parking Lot | 211 W 87th St, New York, NY 10024 | 2015-03-24 ~ 2021-03-31 |
| Business Name | License Category | Office Address | Creation/Expiration |
|---|---|---|---|
| 600 Columbus Parking Corp | Garage | 600 Columbus Ave, New York, NY 10024 | 2020-08-18 ~ 2021-03-31 |
| Plantshed · Plant Shed 87 Corp | Stoop Line Stand | 555 Columbus Ave, New York, NY 10024 | 2020-07-16 ~ 2022-03-31 |
| Westside Mini Market Inc | Electronic Cigarette Dealer | 562 Amsterdam Ave, New York, NY 10024 | 2020-05-18 ~ 2021-11-30 |
| Staples The Office Superstore · Office Superstore East LLC | Secondhand Dealer - General | 2248 Broadway, New York, NY 10024 | 2020-04-08 ~ 2021-07-31 |
| Poly Organic Cleaners · Poly Organic Corp. | Laundries | 217 W 80th St, New York, NY 10024 | 2020-03-03 ~ 2021-12-31 |
| Ecoatm · Ecoatm, LLC | Secondhand Dealer - General | 493 Amsterdam Ave, (inside David's Check Cashing0025), New York, NY 10024 | 2020-01-31 ~ 2021-07-31 |
| Neet Cleaners · Ann's Legacy Inc | Laundries | 251 W 87th St, New York, NY 10024 | 2020-01-14 ~ 2021-12-31 |
| The Consulate Nyc LLC | Sidewalk Cafe | 519 Columbus Ave, New York, NY 10024 | 2020-01-03 ~ 2022-12-15 |
| Seal Rock Development, LLC | Home Improvement Contractor | 530 W End Ave, New York, NY 10024 | 2019-12-23 ~ 2021-02-28 |
| Chenille Cleaners · Symphony 77 Inc. | Laundries | 41 W 86th St, New York, NY 10024 | 2019-12-13 ~ 2021-12-31 |
| Find all businesses in the same zip 10024 | |||
| City | NEW YORK |
| Zip Code | 10024 |
| Category | Sidewalk Cafe |
| Category + Zip | Sidewalk Cafe + 10024 |
| Business Name | License Category | Office Address | Creation/Expiration |
|---|---|---|---|
| Mermaid Medical Supply Inc | Dealer In Products | 2724 Mermaid Ave, Brooklyn, NY 11224 | 2020-07-30 ~ 2021-03-15 |
| Mermaid Electronics Inc. | Secondhand Dealer - General | 1904 Mermaid Ave, Brooklyn, NY 11224 | 2004-03-16 ~ 2005-07-31 |
| Mermaid 2 Deli Inc. | Tobacco Retail Dealer | 3222 Mermaid Ave, Brooklyn, NY 11224 | 2016-11-28 ~ 2021-12-31 |
| Mermaid Madness, Inc. | Stoop Line Stand | 1627 Mermaid Ave, Brooklyn, NY 11224 | 2004-09-10 ~ 2006-03-31 |
| Big Apple of Mermaid Inc. | Tobacco Retail Dealer | 3222 Mermaid Ave, Brooklyn, NY 11224 | 2006-04-25 ~ 2014-12-31 |
| Bargain Land Mermaid Inc. | Electronics Store | 2811 Mermaid Ave, Brooklyn, NY 11224 | 2010-09-10 ~ 2012-12-31 |
| Mermaid Cellular Inc. | Electronics Store | 2722 Mermaid Ave, Brooklyn, NY 11224 | 2016-01-20 ~ 2016-12-31 |
| Fresh Mermaid Farm Inc. | Stoop Line Stand | 2710 Mermaid Ave, Brooklyn, NY 11224 | 2006-10-19 ~ 2010-03-31 |
| Mermaid Gourmet Deli, Inc | Tobacco Retail Dealer | 3222 Mermaid Ave, Brooklyn, NY 11224 | 2013-10-04 ~ 2014-12-31 |
| Mermaid Variety · Cho, Chun I | Tobacco Retail Dealer | 1627 Mermaid Ave, Brooklyn, NY 11224 | 2000-09-16 ~ 2003-12-31 |
Please comment or provide details below to improve the information on THE MERMAID INN.
| Data Provider | City of New York, Department of Consumer Affairs (DCA) |
| Jurisdiction | New York |
This dataset includes 110 thousand businesses licensed with City of New York, Department of Consumer Affairs (DCA). Each business is registered with license number, legal business name, phone, location, license expiration date, etc.