WHITESTONE [Permits for WHITESTONE]

51 - 100 of 609

DIMASI, DAVID L

Individual

Inactive


Zhao, Yue

Individual

Active


SNOW WHITE LAUNDROMAT

Business

Inactive


NEW UTOPIA CLEANERS INC.

Business

Inactive


TEDESCO, ANTHONY

Individual

Active


ROMA LAUNDRY, INC.

Business

Inactive



TIBERI, MARIO

Individual

Active


Van Oss, Eugene

Individual

Inactive


LICALZI, JOSEPH

Individual

Active


GSA GAS, CORP.

Business

Inactive


MEDINA, RICARDO J.

Individual

Active



PACHECO, GERMAN

Individual

Inactive


KIM, YONGHOON

Individual

Active


VICARI, ROSARIO

Individual

Active


CHIN, FREDERICK A

Individual

Active


BRENNAN, SEAN M

Individual

Active


CHUBIRKA, DEANA M

Individual

Active


COLLURA, ANGELO

Individual

Active


HAPSIS, DIANA

Individual

Inactive



DELLAFIORA, LOUIS

Individual

Active



RICCOBONO, ANTONINO

Individual

Active


QRC HOME IMPROVEMENT INC

Business

Active


WONDERLAND MIDWAY CORP.

Business

Active


TOWART, RONALD

Individual

Active


Pacific Lawn Sprinklers

Business

Active


CERQUERA, CARLOS E

Individual

Inactive


SAITTIS, PRODROMOS

Individual

Active


WONDERLAND MIDWAY CORP.

Business

Active


Gattoni, Vincent

Individual

Active


STYLIANOU, ANDREAS

Individual

Active


JIMENEZ, JESUS

Individual

Inactive


BROOKLYN SERVICES GROUP

Business

Inactive


GRAVANIS, VIVIAN

Individual

Inactive


ALL COUNTY AMUSEMENTS, INC.

Business

Inactive


DESPOTOPOULOS, PANAYIOTIS

Individual

Inactive


GAJANAND CONVENIENCE INC.

Business

Active


COSTA, JOSE M

Individual

Inactive


TUFFNELL, LAURA

Individual

Inactive


B&L WIRELESS LLC

Business

Active


TUNG, MICHAEL

Individual

Active



MAKRIS, KYRIACOS

Individual

Active


EFTHIADES, JAMES N

Individual

Active


SWIFT COLLISION & TOWING LTD.

Business

Inactive


JAVID, MUZAFER

Individual

Active



(default) 2 queries took 386 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 50, 50505061
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)11325