FRANKLIN LKS [Permits for FRANKLIN LKS]

201 - 218 of 218

ANGI'S GROCERY STORE

Business

Inactive


P & F EXPRESS AUTO BODY

Business

Active


FRANKLIN DELI & GROCERY

Business

Inactive


STP FRANKLIN INC

Business

Active


507 FRANKLIN CLEANERS, INC.

Business

Active



MD CBD 180 FRANKLIN LLC

Business

Active




FRANKLIN DELI

Business

Inactive


KING FRANKLIN DELI CORP.

Business

Active


FRANKLIN SMOKE SHOP INC

Business

Active


BROTHER'S DELI GROCERY

Business

Inactive


FRANKLIN LAUNDROMAT

Business

Inactive


JAZMIN FLORIST

Business

Active



FRANKLIN, CHARLES

Business

Inactive


KR LEGAL SERVICES

Business

Inactive


(default) 2 queries took 447 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 ( '(+FRANKLIN +LKS)' IN BOOLEAN MODE) LIMIT 200, 501818223
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+FRANKLIN +LKS)' IN BOOLEAN MODE)11224