WADING RIVER [Permits for WADING RIVER]

1 - 9 of 9

FRIED, DAVID SCOTT

Individual

Active


DTA CONTRACTING, INC.

Business

Inactive


ALBERICI, KENNETH

Individual

Active


RONZINO, JOSEPH

Individual

Inactive


ALMAS CONSTRUCTION LLC

Business

Active


O'NEILL, TIMOTHY

Individual

Active


ZOUMAS, NICHOLAS

Individual

Active


ZAITA, PETER

Individual

Active


BAIRD, BARRY

Individual

Inactive


(default) 1 query took 240 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 ( '(+WADING +RIVER)' IN BOOLEAN MODE) LIMIT 5099240