W LONG BRANCH [Permits for W LONG BRANCH]

1 - 7 of 7

BLUE CREEK HOMES, INC

Business

Inactive


EMEN, DAVUT FURKAN

Individual

Active


KAKIASHVILI, MIKHAEL

Individual

Inactive


PT WOOD FLOORS CORP

Business

Active


CONSTRUCTIVE PRO INC.

Business

Inactive


WILCZAK, STEPHEN

Individual

Inactive


ZAIDINSKI, PAUL

Individual

Inactive


(default) 1 query took 234 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 ( '(+W +LONG +BRANCH)' IN BOOLEAN MODE) LIMIT 5077234