ELMHURST [Permits for ELMHURST]

201 - 250 of 1579

Hot, Samira

Individual

Active


SAEKI, TAMIKAZU

Individual

Active


MIEDZIEJEWSKI, MARCIN

Individual

Inactive


GORKHA MINI MART INC

Business

Active


A AND R GROCERY, INC.

Business

Active


SINGH, AVTAR

Individual

Active


RAMOS, CHARLIES

Individual

Active


VEEVA CONSTRUCTION 2 INC.

Business

Active


ASOPARDO, JOSEPH D.

Individual

Active


CORNER 77 BROADWAY

Business

Inactive


KEITA, PAPA

Individual

Inactive


ZARATE, LUIS ENRIQUE

Individual

Active


MUNOZ, JAVIER

Individual

Active


JOHNSON, CHRISTOPHER

Individual

Active


PARKER, HAYWOOD L

Individual

Active


xu, zhuo ran

Individual

Active


ZHICAY, CRISTIAN

Individual

Active


FRESH FOOD BAZAR INC.

Business

Active


SAFOS, ZACHARIAS

Individual

Active


DAY DELI GROCERY CORP.

Business

Active


DAVAL JEWELRY CORP

Business

Active


LORDTHAO, NARONG

Individual

Inactive


DOGANIS, GEORGIOS

Individual

Inactive



FRESH FOOD BAZAR INC.

Business

Active


B & D CONSTRUCTION NY, CORP.

Business

Inactive


SALIM, HASAN

Individual

Active


JUNCTION GOURMET DELI INC

Business

Active


Warranty Logistics, LLC

Business

Active


BUY-ONE COMPUTER INC.

Business

Active


SHERLOCK, JAMES D

Individual

Active


KOLPASHCHIKOV, VICTOR

Individual

Inactive


SPEEDWAY#07806

Business

Active


ALTAY, OMER

Individual

Active


BABIC, MARINKO

Individual

Inactive


Rodriguez Amendano, Raul

Individual

Active


SP PLUS CORPORATION

Business

Active


SP PLUS CORPORATION

Business

Active


VAZQUEZ, GEOVANNA

Individual

Inactive


BURIBAYEV, RASHID

Individual

Inactive


DURSI, FRANK

Individual

Active


SPRINT SPECTRUM L.P.

Business

Active


BERRETTINI, DANNY J

Individual

Active


SPEEDWAY #07808

Business

Active


ZHICAY CONSTRUCTION CORP

Business

Active


KLEVER, JOSE A.

Individual

Active


MIRACLE DELI CORP.

Business

Active


NEW YORK BUYERS GROUP INC.

Business

Inactive


KONTARINES, STEVE E

Individual

Inactive


WE-LINK EMPLOYMENT LLC

Business

Inactive


(default) 2 queries took 257 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 200, 50505034
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)11223