BRUNO IN HARLEM INC.

Sidewalk Cafe NEW YORK NY

BRUNO IN HARLEM INC. is a registered Business operating as a Sidewalk Cafe in NEW YORK. DCA License Number 1104078-DCA is currently Inactive (expiry date 12/15/2015). Sidewalk Cafe Type: Unenclosed, Square Feet: 551, Tables: 16, Chairs: 32

Telephone: 9174924806.

196
MALCOLM X BLVD
NEW YORK
NY
10026

 

BRUNO IN HARLEM INC. Data

Dca License Number 1104078-DCA
License Type Business
License Expiration Date 12/15/2015
License Status Inactive
License Creation Date 02/07/2005
Industry Sidewalk Cafe
Business Name BRUNO IN HARLEM INC.
Business Name 2
Address Building 196
Address Street Name MALCOLM X BLVD
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10026
Contact Phone Number 9174924806
Address Borough Manhattan
Borough Code 1
Community Board 110
Council District 9
Bin 1083963
Bbl 1017180069
Nta MN11
Census Tract 200
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 551, Tables: 16, Chairs: 32
Longitude -73.94790613537198
Latitude 40.804441408651954
Location (40.804441408651954, -73.94790613537198)
 

Have you worked with BRUNO IN HARLEM 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 2 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` = '1104078-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` < 95756 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` >= 95755 AND `Record`.`id` != 95756 ORDER BY `Record`.`id` ASC LIMIT 2220