LITTLE NECK [Permits for LITTLE NECK]

251 - 300 of 418

GP RESTORATION

Business

Active


FENIELLO, ROCCO

Individual

Active


JIANG, WEN Y

Individual

Active


WALSH, KEVIN

Individual

Active


LEE, KWANGBUM

Individual

Active


FOLEY, ARTHUR C

Individual

Active


Brighten Contracting Inc

Business

Active



KIM, JONG WOO

Individual

Active


CHUNG, JAMES G

Individual

Inactive


NIEVES, DERRICK

Individual

Active


LIANG, SUI, HUA

Individual

Active


SANCHEZ, BIENVENIDO

Individual

Active


MO, FRANK

Individual

Active


YEHOSHUA, GIDEON

Individual

Active


NODA, HIROTAKA

Individual

Active


ANNINA, RALPH

Individual

Active


TRIESTE CONSTRUCTION CORP.

Business

Active



WONDERLAND MIDWAY CORP.

Business

Inactive


JOHN ROONEY CONSTRUCTION INC.

Business

Inactive


FERAZZOLI, FRANK

Business

Active


CHAU, KENNY

Business

Inactive



T-MOBILE

Business

Active



CREATIVE CUSTOM CONTRACTING

Business

Active


BOLLA OPERATING CORP

Business

Inactive


POLO DELI, INC.

Business

Inactive


M&M GOLD BUYERS INC.

Business

Inactive


QUEENS CELLULAR CORP

Business

Active


CITY WORKS NEW YORK, INC.

Business

Active


PARK RIGHT CORPORATION

Business

Inactive


UTICA CONTRACTING INC

Business

Active


GAMESTOP STORE #6668

Business

Active



AVANGARD SUPPLY INC

Business

Active


HVAC PLUS INC.

Business

Active


LAWLER DRUG

Business

Active


LITTLE NECK DELI CORP

Business

Active



GREENTREE CONSTRUCTION INC.

Business

Active


GMK RENOVATIONS, INC.

Business

Active




CONTRACTING

Business

Active


TATRA RENOVATION, INC.

Business

Active


SPIRIT HOME IMPROVEMENT LLC

Business

Inactive


THROGS NECK DISCOUNT CENTER

Business

Inactive



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