ROCKAWAY PT [Permits for ROCKAWAY PT]

351 - 400 of 702

ALEX MAGIC ELECTRONICS INC

Business

Active


CITY DELI CORP

Business

Inactive


LONERGAN HOMEIMPROVEMENTS INC

Business

Inactive


ROCKAWAY PAPER PANDA INC

Business

Active


WATER MINIMARKET CORP

Business

Inactive


ROCKAWAY DELI GROCERY

Business

Active


D & D CARPENTRY PLUS

Business

Active



108 BAGEL CORP.

Business

Active


VBA ENTERPRISES, INC.

Business

Active


SCHWAMBERGER CONTRACTING

Business

Active




CSR ROCKAWAY INC

Business

Inactive


WASH YOUR THINGS NY INC.

Business

Active


ALEX MAGIC ELECTRONICS INC

Business

Active


BK WIRELESS, INC.

Business

Active


A&J CONSTRUCTION SERVICES INC.

Business

Inactive


Super Clean

Business

Active



AIN Services LLC

Business

Inactive




APPETITO DELI GROCERY INC.

Business

Active


ROCKAWAY DELI & GROCERY CORP.

Business

Inactive



FAMILY DOLLAR #7949

Business

Inactive


CONNORS, RAYMOND J

Business

Active


RINSE CYCLE

Business

Active


ALLEN PAINTING & REMODELING

Business

Active


WINDOWS PLUS II

Business

Active



RENT-A-CENTER STORE #01914

Business

Active


BEACH CHANNEL NY INC

Business

Active



158 ROCKAWAY DELI INC

Business

Active


WALDBAUM'S STORE #616

Business

Inactive


GOLDMAN ROOFING INC

Business

Active


ROCKAWAY LAUNDROMAT INC.

Business

Inactive



ROCKAWAY CAR WASH INC.

Business

Active


JEMMA CORP

Business

Inactive



PRABHAT CORPORATION

Business

Inactive


ROCKAWAY WASH & DRY, INC.

Business

Active


ROCKAWAY AUTO SALES INC

Business

Active



SQUARE CARPENTRY INC.

Business

Inactive


POINT CONTRACTING CORP.

Business

Inactive


1165 BEACH CHANNEL CORP.

Business

Active


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