LONG IS CITY [Permits for LONG IS CITY]

51 - 100 of 920

TWO MI KIM DRY CLEANERS, INC.

Business

Inactive


LUCKY MAMA LAUNDROMAT

Business

Inactive


Roessler, Kurt

Individual

Active


ASPL CAFE, INC.

Business

Inactive


T & J CRYSTAL, INC.

Business

Inactive


TAYLOR, DANIEL

Individual

Active


EMBASSY LOUNGE

Business

Inactive


FAMOLARI, GERALD

Individual

Active


QUEENS LIC PARKING LLC

Business

Active


SUGARDADDY'S

Business

Inactive



OKS CLEANERS INC.

Business

Inactive


ROMERO, JOSE A

Individual

Inactive


DARSIN, SANDRO

Individual

Inactive


BAKER, CHRISTIAN

Individual

Active


HOOD, AKEEM D.

Individual

Inactive


DEBNATH, BIMAL

Individual

Active


LONG ISLAND CITY FLOWER INC

Business

Active


AHMAD, MUSHTAQ

Individual

Inactive



MELENDEZ, JUAN

Individual

Active


CIAMPA CRESCENT LLC

Business

Inactive


CK PROCLEANERS INC

Business

Active


SGROI, ANTHONY D

Individual

Active


LEGACY FRENCH CLEANERS INC

Business

Inactive


GYPSY ROSE

Business

Inactive


VISTA SKY LOUNGE & CATERING

Business

Inactive


LIC EVERGREEN CLEANERS, INC.

Business

Inactive


3868 PROCLEANERS INC

Business

Inactive


HARKINS, JOHN

Individual

Active


TOP FABRIC CARE INC.

Business

Inactive


PACKARD SQUARE CLEANERS CORP.

Business

Inactive


E Z PAWN CORP.

Business

Active



ALEX ENTERPRISE

Business

Active


KOLJENOVIC, MEDZID

Individual

Active


ARANIBAR, MARTIN W

Individual

Inactive


CHRAIBI MIOU, NACER

Individual

Inactive


FORTIN, HUGO

Individual

Active


J & J NEWS, INC.

Business

Active


MORAN, MARTIN A

Individual

Active


LIC NEWSPAPER STORE, INC

Business

Active



VAN ROSENDAAL, PATRICK

Individual

Active


TABACKMAN, AARON

Individual

Active


EZ PAWN CORP

Business

Active


McEntee, Gerard

Individual

Active


US BRAZIL GROCERY INC

Business

Active


PLAZA EXPRESS DELI, INC.

Business

Active


NEWS AT VERNON INC

Business

Active


(default) 2 queries took 438 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 +IS +CITY)' IN BOOLEAN MODE) LIMIT 50, 50505039
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+LONG +IS +CITY)' IN BOOLEAN MODE)11399