EAST ELMHURST [Permits for EAST ELMHURST]

351 - 400 of 609

MARPRO CONSTRUCTION CORP

Business

Inactive


J-PRO CONTRACTING INC.

Business

Inactive


G DESIGN LLC

Business

Active


CORONA TRANSMISSION CORP.

Business

Active


F.S. AND SON CORP

Business

Active


ALL AMERICAN SUDS, INC.

Business

Inactive


DSM LAUNDROMAT INC

Business

Active


S. LIBERTY CONSTRUCTION INC

Business

Active



gold buyer inc

Business

Inactive


GAMESTOP STORE #7550

Business

Inactive


ARIAS-LEON, HORTENCIA

Business

Active



SINGH GANGA, PATRICIA

Individual

Active


TSAKSOS RESTORATION INC.

Business

Active


CHATA CONSTRUCTION CO. INC.

Business

Active


ESSEX CONSTRUCTION CORP.

Business

Active


GENERAL AUTO GLASS, LLC

Business

Inactive


SADHRA CONSTRUCTION CORP.

Business

Active



J & P SIDING CORP

Business

Inactive


G.T.R 2 CORP.

Business

Active


U.F. DUTAN CORP.

Business

Active



C & J RESTORATION INC

Business

Inactive



SUN BRITE LAUNDROMAT INC.

Business

Active



GAMESTOP STORE #7550

Business

Inactive


NY RENO PROS INC

Business

Active


PRIME CONTRACTING E.P.

Business

Active


G&Q LAUNDROMAT, INC

Business

Active


JAURA CONSTRUCTION LLC

Business

Inactive


HOLIDAY INN CROWN PLAZA

Business

Active



RITE AID STORE #10596

Business

Active


YUKON REMODELING, INC.

Business

Active


THE PAISA JEWELRY CSP CORP

Business

Active


EGAN INTERIORS LLC

Business

Active


CLARION LAGUARDIA

Business

Inactive



THE PAISA JEWELRY CSP CORP

Business

Inactive


NEW A.D. LAUNDROMAT,INC

Business

Active



EAST ELMHURST GROCERY CORP

Business

Active


KUMAR, HARDEEP

Business

Inactive


SJC DELI FOOD CORP.

Business

Inactive



ALFANDY CONTRACTOR CORP.

Business

Active



(default) 2 queries took 444 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 350, 505050184
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)11260