WARREN [Permits for WARREN]

51 - 65 of 65

WARREN GARMENTS NYC, INC.

Business

Inactive





WARREN GROCERY, INC.

Business

Inactive


WARREN, DOYLE J

Business

Active


NEW WARREN MINIMARKET INC

Business

Active


WARREN TOBIN HOME IMPROVEMETS

Business

Inactive


burgess, warren

Individual

Active


AMERICAN CONGLOMERATE

Business

Active


69 WARREN PARKING, LLC

Business

Inactive


WARREN CONTRACTING LLC

Business

Active


FIELD, WARREN

Business

Active


QUIK PARK WARREN GARAGE LLC

Business

Active


BLODGETT, WARREN

Individual

Active


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