HOLLYWOOD [Permits for HOLLYWOOD]

1 - 20 of 20

Stampler, Harry

Individual

Active


Stampler Auctions

Business

Active


NEW HOLLYWOOD CLEANERS INC.

Business

Inactive


HOLLYWOOD ENTERPRISE, INC.

Business

Inactive


JNK HOLLYWOOD, INC.

Business

Inactive


HOLLYWOOD DRY CLEANERS.

Business

Inactive


HOLLYWOOD DRY CLEANING INC.

Business

Inactive


HOLLYWOOD DINER

Business

Active


TEARLE, CHARLES

Individual

Active




JNK HOLLYWOOD, INC.

Business

Active



DOWNTOWN CLEANERS

Business

Active


HOLLYWOOD ENTERPRISE, INC.

Business

Active


NEW HOLLYWOOD CLEANERS INC.

Business

Active


HOLLYWOOD DRY CLEANERS INC,

Business

Active





(default) 1 query took 217 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 ( '(+HOLLYWOOD)' IN BOOLEAN MODE) LIMIT 502020217