Jackson Heights [Permits for Jackson Heights]

351 - 400 of 809

Lemon Farm

Business

Active


POBLANO RECORDS CORP.

Business

Active


I PEAR FIX CORP

Business

Active


ROBERTO ELECTRONIC, INC.

Business

Active


84 NEWS II INC

Business

Inactive


S & K VEGETABLES CORP.

Business

Active


MALORIE REALTY LLC

Business

Active


OULD SOD CONSTRUCTION CORP.

Business

Active


TAQUERIA CHILA CORP

Business

Inactive


37-54 MEAT & PRODUCE, INC.

Business

Active


Cricket Wireless

Business

Inactive




SHREEHARI CONVENIENCE INC

Business

Active




T-MOBILE

Business

Inactive


Q & Q DISCOUNT

Business

Inactive


COLLECTIVE SIX CORP

Business

Inactive


NASH BUILDERS, INC.

Business

Active


TIAN CI LAUNDROMAT INC.

Business

Active


V & A JEWELRY

Business

Inactive


AZAAL DELI CORP

Business

Active


MG DECORATIONS LTD.

Business

Active


RESICOM CORP.

Business

Active



BQE CAFE BILLIARDS INC

Business

Active


COLORS SERVICES LLC

Business

Active


PHOENIX WEDDING CORP.

Business

Active


W & R WIRELESS, CORP.

Business

Active


Aqua Clara Laundry

Business

Active




DTRT Wireless, Inc.

Business

Active


FLOOD COMPUTER SERVICES INC

Business

Inactive



PLANET AUTO

Business

Active


S & M GROCERY CORP

Business

Active


PLANET AUTO

Business

Active



GULXAR, LLC

Business

Active


DAMIR CONTRACTING, INC.

Business

Inactive


QUEENS PAWN & JEWELRY INC.

Business

Active


FLOOD COMPUTER SERVICES INC

Business

Active


MONDOL, RASHIDA

Business

Active


GOTHIC CABINET CRAFT

Business

Inactive


ROJAS GENERAL CORP

Business

Active


WELCOME CONVENIENCE

Business

Active


INDU PAREKH NEWSSTAND

Business

Active


I & Y NEWS AND CANDY INC.

Business

Active


(default) 2 queries took 371 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 ( '(+Jackson +Heights)' IN BOOLEAN MODE) LIMIT 350, 505050147
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Jackson +Heights)' IN BOOLEAN MODE)11224