WHITESTONE [Permits for WHITESTONE]

351 - 400 of 609


FRANK TILE AND MASONRY COMPANY

Business

Inactive


A DIBIASE MASON CONTRACTOR

Business

Active



SEO, KUI JEONG

Business

Inactive


CLINTONVILLE QUICK STOP INC

Business

Inactive


HORIZON TRADING

Business

Inactive



EAGLE LAWN SPRINKLERS, INC.

Business

Active


ROMA LAUNDRY, INC.

Business

Active


BUY-RITE WINDOWS LLC

Business

Active


BLOODHOUND PROCESS, LLC

Business

Active


EHE CLEANERS INC

Business

Active


RADIOSHACK STORE #2752

Business

Inactive


NY JEWELRY & WATCH BUYERS INC

Business

Inactive



A TO Z GROCERY, INC.

Business

Active



FRANCO VICARI CONTRACTOR

Business

Active


ALY LAUNDROMAT INC

Business

Active


JNJ MILSTONE INC.

Business

Active



ARJAY TELECOMMUNICATIONS INC

Business

Inactive




Maxim Service Group

Business

Active


JEN ELECTRIC

Business

Active


GABRIELE'S DESIGN INC.

Business

Active



CONTROLLED SECURITY SYSTEMS

Business

Inactive






GREY-RUSO CONSTRUCTION CORP.

Business

Inactive


WONDERLAND MIDWAY CORP.

Business

Inactive




XG CONTRACTING LLC

Business

Inactive


ARMENDARIZ, JARED

Business

Inactive


PAINTING PLUS II, LLC

Business

Active



CYPRUS PAINTING CORP.

Business

Active


PACHECO, GERMAN

Individual

Active


COS CONSTRUCTION INC

Business

Active


HAPTOH CONSTRUCTION CORP.

Business

Inactive


RANJIT DEVELOPMENT, INC.

Business

Inactive




super convenience store

Business

Active


(default) 2 queries took 398 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 350, 505050150
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)11248