STAMFORD [Permits for STAMFORD]

51 - 61 of 61

CJS MILLWORK, INC

Business

Active


ORAX CORPORATION

Business

Active



CORTESE, VINCENT

Individual

Inactive


European Elegance LLC

Business

Active


GIVENS, ROBERT

Individual

Inactive


NICHOLAS CUSTOM CABINETS

Business

Active


VELEZ, JORGE

Individual

Active


Costabile, Jose

Individual

Active


FIVEISH MOBILE LLC

Business

Active


T-Mobile

Business

Active


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