MERCHANTS NY MNY - CHELSEA, LLC

Sidewalk Cafe NEW YORK NY

MERCHANTS NY is a registered Business operating as a Sidewalk Cafe in NEW YORK. DCA License Number 1160931-DCA is currently Inactive (expiry date 04/15/2018). Sidewalk Cafe Type: Unenclosed, Square Feet: 140, Tables: 6, Chairs: 12

Telephone: 2123667267.

112
7TH AVE
NEW YORK
NY
10011

 

MERCHANTS NY Data

Dca License Number 1160931-DCA
License Type Business
License Expiration Date 04/15/2018
License Status Inactive
License Creation Date 04/14/2006
Industry Sidewalk Cafe
Business Name MNY - CHELSEA, LLC
Business Name 2 MERCHANTS NY
Address Building 112
Address Street Name 7TH AVE
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10011
Contact Phone Number 2123667267
Address Borough Manhattan
Borough Code 1
Community Board 104
Council District 3
Bin 1080489
Bbl 1007660047
Nta MN13
Census Tract 81
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 140, Tables: 6, Chairs: 12
Longitude -73.9984338535459
Latitude 40.74028118180423
Location (40.74028118180423, -73.9984338535459)
 

Have you worked with MERCHANTS NY or used their services?

Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.

(default) 3 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE `Record`.`DCA_License_Number` = '1160931-DCA' LIMIT 1111
2SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE `Record`.`id` < 100141 ORDER BY `Record`.`id` DESC LIMIT 1110
3SELECT `Record`.`id`, `Record`.`DCA_License_Number`, `License Type`, `License Expiration Date`, `License Status`, `License Creation Date`, `Record`.`Industry`, `Record`.`Business_Name`, `Record`.`Business_Name_2`, `Address Building`, `Address Street Name`, `Secondary Address Street Name`, `Record`.`Address_City`, `Address State`, `Address ZIP`, `Contact Phone Number`, `Address Borough`, `Borough Code`, `Community Board`, `Council District`, `Record`.`BIN`, `Record`.`BBL`, `Record`.`NTA`, `Census Tract`, `Record`.`Detail`, `Record`.`Longitude`, `Record`.`Latitude`, `Record`.`Location`, `Record`.`description` FROM `nyc_business`.`records` AS `Record` WHERE `Record`.`id` >= 100140 AND `Record`.`id` != 100141 ORDER BY `Record`.`id` ASC LIMIT 2220