Car Wash [Permits for Car Wash]

301 - 333 of 333

WASH IT HERE INC

Business

Inactive





76

Business

Inactive


PLAN 233 SPARK-WASH INC.

Business

Inactive


Bruckner Creation Inc.

Business

Active


MASPETH WASH RITE LAUNDROMAT

Business

Inactive


YELLOWSTONE WASH

Business

Active


GLADY'S WASH & DRY CLEANERS

Business

Active


109TH & FIRST AVENUE CORP

Business

Active


SMART CAR WASH CORP.

Business

Active


WONDER WASH AND DRY INC.

Business

Active


STAR BRITE LAUNDROMAT

Business

Inactive


WOW TEN WASH INC

Business

Active


THRIFT-O-WASH INC.

Business

Active


WASH'S UP LAUNDROMAT INC

Business

Active


LUCKY MACHINE WASH, CORP.

Business

Active


SUPER WASH CENTER

Business

Active


SNOW WASH LAUNDROMAT INC

Business

Inactive


NEREUSS CORP.

Business

Active


WASH-O-MATIC

Business

Inactive



N Y WASH INC.

Business

Active


JJ WASH, INC

Business

Active



IMPERIAL CWL INC.

Business

Active


A & S CAR CLEAN LLC

Business

Active


CLEANER WASH INC.

Business

Active


WONDER WASH

Business

Inactive


ARMSTRONG CAR WASH INC

Business

Active


Gentle Wash Laundromat

Business

Active


SUNSET PARK STAR WASH LLC

Business

Active


(default) 2 queries took 773 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 ( '(+Car +Wash)' IN BOOLEAN MODE) LIMIT 300, 503333391
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Car +Wash)' IN BOOLEAN MODE)11382