SUNNY ISL BCH [Permits for SUNNY ISL BCH]

1 - 50 of 69

NEW SUNNY LAUNDROMAT, INC.

Business

Inactive


SUPER SUNNY LAUNDROMAT LLC

Business

Inactive


BRIGHT & SUNNY LAUNDRY, LLC

Business

Inactive


Sunny Brite Cleaners

Business

Inactive


SUNNY LAUNDROMAT

Business

Inactive


SUNNY LAUNDROMAT CENTER INC

Business

Inactive




BING FANG ZHOU

Business

Inactive


SUNNY LAUNDROMAT

Business

Inactive


LEE SUNNY LAUNDROMAT CORP.

Business

Inactive


SUNNY CLEAN USA, INC.

Business

Inactive


KALLIOPE'S SUNNY SUDS, LLC

Business

Inactive


SUNNY LAUNDROMAT INC

Business

Inactive


SUNNY MART GROUP INC.

Business

Active



GILL, SUNNY

Individual

Active


BISSOONDIAL, SUNNY J

Individual

Inactive


SUNNY JOBS AGENCY INC

Business

Active


SHAGINYAN, GAREGIN

Individual

Active


Huynh, Sunny

Individual

Active


SUNNY, ALYAS

Individual

Inactive


SUNNY'S BEST FOOD CORP.

Business

Inactive



SUNNY DELI

Business

Inactive


SUNNY LAUNDROMAT

Business

Active


368 SUNNY DELI CORP.

Business

Inactive


SUNNY DELI INC

Business

Active


SUNNY LINDEN CORP.

Business

Inactive


SUNNY WIRELESS ONE INC.

Business

Active


SUNNY GOURMET DELI, INC.

Business

Active



SUNNY MART INC

Business

Active


WONDER CLEANERS

Business

Inactive


SUPER SUNNY LAUNDROMAT LLC

Business

Active


SUNNY & ACE COFFEE CORP.

Business

Active


ALWAYS SUNNY GROCERY, LLC

Business

Active


SUNNY LLC

Business

Inactive


SUNNY LAUNDROMAT CENTER INC

Business

Active


SUNNY BUILDERS NY CORP.

Business

Inactive


SUNNY STATIONERY

Business

Active


SUNNY PARK TRADING INC.

Business

Inactive


A.J. SUNNY LAUNDROMAT

Business

Inactive



SUNNY COIN-OP CORP.

Business

Inactive


SUNNY 1 JEWELRY

Business

Active


LEE SUNNY LAUNDROMAT CORP

Business

Active


MEET SUNNY CONSTRUCTION INC.

Business

Inactive


SUNNY DRY CLEANING INC.

Business

Active


KALLIOPE'S SUNNY SUDS, LLC

Business

Active


(default) 2 queries took 531 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 ( '(+SUNNY +ISL +BCH)' IN BOOLEAN MODE) LIMIT 505050275
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SUNNY +ISL +BCH)' IN BOOLEAN MODE)11256