Long Island City [Permits for Long Island City]

401 - 450 of 695

NEW BANGLA MOTOR

Business

Active


WILLIAMS, PAMELA

Individual

Active


MET FRESH & ORGANIC

Business

Inactive


MIST

Business

Inactive


HVAC

Business

Active


T & J CRYSTAL, INC.

Business

Active



FlyCleaners

Business

Active


K&C TIRE SHOP INC

Business

Inactive


FOOD BAZAAR

Business

Active



K CRYSTAL DRYCLEANERS INC.

Business

Active


STONE WORKS STUDIO INC

Business

Active



QUEENSBRIDGE PAWN SHOP

Business

Inactive


T-Mobile

Business

Active



DEAN CONTRACTING GROUP INC.

Business

Active



KOEPPEL SUBARU

Business

Active


CONSTRUCTION BY ALICE INC

Business

Inactive


INTERIOR SOLUTIONS, CORP.

Business

Inactive


AUTO CENTER COLLISION, INC.

Business

Active


F & Y CONVENIENCE STORE INC

Business

Active



TEAMWORK CONTRACTING

Business

Active


DARTOM CONSTRUCTION, LLC

Business

Active


CHASE CONSTRUCTION

Business

Active


FIVEBORO PEDICAB CORP.

Business

Active


CREATIVE CONCEPTS FIRST

Business

Active


RANET JEWELRY INC.

Business

Active


SOHA ATELIER CORP

Business

Active


SILVER STAR MOTORS

Business

Active


MY NEIGHBOR GROCERY STORE

Business

Active


T-Mobile

Business

Active


RAWAL CONSTRUCTION CORP.

Business

Active


T-MOBILE

Business

Inactive


RICKSHAW ANDY, INC.

Business

Active



PV PARKING II CORP

Business

Active


AKELEY CONSTRUCTION , LLC

Business

Inactive


SKINNY'S CANTINA

Business

Active





ANGEL BRIGHT

Business

Active


QAZI & SONS USED PARTS INC.

Business

Inactive


BIG APPLE RICKSHAW

Business

Active


DEVOLKS

Business

Inactive



(default) 2 queries took 474 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 ( '(+Long +Island +City)' IN BOOLEAN MODE) LIMIT 400, 505050236
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Long +Island +City)' IN BOOLEAN MODE)11238