SANTA MARIA DELI MBM ENTERPRISE LLC

Tobacco Retail Dealer BROOKLYN NY

SANTA MARIA DELI MBM ENTERPRISE LLC is a registered Business operating as a Tobacco Retail Dealer in BROOKLYN. DCA License Number 1248253-DCA is currently Inactive (expiry date 12/31/2017).

9718
4TH AVE
BROOKLYN
NY
11209

 

SANTA MARIA DELI MBM ENTERPRISE LLC Data

Dca License Number 1248253-DCA
License Type Business
License Expiration Date 12/31/2017
License Status Inactive
License Creation Date 02/13/2007
Industry Tobacco Retail Dealer
Business Name SANTA MARIA DELI MBM ENTERPRISE LLC
Business Name 2
Address Building 9718
Address Street Name 4TH AVE
Secondary Address Street Name
Address City BROOKLYN
Address State NY
Address Zip 11209
Contact Phone Number
Address Borough Brooklyn
Borough Code 3
Community Board 310
Council District 43
Bin 3155853
Bbl 3061260041
Nta BK31
Census Tract 5601
Detail
Longitude -74.03220040155199
Latitude 40.61453311775881
Location (40.61453311775881, -74.03220040155199)
 

Have you worked with SANTA MARIA DELI MBM ENTERPRISE 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 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` = '1248253-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` < 86328 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` >= 86327 AND `Record`.`id` != 86328 ORDER BY `Record`.`id` ASC LIMIT 2221