Secondhand Dealer - Auto [Permits for Secondhand Dealer - Auto]

351 - 400 of 2271

NOAH AUTO REPAIR INC

Business

Active





LIBERTY AUTO PARTS, INC.

Business

Inactive


BMW OF MANHATTAN, INC.

Business

Active


JOHN'S AUTO WRECKING CO., INC.

Business

Inactive


RAMON AUTO SERVICE, INC.

Business

Inactive


SHERIDAN AUTO REPAIRS INC.

Business

Active


DI BLASI MOTORS INC

Business

Inactive


NEW AUTO BODIES R' US INC

Business

Active


WORLD STAR AUTO SALES INC

Business

Active




NELSON'S AUTO SALVAGE, INC.

Business

Active




CITY WORLD FORD LINCOLN

Business

Inactive


GARET MOTORS INC.

Business

Active


LUMARA AUTO ELECTRIC

Business

Active



DOCTOR NICKS AUTO CENTER, LLC

Business

Inactive


SUMMIT MOTORS CORP.

Business

Active


MAY KAM AUTO CENTER INC.

Business

Active



ACME STAR AUTO CORP.

Business

Active


UNIQUE MOTORS INC.

Business

Inactive


TNS AUTO COLLISION

Business

Active


AUTO MEX CORP.

Business

Active


STOP 4 AUTO PARTS INC

Business

Inactive


RPS AUTO INC.

Business

Active



NATIONWIDE AUTO SALES INC.

Business

Inactive



SYLHET MOTORS INC.

Business

Active


LSM AUTO BODY & TOWING INC

Business

Inactive



CHAMOX MOTOR CORP.

Business

Active


HAJI AUTO REPAIRS CORP.

Business

Active


TOWER AUTO MALL, INC.

Business

Active



VERRAZANO SERVICE INC

Business

Active



JIREH AUTO BODY SHOP INC

Business

Inactive


FREDDY FRED USED CARS INC.

Business

Active




CASEY TRANSPORT CORP

Business

Active


GRAND OPENING AUTO CENTER INC.

Business

Inactive


KING'S AUTO REPAIR CENTER

Business

Inactive


(default) 2 queries took 532 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 ( '(+Secondhand +Dealer +- +Auto)' IN BOOLEAN MODE) LIMIT 350, 505050131
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Secondhand +Dealer +- +Auto)' IN BOOLEAN MODE)11401