LONG ISLAND CIT [Permits for LONG ISLAND CIT]

401 - 450 of 817

LUPOLI REALTY LLC

Business

Active


T M & T TIRE

Business

Active


VERNON NEWS, INC.

Business

Inactive


P.C. Richard & Son

Business

Active


SIMPLE LOVE CORP

Business

Active


Greenpoint Deli

Business

Active


I.N. BUILDERS GROUP INC

Business

Active


PAK GUJRAT AUTOMOTIVE INC

Business

Inactive


MP NORTHERN LLC

Business

Inactive


BAILEY, IDA

Individual

Active


JAMIE LAUNDROMAT COMPANY

Business

Inactive


TOWER AUTO MALL, INC.

Business

Active






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


Gem Pawnbrokers

Business

Inactive


TR CELES, INC.

Business

Active



H & J AUTO SALES, INC.

Business

Active


(default) 2 queries took 471 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 +CIT)' IN BOOLEAN MODE) LIMIT 400, 505050216
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+LONG +ISLAND +CIT)' IN BOOLEAN MODE)11255