SEA BRIGHT [Permits for SEA BRIGHT]

51 - 72 of 72

BRIGHT LAUNDRY LAND CORP.

Business

Active




CITY BRIGHT DELI CORP

Business

Inactive


BRIGHT LYONS INC.

Business

Active


MASTER COLOR BRIGHT LLC

Business

Inactive


BRIGHT & SUNNY LAUNDRY, LLC

Business

Active


CLEAN BRIGHT CLEANERS, INC.

Business

Inactive


GOLD BRIGHT IDA, INC.

Business

Active



1836 BRIGHT STAR CORP

Business

Active



BRIGHT CONSTRUCTION CO

Business

Active



BRIGHT STONE CONTRACTING CO

Business

Active




49 BRIGHT LAUNDROMAT INC

Business

Active


15TH ST BRIGHT & CLEAN INC

Business

Active



HAPPY & BRIGHT LAUNDROMAT

Business

Inactive


SUNNY BRITE CLEANERS

Business

Inactive


(default) 2 queries took 464 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 ( '(+SEA +BRIGHT)' IN BOOLEAN MODE) LIMIT 50, 502222245
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+SEA +BRIGHT)' IN BOOLEAN MODE)11219