YORKSHIRE STONE, INC.

Home Improvement Contractor HAUPPAUGE NY

YORKSHIRE STONE, INC. is a registered Business operating as a Home Improvement Contractor in HAUPPAUGE. DCA License Number 1415202-DCA is currently Active (expiry date 02/28/2019).

Telephone: 6318734290.

175
MARCUS BLVD
HAUPPAUGE
NY
11788

 

YORKSHIRE STONE, INC. Data

Dca License Number 1415202-DCA
License Type Business
License Expiration Date 02/28/2019
License Status Active
License Creation Date 12/06/2011
Industry Home Improvement Contractor
Business Name YORKSHIRE STONE, INC.
Business Name 2
Address Building 175
Address Street Name MARCUS BLVD
Secondary Address Street Name
Address City HAUPPAUGE
Address State NY
Address Zip 11788
Contact Phone Number 6318734290
Address Borough Outside NYC
Borough Code
Community Board
Council District
Bin
Bbl
Nta
Census Tract
Detail
Longitude
Latitude
Location
 

Have you worked with YORKSHIRE STONE, INC. 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 3 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` = '1415202-DCA' LIMIT 1112
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` < 32873 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` >= 32872 AND `Record`.`id` != 32873 ORDER BY `Record`.`id` ASC LIMIT 2220