HOLLIS QUEENS [Permits for HOLLIS QUEENS]

1 - 17 of 17


WIRELESS 1 OF QUEENS VILLAGE

Business

Inactive


NEW HOLLIS 18 LAUNDROMATS LLC

Business

Inactive


HOLLIS HAPPY CLEANERS INC.

Business

Inactive


WIRELESS 1 OF QUEENS VILLAGE

Business

Inactive


HOLLIS DELI & GRILL CORP

Business

Active


QUEENS FINEST COLLISION INC

Business

Active


Queens Best Auto

Business

Inactive


QUEENS FINEST COLLISION INC

Business

Active


HANOMAN, CHANDILALL

Individual

Active


HOLLIS 18 LAUNDROMATS LLC

Business

Inactive


206 HOLLIS LAUNDROMAT, LLC

Business

Inactive


HOLLIS JEWELRY LLC

Business

Active


Queens Best Auto

Business

Active


HOLLIS HAPPY CLEANERS INC.

Business

Active



QUEENS FINEST AUTO BODY INC.

Business

Inactive


(default) 1 query took 254 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 ( '(+HOLLIS +QUEENS)' IN BOOLEAN MODE) LIMIT 501717254