ROCKAWAY PT [Permits for ROCKAWAY PT]

401 - 450 of 702


FAMILY FOODS MARKET INC

Business

Active



ROCKAWAY VARIETY STORE

Business

Inactive


KING & QUEEN DELI GROCERY CORP

Business

Inactive


CELL NATION 1305, INC

Business

Active


BEACH CHANNEL NY INC

Business

Inactive


HARBOR CLEANING CORPORATION

Business

Active


M & I G VIDEO CORP.

Business

Inactive


SKY TECHNOLOGY

Business

Active


BEER HOUSE INC.

Business

Active


CRICKET WIRELESS

Business

Inactive


ASP Printing LLC

Business

Active


SEAGIRT BLVD LAUNDROMAT INC

Business

Active


LEVINE,CHARLES

Business

Active


GOLD FASHION JEWELRY, INC.

Business

Active


ROCKAWAY FOOD MART, INC.

Business

Active


EXPRESS SHOE REPAIR

Business

Active


ALL MIGHT INC.

Business

Active



MBA WIRELESS

Business

Inactive



ALL SEASON RENOVATION LLC

Business

Active



BV MOBILE 5, INC.

Business

Active


R&R FOOD STORE, INC

Business

Active


JKS Printing

Business

Active



REDFERN DRUGS, INC.

Business

Active


A & J JEWELRY

Business

Active


SAM CONVENIENCE DELI CORP.

Business

Inactive


BRYAN'S AUTO EAST, LTD.

Business

Active



YL SNOW WHITE CLEANERS

Business

Inactive


FOUR SISTERS LAUNDROMAT, INC.

Business

Inactive



BIG CITY DELI EXPRESS CORP

Business

Inactive


Wireless Beat

Business

Inactive


DENNISEIS GROCERY INC

Business

Active


PAPA FOOD MARKET CORP

Business

Active



FRIENDLY PHARMACY

Business

Active


TGC CUSTOM LLC

Business

Inactive


KELVIN GROCERY & DELI, INC.

Business

Active


ROCKAWAY EXPRESS DELI

Business

Active


T-Mobile

Business

Inactive


EMPIRE CLOSETS INC

Business

Active


Central Moving & Storage

Business

Active



UNIVERSAL WINDOW CO

Business

Inactive


(default) 2 queries took 379 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 400, 505050157
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)11222