N MERRICK [Permits for N MERRICK]

51 - 100 of 125

SHOGAN, ANDREW

Individual

Inactive


Bachas, Peter

Individual

Active



NINIVAGGI, MICHAEL J

Individual

Active


PERROTTA, GREGORY

Individual

Inactive


GALITOS, KONSTANTINOS

Individual

Active


MARINELLO, JAMES F

Individual

Inactive


GUSKIN, COREY

Individual

Inactive


JONNY'S JSG CONSTRUCTION CORP.

Business

Inactive


PB Titan Corp.

Business

Inactive


PABON, SOLEDAD R

Individual

Active


ANTIS, GREGORY E

Individual

Inactive


SCIULLA, DANIEL

Business

Active


DARCAN, NURSAD

Individual

Active


CUCCIAS, JAMES P

Individual

Active


LOVELIDGE, JEFFREY J

Individual

Inactive


GARCIA, SASHA A

Individual

Inactive



VILLAFANE CORPORATION

Business

Inactive


CUTTITTA, NUNZIO

Individual

Active


DIAMANTIDIS, NICHOLAS

Individual

Active



JANCKO, ROBERT D

Individual

Inactive


GIAMBRUNO, VINCENT G

Individual

Inactive


KIRBY, BEN C

Individual

Active


FINKEL, ANDREW

Individual

Active


STANLEY, MICHAEL

Individual

Inactive


Gotay, Daniel

Individual

Active


GEORGE, GEORGE H

Individual

Inactive


THE HOUSE OF LAURENCE

Business

Active


DARCAN, NURSAD

Individual

Inactive


OLIVO, EFRAIN

Individual

Active


GREENBERG, JOSEPH D

Individual

Active


FISCHETTO, DONALD

Individual

Active


SMITH, MICHAEL

Individual

Active


SINGH, HARJEET

Individual

Inactive


RATZKER, STEWART

Individual

Inactive


decosimo, Michael

Individual

Active


CICCONE, MICHAEL

Individual

Active



Bros Handywork Corp

Business

Inactive




CARECCIA, ANTHONY JAMES

Individual

Active


SCOLIERI, PAUL

Individual

Active


CRISPINO, CARMINE

Individual

Active


MERRICK USED CARS CORP

Business

Active




CARVER 10-15 MERRICK BLVD INC.

Business

Inactive


(default) 2 queries took 356 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 ( '(+N +MERRICK)' IN BOOLEAN MODE) LIMIT 50, 505050133
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+N +MERRICK)' IN BOOLEAN MODE)11223