CHELSEA [Permits for CHELSEA]

1 - 50 of 56

VAN GOGH CLEANERS

Business

Inactive


CHELSEA LAUNDRY

Business

Inactive




CHELSEA DELI CORP.

Business

Active


CHELSEA WIRELESSONE INC

Business

Active


PARS GRILL HOUSE & BAR

Business

Inactive


CHELSEA WATCH REPAIR

Business

Inactive


CHELSEA CONSTRUCTION LLC

Business

Inactive


CHELSEA HYPERMARKET, INC.

Business

Active


VAN GOGH CLEANERS

Business

Active


22 CHELSEA FARM LLC

Business

Active


CHELSEA 7 CORPORATION

Business

Inactive


CHELSEA WIRELESSONE INC

Business

Active


CHELSEA SQUARE MARKET

Business

Active


CHELSEA BUILDERS CORP.

Business

Inactive


CHELSEA LAUNDRY

Business

Active


LONDON TERRACE CLEANERS

Business

Inactive


CHELSEA NEWS LLC

Business

Active


NISHI CLEANERS LAUNDROMAT

Business

Inactive




239 CHELSEA DELI CORP.

Business

Inactive


22 CHELSEA FARM LLC

Business

Active


CHELSEA HAIR STUDIO INC

Business

Active



CHELSEA ENCLAVE GARAGE LLC

Business

Active


CHELSEA FLORIST INC.

Business

Active


DAN'S CHELSEA GUITARS, INC.

Business

Active


LE PAIN QUOTIDIEN

Business

Active



CHELSEA FINE FOODS

Business

Active


CHELSEA MARKET INC I

Business

Active


7TH AVE. CHELSEA CLEANER

Business

Inactive



MERCHANTS NY

Business

Inactive


CHELSEA CLEANER CORP

Business

Inactive



TELLO'S

Business

Inactive


CHELSEA WHOLESALE CORP.

Business

Inactive


chelsea mobility

Business

Active


WIRELESS ONE

Business

Active


CHELSEA FRUIT & VEGETABLE INC.

Business

Inactive


CHELSEA 29 PARKING LLC

Business

Active



CHELSEA HYPERMARKET, INC.

Business

Active


154 7TH AVE CHELSEA INC.

Business

Inactive




THE COMMONS CHELSEA

Business

Active


(default) 2 queries took 419 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 ( '(+CHELSEA)' IN BOOLEAN MODE) LIMIT 505050211
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+CHELSEA)' IN BOOLEAN MODE)11208