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]
COLOR TREND INC - Home Improvement Contractor YONKERS

COLOR TREND INC

Home Improvement Contractor YONKERS NY

COLOR TREND INC is a registered Business operating as a Home Improvement Contractor in YONKERS. DCA License Number 2026429-DCA is currently Active (expiry date 02/28/2019).

Telephone: 2127246837.

941
MCLEAN AVE
YONKERS
NY
10704

 

COLOR TREND INC Data

Dca License Number 2026429-DCA
License Type Business
License Expiration Date 02/28/2019
License Status Active
License Creation Date 07/31/2015
Industry Home Improvement Contractor
Business Name COLOR TREND INC
Business Name 2
Address Building 941
Address Street Name MCLEAN AVE
Secondary Address Street Name
Address City YONKERS
Address State NY
Address Zip 10704
Contact Phone Number 2127246837
Address Borough Outside NYC
Borough Code
Community Board
Council District
Bin
Bbl
Nta
Census Tract
Detail
Longitude
Latitude
Location
 

Have you worked with COLOR TREND INC or used their services?

Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.

(default) 3 queries took 12 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 `Record`.`DCA_License_Number` = '2026429-DCA' LIMIT 1116
2SELECT `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 `Record`.`id` < 45750 ORDER BY `Record`.`id` DESC LIMIT 1113
3SELECT `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 `Record`.`id` >= 45749 AND `Record`.`id` != 45750 ORDER BY `Record`.`id` ASC LIMIT 2223
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]