ROCKVILLE CTR [Permits for ROCKVILLE CTR]

1 - 50 of 74

KOEHLER, PAMELA

Individual

Inactive


WU, QI XIN

Individual

Inactive


MINUTELLO, ANTHONY

Individual

Active


MCDERMOTT, BRIAN

Individual

Active


CUSUMANO CONSTRUCTION, INC.

Business

Inactive


STAVBA GROUP INC.

Business

Active


SHAMROTH, HARRY

Individual

Active


LILLY, JAMES PHILIP

Individual

Inactive


HOSPODKA, MILAN

Individual

Active


FORD, ROBERT

Individual

Active


J-JAY MAINTENANCE LLC

Business

Active


LONERGAN, PAUL

Individual

Active


GALLAGHER, MICHAEL G

Individual

Active


SYLVESTER, PATRICK

Individual

Inactive


LAVELLE, GERARD

Individual

Active


ARTIEDA, ALAN

Individual

Active


RYAN, CHRISTOPHER

Individual

Active



DIPRESSO, CARL G

Individual

Active


GREY STREET BUILDERS LLC

Business

Active



ARORA CONSTRUCTION INC

Business

Active



GO CONTRACTING

Business

Active


ARORA, ANUJ

Individual

Active


MCCARTHY, THOMAS S

Individual

Active


Ruda, Joseph

Individual

Active


DEBENEDITTIS, JOHN

Individual

Active


ARTISAN CONSTRUCTION, INC.

Business

Inactive


GRACE HOME IMPROVEMENT

Business

Active


PENA, MIGUEL

Individual

Inactive


SCHENE, ROBERT K

Individual

Active


GUZZO, LOUIS

Individual

Active


JUDGE, MICHAEL

Individual

Active


MBI Associates, Inc.

Business

Active


PERCY CONSTRUCTION CORP

Business

Active


HUTHWAITE, JOHN

Individual

Active



FERNANDEZ, FEDERICO

Individual

Active


DUSKIEWICZ, RICHARD

Individual

Active


DOERFLEIN, RONALD

Individual

Active


WU, QI XIN

Business

Inactive


BOSSART, MARY W

Individual

Active


TRI-COUNTY REMODELING, INC.

Business

Active




WEISSMAN, ANDREW

Individual

Active


CUSTOM VIEW INC

Business

Active


CLANCY, SEAN P

Individual

Inactive



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