KEW GARDENS [Permits for KEW GARDENS]

1 - 50 of 534

BROWNELL, LOCKSLEY S

Individual

Active


MALLA, FILOTEO

Individual

Active


PIERRE, JOSUE

Individual

Inactive


JONES, BRIGITTE

Individual

Inactive


TAVERAS, ADAM

Individual

Active


Katz, Lior

Individual

Active


BAYSIDE GROCERY & DELI, INC.

Business

Inactive



JEAN-PIERRE, ANTOINE

Individual

Active


KHAN, RIZWAN

Individual

Active


WINDSOR PARK CLEANERS

Business

Inactive



DONG & JING, CORP.

Business

Inactive


LEO LEVI & SON INC

Business

Inactive



MCDERMON, MICHAEL

Individual

Active


Chen, Henry

Individual

Active


CL CLEANERS, INC.

Business

Inactive


8168 LAUNDRY SERVICES LLC

Business

Inactive


MARONAK, JOSE O

Individual

Active


OAKLAND GARDEN CLEANERS CORP.

Business

Inactive


LASHLEY, COREY

Individual

Inactive


NEW GRANT CLEANERS

Business

Inactive


RASHEED, HAROON

Individual

Active


JOY S. CLEANERS INC.

Business

Inactive


KEW GARDENS LAUNDROMAT INC

Business

Inactive


ELENA DRY CLEANER INC

Business

Inactive


YANG HING LAUNDROMAT INC

Business

Inactive


SKY VIEW CLEANERS INC.

Business

Inactive


BAYSIDE FAMILY LAUNDROMAT INC

Business

Inactive


KHAITOV, SERGEY

Individual

Active


MITCHELL GARDENS CLEANERS INC.

Business

Inactive


EXECUTIVE FABRICARE NY

Business

Inactive


BAYSIDE LAUNDROMAT INC

Business

Inactive


WL LAUNDRY SERVICE, INC.

Business

Inactive


BLACK, ERIC

Individual

Active


OK CLEANERS

Business

Inactive


LEE LAUNDROMAT

Business

Inactive


ARCE, JUAN

Individual

Active



LAMODA CUSTOM TAILORS INC

Business

Inactive


PARHAR, JODH S

Individual

Inactive


SPRINGFIELD LAUNDROMAT INC.

Business

Inactive


6 MEN ENTERPRISE INC

Business

Inactive


WASH AND FOLD SUPER LAUNDRY

Business

Inactive


ROLDAN, DOMINGO

Individual

Inactive


BURD J LAU LAUNDROMAT

Business

Inactive


O'BRIEN, JAMES

Individual

Active


SHAKED, YOSSI

Individual

Active


Bashir, Sohail

Individual

Active


(default) 2 queries took 243 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 ( '(+KEW +GARDENS)' IN BOOLEAN MODE) LIMIT 50505025
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+KEW +GARDENS)' IN BOOLEAN MODE)11218