OAKLAND [Permits for OAKLAND]

151 - 198 of 198

SCHWARTZ HOLDINGS LLC

Business

Active


SKY VIEW CLEANERS INC.

Business

Active


NEW OAKLAND FURNITURE CORP

Business

Active


WING JAY CONSTRUCTION INC.

Business

Inactive


UNITED PHONES CORPORATION

Business

Inactive


LJPY CORP

Business

Active



CAMPBELL, JOSEPH

Business

Active



NHance Wood Renewal

Business

Active


JROD CONSTRUCTION, CORP.

Business

Active


THE LATIN WELDER, LLC

Business

Active


LDU THERAPY, INC

Business

Active


DESIGNS BY DAVID INC.

Business

Inactive


OAKLAND FURNITURE CORP.

Business

Inactive


SATKAIVAL DELI INC

Business

Active


NKR NEWS INC.

Business

Inactive


VALENTIN AND SON L.L.C.

Business

Active


AFRIDA ANAN KOTWAL INC

Business

Active


CVS PHARMACY #1906

Business

Inactive


SPRING GOLF CORPORATION

Business

Active


LU, RUNQING

Business

Active


SANAT CARDS & GIFTS, INC.

Business

Inactive


JEANNEY CLEANERS INC

Business

Active



UMIYA DELI & GROCERY INC

Business

Inactive


TEKTON CONTRACTING CORP.

Business

Inactive


SEW RIGHT SEWING MACHINES, INC

Business

Inactive



Yame Inc.

Business

Active


XIE, GUOBING

Business

Active



Windsor Park Cleaners

Business

Active


BAYSIDE SUPPLY, INC.

Business

Inactive


ADVANT ORTHOCARE INC

Business

Active


TOP DOLLAR FOR GOLD INC.

Business

Inactive


MUKTI TOWING INC

Business

Active


SANAT CARDS & GIFTS, INC.

Business

Active


YOGI 19, LLC

Business

Active


PROMISE CLEANERS II

Business

Inactive


JONG KI LEE

Business

Inactive




MAJOR HOMES CORP.

Business

Active




lxc construction inc.

Business

Active


MX GROUP INC

Business

Active


(default) 2 queries took 468 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 150, 504848256
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)11212