1. Home
  2. Electronic & Appliance Service
  3. BRONX
  4. Showcase Cleaners

Showcase Cleaners pichardo, nelson

Electronic & Appliance Service BRONX NY

Showcase Cleaners is a registered Business operating as a Electronic & Appliance Service in BRONX. DCA License Number 2069299-DCA is currently Active (expiry date 06/30/2020).

163
W TREMONT AVE
BRONX
NY
10453

 

Showcase Cleaners Data

Dca License Number 2069299-DCA
License Type Business
License Expiration Date 06/30/2020
License Status Active
License Creation Date 04/11/2018
Industry Electronic & Appliance Service
Business Name pichardo, nelson
Business Name 2 Showcase Cleaners
Address Building 163
Address Street Name W TREMONT AVE
Secondary Address Street Name
Address City BRONX
Address State NY
Address Zip 10453
Contact Phone Number
Address Borough Bronx
Borough Code 2
Community Board 205
Council District 14
Bin 2009089
Bbl 2028790100
Nta BX36
Census Tract 24501
Detail
Longitude -73.91572141207084
Latitude 40.85072298293725
Location (40.85072298293725, -73.91572141207084)
 
GARDEN CONVENIENCE DELI CORP RIDGEWOOD AA'S TOWING & COLLISION INC. BROOKLYN

Have you worked with Showcase Cleaners or used their services?

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

© 2024 NYCbizdatabase.com | Search | Privacy
(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` = '2069299-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` < 18498 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` >= 18497 AND `Record`.`id` != 18498 ORDER BY `Record`.`id` ASC LIMIT 2220