EAST ELMHURST [Permits for EAST ELMHURST]

151 - 200 of 609

HADI, AMINE

Individual

Inactive


SINGH, SATNAM

Individual

Inactive


BELLO, NANCY

Individual

Active


AXHAMI, KISMET

Individual

Active


AXHAMI, ELTON

Individual

Active


LEMA, CRISTIAN

Individual

Active


CHAVEZ, WILLIAM

Individual

Inactive


SHAIKH, ZUBAIR

Individual

Inactive


SINGH, RAM

Individual

Active


DIAZ, MARIO, A

Individual

Active


MAHMOOD, NASIR

Individual

Active


SINGH, DAVINDER

Individual

Active


ORTIZ, LEON

Individual

Inactive


AHMED, MUSHTAQ

Individual

Active


SINCHI, LUIS

Individual

Active


SINGH, NISHAN

Individual

Active


HUSSAIN, FIAZ

Individual

Active


ETTAMYMY, ZAK

Individual

Inactive


SINGH, MANOJ

Individual

Active


HOQUE, HAMIDUL

Individual

Active


PEREZ, EDWIN

Individual

Active


ULLOA, ANGEL G.

Individual

Inactive


SHARMA, SHUBHAGATA

Individual

Active


M & Q GENERAL, CORP

Business

Inactive


MEHMOOD, ZAHID

Individual

Active


GUAMAN, NICOLAS

Individual

Inactive


GIANNOPULOS, IOANNIS

Individual

Active


SINGH, CHARANJEET

Individual

Active


SINGH, HIMMAT

Individual

Active


BURIGO, REGINALDO

Individual

Inactive


SINHA, AMBRISH

Individual

Active


ZHU, YIN

Individual

Active


GOONDALL, RAHILL

Individual

Active


CHATZIGEORGAKIS, NIKOLAOS

Individual

Active


KODRA, ERJON JOHN

Individual

Active


PEREZ-COBO, CRISTIAN

Individual

Active


SHATAN, NICHOLAS

Individual

Inactive


LETZ, CHRISTOPHER

Individual

Active


GILDEA, JAMES

Individual

Active


TVERDY, JOHN D

Individual

Active


VASQUEZ, JOSE

Individual

Active


BATSIVARIS, DEMETRIOS

Individual

Active


PLAZAS, ROGER G.

Individual

Active


JIANG, QUN

Individual

Inactive


PEREZ, ARCESIO

Individual

Active


ANDRADE, ARTHUR A

Individual

Inactive


KEISER, STEVEN

Individual

Active


KOUNAS, NICK

Individual

Active


KAISER, JERRY

Individual

Active


DANIELS, WILLIE

Individual

Active


(default) 2 queries took 358 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 ( '(+EAST +ELMHURST)' IN BOOLEAN MODE) LIMIT 150, 50505081
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+EAST +ELMHURST)' IN BOOLEAN MODE)11277