SPRNGFLD GDNS [Permits for SPRNGFLD GDNS]

51 - 62 of 62

ESTEVEZ MINI MARKET CORP.

Business

Inactive


ALFRED, WILLIAM

Business

Inactive


JYD TOWING LLC

Business

Inactive


O-T HOME IMPROVEMENTS CORP.

Business

Inactive


IS IN GOLD CORPORATION

Business

Inactive



FLEMING TRANSPORT, INC.

Business

Inactive


ABN STOP ONE GROCERY, INC.

Business

Active


FREEDOM AUTO MALL, INC.

Business

Inactive


DIAMOND CUT CONSTRUCTION

Business

Inactive


GNM DELI & GROCERY INC.

Business

Active


SPRINGFIELD TIRE INC.

Business

Inactive


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