N CHARLESTON [Permits for N CHARLESTON]

1 - 9 of 9

KARALES, MONICA J

Individual

Inactive


ALLIED INTERSTATE LLC

Business

Active


araujo, charleston

Individual

Active


SYNTER RESOURCE GROUP, LLC

Business

Active


SYNTER RESOURCE GROUP, LLC

Business

Inactive


ALLIED INTERSTATE LLC

Business

Inactive


CHARLESTON

Business

Active



34 THE CHARLESTON VALET, INC.

Business

Inactive


(default) 1 query took 357 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 ( '(+N +CHARLESTON)' IN BOOLEAN MODE) LIMIT 5099357