EAST BRUNSWICK [Permits for EAST BRUNSWICK]

1 - 13 of 13

yu, zhenzi

Individual

Inactive


ACCORD POWER INC

Business

Active


MID STATE POOL LINERS, INC.

Business

Active


LIU, SOPHIA

Individual

Active


HAMILTON COLLECTION AGENCY

Business

Active


LITRIC CONTRACTING CO.

Business

Active




MANNA, JOSEPH C

Individual

Active


mason, ashleigh

Individual

Active


KONDAUR CAPITAL CORPORATION

Business

Inactive


STEPHEN, AQUALLA

Individual

Inactive



(default) 1 query took 305 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 ( '(+EAST +BRUNSWICK)' IN BOOLEAN MODE) LIMIT 501313305