OAKLAND GARDENS [Permits for OAKLAND GARDENS]

101 - 141 of 141

CHI WING CONSTRUCTION INC

Business

Inactive


ZIRCON GROUP INC

Business

Active


ZHAO'S CONSTRUCTION INC.

Business

Active




SCHWARTZ HOLDINGS LLC

Business

Active


SKY VIEW CLEANERS INC.

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


LDU THERAPY, INC

Business

Active


SATKAIVAL DELI INC

Business

Active


NKR NEWS INC.

Business

Inactive


VALENTIN AND SON L.L.C.

Business

Active


SPRING GOLF CORPORATION

Business

Active


LU, RUNQING

Business

Active


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


ADVANT ORTHOCARE INC

Business

Active


MUKTI TOWING INC

Business

Active


SANAT CARDS & GIFTS, INC.

Business

Active


JONG KI LEE

Business

Inactive




MAJOR HOMES CORP.

Business

Active




lxc construction inc.

Business

Active


MX GROUP INC

Business

Active


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