HARRISBURG [Permits for HARRISBURG]

1 - 7 of 7

FRIEDLANDER, MARC STEPHEN

Individual

Inactive


Penn Credit Corporation

Business

Active


NATIONAL RECOVERY AGENCY

Business

Active


LEGUENNES, ANNIE

Individual

Active


AMERICAN AGENCIES, LLC

Business

Inactive


DELGADO, STEVEN

Individual

Active


SILBERMAN, LINDA

Individual

Active


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