UNO OF ASTORIA, INC.

Sidewalk Cafe LONG ISLAND CITY NY

UNO OF ASTORIA, INC. is a registered Business operating as a Sidewalk Cafe in LONG ISLAND CITY. DCA License Number 1157157-DCA is currently Inactive (expiry date 05/24/2018). Sidewalk Cafe Type: Unenclosed, Square Feet: 320, Tables: 8, Chairs: 22

Telephone: 7815404518.

3711
35TH AVE
LONG ISLAND CITY
NY
11101

 

UNO OF ASTORIA, INC. Data

Dca License Number 1157157-DCA
License Type Business
License Expiration Date 05/24/2018
License Status Inactive
License Creation Date 02/28/2006
Industry Sidewalk Cafe
Business Name UNO OF ASTORIA, INC.
Business Name 2
Address Building 3711
Address Street Name 35TH AVE
Secondary Address Street Name
Address City LONG ISLAND CITY
Address State NY
Address Zip 11101
Contact Phone Number 7815404518
Address Borough Queens
Borough Code 4
Community Board 401
Council District 26
Bin 4009644
Bbl 4006450001
Nta QN70
Census Tract 57
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 320, Tables: 8, Chairs: 22
Longitude -73.92351886231768
Latitude 40.755802058541
Location (40.755802058541, -73.92351886231768)
 

Have you worked with UNO OF ASTORIA, INC. 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 8 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` = '1157157-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` < 17925 ORDER BY `Record`.`id` DESC LIMIT 1111
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` >= 17924 AND `Record`.`id` != 17925 ORDER BY `Record`.`id` ASC LIMIT 2226