SUNNY ISL BCH [Permits for SUNNY ISL BCH]

51 - 69 of 69

SUNNY M CONSTRUCTION INC

Business

Active


SUNNY CHEN LAUNDROMAT INC.

Business

Active


SUNNY'S LAUNDROMAT NY CORP

Business

Inactive


Sunny Windows Inc

Business

Active


BRIGHT & SUNNY LAUNDRY, LLC

Business

Active


SUNNY GROCERY YILDIZ CORP.

Business

Active


SUNNY TRIANGLE, INC.

Business

Inactive



SUNNY

Business

Active


SUNNY CAR PARK, LLC

Business

Inactive


NEIGHBORHOOD DISCOUNT STORE

Business

Inactive


SUNNY LAUNDROMAT INC

Business

Active


SUNNY IMPROVEMENT INC.

Business

Inactive


TOWN CLEANER

Business

Inactive


SUNNY ON 18 INC.

Business

Inactive


NEW SUNNY LAUNDROMAT, INC.

Business

Active


SUNNY CLEAN USA, INC.

Business

Active


SUNNY BRITE CLEANERS

Business

Inactive



(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 ( '(+SUNNY +ISL +BCH)' IN BOOLEAN MODE) LIMIT 50, 501919212
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)11215