LONG ISLAND CIT [Permits for LONG ISLAND CIT]

301 - 350 of 817

YIM, NAI MING

Individual

Active


VASQUEZ, ANGELO

Individual

Active



Long Island Builders Corp.

Business

Inactive


COLON, RANDY

Individual

Active


LONG ISLAND CONSTRUCTION PLUS

Business

Inactive


EREG, EMILY

Individual

Active


APTER, MATTHEW

Individual

Active


RISQUEZ, GERONIMO

Individual

Inactive


GALEA, JOSEPH

Individual

Active


OZGUR, ILKER

Individual

Inactive


CHIANG, PETER

Individual

Active


KIRKPATRICK, KEITH D.

Individual

Active



NIR, IDAN

Individual

Active


PRUNELLA, ANDRE

Individual

Active


PALLADIAN CONSTRUCTION LLC

Business

Active


FROES, FABIO

Individual

Active


BARTOLOTTA, ANTONIO

Individual

Active


KERSHAW, PREET

Individual

Active


SLINGERLAND, JOHN

Individual

Active


KIM, TEAHYUN

Individual

Active


WINDOW WORLD OF LONG ISLAND

Business

Active


TOPCU, FATIH

Individual

Active


NOWAK, ERIK

Individual

Active


MURRAY, CONSTANCE

Individual

Active


Courtney, Jillian

Individual

Active


SUGGS, LEONTA

Individual

Active


TOPCU, FATIH

Individual

Active


BAR CONSTRUCTION CORP.

Business

Active



CHAMPION PARKING NORTH LLC

Business

Inactive


STOJKOV, IGOR

Business

Inactive


ARISAM INC

Business

Inactive


LUXOR MOTOR CARS INC

Business

Active


NOOR DELI & GROCERY INC

Business

Active


SRN HOME IMPROVEMENT, LLC

Business

Active


HARLEY DAVIDSON OF NYC

Business

Active


LIC LOT, LLC

Business

Active


PIATTO

Business

Inactive


NEW YORK HONDA YAMAHA

Business

Active


47 operating llc

Business

Active


SMARTALK XII CORP.

Business

Inactive


SICULA RENOVATIONS INC.

Business

Active




CW CUSTOM INC

Business

Inactive


MEG VACUUM & SEWING

Business

Inactive




(default) 2 queries took 525 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 300, 505050153
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)11372