DANBURY [Permits for DANBURY]

1 - 13 of 13

GHANIE, MARC A.

Individual

Active


PREFERRED AIR SYSTEMS, INC

Business

Active


GHANIE, MARC A.

Business

Active


QUINN, DECLAN

Individual

Active


MEZZETTA, LUIGI

Individual

Active


CHAVE, RUSSELL

Individual

Inactive


FIORELLI, ROLANDO

Individual

Active


CREDIT CENTER, LLC

Business

Active




WILLIAMS, HERMAN G,

Individual

Active



CARTUS CORPORATION

Business

Inactive


(default) 1 query took 235 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 ( '(+DANBURY)' IN BOOLEAN MODE) LIMIT 501313235