1. Home
  2. Home Improvement Contractor
  3. GLENDALE
  4. ARTISANAL FINISHES, INC.

ARTISANAL FINISHES, INC.

Home Improvement Contractor GLENDALE NY

ARTISANAL FINISHES, INC. is a registered Business operating as a Home Improvement Contractor in GLENDALE. DCA License Number 2006819-DCA is currently Inactive (expiry date 02/28/2017).

7851
85TH ST
GLENDALE
NY
11385

 

ARTISANAL FINISHES, INC. Data

Dca License Number 2006819-DCA
License Type Business
License Expiration Date 02/28/2017
License Status Inactive
License Creation Date 04/24/2014
Industry Home Improvement Contractor
Business Name ARTISANAL FINISHES, INC.
Business Name 2
Address Building 7851
Address Street Name 85TH ST
Secondary Address Street Name
Address City GLENDALE
Address State NY
Address Zip 11385
Contact Phone Number
Address Borough Queens
Borough Code 4
Community Board 405
Council District 30
Bin 4093956
Bbl 4038440022
Nta QN19
Census Tract 637
Detail
Longitude -73.86395176403389
Latitude 40.70451070100932
Location (40.70451070100932, -73.86395176403389)
 
GARDEN COURT SURGICAL & HOSPITAL SUPPLY CORPORATION BROOKLYN ROBERT L. MONETTI CUSTOM BUILDER, LLC BRIELLE

Have you worked with ARTISANAL FINISHES, INC. 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` = '2006819-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` < 74907 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` >= 74906 AND `Record`.`id` != 74907 ORDER BY `Record`.`id` ASC LIMIT 2220