Long Island City [Permits for Long Island City]

351 - 400 of 695

BROUSKO

Business

Inactive


LAST STOP GARAGE

Business

Active


Stone Masters, Inc

Business

Active


OKS CLEANERS INC.

Business

Active


LUCKY CLEANERS

Business

Active


LIC ORGANIC GOURMET DELI INC

Business

Inactive


APRIA HEALTHCARE LLC

Business

Active


PENTA RESTORATION CORP.

Business

Active


KING OF QUEENS AUTOMOTIVE, LLC

Business

Inactive


SILVER STAR MOTORS

Business

Active


ALPHA LAUNDROMAT INC

Business

Active




NEW HARI AUTO REPAIR INC.

Business

Inactive



nb net solutions 13 inc

Business

Active



L.T. MOTORS AUTO SALES INC.

Business

Inactive


CESI VERNON CORP

Business

Active


BELLA VIA RESTAURANT

Business

Active


MOISHE'S MINI STORAGE, INC.

Business

Active


TGM AUTO SERVICE INC.

Business

Active


VAN-GOGH PAINTING, CORP.

Business

Inactive


TOP NOTCH FINISHES INC.

Business

Active


WEB LAUNDROMAT LTD

Business

Active


EXPRESS 1 LAUNDROMAT

Business

Active



P & A CANDY & DELI INC.

Business

Inactive


TR CELES, INC.

Business

Active



H & J AUTO SALES, INC.

Business

Active


LIC NEWSPAPER STORE, INC

Business

Active


RAM ALIGNMENT

Business

Active


MERCURY ELECTRONICS, INC.

Business

Inactive


MP HUNTER 50 LLC

Business

Active


Hess Express #32502

Business

Inactive


CAPO AUCTION

Business

Active


GUITAR CENTER #812

Business

Active


GOOD FORTUNE LAUNDROMAT INC

Business

Active


TPEC CRESCENT LLC

Business

Active



M & B TWINS COLLISION INC.

Business

Active


J&J FLOORMASTERS INC.

Business

Active


EVISTA GROUP, INC.

Business

Active


EUROPA WOODWORK INC.

Business

Active


CENTURION SOLAR ENERGY, LLC

Business

Active


AIK RENOVATION INC

Business

Active


PETER COSOLA, INC.

Business

Active


MODERN WOOD OF NY INC

Business

Inactive


INTERCONTINENT, INC.

Business

Active


(default) 2 queries took 142 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 ( '(+Long +Island +City)' IN BOOLEAN MODE) LIMIT 350, 505050142
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Long +Island +City)' IN BOOLEAN MODE)110