KEW GARDENS [Permits for KEW GARDENS]

201 - 250 of 534

Sprint

Business

Active


VASQUEZ, EDWARDO

Individual

Active


DOWNEY, JAMES P.

Individual

Active


VALENTIN, MARTIN

Individual

Active


ESTRADA SUAREZ, BRIAN

Individual

Active



COOPERMAN, LAWRENCE

Individual

Active


MILLER, DAVID G

Individual

Inactive


MAKSUMOV, ARTHUR

Individual

Active


PELAEZ, GIOVANNI

Individual

Inactive


CHEN, FENG LING

Individual

Active


TORRES, JR. ROGELIO

Individual

Active


MARTINKEVICIUS, EGIDIJUS

Individual

Active


HAO, JIAPENG

Individual

Active


SORIA, GLORIA

Individual

Active


ANTONELLI, TONI

Individual

Active


Dhillon, Kiranjeet

Individual

Active


TANTILLO, MICHAEL

Individual

Active


DWYER ALLISON, PAULA

Individual

Active


IRBY, TIMOTHY

Individual

Inactive


CHEN, GUANG HE

Individual

Active


SINGH, LUCKY

Individual

Active


Guetta, Amos

Individual

Active


FREDERICK, GEORGE E

Individual

Inactive


MARQUINA, DANIEL

Individual

Active


SINGH, HARVINDER

Individual

Active


CHAO, CHUN

Individual

Active


SUAREZ, MAXIMO A

Individual

Active


Lee, Ka Ming

Individual

Inactive


HALLPIKE, MAURICE

Individual

Active


XENOS, GEORGE

Individual

Inactive


WESTON, ROBERT E

Individual

Active


BENHAMU, MICHAEL

Individual

Inactive


SAITO, YUMIKO

Individual

Active


XIE, GUOBING

Individual

Active


ANWAR, MUHAMMAD

Individual

Active


VASERMAN, BARAK

Individual

Active


Cheung, Yue Hong

Individual

Active


POLANCO, JOSE

Individual

Active


IRBY, TIMOTHY

Individual

Active


GERDTS, ROBERT

Individual

Active


FOOD U DESIRE

Business

Active



DONG UN, KIM

Business

Active


2-4-1 ENTERTAINMENT

Business

Inactive


VICTORIAN GARDENS

Business

Inactive


ELENA DRY CLEANER

Business

Inactive


HUNZA G.C. CORP.

Business

Active




(default) 2 queries took 400 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 ( '(+KEW +GARDENS)' IN BOOLEAN MODE) LIMIT 200, 505050114
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+KEW +GARDENS)' IN BOOLEAN MODE)11286