Back to Search
Mixed-Use Restaurant with Apartments

211 2nd Street, Aurora, IN 47001

$780,000

Commercial Sale, Aurora, IN

Property SizeContact for details
Lot Size0.73 Acres
Days on Market55

Property Features for 211 2nd Street

General Information

Property type Commercial Sale
Property subtype Other
Subdivision Center
Standard status Active
APN 150732103033000003
Lot size 0.73 Acres

Amenities

large deck

Building Details

Year built 1900
Listing Agency: Lohmiller Real Estate
Listed By: Sandra Baker · License IN RB14039879
Added: Sep 28 Changed: Oct 7 Last Checked: Nov 21 at 6:06AM
MLS# 208428

Copyright © 2026 Southeastern Indiana Board of Realtors. 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 1900-built brick property combines restaurant and bar space with two apartments on the third floor. One apartment has one bedroom and one bathroom; the other has two bedrooms and one bathroom. Business inventory and operating contents are included, while personal belongings are excluded. A deck spans the front of the building and faces the Ohio River.

The property sits on a 0.73-acre site at 211 2nd Street in Aurora, Indiana.

Key Highlights

  • Brick restaurant and bar building with two third‑floor apartments
  • One apartment has 1 bedroom and 1 bathroom; the other has 2 bedrooms and 1 bathroom
  • Front deck overlooks the Ohio River

Property Analytics

Who owns this building? See the owner, sales and loan history
Open Analytics

Current Use

Tiffanys Saloon Bar & Pub J. Miller Steak ... Restaurant

Suggested Use

Top Pick

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

2
Residential units
Turnkey business
Opportunity

Location Intelligence

Trade Area within ½ mile

347
Businesses Nearby
Monthly Visits Nearby

Foot Traffic Nearby

Shops & Services 100%
Shell Shops & Services
visits/mo 0.2 miles
Sinclair Shops & Services
visits/mo 0.1 miles
U.S. Bank Shops & Services
visits/mo 0.1 miles
New Seasons Auction and Estates Shops & Services
visits/mo 0.1 miles

Demographics for 47001, IN

10,208
Population
4,529
Households
2.3
Avg Household Size
43
Median Age
18%
College-Educated
92%
High-School Grad
76.2 sq mi
ZIP Area
134
Density / Sq Mi
Median Household Income
Median Earnings
Median Rent
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 Midwest region

2020
2021
2022
2023
2024
2025

Frequently Asked Questions

What type of property is this?
Mixed-use property - The brick dining and bar property includes two upper-floor apartments and a deck overlooking the Ohio River.
Where is this mixed-use property located?
The property is located at 211 2nd Street Aurora, IN.
What is the asking price?
The asking price for this property is $780,000.
What are key features of this property?
This property features: Brick restaurant and bar building with two third‑floor apartments; One apartment has 1 bedroom and 1 bathroom; the other has 2 bedrooms and 1 bathroom; Front deck overlooks the Ohio River
Research This Page with AI

Rey answers here. ChatGPT, Grok and Claude get the same data packet.

Includes: Price & PSF · Cap rate · Location · Zoning

Ask Rey → ChatGPT Grok Claude
Preferred Make Realmo a preferred source.

Our comps and market reports get this label in your Google results.

Add as a preferred source on Google One click on Google
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?
Why hide this one?