ELMHURST [Permits for ELMHURST]

1 - 50 of 1579

allahverdi, samet

Individual

Inactive


CHIEN, TOM JENG-HUAH

Individual

Inactive


Soe, Yan Naing

Individual

Active


FAULKNER, EDNA

Individual

Inactive


DJ GROCERY DELI NY INC.

Business

Inactive


Valentin, Wilfrido

Individual

Inactive


Barney, Michael

Individual

Active


PEREZ, ELAINY

Individual

Inactive


YOH, MENG NAN

Individual

Active


YAMIN FOOD MART INC

Business

Inactive


VELEZ, JORGE

Individual

Inactive


CORNER 77

Business

Inactive


FARHAT, OMAR

Individual

Active


MARIA GROCERY STORE INC

Business

Inactive


LIU, ZHONG HUANG

Individual

Inactive


GRAB AND GO CANDY GROCERY CORP

Business

Inactive


TOLLI, DANIEL

Individual

Active


KORMENDY, REKA

Individual

Inactive


ZHAO, XIAO YUN

Individual

Active


WU, XUE SONG

Individual

Active


HERNANDEZ, JAIRO

Individual

Active


G & K FLORCHID, CORP.

Business

Inactive


BARRAGAN, SERGIO

Individual

Inactive



HECHAVARRIA, ANNA M

Individual

Inactive


LA CALENITA BAKERY

Business

Inactive


WU, MICHAEL

Individual

Inactive


PADILLA, DAVID

Individual

Active


A.G.J. METRO DELI CORP.

Business

Inactive


JIN, GAB

Individual

Active


MORETZKY, ALEX

Individual

Inactive


OREJUELA, MANUEL A.

Individual

Active


CRUZ, RICHARD

Individual

Active


SINGH, HIMMAT

Individual

Inactive


LAMA, MINGMA

Individual

Inactive


MANGO RICO INC.

Business

Inactive


MURUDUMBAY, SANDRA

Individual

Active


RODRIGUEZ MOROCHO, WILMER

Individual

Inactive


QUINTANA, FABIAN OMAR

Individual

Active


OCHOA RENOVATIONS INC.

Business

Inactive


POLANCO, LEONEL

Individual

Active


SALAZAR, WILLIAM

Individual

Inactive


BUTTNER, JOHN GEORGE

Individual

Active


POLLOS Y MAS CORP

Business

Inactive


LUPITA LAUNDROMAT INC

Business

Inactive


GALLEGO, MOISES

Individual

Inactive


BAROULAKIS, HARRY

Individual

Active



LAMA, MINGMA

Individual

Active


PAPADATIS, FOTIS

Individual

Active


(default) 2 queries took 271 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 5050508
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)11263