BLACKSTONE BAR & GRILL 3713 RIVERDALE REST CORP.

Sidewalk Cafe BRONX NY

BLACKSTONE BAR & GRILL is a registered Business operating as a Sidewalk Cafe in BRONX. DCA License Number 2058401-DCA is currently Active (expiry date 04/15/2019). Sidewalk Cafe Type: Unenclosed, Square Feet: 140, Tables: 9, Chairs: 21

Telephone: 3473466004.

3713
RIVERDALE AVE
BRONX
NY
10463

 

BLACKSTONE BAR & GRILL Data

Dca License Number 2058401-DCA
License Type Business
License Expiration Date 04/15/2019
License Status Active
License Creation Date 09/20/2017
Industry Sidewalk Cafe
Business Name 3713 RIVERDALE REST CORP.
Business Name 2 BLACKSTONE BAR & GRILL
Address Building 3713
Address Street Name RIVERDALE AVE
Secondary Address Street Name
Address City BRONX
Address State NY
Address Zip 10463
Contact Phone Number 3473466004
Address Borough Bronx
Borough Code 2
Community Board 208
Council District 11
Bin 2097850
Bbl 2057960158
Nta BX29
Census Tract 295
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 140, Tables: 9, Chairs: 21
Longitude -73.90713633996403
Latitude 40.887209875129344
Location (40.887209875129344, -73.90713633996403)
 

Have you worked with BLACKSTONE BAR & GRILL 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 3 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` = '2058401-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` < 89708 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` >= 89707 AND `Record`.`id` != 89708 ORDER BY `Record`.`id` ASC LIMIT 2220