ELMHURST [Permits for ELMHURST]

251 - 300 of 1579

DOMINGUEZ, MARIO

Individual

Active



SINGH, JASBIR

Individual

Active


LI, JINGHAN

Individual

Active


DOUKAKIS, NIKOLAOS

Individual

Active


COREA, ANDRE

Individual

Active


JAYBO'S PAWN CORP

Business

Active


WILSON, JOE

Individual

Inactive


ISLAM, ARIFUL

Individual

Active


CARPENTER

Business

Active


Wenzhou Wireless

Business

Active


SANCHEZ-PINEDA, JUAN

Individual

Inactive


JOSEPH, JEAN B

Individual

Inactive


TALK N FIX

Business

Active


WALGREENS STORE #04058

Business

Active


SP PLUS CORPORATION

Business

Active


100-15 DITMARS PARKING LLC

Business

Active


SPRINT SPECTRUM L.P.

Business

Active


PAWAR BROS CORP.

Business

Inactive


ZHENG, JEFF ZHEFAN

Individual

Active


APPLE INC.

Business

Active


WALGREENS STORE #04319

Business

Active


SPRINT SPECTRUM L.P.

Business

Active


GAVIRIA JR., JOHN J

Individual

Active


AHMED, SHABBIR

Individual

Active


SINGH, SUKHBIR

Individual

Inactive


KHAN, RIAZ

Individual

Active


PACUMIO, WALFREDO A

Individual

Active


BINER, HAMDI

Individual

Inactive


WALGREENS STORE #01616

Business

Active



GAO, FEI

Individual

Active


MANDI CONSTRUCTION CORP

Business

Active


DIAZ, ADRIAN

Individual

Active


FRANCISCO, ANDRIAN

Individual

Active


98-02 SUPERIOR DELI CORP.

Business

Active


PARRA, WILSON

Individual

Active



KUSOVAC, VLADIMIR

Individual

Active


KIZILYIL, HUSEYIN

Individual

Inactive


CHENG, GUO

Individual

Active


UMUT, EMRE

Individual

Inactive


ANDRADE, MIGUEL

Individual

Active



Your Wireless

Business

Inactive


MUSTAFA, ADEEL

Individual

Active


MARUTINANDAN 77 CORP

Business

Active


HUERTA, JORGE

Individual

Active


SP PLUS CORPORATION

Business

Active


LEVINE, SAMUEL

Individual

Active


(default) 2 queries took 285 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 250, 50505073
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)11212