RUSSO'S ON THE BAY TAR CATERING CORP.

Catering Establishment HOWARD BEACH NY

RUSSO'S ON THE BAY is a registered Business operating as a Catering Establishment in HOWARD BEACH. DCA License Number 0554283-DCA is currently Inactive (expiry date 09/30/2018). Capacity of each room: 125, 435, 560

Telephone: 7188435055.

16245
CROSSBAY BLVD
HOWARD BEACH
NY
11414

 

RUSSO'S ON THE BAY Data

Dca License Number 0554283-DCA
License Type Business
License Expiration Date 09/30/2018
License Status Inactive
License Creation Date 09/13/2012
Industry Catering Establishment
Business Name TAR CATERING CORP.
Business Name 2 RUSSO'S ON THE BAY
Address Building 16245
Address Street Name CROSSBAY BLVD
Secondary Address Street Name
Address City HOWARD BEACH
Address State NY
Address Zip 11414
Contact Phone Number 7188435055
Address Borough Queens
Borough Code 4
Community Board 410
Council District 32
Bin 4447625
Bbl 4141950013
Nta QN57
Census Tract 892
Detail Capacity of each room: 125, 435, 560
Longitude -73.83842129304207
Latitude 40.65335345619689
Location (40.65335345619689, -73.83842129304207)
 

Have you worked with RUSSO'S ON THE BAY 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` = '0554283-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` < 8228 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` >= 8227 AND `Record`.`id` != 8228 ORDER BY `Record`.`id` ASC LIMIT 2220