MONTCLAIR [Permits for MONTCLAIR]

1 - 22 of 22

GALL, KRISHNA

Individual

Inactive


SMITH, JOSEPH

Individual

Active


LUTZ, JEFFREY

Individual

Inactive


89 MONTCLAIR CLEANERS INC.

Business

Inactive


31 MONTCLAIR CLEANERS INC.

Business

Inactive


HAMILTON, WILLIAM E

Individual

Active


CORDONNIER, PASCAL R

Individual

Active


MCDERMOTT, PATRICK

Individual

Active


SHERMAN, JOHN M

Individual

Active


mbaye, cheick

Individual

Inactive


Scandalios, Chris

Individual

Inactive


SAPP, ANTHONY C

Individual

Active


CORDONNIER CONTRACTING, LLC

Business

Active


KUPFERMAN, NOAH

Individual

Inactive


BOZARTH, WARREN

Individual

Active



DOWNING, JOHN

Individual

Active


MACON, VALENCIA

Individual

Inactive


COUNCIL, JONATHAN

Individual

Active


89 MONTCLAIR CLEANERS INC.

Business

Active


31 MONTCLAIR CLEANERS INC.

Business

Active


SHERWOOD PROPRIETARY

Business

Inactive


(default) 1 query took 220 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 ( '(+MONTCLAIR)' IN BOOLEAN MODE) LIMIT 502222220