MCGUIRE, BRIAN J

Locksmith S SETAUKET NY

MCGUIRE, BRIAN J is a registered Individual operating as a Locksmith in S SETAUKET. DCA License Number 0865852-DCA is currently Active (expiry date 05/31/2019).

Telephone: 5167322264.

S SETAUKET
NY
11720

 

MCGUIRE, BRIAN J Data

Dca License Number 0865852-DCA
License Type Individual
License Expiration Date 05/31/2019
License Status Active
License Creation Date 05/02/1995
Industry Locksmith
Business Name MCGUIRE, BRIAN J
Business Name 2
Address Building
Address Street Name
Secondary Address Street Name
Address City S SETAUKET
Address State NY
Address Zip 11720
Contact Phone Number 5167322264
Address Borough
Borough Code
Community Board
Council District
Bin
Bbl
Nta
Census Tract
Detail
Longitude
Latitude
Location
 

Have you worked with MCGUIRE, BRIAN J 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 1 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` = '0865852-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` < 31749 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` >= 31748 AND `Record`.`id` != 31749 ORDER BY `Record`.`id` ASC LIMIT 2220