ROCKAWAY PARK [Permits for ROCKAWAY PARK]

201 - 219 of 219



RPA TRADING INC

Business

Inactive


PAR CARD & GIFT, LLC

Business

Active



Kim's Rainbow Cleaners, Inc

Business

Active


BLUE DRAFT CORPORATION

Business

Active


JKS Printing

Business

Active


Mazzone Ace Hardware

Business

Active


INTERIOR CONTRACTING CORP

Business

Active


DUANE READE

Business

Active



ROCKAWAY SERVICE STATION INC.

Business

Inactive


SANDY LABOR NETWORK INC.

Business

Inactive


NYC DAYLIGHTING INC.

Business

Active


SNACK PARADISE INC

Business

Active


SANDCASTLE GROCERY, INC.

Business

Inactive


AAA ROCKAWAY GAS INC

Business

Active


131 ROCKAWAY FOOD CORP.

Business

Active


(default) 2 queries took 432 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 ( '(+ROCKAWAY +PARK)' IN BOOLEAN MODE) LIMIT 200, 501919215
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+ROCKAWAY +PARK)' IN BOOLEAN MODE)11217