HOPEWELL JUNCTION [Permits for HOPEWELL JUNCTION]

1 - 23 of 23

SANTIAGO, LUIS

Individual

Active


KENNY, JAMES

Individual

Active


CONTO, JOHN

Individual

Active


Garcia, Damian

Individual

Active



MERCADANTE, DANTE

Individual

Active



HUGHES, THOMAS

Individual

Active


GABLEMAN, PHILIP

Individual

Active


WITMAN, ROY

Individual

Inactive


HUGHES, THOMAS

Business

Active


ENERGY FREE

Business

Inactive


ZINGARO, MICHAEL A

Individual

Active


ENERGY FREE LLC

Business

Active


PRENDERGAST, CYRIL P

Individual

Active



ALVARADO, RAMON

Individual

Inactive


JMI CONTRACTING CORP

Business

Active


ACEVEDO, ORLANDO

Individual

Inactive


SAUER, GARY

Individual

Inactive


GARCIA, DAMIAN

Individual

Active


AVILES, JOSELITO

Individual

Active


MARCUS PAVERS INC.

Business

Active


(default) 1 query took 349 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 ( '(+HOPEWELL +JUNCTION)' IN BOOLEAN MODE) LIMIT 502323349