Rolling on the River! Opportunity to own this beautiful one of a kind property with ohio River frontage, river access & stunning views all conveniently located in Aurora, In. Features 4 BR, 3 full BA, excellent entertaining space with a large 40 x 45 cement patio overlooking the river and steps from Lesko Park and the dearborn Trail. Currently used as a n established AirBNB with consistent 10/10 star reviews. This property comes fully furnished including TV's, linens, dishes, kitchen appliances, laundry, outdoor recreation items; floating dock, hot tub, kayaks, bicycles and fishing poles. Everything you need for your convenience. Enjoy nearby attractions such as Perfect North Slopes, The Creation Museum, Cincinnati museum Center, Cincinnati Zoo, Newport Aquarium, The Ark Encounter, and area casinos. Don't miss this unique and stunning home.
For sale
$594,999
475 Decatur St, Aurora, IN 47001
4beds
3,736sqft
Est.:
Single Family Residence
Built in 2018
1.12 Acres Lot
$592,900 Zestimate®
$159/sqft
$-- HOA
What's special
Ohio river frontageRiver accessExcellent entertaining spaceOverlooking the riverStunning views
- 1 day
- on Zillow |
- 352 |
- 25 |
Likely to sell faster than
Zillow last checked: 7 hours ago
Listing updated: August 02, 2025 at 02:21am
Listed by:
Lohmiller Real Estate
Source: SEIBR,MLS#: 205602
Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Features: Bath Adjoins, Walk-In Closet(s), WW Carpet
- Level: Second
- Area: 196
- Dimensions: 14 x 14
Bedroom 2
- Level: Second
- Area: 168
- Dimensions: 12 x 14
Bedroom 3
- Level: Second
- Area: 168
- Dimensions: 12 x 14
Bedroom 4
- Level: Third
- Area: 532
- Dimensions: 19 x 28
Bedroom 5
- Area: 0
- Dimensions: 0 x 0
Primary bathroom
- Features: Tile Floor, Tub w/Shower
Bathroom 1
- Description: Full
- Level: Second
Bathroom 2
- Description: Full
- Level: Second
Bathroom 3
- Description: Full
- Level: Third
Dining room
- Level: Second
- Area: 238
- Dimensions: 14 x 17
Family room
- Features: Tile Floor, Vaulted Ceiling(s)
- Level: Third
- Area: 570
- Dimensions: 19 x 30
Kitchen
- Features: Marble/Granite/Slate, Tile Floor, Wood Cabinets
- Area: 0
- Dimensions: 0 x 0
Living room
- Features: Other
- Level: Second
- Area: 308
- Dimensions: 14 x 22
Office
- Area: 0
- Dimensions: 0 x 0
Heating
- Electric, Heat Pump
Cooling
- Mini-Split, Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Oven/Range, Refrigerator, Washer, Wine Cooler, Electric Water Heater
Features
- Smart Thermostat
- Windows: Double Hung, Vinyl
- Basement: Concrete,Walk-Out Access
Interior area
- Total structure area: 3,736
- Total interior livable area: 3,736 sqft
- Finished area below ground: 0
Property
Parking
- Total spaces: 3
- Parking features: Attached, With Electric, With Water, Off Street, Driveway, Gravel
- Attached garage spaces: 3
- Has uncovered spaces: Yes
Features
- Levels: Three Or More
- Stories: 3
- Patio & porch: Covered Deck/Patio, Deck, Enclosed Porch, Patio, Porch, Screened Porch
- Exterior features: Balcony, Dock, Fire Pit
- Has spa: Yes
- Spa features: Private
- Has view: Yes
- View description: City, River
- Has water view: Yes
- Water view: River
- Frontage length: 0.00
Lot
- Size: 1.12 Acres
- Features: Flood Plain, Other
- Topography: large 1.12 acre lot cleared on river
Details
- Parcel number: 151204203094003003
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Cape Cod
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Foundation: Concrete Perimeter
- Roof: Metal
Condition
- New construction: No
- Year built: 2018
Utilities & green energy
- Gas: Natural
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Features: Boating, Fishing, River, Walk/Run Paths, Water Features
Location
- Region: Aurora
Financial & listing details
- Price per square foot: $159/sqft
- Tax assessed value: $2,800
- Annual tax amount: $3,868
- Date on market: 8/1/2025
- Road surface type: Paved
- Loading
- Loading