WHITESTONE [Permits for WHITESTONE]

401 - 450 of 609

BELIDA ASSOCIATES, INC.

Business

Active


Gladiator Renovations, LLC

Business

Active



WINDOW TECH OF NYC INC.

Business

Active


CARPENTARY

Business

Inactive


SHENG SHENG CONSTRUCTION

Business

Active


ROOFING & SHEET METAL

Business

Active


SV CONTRACTORS INC

Business

Active


CHO, SO HYUN

Business

Inactive


WHITESTONE CAR WASH INC

Business

Active


WALDBAUM'S STORE #270

Business

Inactive


CITY INTERIORS, INC.

Business

Active




WONDERLAND MIDWAY CORP

Business

Inactive


DMKD INC.

Business

Active


MARIO TILE & MARBLE CO

Business

Active


ABOVE AND BEYOND CARPENTRY

Business

Inactive


NEW UTOPIA CLEANERS INC.

Business

Active


DOM'S HOME IMPROVEMENT

Business

Active



MELE CONSTRUCTION

Business

Active


ARTISTIC DESIGN CORP.

Business

Active


NUST CONSTRUCTION INC

Business

Active


GLASS FACTOR, INC.

Business

Inactive



PAGING ZONE

Business

Active




FAIRWAY INTERIOR GROUP LLC

Business

Active




STEPHEN CLEANERS

Business

Active


SEMA CONTRACTING LLC

Business

Active


WONDERLAND MIDWAY CORP.

Business

Inactive


Ebro Group LLC

Business

Active


ARMA CONTRACTING CORP.

Business

Inactive


FOOD MART

Business

Active


Sprint

Business

Active


DISANO DEMOLITION CO., INC.

Business

Active


APT WIRELESS

Business

Inactive


TESMAN DEVELOPMENT LLC

Business

Active




RadioShack

Business

Active



P&P RESTORATION CORP

Business

Active


BENCIC, PAOLO

Business

Active



SCREEN MAX LLC

Business

Active


(default) 2 queries took 381 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 400, 505050162
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)11219