WHITESTONE [Permits for WHITESTONE]

1 - 50 of 609

CHEN, MEI FENG

Individual

Active


BONO, DOMENICO

Individual

Active


VAGGELAS, ANTONIOS

Individual

Active


Lalicata, Salvatore

Individual

Active


ANDREOU, GEORGE

Individual

Active


BERNIE SALES APPLIANCES INC

Business

Inactive


LEE, EUNG S

Individual

Inactive


GATTONI, CALOGERO

Individual

Inactive


DEVITO, THOMAS J

Individual

Active


ARAZQI, HASSANE

Individual

Active


150 STREET PRODUCE CORP.

Business

Inactive


D'AMICO, GIUSEPPE

Individual

Active


GIUSEPPE, RICCOBONO

Individual

Active


AMATO, ANTHONY

Individual

Active


RICCOBONO, FRANCESCO

Individual

Active


QIN, JEFF

Individual

Active



CALVO, RAMON

Individual

Inactive


TSIOULIDIS, DIMITRIOS T

Individual

Active


CHARTZOULAKIS, JOHN

Individual

Active


TSATIS, FOTIS

Individual

Active


MNM LAUNDROMAT CORP.

Business

Inactive


MOLINARI, ELIZABETH A.

Individual

Inactive


FALLON, DENNIS G

Individual

Inactive


MOLLURA, JOSEPH

Individual

Inactive


HAN, YU

Individual

Active


SEO, KUI JEONG

Individual

Inactive


MOTSIOS, ANDREW

Individual

Active


PAXINOS, SPIROS P

Individual

Active


CUI, QIANG

Individual

Inactive


CHUBIRKA, ERIC F

Individual

Active


VALENZA, FELICE

Individual

Active



STEININGER, KAREN

Individual

Active


FRANGAKIS, DIONYSIOS

Individual

Active


SMILE CLEANERS

Business

Inactive


REMSEN, CHARLES J

Individual

Active


STEPHEN CLEANERS

Business

Inactive


LOCCISANO, DOMENICO F

Individual

Active


VERIVAKIS, STEVE

Individual

Active


UniFirst Corporation

Business

Active


POON'S LAUNDROMAT

Business

Inactive


ALY LAUNDROMAT INC.

Business

Inactive


ARMENDARIZ, JARED

Individual

Inactive


SUDZY INC

Business

Inactive


ADELPHI CLEANERS

Business

Inactive


KUHNLE, ANDREW

Individual

Active


SAKATIS, EMMANUEL

Individual

Active


FARACI, SALVATORE

Individual

Active


SALABY, MICHAEL, J

Individual

Active


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