JOYA HALL RAN NY GROUP LLC

Catering Establishment REGO PARK NY

JOYA HALL is a registered Business operating as a Catering Establishment in REGO PARK. DCA License Number 2047642-DCA is currently Inactive (expiry date 09/30/2018). Capacity of each room: 463

63108
WOODHAVEN BLVD
REGO PARK
NY
11374

 

JOYA HALL Data

Dca License Number 2047642-DCA
License Type Business
License Expiration Date 09/30/2018
License Status Inactive
License Creation Date 01/25/2017
Industry Catering Establishment
Business Name RAN NY GROUP LLC
Business Name 2 JOYA HALL
Address Building 63108
Address Street Name WOODHAVEN BLVD
Secondary Address Street Name
Address City REGO PARK
Address State NY
Address Zip 11374
Contact Phone Number
Address Borough Queens
Borough Code 4
Community Board 405
Council District 30
Bin 4070122
Bbl 4030150032
Nta QN21
Census Tract 679
Detail Capacity of each room: 463
Longitude -73.86684952642737
Latitude 40.721775915292184
Location (40.721775915292184, -73.86684952642737)
 

Have you worked with JOYA HALL 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 1 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` = '2047642-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` < 10555 ORDER BY `Record`.`id` DESC LIMIT 1110
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` >= 10554 AND `Record`.`id` != 10555 ORDER BY `Record`.`id` ASC LIMIT 2220