ROOSEVELT [Permits for ROOSEVELT]

51 - 76 of 76

ROOSEVELT JEWELRY

Business

Inactive




ROOSEVELT FOOD CORP.

Business

Inactive



ROOSEVELT AUTO WRECKING

Business

Active


ROOSEVELT AUTO WRECKING

Business

Active



LAUNDRY CITY

Business

Inactive


ROOSEVELT FLOWER SHOP

Business

Inactive


ROOSEVELT ELECTRONICS INC.

Business

Inactive


Roosevelt Mobil Corp

Business

Active





ROOSEVELT LAUNDROMAT CORP.

Business

Inactive


DISASTER PRO INC.

Business

Active


ROOSEVELT DRUG & SURGICALS

Business

Inactive






ROOSEVELT RESTORATION INC.

Business

Inactive




Roosevelt Drugs & Surgicals

Business

Active


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