1. Home
  2. Home Improvement Contractor
  3. VALLEY STREAM
  4. STUNNING FINISH CORP.

STUNNING FINISH CORP.

Home Improvement Contractor VALLEY STREAM NY

STUNNING FINISH CORP. is a registered Business operating as a Home Improvement Contractor in VALLEY STREAM. DCA License Number 2000858-DCA is currently Active (expiry date 02/28/2019).

Telephone: 5164396450.

6
COHILL RD
VALLEY STREAM
NY
11580

 

STUNNING FINISH CORP. Data

Dca License Number 2000858-DCA
License Type Business
License Expiration Date 02/28/2019
License Status Active
License Creation Date 11/19/2013
Industry Home Improvement Contractor
Business Name STUNNING FINISH CORP.
Business Name 2
Address Building 6
Address Street Name COHILL RD
Secondary Address Street Name
Address City VALLEY STREAM
Address State NY
Address Zip 11580
Contact Phone Number 5164396450
Address Borough Outside NYC
Borough Code
Community Board
Council District
Bin
Bbl
Nta
Census Tract
Detail
Longitude
Latitude
Location
 
FAIRCHILD, ANTHONY LINDENHURST NEW YORK ENERGY CONSERVATION CO., INC. BEDFORD HILLS

Have you worked with STUNNING FINISH CORP. 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` = '2000858-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` < 38895 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` >= 38894 AND `Record`.`id` != 38895 ORDER BY `Record`.`id` ASC LIMIT 2220