PITTSBURGH [Permits for PITTSBURGH]

1 - 9 of 9

CARSON SMITHFIELD, LLC

Business

Active



TRANSWORLD SYSTEMS INC.

Business

Inactive


TRANSWORLD SYSTEMS INC.

Business

Active


CREDIT MANAGEMENT COMPANY

Business

Active


DAVIS, HARRY

Individual

Active


DAVIS, MARTIN

Individual

Active


EGS FINANCIAL CARE, INC

Business

Active


COLLECTION MANAGEMENT COMPANY

Business

Inactive


(default) 1 query took 213 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 ( '(+PITTSBURGH)' IN BOOLEAN MODE) LIMIT 5099213