SUNRISE [Permits for SUNRISE]

1 - 50 of 76

STEWART, ALEXANDER G

Individual

Active


SUNRISE MINI MART

Business

Inactive


KARCHEUNY, ALIAKSEI

Individual

Inactive


STEWART, ALEXANDER G

Business

Active


NEW SUNRISE DRY CLEANERS INC

Business

Inactive



QU SUNRISE LAUNDROMAT, INC.

Business

Inactive


NEW SUNRISE LAUNDROMAT, INC.

Business

Inactive


SUNRISE MARKETPLACE

Business

Active



SUNRISE EXPRESS DELI INC

Business

Active


SUNRISE GROCERY CORP

Business

Inactive


SUNRISE 2015 INC.

Business

Active


SUNRISE CLEANER MS INC.

Business

Active


SUNRISE STREAM PETROLEUM CORP

Business

Inactive






SUNRISE RECYCLING CORP.

Business

Inactive


SUNRISE PHARMACY

Business

Active


ONE SUNRISE

Business

Inactive



SUNRISE CONSTRUCTION I INC

Business

Inactive


SUNRISE 28, INC.

Business

Active



SUNRISE FARMS OF BKLYN, INC.

Business

Inactive


SUNRISE CLEANER MS INC.

Business

Inactive


BRISCOE SUNRISE CORPORATION

Business

Inactive


SUNRISE HERBS, INC

Business

Active



TAINO SUNRISE, CORP.

Business

Active


CSR SUNRISE INC

Business

Active


SUNRISE GOURMET DELI CORP.

Business

Inactive



SUNRISE GROCERY DELI, INC.

Business

Inactive




SUNRISE (NY) CORP.

Business

Active


s&f sunrise usa corp

Business

Inactive


SUNRISE GOURMET GRILL

Business

Active


QUEENS HEALTH PHARMACY

Business

Active


CHEN SUNRISE MINI MARKET INC.

Business

Inactive


SUNRISE CLEANER MS INC.

Business

Inactive



SUNRISE WINDOW INSTLLTNS

Business

Inactive


CSR SUNRISE INC

Business

Active



SUNRISE 86 INC.

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 ( '(+SUNRISE)' IN BOOLEAN MODE) LIMIT 505050208
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)11211