OAKLAND [Permits for OAKLAND]

51 - 100 of 198

KIM, DONALD

Individual

Active


CHEN, XIUYU

Individual

Active


Butzlaff, Dennis

Individual

Active


HAN, JAI YUL

Individual

Active


SHAOXIAN, ZHANG

Individual

Active


CHU, TING-CHANG

Individual

Active


ARNS, HEATHER E.

Individual

Active


BLASI, JON P

Individual

Inactive


PYEON, DO YOUNG

Individual

Active


LI, YUE

Individual

Active


FENG, YITIAN

Individual

Inactive


CHANG, JONATHAN

Individual

Active


LIN, GUOPU

Individual

Inactive


SONEX CONTRACTING, INC.

Business

Inactive


SOLAR SPECTRUM LLC

Business

Active


PAUL, CHHINDER

Individual

Active


GRANT, PATRICK

Individual

Active


TAI, HOWARD

Individual

Inactive


HANCZOR, JOHN

Individual

Active


GAUTHIER, JOSEPH M.

Individual

Active


PRESSOIR, SYLVAIN

Individual

Active


WANG, MIAN

Individual

Active


CHUNG, SUI SAN

Individual

Active


KIM, SOON TAE

Individual

Active


SCLAFANI, STEVEN

Individual

Active


KIM, DONG UN

Individual

Active


DOWNEY, JAMES P.

Individual

Active


LAMENDOLA, ROBERT

Individual

Active


VALENTIN, MARTIN

Individual

Active


MINASSIAN, MARISEL M

Individual

Inactive


MULEA, MARIO J

Individual

Active


YI, CHONG H

Individual

Inactive


CHEN, FENG LING

Individual

Active


HAO, JIAPENG

Individual

Active


LIN, LIPO

Individual

Active


DEMENDONCA, PAMELA A

Individual

Inactive


CHEN, GUANG HE

Individual

Active


Guetta, Amos

Individual

Active


CHENG, DI-HUNG

Individual

Active


CHAO, CHUN

Individual

Active


SUAREZ, MAXIMO A

Individual

Active


Lee, Ka Ming

Individual

Inactive


LIM, JAE D

Individual

Inactive


XENOS, GEORGE

Individual

Inactive


ELKHAMISSY, AHMED H

Individual

Inactive


XIE, GUOBING

Individual

Active


Cheung, Yue Hong

Individual

Active


GERDTS, ROBERT

Individual

Active



KNI CONSTRUCTION CORP

Business

Inactive


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