BREWSTER [Permits for BREWSTER]

1 - 23 of 23

KURTI, ILMIH

Individual

Active


MARTINEZ, ANDRES

Individual

Active


NUZA HOME IMPROVEMENT CORP

Business

Active


OGARA, PATRICK

Individual

Active



BREWSTER-PATTERSON, DELON

Individual

Active


QUINN, DECLAN

Individual

Inactive


SHALA, BESIM

Individual

Active


RAZA, MUHAMMAD

Individual

Active


HULAJ, IDRIZ

Individual

Active


LOGIUDICE, MICHAEL

Individual

Inactive


WESTERN WORKS, LLC

Business

Active


DERVISHAJ, HALIT

Individual

Active


HD CARPENTRY CORPORATION

Business

Active


BREWSTER, WAYNE A

Individual

Active


TAULAND KITCHEN & BATH INC.

Business

Active


VUKA, RIKARD

Individual

Active


SAUNDERS, JOSEPH

Individual

Active


ACARA CONSTRUCTION INC.

Business

Active



JC REMODELING

Business

Active


FAIRFIELD COUNTY PAINTERS INC.

Business

Inactive


WAYNE, BREWSTER A

Business

Active


(default) 1 query took 353 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 ( '(+BREWSTER)' IN BOOLEAN MODE) LIMIT 502323353