EAST ELMHURST [Permits for EAST ELMHURST]

101 - 150 of 609

AHMED, SHABBIR

Individual

Active


SINGH, SUKHBIR

Individual

Inactive


MANDI CONSTRUCTION CORP

Business

Active


DIAZ, ADRIAN

Individual

Active


98-02 SUPERIOR DELI CORP.

Business

Active


MUSTAFA, ADEEL

Individual

Active


HUERTA, JORGE

Individual

Active


P & S CONTRACTING NY CORP

Business

Active


DANIEL, SANDEEP

Individual

Active


OLIVER, FRANCISCO

Individual

Inactive


SINGH, MANPREET

Individual

Active


100-15 DITMARS PARKING LLC

Business

Active


THE KING OF TACOS HOUSE, INC

Business

Inactive


CASE, STEVE

Individual

Active


DRAGAN, VALENTIN

Individual

Active


PAEZ, PEDRO

Individual

Active


Rios, Jonathan

Individual

Inactive


SUAREZ, WILLIAM

Individual

Active


SOLER, JAMIE

Individual

Active


SHIN, HO S.

Individual

Inactive


PAPADOPOULO, JOHN

Individual

Inactive


MEHMOOD, RASHAAD

Individual

Active


DAYANC, AHMET

Individual

Inactive


KHOKHAR, ABDUL

Individual

Active


GUARTAN CAJAMARCA, LUIS

Individual

Active


SINCHI, LUIS

Individual

Inactive


WOJTCZACK, BERND

Individual

Active


crown construction group

Business

Inactive


VELEZ, LUIS R.

Individual

Active


SARAFELNTIN, CHRISTOS

Individual

Inactive


MOSQUERA, GRICELIO

Individual

Active


Gallardo, Earvin

Individual

Inactive


SUASNABAR, JORGE HUGO

Individual

Active


KEITA, PAPA

Individual

Inactive


OSORIO, CARLOS

Individual

Inactive


BIESINGER, IAN-JOSEF

Individual

Inactive


HAYAT, SHAUKAT

Individual

Active


TSERING, TASHI

Individual

Active


AFM, MAHIBULLAH

Individual

Active


forbes, franz

Individual

Active


SAPOKOLOS, ARISTOTELIS

Individual

Inactive


ANJUM, MASNOON

Individual

Active


ESPINOSA, EDGAR

Individual

Inactive


IOCCO, DANIEL E

Individual

Active


GARCIA, LEGNI H.

Individual

Active


CONNORS, EDWARD

Individual

Active


SAVVA, SAVVAS

Individual

Inactive


IQBAL, NASIR

Individual

Active


ROSADO, NOEL A

Individual

Active


LOPEZ, GUSTAVO

Individual

Active


(default) 2 queries took 297 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 100, 50505065
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)11232