CHATHAM [Permits for CHATHAM]

1 - 13 of 13

KALUSTIAN, LYNNE A

Individual

Active


xu, xiaoyan

Individual

Active


CHATHAM CLEANERS

Business

Inactive


OMNI CLEANER

Business

Inactive


GRACIE MANSION CLEANERS

Business

Inactive


OMNI CLEANER

Business

Inactive


XIKES, GREGORY J

Individual

Inactive


steif, maurice

Individual

Inactive


DAVID EVAN INC.

Business

Active


CHATHAM PARKING SYSTEMS INC.

Business

Inactive


Gracie Mansion Cleaners

Business

Active


CHATHAM CLEANERS, INC.

Business

Inactive


MH3 CO., INC.

Business

Inactive


(default) 1 query took 215 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 ( '(+CHATHAM)' IN BOOLEAN MODE) LIMIT 501313215