Building Details

Year built 1900

Listing Agency: Lohmiller Real Estate Show Phone

Listed By: Sandra Baker · License #RB14039879 Show Phone

Added: Sep 28 Changed: Sep 29 Last Checked: Oct 2 at 5:06AM

Report an Issue

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.

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

Unlock full access to Insights Subscribe to Realmo Intelligence

Open Analytics

Current Use

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

Suggested Use

Top Pick Electrical Service Plumbing Service (Bike/Boat/Book/etc) Store Bakery Auto Parts Store Dental Office

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

14k

Monthly Visits Nearby

Explore this area Business Placement

Foot Traffic Nearby

Shops & Services 100%

Shell Shops & Services

8,615 visits/mo 0.2 miles

Sinclair Shops & Services

3,798 visits/mo 0.1 miles

U.S. Bank Shops & Services

1,273 visits/mo 0.1 miles

New Seasons Auction and Estates Shops & Services

666 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

$72,560

Median Household Income

$42,146

Median Earnings

$848

Median Rent

$190,300

Median Home Value

Market

Vacancy Rate% for Retail in Midwest region

8% 2020

7.3% 2021

6.5% 2022

6% 2023

5.7% 2024

6.3% 2025

Questions? Ask Rey

Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

What type of property is this? Where is this mixed-use properties located? What is the asking price? Find similar properties What are key features of this property?

Similar For Sale Nearby

Waterfront Restaurant with Patio

617 Green Boulevard, Aurora, IN 47001

$675,000

0.99 Acres

View details

Mixed-Use Brick Building

219 2nd Street, Aurora, IN 47001

$118,000

0.08 Acres

View details

Concrete Plant and Storage Yard

3919 E Laughery Creek Rd, Aurora, IN 47001

$775,000

21.00 Acres

View details

Duplex with Flexible Occupancy

201 Walker Avenue, Aurora, IN 47001

$189,900

2,040 SF

View details

Retail Showroom with On-Site Parking

621 Green Blvd, Aurora, IN 47001

Contact for pricing

View details

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