STA ROSA [Permits for STA ROSA]

51 - 64 of 64

37-29 DELI GROCERY

Business

Inactive


ADAM ROSA

Business

Active


R TIRES SHOP

Business

Inactive


CHABELITA LAUNDROMAT

Business

Inactive



ROSA COFFEE SHOP CORP.

Business

Active


LA BODEGUITA DE ROSA, CORP.

Business

Active


ROSA S FERNANDEZ

Business

Inactive


LORENZO, ROSA

Business

Active


FERNANDEZ COMPRO ORO

Business

Inactive


TRANSWORLD SYSTEMS INC.

Business

Inactive


ROSY'S DELI GROCERY

Business

Inactive


DE LA ROSA BUY AND SELL INC.

Business

Inactive


FRASCA, ROSA

Business

Active


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