LORD AND HOWELL LLC

Secondhand Dealer - Auto BROOKLYN NY

LORD AND HOWELL LLC is a registered Business operating as a Secondhand Dealer - Auto in BROOKLYN. DCA License Number 2001154-DCA is currently Inactive (expiry date 07/31/2015).

Telephone: 9174684924.

442
DEWITT AVE
BROOKLYN
NY
11207

 

LORD AND HOWELL LLC Data

Dca License Number 2001154-DCA
License Type Business
License Expiration Date 07/31/2015
License Status Inactive
License Creation Date 11/29/2013
Industry Secondhand Dealer - Auto
Business Name LORD AND HOWELL LLC
Business Name 2
Address Building 442
Address Street Name DEWITT AVE
Secondary Address Street Name
Address City BROOKLYN
Address State NY
Address Zip 11207
Contact Phone Number 9174684924
Address Borough Brooklyn
Borough Code 3
Community Board 305
Council District 42
Bin 3000000
Bbl 3043420010
Nta BK82
Census Tract 1104
Detail
Longitude -73.89393414398974
Latitude 40.65697802979596
Location (40.65697802979596, -73.89393414398974)
 

Have you worked with LORD AND HOWELL LLC 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 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` = '2001154-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` < 120160 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` >= 120159 AND `Record`.`id` != 120160 ORDER BY `Record`.`id` ASC LIMIT 2220