EAST ELMHURST [Permits for EAST ELMHURST]

1 - 50 of 609

allahverdi, samet

Individual

Inactive


FAULKNER, EDNA

Individual

Inactive


PEREZ, ELAINY

Individual

Inactive


FARHAT, OMAR

Individual

Active


KORMENDY, REKA

Individual

Inactive


BARRAGAN, SERGIO

Individual

Inactive


HECHAVARRIA, ANNA M

Individual

Inactive


A.G.J. METRO DELI CORP.

Business

Inactive


MORETZKY, ALEX

Individual

Inactive


OREJUELA, MANUEL A.

Individual

Active


SINGH, HIMMAT

Individual

Inactive


MURUDUMBAY, SANDRA

Individual

Active


QUINTANA, FABIAN OMAR

Individual

Active


OCHOA RENOVATIONS INC.

Business

Inactive


POLANCO, LEONEL

Individual

Active


SALAZAR, WILLIAM

Individual

Inactive


BUTTNER, JOHN GEORGE

Individual

Active


LUPITA LAUNDROMAT INC

Business

Inactive


GALLEGO, MOISES

Individual

Inactive


BAROULAKIS, HARRY

Individual

Active


PAPADATIS, FOTIS

Individual

Active


CURIEL, JUAN C

Individual

Inactive


BENJAMIN CLEANERS

Business

Inactive


CLEAN CITY E ELMHURST, LLC

Business

Inactive


PLAZA, JULIO C

Individual

Active


LA GUARDIA LAUNDRY MART CORP.

Business

Inactive


HI-STYLE CLEANERS CORP.

Business

Inactive


SANABRIA, OSCAR

Individual

Active


GUERRA, MANUEL R

Individual

Active


DELAHANTY, JAMES E

Individual

Active


GARDEN BAY CLEANER 1 INC

Business

Inactive


CORONA, ROBERT

Individual

Active


MOROCHO, GERMAN

Individual

Inactive


MARCANO, ENRIQUE

Individual

Active


SIBRE, ROBERTH

Individual

Active


LUXURY LAUNDROMAT, INC

Business

Inactive


KEARNEY STREET LAUNDROMAT INC.

Business

Inactive


URREHMAN, KHALIL

Individual

Active


DSM LAUNDROMAT INC

Business

Inactive


CHILLOGALLI, CESAR

Individual

Active


USA CLEAN CENTER CO., INC.

Business

Inactive


RENOIR FRENCH CLEANERS

Business

Inactive


TJP CLEANERS INC

Business

Inactive


ENCARNACION, DANILSA

Individual

Inactive


ULLAH, NAQI

Individual

Active


32-01 JUNCTION INC.

Business

Inactive


G&Q LAUNDROMAT, INC

Business

Inactive


KINGS AND QUEENS HOMES CORP

Business

Inactive


M.Y LAUNDROMAT

Business

Inactive


BAO'S LAUNDROMAT INC.

Business

Inactive


(default) 2 queries took 323 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 50505082
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)11241