ALBANY

1 - 50 of 631


156 ALBANY LLC

#

INCORRECT LICENSE


3154 ALBANY CRESCENT

#

INCORRECT LICENSE

BRONX

BRONX


ALBANY MANOR INC

#

FOOD SERVICE ESTAB

BROOKLYN

BROOKLYN


ALBANY DAVIS

#

FOOD SERVICE EST.


ALBANY BEAUTY SALON INC.

#

BEAUTY PARLOR

NEW YORK

MANHATTAN


601 ALBANY REALTY CORP.

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


601 ALBANY REALTY CORP.

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


143 ALBANY REALTY INC

#

INCORRECT LICENSE


ALBANY ESTATES INC

#

INCORRECT LICENSE


CVS ALBANY LLC

#

INCORRECT LICENSE


ALBANY CROSSING APARTMENTS LP

#

INCORRECT LICENSE


196 ALBANY AVENUE DAY CARE

#

FSE DAY CARE SERVICE


1155 PARK ALBANY LLC

#

INCORRECT LICENSE


ALBANY DECATUR REDEV

#

INCORRECT LICENSE


268 ALBANY REALTY INC

#

INCORRECT LICENSE


268 ALBANY REALTY INC

#

FULL TERM MFV PERMIT


ALBANY HOUSE

#

INCORRECT LICENSE


ALBANY RESTAURANT, INC.

#

FOOD SERVICE EST.


ALBANY RESTAURANT, INC.

#

FOOD SERVICE EST.


ALBANY MANOR INC

#

FOOD SERVICE EST.

BROOKLYN

BROOKLYN


158 ALBANY LLC

#

INCORRECT LICENSE


ALBANY DECATUR REDEVELOPMENT C

#

INCORRECT LICENSE


ALBANY DECATUR REDEVE

#

INCORRECT LICENSE


196 ALBANY AVENUE DAY CARE

#

FSE DAY CARE SERVICE


ALBANY CROSSINGS APT LP

#

INCORRECT LICENSE


196 ALBANY AVENUE DCC

#

AFTER SCHOOL


647 ALBANY AVE L.L.C

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN



143 ALBANY REALTY INC

#

INCORRECT LICENSE


572-574 ALBANY AVENUE REALTY LLC

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


ALBANY ESTATES INC

#

DOHMH permit not required


273 ALBANY AVENUE L

#

INCORRECT LICENSE


601 ALBANY REALTY CORP

#

INCORRECT LICENSE

BROOKLYN

BROOKLYN


FORTUNE OF ALBANY CORPORATION

#

FOOD SERVICE EST.



273 ALBANY AVENUE L

#

INCORRECT LICENSE


ALBANY RESTAURANT, INC.

#

FOOD SERVICE EST.




ALBANY AVENUE D 196

#

FSE DAY CARE SERVICE



1505 ALBANY CORP.

#

INCORRECT LICENSE


JAMES HOYTE D/B/A ALBANY BAKERY

#

FOOD SERVICE EST.


196 ALBANY AVENUE DAY CARE

#

CHILD CARE APPLICATION TRACKING SYSTEM


BRONX

BRONX


ALBANY ESTATES INC

#

INCORRECT LICENSE


ALBANY CROSSINGS APT LP

#

DOHMH permit not required


ALBANY DECATUR REDEVE

#

INCORRECT LICENSE


269 ALBANY AVENUE LLC

#

INCORRECT LICENSE


(default) 2 queries took 134 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Permit`.`id`, `Permit`.`Source`, `Permit`.`License_Permit_Holder`, `Permit`.`Business_Description`, `Permit`.`License/Permit_Number`, `Permit`.`Permit_Type_Description`, `Permit`.`Permit_Subtype_Description`, `Permit`.`Permit_Issuance_Date`, `Permit`.`Permit_Expiration_Date`, `Permit`.`Permit_Status_Date`, `Permit`.`Permit_Status_Description`, `Permit`.`Address`, `Permit`.`Street`, `Permit`.`City`, `Permit`.`Zip_Code`, `Permit`.`Borough`, `Permit`.`Building_ID_No`, `Permit`.`Borough_Block_Lot`, `Permit`.`Latitude_WGS84`, `Permit`.`Longitude_WGS84`, `Permit`.`License/Permit_Holder_Name`, `Permit`.`DOB_Skilled_Trades_Lic_Num`, `Permit`.`DOB_Skilled_Trades_Lic_Type` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+ALBANY)' IN BOOLEAN MODE) LIMIT 50505015
2SELECT COUNT(*) AS `count` FROM `nyc_business`.`permits` AS `Permit` WHERE MATCH (License_Permit_Holder, City) AGAINST ( '(+ALBANY)' IN BOOLEAN MODE)11119