DUMONT [Permits for DUMONT]

1 - 15 of 15

GRABSTEIN, MARTY C

Individual

Active


ROI, RUBEN

Individual

Active


QUINN, THOMAS

Individual

Active


MCINTYRE, SHANE

Individual

Active


Tolve, Jeanine

Individual

Inactive


AJRAM, AREF

Individual

Active



SAFA, MAHER

Individual

Active


O'HAGAN, NIALL

Individual

Inactive


BECKER, JASON M

Individual

Active



DUMONT DELI & GROCERY INC.

Business

Active


DUMONT DELI GROCERY

Business

Inactive


ARTISAN CRAFT BUILDERS LLC

Business

Inactive


DUMONT BURGER LLC

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 ( '(+DUMONT)' IN BOOLEAN MODE) LIMIT 501515220