LONG ISLAND CIT [Permits for LONG ISLAND CIT]

151 - 200 of 817

P.C. RICHARD & SON

Business

Active


BOUTEBIBA, EL ARABI

Individual

Inactive


TMT TIRE

Business

Inactive


SPEEDWAY #07830

Business

Active


NOOR DELI & GROCERY INC

Business

Active




449-A MAC, LLC

Business

Active


L.I.C. DELI GROCERY INC 1

Business

Active


LA PADULA, STEPHEN J

Individual

Inactive


SUTTON JR, DOUGLAS

Individual

Active



OBSTACLE COURSE 70 LONG

Business

Active



ERENOGLU, EGEHAN

Individual

Inactive



P.C. RICHARD & SON

Business

Active


1-2-3 TOWING

Business

Inactive



SPANKY'S ASSET RECOVERY INC.

Business

Inactive


PEREZ, JOSE

Individual

Active



MIDTOWN OPERATING CORP.

Business

Active


SUREN, ARIF

Individual

Inactive


SP PLUS CORPORATION

Business

Active


NAULA MAZA, SEGUNDO

Individual

Active


Ertas, Erman

Individual

Inactive


SWEENEY, TERENCE

Individual

Active


P.C. RICHARD & SON

Business

Active


A.T.A. TOWING, INC.

Business

Inactive


P.C. RICHARD & SON

Business

Active





Nimmer, Andrew

Individual

Active




MAIORANA, BRIAN

Individual

Active


USAC TOWING CORP.

Business

Inactive



WHALEY, SHARICE

Individual

Inactive


PRUNELLA, VINCENT

Individual

Active


ESCHELBACHER, MARK B

Individual

Active



Paynow Inc

Business

Inactive


THRIFTOLOGY LLC

Business

Active


TAYLOR, JASON

Individual

Active


PERSAUD, ALICEIA

Individual

Inactive


PANTOJA, RENE

Individual

Inactive


HOUIS, SERGE JACQUES

Individual

Active


(default) 2 queries took 281 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 150, 50505050
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)11231