WHITESTONE [Permits for WHITESTONE]

301 - 350 of 609

WALSH, DEBORAH A

Individual

Active


MARRIEZ, ABDELTAWAB

Individual

Active


KRUK, REMIGIUSZ

Individual

Active


VILA, BRUNO

Individual

Inactive


DARCY, JOHN T.

Individual

Active


ANDREOU, STELIOS

Individual

Active


HUANG, ZIJIE

Individual

Active


SABOVIC, NUSRET

Individual

Active


BORDONE, PAOLO

Individual

Active


ZIAS, CONSTANTINE

Individual

Active


GARCIA, ROBERTO

Individual

Active


LULI, NDOC

Individual

Inactive


BENEVENTANO, ANTONIO

Individual

Active


BARTELLINO, SALVATORE

Individual

Active


FLYNN, PAUL

Individual

Active


ROBERTI, JOHN

Individual

Inactive


KAZNESIOTIS, CHRISTOS

Individual

Inactive


THEODORAKATOS, VASILIOS

Individual

Active


ANGELIDAKIS, ZANNIS

Individual

Active


PANTELIODIS, Pete

Individual

Inactive


COZEOLINO, JOSEPH C

Individual

Active


ZAPATA, ELOY

Individual

Active


MARMO, GIOVANNI

Individual

Active


BRISNOVALIS, ANGELOS

Individual

Active


RODRIGUEZ, ELAINE MARIE

Individual

Active


PINKHAM JR, LAURENCE DOW

Individual

Active


Beechhurst Wash & Dry

Business

Active


JIE'S LAUNDROMAT INC.

Business

Active


FENWA CONSTRUCTION INC

Business

Active


NATIONAL SERVICES INC

Business

Active


KUBER CONVENIENCE INC.

Business

Active


NY DYNAMIC INTERIORS

Business

Inactive


M M HOME IMPROVEMENT

Business

Active


VINTAGE CRAFTSMEN LLC

Business

Inactive


CKC MAINTENANCE CORP.

Business

Active







RADIOSHACK STORE #2752

Business

Inactive



TOTAL INSTALL INC.

Business

Active


KELTIC KROSS, INC.

Business

Active


DE CONTRACTING OF QUEENS, INC.

Business

Inactive


DELPHINI CONTRACTING INC.

Business

Active


PURPLE'S HAPPY SHOP, INC.

Business

Active




SJD CONSTRUCTION INC.

Business

Active


(default) 2 queries took 344 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 300, 505050111
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)11233