DEER PARK [Permits for DEER PARK]

101 - 132 of 132

C & S NURSERY, INC.

Business

Active



DOOR PRO AMERICA INC

Business

Active


HEIRLOOM WOODWORKING, INC.

Business

Active


VANHOUTEN, ROBERT C

Individual

Active


PLOTKE, JOHN K

Individual

Inactive


STALLONE, ROSEMARY

Individual

Active


BISAGNI, VALENTINE

Individual

Inactive




PRIOR, ARTHUR

Individual

Active


KENJESKY, MICHAEL T

Individual

Active


WADE SR, STEVEN

Individual

Inactive


JAKUBIAK, ZBIGNIEW

Individual

Active


DILEO, KIMBERLY N.

Individual

Active






PHASE NY, INC.

Business

Active




CELPAR CONSTRUCTION, INC.

Business

Inactive


SUN ENERGY GROUP

Business

Inactive


TRI-STATE WINDOW FACTORY CORP.

Business

Inactive


LONG ISLAND SIDING SYSTEMS

Business

Inactive


ROOF SERVICES

Business

Inactive


HERITAGE CHIMNEY SERVICE, INC.

Business

Inactive


KEN DEER CARPENTRY

Business

Active



ALSTATE PROCESS SERVICE INC.

Business

Inactive


2K-TEM INC.

Business

Inactive


(default) 2 queries took 684 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 ( '(+DEER +PARK)' IN BOOLEAN MODE) LIMIT 100, 503232377
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+DEER +PARK)' IN BOOLEAN MODE)11307