ROCKVILLE CTR [Permits for ROCKVILLE CTR]

51 - 74 of 74

SHEEHAN, DENIS A

Individual

Active


MARSHALL, BARRY

Individual

Active


WALL, STEPHEN

Individual

Inactive


ARDI, STEVEN R

Individual

Active


THOMAS, CAROL O

Individual

Active


DEE & CEE CRAFT INC.

Business

Active


shakir, ali

Individual

Active


SEIPP, FRANK EDWIN

Individual

Inactive


PAPADOPOULOS, CHISTOS

Individual

Active


CUSUMANO, RICK A

Individual

Inactive


ADLER, ROSS

Individual

Active


KATSOULAS, EFSTATHIOS

Individual

Inactive


GIAKOUMATOS, DIMOSTHENIS

Individual

Inactive


AHMED, HOSSAM EL DIN

Individual

Active


MIGUEL PENA & SONS, INC.

Business

Inactive


MBI ASSOCIATES

Business

Inactive




JOHN HUBLER SOLAR INC.

Business

Inactive



COMPASS CONSTRUCTION LLC

Business

Inactive



E. R. QUINN CO., INC.

Business

Active


TOP LINE CONTRACTING INC

Business

Inactive


(default) 2 queries took 600 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 50, 502424372
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)11228