Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_list): failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_cake_dev_eng) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'cake_dev_eng' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_list' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_list) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_list' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_records) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_records' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/models/myapp_cake_model_default_nyc_business_records) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_model_ cache was unable to write 'default_nyc_business_records' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Secondhand Dealer - General

Secondhand Dealer - General [Permits for Secondhand Dealer - General]

Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_cake_eng) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'cake_eng' to File cache [CORE/Cake/Cache/Cache.php, line 328]
1 - 50 of 8313

COMPUTER & CELLULAR REPAIR

Business

Active


STAR ONE WIRELESS CORP

Business

Active


ecoATM, Inc.

Business

Inactive



GUAYQUIL GOLD REPAIR

Business

Inactive


MIDTOWN GOLD BUYERS INC.

Business

Active


DARLIN DREAM STOP CORPORATION

Business

Inactive


GLB TOWING & COLLISION INC.

Business

Inactive


WIRELESS VISION LLC

Business

Inactive


SECURITY WORLD NYC INC

Business

Inactive


VERIZON WIRELESS

Business

Active


VERIZON WIRELESS

Business

Active


KALEIDOSCOPE GALLERY

Business

Active


VERIZON WIRELESS

Business

Inactive


ELIO AUTO REPAIR CORP

Business

Active


VERIZON WIRELESS

Business

Inactive


REPAIRGUYS INC

Business

Active


VERIZON WIRELESS

Business

Active


M-DOLLA AUTO COLLISION CORP

Business

Active


AT&T MOBILITY

Business

Inactive


EAST RIVER AUTO CARE INC.

Business

Active


VERIZON WIRELESS

Business

Active


Sprint

Business

Active


WIRELESS 1 OF GLEN OAKS

Business

Inactive


Sprint

Business

Active


AMERICAN GOLD & DIAMONDS INC

Business

Inactive


ILUSION MULTISERVICE CORP

Business

Inactive



ALEXANDER ANTIQUE SHOP

Business

Active


VERIZON WIRELESS

Business

Active


VERIZON WIRELESS

Business

Active


SABA JEWELERS INC.

Business

Active


WIRELESS 1 OF WOODHAVEN

Business

Inactive


VERIZON WIRELESS

Business

Active


EXOTIC SECOND HAND

Business

Active


Auctionata, Inc

Business

Inactive


AERUS ELECTROLUX

Business

Active


VERIZON WIRELESS

Business

Active


WIRELSS 1 OF BELLEROSE

Business

Inactive


VERIZON WIRELESS

Business

Active


SALMA L& M JEWELRY CORP

Business

Inactive


VERIZON WIRELESS

Business

Active


VERIZON WIRELESS

Business

Active


T-Mobile Limited

Business

Active


AAA ACE TRANSMISSIONS INC.

Business

Inactive


VERIZON WIRELESS

Business

Active


VERIZON WIRELESS

Business

Active



GOLDEN TOUCH AUTO HOUSE

Business

Active


G'S TIRES INC

Business

Active


(default) 2 queries took 259 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 +- +General)' IN BOOLEAN MODE) LIMIT 50505022
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`records` AS `Record` WHERE MATCH (Business_Name, Business_Name_2 , Address_City, Industry) AGAINST ( '(+Secondhand +Dealer +- +General)' IN BOOLEAN MODE)11237
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_file_map) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'file_map' to File cache [CORE/Cake/Cache/Cache.php, line 328]
Warning (512): SplFileInfo::openFile(/var/www/html/nyc.millsbomb.com/app/tmp/cache/persistent/myapp_cake_core_method_cache) [<a href='http://php.net/splfileinfo.openfile'>splfileinfo.openfile</a>]: failed to open stream: No such file or directory [CORE/Cake/Cache/Engine/FileEngine.php, line 360]
Warning (512): _cake_core_ cache was unable to write 'method_cache' to File cache [CORE/Cake/Cache/Cache.php, line 328]