1. Home
  2. Sidewalk Cafe
  3. NEW YORK
  4. RANDOLPH BEER

RANDOLPH BEER 343 BROOME STREET RESTAURANT INC

Sidewalk Cafe NEW YORK NY

RANDOLPH BEER is a registered Business operating as a Sidewalk Cafe in NEW YORK. DCA License Number 1426393-DCA is currently Active (expiry date 09/15/2018). Sidewalk Cafe Type: Unenclosed, Square Feet: 132, Tables: 6, Chairs: 14

Telephone: 9176530633.

343
BROOME ST
NEW YORK
NY
10013

 

RANDOLPH BEER Data

Dca License Number 1426393-DCA
License Type Business
License Expiration Date 09/15/2018
License Status Active
License Creation Date 04/27/2012
Industry Sidewalk Cafe
Business Name 343 BROOME STREET RESTAURANT INC
Business Name 2 RANDOLPH BEER
Address Building 343
Address Street Name BROOME ST
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10013
Contact Phone Number 9176530633
Address Borough Manhattan
Borough Code 1
Community Board 102
Council District 1
Bin 1006944
Bbl 1004700050
Nta MN24
Census Tract 41
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 132, Tables: 6, Chairs: 14
Longitude -73.99468973865227
Latitude 40.719635019942864
Location (40.719635019942864, -73.99468973865227)
 
SEND IN THE CLOWNS ENTERTAINMENT CORP. NEW HYDE PARK BERETIN, NEDILJKO BROOKLYN

Have you worked with RANDOLPH BEER or used their services?

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

© 2024 NYCbizdatabase.com | Search | Privacy
(default) 3 queries took 7 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` = '1426393-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` < 118671 ORDER BY `Record`.`id` DESC LIMIT 1116
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` >= 118670 AND `Record`.`id` != 118671 ORDER BY `Record`.`id` ASC LIMIT 2220