MASPETH [Permits for MASPETH]

51 - 100 of 745

COTOIA, JOSEPH J

Individual

Active


McClean, Martin

Individual

Active


MOGA, CONSTANTIN

Individual

Active


CZARNECKI, GRZEGORZ

Individual

Active


ZAMPELLI, ANTHONY C

Individual

Active


GOMEZ, BENLLYS DENIEL

Individual

Inactive


SINGH, HARMIT

Individual

Active


Jeremy Corporation

Business

Inactive


KLIMCZYK, SEBASTIAN

Individual

Active


MASPETH DRY CLEANERS

Business

Inactive


KIMSZAL, JAN

Individual

Active


MASPETH DRY CLEANER

Business

Inactive


WOJTOWICZ, ZBIGNIEW

Individual

Inactive


RIVERA, LUIS

Individual

Inactive


COLOMBINI, SIDNEY

Individual

Active


MASPETH LAUNDROMAT INC.

Business

Inactive


CHOE'S CLEANERS

Business

Inactive


DUFFY, JAMES

Individual

Active


SANGIOVANNI, ANTHONY

Individual

Active


BAYTER, JACQUELINE

Individual

Inactive


SIMONETTA, GIUSEPPE

Individual

Active


Zhang, Stephanie

Individual

Active


KOSTRZEWSKI, CHARLES JR. P

Individual

Active


Lesniewski, Marek

Individual

Active


GRIPPO, JOSEPH P

Individual

Active


HU, XIU WEI

Individual

Active


WOJCIK, PAWEL

Individual

Inactive



SANCHEZ, JOEMER

Individual

Inactive


PETRO INC

Business

Active


GIAMPAPA, FRANCESCO

Individual

Active


LICAUSI, PADDY J

Individual

Active


BODMAN, ALANNA

Individual

Active


BALK, OZKAN

Individual

Active


JYD TOWING

Business

Inactive


CUOCO, ERNESTO

Individual

Inactive


MCCARNEY, SIMON

Individual

Active


MALINOWSKI, BOGDAN

Individual

Active



SEREMET, BOGUSLAW

Individual

Active


MASPETH HALL

Business

Active


TOP RECREATION INC

Business

Active


OZGENC, YIGITHAN

Individual

Active


LOJEK, MARZENA

Individual

Active


MASPETH HALL INC

Business

Active


MASPETH HALL

Business

Active


PLATHO DELI GROCERY INC

Business

Active


JAEGER, ANTHONY

Individual

Active



TUNNEY, EUGENE

Individual

Active


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