Catering Establishment [Permits for Catering Establishment]

51 - 65 of 65

ROMANOFF RESTAURANT

Business

Inactive


IW COLUMBUS CENTRE LLC

Business

Active


REX MANOR

Business

Inactive


KISMET CATERERS

Business

Inactive


PATRICIAN RM

Business

Inactive


ANTUN'S

Business

Inactive


MARYANN'S WOODSIDE EVENTS

Business

Inactive


THE ASTORIA WORLD MANOR, INC.

Business

Inactive


LIVINGSPRING VENTURES, INC.

Business

Inactive



SUGAR CITY BAKERY, INC.

Business

Inactive


WEYLIN SEYMOUR LLC

Business

Inactive



PJ'S DANCE CHARISMA, INC.

Business

Inactive



(default) 2 queries took 617 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 MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Catering +Establishment)' IN BOOLEAN MODE) LIMIT 50, 501515360
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Catering +Establishment)' IN BOOLEAN MODE)11257