ELMHURST [Permits for ELMHURST]

401 - 450 of 1579

LOPEZ, GUSTAVO

Individual

Active


HADI, AMINE

Individual

Inactive


SINGH, SATNAM

Individual

Inactive


WU, LESHEN

Individual

Active


MURIEL, JHON

Individual

Active


CHEN, A YU

Individual

Inactive


BELLO, NANCY

Individual

Active


AXHAMI, KISMET

Individual

Active


AXHAMI, ELTON

Individual

Active


MILLER, IVAN

Individual

Active


SEMINARIO, MIRIAM I.

Individual

Active


TORRES, ENRIQUE JR

Individual

Inactive


LEMA, CRISTIAN

Individual

Active


LAW, CHAI GUAN

Individual

Inactive


FORMAN, BRIAN W

Individual

Inactive


PAN, LI

Individual

Active


BEKESSOV, ANARBEK

Individual

Inactive


CHAVEZ, WILLIAM

Individual

Inactive


TSOI-AHO, RAULE

Individual

Active


SHAIKH, ZUBAIR

Individual

Inactive


KAUR, JASWANT

Individual

Active


SINGH, RAM

Individual

Active


DIAZ, MARIO, A

Individual

Active


LI, XIN YUAN

Individual

Inactive


MAHMOOD, NASIR

Individual

Active


SINGH, DAVINDER

Individual

Active


SANCHEZ, RICARDO

Individual

Active


ORTIZ, LEON

Individual

Inactive


HERRERA, LUIS

Individual

Active


SEMINARIO, FRANKLIN A

Individual

Active


KUMAR, MANOJ

Individual

Active


NABILI, TURAL

Individual

Inactive


AHMED, MUSHTAQ

Individual

Active


PAGLINAWAN, NOEL A

Individual

Inactive


BRAUN, MARYANN

Individual

Inactive


SINCHI, LUIS

Individual

Active


AREVALO, JORGE R

Individual

Active


VIDAL, JOSE

Individual

Active


SINGH, NISHAN

Individual

Active


HUSSAIN, FIAZ

Individual

Active


CLAVIJO, JOSE F

Individual

Active


SALIMBEKOV, DOSSYMZHAN

Individual

Inactive


LUNA, CINTHIA

Individual

Active


ETTAMYMY, ZAK

Individual

Inactive


SINGH, MANOJ

Individual

Active


Castro, Pennapa

Individual

Active


MONTEHERMOSO, CARLOS

Individual

Active


HOQUE, HAMIDUL

Individual

Active


PEREZ, EDWIN

Individual

Active


ULLOA, ANGEL G.

Individual

Inactive


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