PLAINVIEW [Permits for PLAINVIEW]

1 - 50 of 120

REESE, RICHARD A.

Individual

Active


RODRIGUEZ, HERIBERTO

Individual

Inactive


FREED, MICHAEL

Individual

Active


VANMEURS, HUBERT A

Individual

Active


VAGLICA, MICHAEL

Individual

Active


CURRY, BRIAN

Individual

Inactive


TANTURRI, JOHN

Individual

Active


G CONTRACTING INC.

Business

Active


VESCOVA, KAREN

Individual

Inactive


WILLETT, HARVEY

Individual

Active


GOLDBLATT, KENNETH C

Individual

Active


ANDRLE, JASON

Individual

Active



Ornstein, Lawrence

Individual

Active


ZORER, ELEANOR

Individual

Active



JAY A PRESS PC.

Business

Active


LAPIDUS, SHELDON

Individual

Active


HOWARD BELFER, INC.

Business

Active


RODRIGUEZ, MARIA

Individual

Active


WEISS, RICHARD S

Individual

Active



KORUS, LLC

Business

Inactive


BUTT, ATIF

Individual

Active


LAUCELLA, MICHAEL

Individual

Inactive


KUPLICKI, MICHAEL

Individual

Active


GIANFRANCESCO, ANTHONY

Individual

Active


TESTA, JANICE M

Individual

Inactive


RHK RECOVERY GROUP

Business

Active


MORDECHAI, ROEE

Individual

Inactive


BORITZ, STUART

Individual

Inactive


BOLOGNINO, FRANK

Individual

Active


GETTLEMAN, CARL

Business

Active


BROWER, JOHN D

Individual

Active


FILAKOURIS, JOHN

Individual

Inactive


CHINEA, PAPO

Individual

Active


LERNER, LANCE

Individual

Inactive


A & G QUALITY REFINISHING INC.

Business

Inactive


PAPPAS, THOMAS

Individual

Active


NEWMAN, ERIC

Individual

Inactive


BELFER, HOWARD L

Individual

Active


SUH, MINHO

Individual

Inactive


HILFMAN, DOUGLAS G

Individual

Inactive


FILAKOURIS, ANTONIOS

Individual

Active


KOZLOVSKY, ALEXANDER

Individual

Active


TRACT, BLYTHE

Individual

Inactive


MITCHELL, JAMES

Individual

Inactive


SAMANDA CONSTRUCTION CORP

Business

Inactive


WASSERMAN, MELVYN

Individual

Active


SCHULTZ, RICHARD A.

Individual

Active


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