ROCKAWAY PT [Permits for ROCKAWAY PT]

51 - 100 of 702

CHU-CHENG, SAMANTHA

Individual

Active


AMRUSSI, YEHUDA

Individual

Active


YING LI LAUNDROMAT INC

Business

Inactive


HARBOR CLEANING CORPORATION

Business

Inactive


MEI'S CLEANERS INC

Business

Inactive



KAUFMAN, AVI

Individual

Inactive


LONDON FRENCH CLEANERS.

Business

Inactive


O'TOOLE, MICHAEL

Business

Inactive


DEVINE, FINBAR

Individual

Active


ROCKAWAY BEACH PAWNBROKERS

Business

Active


Kelly, Taurean

Individual

Active



LOPOPOLO, JOSEPH

Individual

Active


GORDON, DAVID A

Individual

Inactive


BAUSEMAN, ISIAH R.

Individual

Inactive


WONG, HONVER

Individual

Inactive


SUPER CLEAN

Business

Inactive


RINSE CYCLE CORP.

Business

Inactive


WILLMER, JAMES

Individual

Active


LOWTHER, CHRISTOPHER

Individual

Inactive


MILES, MICHAEL T.

Individual

Active


CALABRESE, ANTHONY J

Individual

Active



Rockaway Car Care, Inc

Business

Active


BECK, STEPHEN

Individual

Active


AAA Rockaway Gas, Inc

Business

Active



FINDLAY, ANTHONY

Individual

Active


DAY & NIGHT II DELI INC

Business

Active


blue wave accessories inc

Business

Active


Spann, Courtney

Individual

Active


GAMPERO, LOUIS C.

Individual

Active


BUKOWSKI, MICHAEL

Individual

Active


Bifulco, Richard

Individual

Inactive




KELLY, NICHOLAS R

Individual

Active


ROMANO, NICHOLAS

Individual

Active


Israel, Trevon

Individual

Active



KHAN, JAMEELA

Individual

Active


JE GROCERY FOOD CENTER CORP

Business

Active


PAKETERIA INCORPORATED

Business

Active


VOLQUEZ, TAILYN

Individual

Active


AGS Appliance Corporation

Business

Active


RITE AID STORE #7930

Business

Active



CASINO AUTO BODY, INC

Business

Inactive


MCLEAN, JOHN H

Individual

Inactive


(default) 2 queries took 260 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 50, 50505035
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)11225