Search
Mixed-Use Property with Tavern
New
For Sale
$425,000

507 Yates Street, Albany, NY 12208

Commercial Sale, Albany, NY

Property Size1,872 SF
Lot Size0.05 Acres
Price / SF$227.03
Days on Market2

Property Features for 507 Yates Street

General Information

Property type Commercial Sale
Property subtype Other
Zoning Mixed
Bathrooms 3
Full bathrooms 3
Rooms Bathroom 1, Bathroom 2, Bathroom 3
Basement Full
High school Albany
Elementary school district Albany
Middle school district Albany
High school district Albany
Directions Madison Ave West, left on Quail St, first right on Yates (Yates is a one way street).
Standard status Active
APN 010100 64.76-1-24
Size 1,872 SF
Lot size 0.05 Acres

Taxes and HOA fees

Tax Annual Amount 6198

Utilities

Sewer type Public Sewer
Heating system Radiant
Cooling system Window Unit(s)
Water source Public

Building Details

Year built 1930
Floors in Building 2
Building materials Frame, Drywall, Vinyl Siding
Roof type Flat
Listing Agency: Venture Fox Realty Group LLC
Listed By: Christopher Pratt · License #10401381795
Added: Oct 19 Last Checked: Oct 20 at 1:06PM
MLS# 202628536

Copyright © 2026 Global MLS, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

This mixed-use property combines a tavern business with a two-bedroom apartment on the upper floor. The 1,872-square-foot building includes a bar, kitchen and preparation area, and outdoor patio. The sale package also includes the operating business, furniture, fixtures, and equipment. Built in 1930, the property has mixed zoning and occupies a 0.05-acre parcel.

The Albany property is one block from the College of Saint Rose campus. A proposed 160-unit residential development for residents age 55 and older is nearby.

Key Highlights

  • 1,872‑square‑foot building on a 0.05‑acre lot
  • Tavern business, real estate, furniture, fixtures, and equipment included
  • Second‑floor apartment with two bedrooms

Financial Insights

Estimated NOI and Cap Rate

NOI / Yr
$25,937
Cap Rate
6.10%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$518,740 $518.7K
Cap Rate 7%
$370,529 $370.5K
Cap Rate 9%
$288,189 $288.2K
Market Conditions
NOI Build-Up for 1,872 SF
Gross rent
$37.1K $19.80/SF
− Vacancy
−$2.5K −$1.33/SF
EGI
$34.6K $18.47/SF
− OpEx
−$8.6K −$4.62/SF
NOI
$25.9K $13.86/SF
Area
Albany, NY
Vacancy
6.70%
Lease Rate
$19.80 /SF/Yr
Expense Ratio
25.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$518,740
Cap Rate 7%
$370,529
Cap Rate 9%
$288,189

Alternative Uses

Best Use
Specialty Retail
$370.5K
$324.2K – $432.3K (±1% cap)
NOI $25,937 @ 7.0% cap · market cap 6.10%
Second Best
Mixed Use
$315.2K
$275.8K – $367.7K (±1% cap)
NOI $22,064 @ 7.0% cap · market cap 5.19%
Theoretical Best
Office A
$493.9K
$432.2K – $576.2K (±1% cap)
NOI $34,572 @ 7.0% cap · market cap 8.13%
Zoning and permitted uses should be independently verified with authorities. How Realmo checks its estimates

Property Analytics

Unlock full access to Insights Subscribe to Realmo Intelligence
Open Analytics

Current Use

Casey Finn's Bar & Pub

Suggested Use

Top Pick Real Estate Agency HVAC Service Kitchen & Bath Showroom Bakery Acupuncture Furniture & Home Goods

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

Turnkey business
Opportunity

Location Intelligence

Trade Area within ½ mile

1,712
Businesses Nearby
27k
Monthly Visits Nearby

Foot Traffic Nearby

Shops & Services 77% Dining 23%
Mobil Shops & Services
10,707 visits/mo 0.4 miles
Exxon Shops & Services
7,137 visits/mo 0.5 miles
Dunkin' Donuts Dining
6,383 visits/mo 0.4 miles
Citizens Bank Shops & Services
3,088 visits/mo 0.4 miles

Demographics for 12208, NY

22,118
Population
11,522
Households
1.9
Avg Household Size
34
Median Age
56%
College-Educated
93%
High-School Grad
4.4 sq mi
ZIP Area
5,027
Density / Sq Mi
$69,505
Median Household Income
$39,268
Median Earnings
$1,291
Median Rent
$255,300
Median Home Value
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

Market

Vacancy Rate% for Retail in Albany, NY

5.4% 2020
4.8% 2021
5.5% 2022
4.7% 2023
5.5% 2024
5.8% 2025

Frequently Asked Questions

What type of property is this?
Mixed-use property - A second-floor two-bedroom apartment sits above a bar and kitchen, with the business and its furnishings included in the sale.
Where is this mixed-use property located?
The property is located at 507 Yates Street Albany, NY.
What is the asking price?
The asking price for this property is $425,000.
What are key features of this property?
This property features: 1,872‑square‑foot building on a 0.05‑acre lot; Tavern business, real estate, furniture, fixtures, and equipment included; Second‑floor apartment with two bedrooms
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message
Why this one?
Saved
Reason not saved — we won't ask again