PEARL RIVER [Permits for PEARL RIVER]

51 - 65 of 65


WHITE, JOHN

Individual

Active


CASTELLO, FRANK

Individual

Active


MCKENNA, HUGH N

Individual

Active


Pace, James

Individual

Active


NMK CABINETRY INC.

Business

Active



AMPOFO BROTHERS, LLC

Business

Inactive



T.G. ELLIOTT ASSOCIATES INC

Business

Inactive


PLUMB LEVEL SQUARE INC.

Business

Inactive



JIM CHARLTON INC

Business

Active


FLANAGAN, GERALD

Individual

Active


SCHWEIKER, JAMES

Individual

Active


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