Fresh Meadows [Permits for Fresh Meadows]

401 - 450 of 548

AVR CONTRACTING INC.

Business

Active


BEYOND BUILDING INC

Business

Active


COMPUTER SERVICE

Business

Inactive


T MOBILE

Business

Active


CHEN, SHUN

Business

Active


LUCKY DELI STORE, INC.

Business

Active


UNDERGROUND BARBER SHOP

Business

Inactive




GMDV TRANS INC

Business

Active


I LOCK NEW YORK INC

Business

Inactive


joy up inc

Business

Inactive




GAS SALE

Business

Active


BRENDAN'S AUTO SERVICE INC.

Business

Active


I DJ NOW

Business

Active


HONG'S CONSTRUCTION INC

Business

Inactive


A Wireless

Business

Active



CAPRY GROUP INC

Business

Active


UNION WELLNESS PHARMACY INC

Business

Active



ZAMORA HILLS REMODELING INC.

Business

Inactive



ALL-COUNTY AMUSEMENTS, INC.

Business

Inactive


RADIOSHACK CORPORATION

Business

Inactive


CW DELI INC.

Business

Inactive


198-25 HORACE 11365 INC

Business

Active


VAPE N SMOKE INC

Business

Active


WISDOM CONSTRUCTION INC.

Business

Active


TECH ELECTRONICS SHOP INC.

Business

Active


AMMK, INC.

Business

Active


VLP, INC.

Business

Active


BETHEL DRY CLEANERS, INC.

Business

Active


AVENTADOR CONSTRUCTION INC

Business

Active


EURO SUCCESS 2006 INC

Business

Inactive


ELEGANT INTERIORS USA, INC.

Business

Inactive


SPRINT SPECTRUM L.P.

Business

Inactive


J & A HAIRSTYLING INC.

Business

Inactive




GALIL DEVELOPMENT INC.

Business

Active


GEORGE GOLD MARKET

Business

Inactive


J. C. BONG INC.

Business

Inactive


C&D GOOD JOB LLC

Business

Active


INSIGHT CONTRACTING

Business

Inactive


BEAUTIFUL HOME IMPROVEMENT INC

Business

Inactive


GOLDEN LION CHENG LE INC.

Business

Active



(default) 2 queries took 427 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 ( '(+Fresh +Meadows)' IN BOOLEAN MODE) LIMIT 400, 505050185
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Fresh +Meadows)' IN BOOLEAN MODE)11242