MASTIC [Permits for MASTIC]

1 - 17 of 17

FIRST IMPRESSIONS

Business

Inactive


HHI TECH INC.

Business

Active


DISTEFANO, ALICIA

Individual

Inactive


PRO LEVEL LINE INC

Business

Active


EFL SERVICES INC

Business

Active


FLORES, ERICK

Individual

Active


JDM HOME SERVICES INC.

Business

Inactive


RODRIGUEZ, MARCIA

Individual

Inactive


TORRES, NELSON

Individual

Inactive


ROSEN, ARTHUR

Individual

Active


HERON, MICHAEL A

Individual

Active


SCANLON, MICHAEL

Individual

Active


JACKSON, WILLIAM

Individual

Inactive


NARGI, ERIC J.

Individual

Inactive


PERRY, JOHN

Individual

Inactive


MCGOVERN, KARL

Individual

Active


ISLAND EAST FINISHING

Business

Inactive


(default) 1 query took 225 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 ( '(+MASTIC)' IN BOOLEAN MODE) LIMIT 501717225