THE ROCK HOUSE JAHMI, AHMED

Tobacco Retail Dealer BROOKLYN NY

THE ROCK HOUSE is a registered Business operating as a Tobacco Retail Dealer in BROOKLYN. DCA License Number 1053671-DCA is currently Active (expiry date 12/31/2019).

Telephone: 9173659252.

263A
AVENUE X
BROOKLYN
NY
11223

 

THE ROCK HOUSE Data

Dca License Number 1053671-DCA
License Type Business
License Expiration Date 12/31/2019
License Status Active
License Creation Date 10/24/2000
Industry Tobacco Retail Dealer
Business Name JAHMI, AHMED
Business Name 2 THE ROCK HOUSE
Address Building 263A
Address Street Name AVENUE X
Secondary Address Street Name
Address City BROOKLYN
Address State NY
Address Zip 11223
Contact Phone Number 9173659252
Address Borough Brooklyn
Borough Code 3
Community Board 315
Council District 47
Bin 3194400
Bbl 3071730042
Nta BK26
Census Tract 386
Detail
Longitude -73.97322650781189
Latitude 40.590223844255995
Location (40.590223844255995, -73.97322650781189)
 

Have you worked with THE ROCK HOUSE 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` = '1053671-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` < 17227 ORDER BY `Record`.`id` DESC LIMIT 1110
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` >= 17226 AND `Record`.`id` != 17227 ORDER BY `Record`.`id` ASC LIMIT 2220