NEW WEST END SUPERETTE BIG JOYS CORP.

Stoop Line Stand NEW YORK NY

NEW WEST END SUPERETTE is a registered Business operating as a Stoop Line Stand in NEW YORK. DCA License Number 1376927-DCA is currently Active (expiry date 03/31/2020). Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 4, 5 foot stands: 0, 5.01 to 10 foot stands: 0

Telephone: 212-787-1874.

271
W 72ND ST
NEW YORK
NY
10023

 

NEW WEST END SUPERETTE Data

Dca License Number 1376927-DCA
License Type Business
License Expiration Date 03/31/2020
License Status Active
License Creation Date 11/15/2010
Industry Stoop Line Stand
Business Name BIG JOYS CORP.
Business Name 2 NEW WEST END SUPERETTE
Address Building 271
Address Street Name W 72ND ST
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10023
Contact Phone Number 212-787-1874
Address Borough Manhattan
Borough Code 1
Community Board 107
Council District 06
Bin 1030504
Bbl 1011640001
Nta MN14
Census Tract 159
Detail Product Category: Fruits, Vegetables, Soft Drinks, or Flowers, 4 foot stands: 4, 5 foot stands: 0, 5.01 to 10 foot stands: 0
Longitude -73.98362161275178
Latitude 40.77945850008403
Location (40.77945850008403, -73.98362161275178)
 

Have you worked with NEW WEST END SUPERETTE 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 5 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` = '1376927-DCA' LIMIT 1112
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` < 101153 ORDER BY `Record`.`id` DESC LIMIT 1112
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` >= 101152 AND `Record`.`id` != 101153 ORDER BY `Record`.`id` ASC LIMIT 2221