AIRMONT [Permits for AIRMONT]

1 - 17 of 17

GUTTMAN, JACOB

Individual

Active


NAILIT HANDYMAN LLC

Business

Active


WALD, ANNA

Individual

Active


MOZART UNLIMITED, LLC

Business

Active


KALISCH, MICHAEL

Individual

Active


Abuladze, Malkhaz

Individual

Inactive


MURPHY, FRED

Individual

Active


LIEF, LESLIE A

Individual

Active


STRASSER, PETER J

Individual

Inactive


R.C.A. ROOFING

Business

Active


VALDEZ, MIRCA M

Individual

Active


SIMON, ABRAHAM

Individual

Active



DCQ, LLC

Business

Inactive


CCS CREDIT COLLECTIONS

Business

Inactive


STRASSER & ASSOCIATES INC

Business

Inactive


DCQ, LLC

Business

Inactive


(default) 1 query took 221 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 ( '(+AIRMONT)' IN BOOLEAN MODE) LIMIT 501717221