TURAN ENTERPRISE TURAN, AFSIN

Pedicab Business ASTORIA NY

TURAN ENTERPRISE is a registered Business operating as a Pedicab Business in ASTORIA. DCA License Number 1338958-DCA is currently Active (expiry date 11/01/2018). Active Sticker Numbers: 1588, 1585

Telephone: 3478567703.

2518
18TH ST
ASTORIA
NY
11102

 

TURAN ENTERPRISE Data

Dca License Number 1338958-DCA
License Type Business
License Expiration Date 11/01/2018
License Status Active
License Creation Date 10/03/2012
Industry Pedicab Business
Business Name TURAN, AFSIN
Business Name 2 TURAN ENTERPRISE
Address Building 2518
Address Street Name 18TH ST
Secondary Address Street Name
Address City ASTORIA
Address State NY
Address Zip 11102
Contact Phone Number 3478567703
Address Borough Queens
Borough Code 4
Community Board 401
Council District 22
Bin 4020512
Bbl 4008990095
Nta QN71
Census Tract 91
Detail Active Sticker Numbers: 1588, 1585
Longitude -73.92632361835462
Latitude 40.77520647080246
Location (40.77520647080246, -73.92632361835462)
 

Have you worked with TURAN ENTERPRISE 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 0 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` = '1338958-DCA' LIMIT 1110
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` < 15068 ORDER BY `Record`.`id` DESC LIMIT 1110
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` >= 15067 AND `Record`.`id` != 15068 ORDER BY `Record`.`id` ASC LIMIT 2220