1. Home
  2. Sidewalk Cafe
  3. NEW YORK
  4. CAFE FREDERICK HARLEM PARLOR

CAFE FREDERICK HARLEM PARLOR RSO CAFE, LLC

Sidewalk Cafe NEW YORK NY

CAFE FREDERICK HARLEM PARLOR is a registered Business operating as a Sidewalk Cafe in NEW YORK. DCA License Number 2052349-DCA is currently Active (expiry date 09/15/2019). Sidewalk Cafe Type: Unenclosed, Square Feet: 222, Tables: 12, Chairs: 26

Telephone: 2122221987.

2104
FREDERICK DOUGLASS BLVD
NEW YORK
NY
10026

 

CAFE FREDERICK HARLEM PARLOR Data

Dca License Number 2052349-DCA
License Type Business
License Expiration Date 09/15/2019
License Status Active
License Creation Date 05/03/2017
Industry Sidewalk Cafe
Business Name RSO CAFE, LLC
Business Name 2 CAFE FREDERICK HARLEM PARLOR
Address Building 2104
Address Street Name FREDERICK DOUGLASS BLVD
Secondary Address Street Name
Address City NEW YORK
Address State NY
Address Zip 10026
Contact Phone Number 2122221987
Address Borough Manhattan
Borough Code 1
Community Board 110
Council District 09
Bin 1087078
Bbl 1018297501
Nta MN11
Census Tract 216
Detail Sidewalk Cafe Type: Unenclosed, Square Feet: 222, Tables: 12, Chairs: 26
Longitude -73.95642084980501
Latitude 40.80296279006334
Location (40.80296279006334, -73.95642084980501)
 
MANUEL ANTONIO SANTANA JAMAICA ALI 2023 DELI & GROCERY LLC NEW YORK

Have you worked with CAFE FREDERICK HARLEM PARLOR or used their services?

Leave your comments, questions and feedback on this listing below. You can also correct any listing errors or omissions.

© 2024 NYCbizdatabase.com | Search | Privacy
(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` = '2052349-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` < 63465 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` >= 63464 AND `Record`.`id` != 63465 ORDER BY `Record`.`id` ASC LIMIT 2220