ATHENS [Permits for ATHENS]

1 - 13 of 13

GREAT SOUTHERN AMUSEMENT LLC

Business

Inactive


BAGGOTT, BRIAN

Individual

Active


GOTHIC CABINET CRAFT

Business

Inactive


GOTHIC CABINET CRAFT

Business

Inactive


GOTHIC CABINET CRAFT

Business

Inactive


GOTHIC CABINET CRAFT

Business

Active


GOTHIC CABINET CRAFT

Business

Active


ATHENS WOODWORKING INC.

Business

Inactive


GOTHIC CABINET CRAFT

Business

Inactive


GOTHIC CABINET CRAFT

Business

Active


GOTHIC CABINET CRAFT

Business

Inactive


GOTHIC CABINET CRAFT

Business

Active


ATHENS WOODWORKING INC.

Business

Inactive


(default) 1 query took 255 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 ( '(+ATHENS)' IN BOOLEAN MODE) LIMIT 501313255