SUNRISE [Permits for SUNRISE]

51 - 76 of 76


SUNRISE CHEVROLET

Business

Active


SUNRISE AUTOMOTIVE CENTER

Business

Active


SUNRISE GOURMET DELI I CORP

Business

Inactive






SUNRISE AUTO SALES

Business

Active



SUNRISE CONTRACTING CORP.

Business

Active


C & L SUNRISE INC

Business

Active


SUNRISE FOOD & CANDY INC

Business

Active


SUNRISE DELI CANDY & GROCERY

Business

Inactive


UBREAKIT WEFIXIT CORP

Business

Active


SUNRISE EXPRESS DELI INC

Business

Active


SUNRISE RENOVATION INC.

Business

Active




QU SUNRISE LAUNDROMAT, INC.

Business

Active


SUNRISE AUTO LAND INC

Business

Inactive


SUNRISE AUTOLAND

Business

Active


SUNRISE MARKETPLACE

Business

Active


C & L SUNRISE INC

Business

Inactive



SUNRISE FINE JEWELRY INC.

Business

Active


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