MASPETH [Permits for MASPETH]

251 - 300 of 745

HYNSON, BRIAN

Individual

Active


CUCCHIARA, GUISEPPE

Individual

Active


ASPIAZU, HARRY

Individual

Active


PIEKARSKI, RAFAL

Individual

Active


WALSH, ORLA P

Individual

Inactive


NEUSTADT, HOWARD I

Individual

Inactive


ORLOWSKI, MIROSLAW

Individual

Inactive


SINGH, DARBARA

Individual

Active


CARBONE, FRANK

Individual

Active


CIRIGLIANO, JOSE A.

Individual

Inactive


MISTRETTA, GASPARE

Individual

Active


KUROPATNICKI, WOJCIECH

Individual

Inactive


HUANG, YI HAI

Individual

Inactive


HURD, CHRISTOPHER E

Individual

Active


Tzivas, Anthony

Individual

Active


FLUSNIAK, KRZYSZTOF

Individual

Active


Zhou, Pei Tang

Individual

Active


ZUNIGA, ANGELO

Individual

Active


MORABITO, ROSA

Individual

Active


BURNS, JAMES

Individual

Active


MALINOWSKI, URSZULA

Individual

Active


CHEN, GUO L

Individual

Inactive


MODAN, ERAN

Individual

Inactive


BONILLA, ALFONSO

Individual

Active


GLENNON, COLM M.

Individual

Active


BLANKE, GEORGE N

Individual

Active


CARANO, DOMINICK L.

Individual

Inactive


PLONSKI, ZBIGNIEW

Individual

Active


MARTINEZ, DARRAL

Individual

Active


ORELLANA, EDISON

Individual

Active


ZYWNO, ADAM

Individual

Inactive


FAY, SEAN

Individual

Active


QUITO, CARLOS

Individual

Active


DEVIVO, JOSEPH

Individual

Active


PLONSKI, ZBIGNIEW

Individual

Inactive


Konstantin, Rade

Individual

Active


BLANCHARD, RICHARD S

Individual

Active


SULLIVAN, SEAN

Individual

Inactive


Lewandowski, Barbara

Individual

Inactive


MURAWSKI, JAN

Individual

Active


MCFADDEN, MICHAEL

Individual

Active


PALCZEWSKI, JAROSLAW

Individual

Active


SHAMSI, FAROOQ

Individual

Active


HAGAN, COLM

Individual

Active


NOVA REMODELLING, INC

Business

Active


AVILES, JOSHUA

Individual

Inactive


CERMA, RAMAZAN

Individual

Inactive


ROMANO, DONATO

Individual

Inactive


BONANNO, ANTHONY

Individual

Inactive


CONNAUGHTON, JARLATH

Individual

Active


(default) 2 queries took 96 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 250, 50505096
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)110