EAST ELMHURST [Permits for EAST ELMHURST]

401 - 450 of 609

BABIC, MARINKO

Business

Inactive


ENTERPRISE CAR SALES

Business

Active


T-MOBILE

Business

Inactive


ULLOA, JOSE D.

Business

Inactive


MORA CONSTRUCTION INC.

Business

Inactive


ACTIVE AIR SYSTEMS INC.

Business

Inactive


OLD V & D CONSTRUCTION CORP

Business

Inactive


HI-STYLE CLEANERS CORP.

Business

Active



SYED EMPIRES INC.

Business

Active





Hess Express #32504

Business

Inactive


Miracle Method

Business

Active



32-01 JUNCTION INC.

Business

Active


KESRI CONSTRUCTION INC

Business

Inactive


NEW TREND LAUNDROMAT CORP

Business

Inactive


LIONEL CONTRACTING CORP

Business

Active


LAGUARDIA WIRELESS CORPORATION

Business

Inactive


T-Mobile Limited

Business

Active




GENERAL LABOR

Business

Active


LION KING HOME IMPROVEMENT

Business

Active


CABRERA, CHRISTIAN

Individual

Active


93RD DELI CORP I

Business

Active


MAJESTIC HOME IMPROVEMENT.

Business

Active


RAB Construction

Business

Inactive


PROWISH CONSTRUCTION CORP

Business

Active


KBS ENTERPRISES LTD.

Business

Inactive


THE NEXT STEP

Business

Inactive


ALBERT'S GIFT SHOP, INC.

Business

Inactive


GA CONTRACTORS LTD

Business

Inactive


RICOCHET CONSTRUCTION CORP.

Business

Active


M & R DELI GROCERY CORP.

Business

Active



DEMO CUSTOM CABINETS INC.

Business

Active


KOEPPEL NISSAN, INC.

Business

Inactive


SPY GIRLS

Business

Active


DYNAMIC FLOORING & MORE INC

Business

Active



A D DELI GROCERY

Business

Inactive


SNOW LION HOME IMPROVEMENT

Business

Active



Rios Interiors Corporation

Business

Active


FILIS CORP.

Business

Inactive


TUSU CONTRACTING INC

Business

Active


A.V.K. Contracting Corp

Business

Active


(default) 2 queries took 397 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 400, 505050161
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)11236