SHOE CARE SERVICES ARONOV, ARTUR

Secondhand Dealer - General KEW GARDENS NY

SHOE CARE SERVICES is a registered Business operating as a Secondhand Dealer - General in KEW GARDENS. DCA License Number 1230335-DCA is currently Active (expiry date 07/31/2019).

Telephone: 7188475954.

8153A
LEFFERTS BLVD
KEW GARDENS
NY
11415

 

SHOE CARE SERVICES Data

Dca License Number 1230335-DCA
License Type Business
License Expiration Date 07/31/2019
License Status Active
License Creation Date 06/13/2006
Industry Secondhand Dealer - General
Business Name ARONOV, ARTUR
Business Name 2 SHOE CARE SERVICES
Address Building 8153A
Address Street Name LEFFERTS BLVD
Secondary Address Street Name
Address City KEW GARDENS
Address State NY
Address Zip 11415
Contact Phone Number 7188475954
Address Borough Queens
Borough Code 4
Community Board 409
Council District 29
Bin
Bbl
Nta QN60
Census Tract 136
Detail
Longitude -73.83082573853342
Latitude 40.70817221950227
Location (40.70817221950227, -73.83082573853342)
 

Have you worked with SHOE CARE SERVICES 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 2 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` = '1230335-DCA' LIMIT 1111
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` < 99152 ORDER BY `Record`.`id` DESC LIMIT 1111
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` >= 99151 AND `Record`.`id` != 99152 ORDER BY `Record`.`id` ASC LIMIT 2220