ELMHURST [Permits for ELMHURST]

301 - 350 of 1579

UMAROV, DANIYAR

Individual

Inactive


W.Q. TOWING

Business

Inactive


P & S CONTRACTING NY CORP

Business

Active


DANIEL, SANDEEP

Individual

Active


REZIR, PATRICK

Individual

Inactive


ALI, MOHAMMED

Individual

Active


OLIVER, FRANCISCO

Individual

Inactive


SINGH, MANPREET

Individual

Active


100-15 DITMARS PARKING LLC

Business

Active


YILDIZ, MURAT

Individual

Inactive


BAITEMIROV, DAUREN

Individual

Active


SERRANO, ANGEL W

Individual

Active


BERIOZA, OLEG

Individual

Inactive


KAJOL DELI & GROCERY INC.

Business

Active


BOCCIO, FRANCIS

Individual

Active


MOROCHO, JOFRE

Individual

Active


BHUTAN MULTI SERVICES

Business

Active


ONAY, MEHMET

Individual

Inactive


ROSSELLO, DOMINICK J

Individual

Active


THE KING OF TACOS HOUSE, INC

Business

Inactive


O SUNG TOWING

Business

Active


BLUE BLOOD TOWING CORP

Business

Inactive


CASE, STEVE

Individual

Active


DRAGAN, VALENTIN

Individual

Active


RAHMAN, MD

Individual

Inactive


PAEZ, PEDRO

Individual

Active


Rios, Jonathan

Individual

Inactive


SUAREZ, WILLIAM

Individual

Active


SOLER, JAMIE

Individual

Active


PAN, ZHONGQUAN

Individual

Active


AUTO IMAGE

Business

Active


SHIN, HO S.

Individual

Inactive


SHERLOCK, ANNMARIA

Individual

Active


PAPADOPOULO, JOHN

Individual

Inactive


GULSOY, ERAY ZUHURI

Individual

Inactive


MEHMOOD, RASHAAD

Individual

Active


GARAY GONZALEZ, MARIO

Individual

Active


ONOFRI, ADRIENNE

Individual

Active


DAYANC, AHMET

Individual

Inactive


KHOKHAR, ABDUL

Individual

Active


SABIR, MUHAMMOD

Individual

Inactive


MAUNG, YE

Individual

Active


GUARTAN CAJAMARCA, LUIS

Individual

Active


CHOW, HENRY

Individual

Active


SINCHI, LUIS

Individual

Inactive


WOJTCZACK, BERND

Individual

Active


KIM, JIN SANG

Individual

Active


MOGOLLON, ELMER

Individual

Inactive


MARTINEZ, RICHARD

Individual

Active


crown construction group

Business

Inactive


(default) 2 queries took 50 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 300, 50505050
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)110