PELHAM [Permits for PELHAM]

1 - 50 of 78

LEPRE, NANCY M

Individual

Active


THEN AND NOW RESTORATION, INC

Business

Inactive


OCONNOR, WILLIAM

Individual

Active


NEW PELHAM CLEANER CORP.

Business

Inactive


WESTSIDE HALL, INC

Business

Active


SANGUILIANO, JOHN F

Individual

Inactive


WP Bluestone, Inc.

Business

Active


LETTIRE, NICHOLAS

Individual

Active


Keith, Thomas

Individual

Active


PASTORE, HELGA ANNA

Individual

Active


3250 PELHAM BAY LLC

Business

Active


DODAJ, NDUE

Individual

Active


TAVERNA, LIAM

Individual

Active


LAGE, MICHAEL

Individual

Active


STOKES, THOMAS

Individual

Inactive


GEISLER, WARREN W

Individual

Active


DELPONTE, FRANK

Individual

Inactive


BROWN, DAREN

Individual

Active


BRUZZESE, JOSEPH

Individual

Active


PRELA, SUELA

Individual

Active


STOKES, THOMAS

Individual

Active


J. MAYO CONSTRUCTION INC

Business

Inactive


PPM RESTORATION

Business

Active


MSC RESTORATIONS LLC

Business

Active



MARANINO, JOSEPH

Individual

Inactive


GARCIA, NELSON

Individual

Active


BAGINSKI, MAREK

Individual

Active


BARNETT, WALTER

Individual

Active


DODARO, GIUSEPPE JR

Individual

Active



GIMIGLIANO, ROBERT

Individual

Inactive


EURO-COMFORT CORP

Business

Active


CRESCENT HALL INC

Business

Active


CULLEN, MARIA

Individual

Inactive


SIMPLE SOLUTIONS

Business

Active


Marchese Builders

Business

Active


PRELA, SUELA

Individual

Inactive



DEERE, RICHARD

Individual

Active


HILL, ASHLEY

Individual

Active


Marchese, Dominick

Individual

Active


MICELI, VICTOR, J

Individual

Active



Kirmser, Matthew

Individual

Active



COBAJ, NASER

Individual

Inactive


MAINTAIN-A-CHAIN CORP.

Business

Active


LAGE MGMT. CORP.

Business

Active


APICELLA, PETER

Individual

Inactive


(default) 2 queries took 327 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 ( '(+PELHAM)' IN BOOLEAN MODE) LIMIT 505050104
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+PELHAM)' IN BOOLEAN MODE)11223