GREAT NECK [Permits for GREAT NECK]

101 - 150 of 164

TRINH, AI LINH

Individual

Active


Mizrachi, Menachem

Individual

Active


EISO USA INC

Business

Inactive


WANG, YONG QIANG

Individual

Active


POURATIAN, FEREYDOUN

Individual

Active


KESSEL, DORON

Individual

Active



PFEIFFER, NICHOLAS

Individual

Active


ZUCKERMAN, ZEEV

Individual

Inactive


EDERY, ISRAEL

Individual

Active


WEISSMAN, DWIGHT

Individual

Active


The Gamut Organization Inc.

Business

Active


STEWART, DANIEL

Individual

Active


KURIYAMA, LIN

Individual

Active


AB'S A-Z CONTRACTING INC

Business

Inactive


WANG, YONG QIANG

Business

Active


BIKHMAN, KARL

Individual

Inactive


LALO, ERIC

Individual

Inactive


LEE, JU T

Individual

Inactive


LIN, KU-LONG

Business

Active


ZADE, MET

Individual

Active


VIVERITO, GERARD E

Individual

Inactive



FU, ERMIN

Individual

Active


HDNY CONSTRUCTION INC

Business

Active



CARBONE, ANTHONY N

Individual

Active


Bonim Remodeling Inc

Business

Active



MALAYERI, PAYMAN

Individual

Active


JDS RE DEVELOPMENT INC

Business

Active


ELISEO, LLOYD

Individual

Inactive


Beecham, Earl

Individual

Active


Danielle N. Grzan Esq. P.C.

Business

Active


HONG, CHARLIE

Individual

Active


BEN-HAYUN, ITZHAK

Individual

Active


GP RESTORATION

Business

Active


LEE, KWANGBUM

Individual

Active


Brighten Contracting Inc

Business

Active



KIM, JONG WOO

Individual

Active


LIANG, SUI, HUA

Individual

Active


MO, FRANK

Individual

Active


YEHOSHUA, GIDEON

Individual

Active


NODA, HIROTAKA

Individual

Active


TRIESTE CONSTRUCTION CORP.

Business

Active



JOHN ROONEY CONSTRUCTION INC.

Business

Inactive


CITY WORKS NEW YORK, INC.

Business

Active


HVAC PLUS INC.

Business

Active


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