HUNTINGTON [Permits for HUNTINGTON]

1 - 50 of 151

CZAJKOWSKI, MARTIN

Individual

Active



MARTINEZ, CHRISTOPHER

Individual

Active


GURKAS, JIMMY CEMIL

Individual

Active


LAVITT, JASON A

Individual

Inactive


RIVAS, RICARDO

Individual

Inactive


LORRIMER, MICHAEL

Individual

Active


MCGINLEY, MICHAEL

Individual

Active


MANISCALCO, FRANK L

Individual

Inactive



SCHMIDT, PETER E

Individual

Active


HALLER, MICHAEL

Individual

Active


Derevjanik, Gabriel

Individual

Active


SMITH, MICHAEL T

Individual

Active


TOVIA CAPITAL LLC

Business

Active


FEIGELMAN, GLENN R

Individual

Active



JOHNSON, RALPH G

Individual

Inactive


KAUFMAN, AMY

Individual

Inactive



MONTERROSO IMPROVEMENT INC

Business

Active


PAK BUILDERS INC.

Business

Inactive



MONARES, JOHNNY

Individual

Active


DAUBEL, EDWARD

Individual

Active


THOMAS, RALPH

Individual

Active


SERAFIN, ROBERT

Individual

Active


RODRIGUEZ, MYNOR O

Individual

Inactive


GRECO, EDWARD

Individual

Active


MUSSO, JOSE

Individual

Active


FARALDO, ROCCO D

Business

Active


COYLE, TIMOTHY

Individual

Inactive


GEDACHT, MICHAEL

Individual

Active


PIPIA CONTRACTING

Business

Active


ALLSASH WINDOW REPAIR CO

Business

Inactive


FARALDO, ROCCO

Individual

Active


Huntington Closet Company

Business

Active



SUFFOLK SYSTEMS INC.

Business

Active



FLM CONTRACTING INC.

Business

Inactive


VAK V1 Fund, LLC

Business

Active


CLINGO, THOMAS

Individual

Active



KENT, GAVIN

Individual

Active


PITTELLI, CARMINE

Individual

Active


RAMDASS, CHARLES

Individual

Active


CANCEL, GEORGE

Individual

Active


SURUJBALI, BRIGRAJ

Individual

Active


LEE, SUNGHOON

Individual

Inactive


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