ROCKAWAY BEACH [Permits for ROCKAWAY BEACH]

51 - 76 of 76


STORE #30358

Business

Active



LONDON CLEANERS, INC.

Business

Active


BEACH BOY 92 CLEANER INC.

Business

Active



BEACH 116 DELI & GROCERY

Business

Inactive


SEVENTY 9 PLUS INC

Business

Active


Rockaway Beach Gourmet Deli

Business

Inactive


SMK PHARMACY, CORP.

Business

Active



ON THE ROC CONSTRUCTION

Business

Inactive


MUALLA DELI CORP

Business

Active


224 BEACH DELI GROCERY

Business

Inactive


wireless Beat Corp

Business

Inactive


ROCKAWAY SCALE COMPANY

Business

Active


GRIMM, SAMUEL

Individual

Active


BRYAN'S AUTO EAST, LTD.

Business

Active


THE SANDWICH SPOT INC

Business

Active



J & J JEWELERS, LLC

Business

Active


J & F FLOOR SPECIALIST

Business

Inactive




T-Mobile

Business

Active


THE ST BERNARD PROJECT INC

Business

Inactive


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