DOUGLASTON [Permits for DOUGLASTON]

51 - 76 of 76

RUSSO, FRANK

Individual

Active


Kaparakos, Michael

Individual

Active


VILLAMENA, MICHAEL L

Individual

Inactive


KOUTSOURAS, STEVEN

Individual

Inactive


MININO, MANUEL

Individual

Active


MCCARTHY, TIMOTHY

Individual

Inactive


TRILIVAS, THOMAS

Individual

Active


BIRAMIAN, RAZMIK

Individual

Inactive


JOHN ARNOLD CONTRACTING INC.

Business

Inactive



DMA CONTRACTING INC.

Business

Active



ECO AIR INC.

Business

Active


CHARLIE & FRANK TRADING, INC.

Business

Inactive


JAC-ON THE LEVEL INC.

Business

Active




T-MOBILE

Business

Inactive


DOUGLASTON FRENCH CLEANERS

Business

Active


BIRAMIAN, RAZMIK

Business

Inactive







KOREAN GLASS

Business

Inactive


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