Refine Search
Sort by
2401 Ingleside Avenue, Cincinnati
$515,000
2 Beds ⋅ 2 Baths ⋅ 1892516 MLS
Sweeping city, river and Northern Kentucky views take center stage throughout this beautifully updated River Terrace residence. From treetop and urban vistas to panoramic views across the city, nearly every room offers a distinctive perspective. A private balcony provides an inviting outdoor retreat to take it all in. Generous living and entertaining spaces complement a renovated kitchen with Sub-Zero, Wolf and Cove appliances, abundant cabinetry and thoughtful finishes. Updated baths and in-unit laundry hookups add everyday convenience. Enjoy lock-up-and-leave living with the peace of mind of a 24-hour attended lobby entrance, fitness center, 1-car garage parking and two storage units. The monthly association fee includes heating and cooling (in-unit controlled), hot and cold water, sewer, trash, internet, building insurance and maintenance, and elevator service. Owners pay separately for in-unit electricity and Spectrum TV package (approx $51/month for both).

2401 Ingleside Avenue, Cincinnati

Courtesy of Jody Aschendorf with Kopf Hunter Haas

907 35th Avenue Drive W, Palmetto
$4,995,000
5 Beds ⋅ 6 Baths ⋅ A4697289 MLS
This tropical paradise, crafted with contemporary European precision, is engineered and designed to be your serene and private oasis as well as a storm-safe haven built to the highest standards. Welcome to 907 35th Ave Dr West, a gated compound with a newly constructed home overlooking the River with access to the Gulf, and a fully renovated guest house or care-taker’s residence. This estate is one-of-a-kind and boasts quality, elegance, design, and world-class sunsets each and every night. The main house, completed in 2020, is positioned high above the water with exceptional views and supported by 31 augured pilings bored into bedrock. The home itself is built out of concrete (72 truckloads in total), columns poured at a minimum of every three feet with many walls being solid concrete. The floors on each level are pre-stressed concrete, and all interior framing is engineered wood which is fire retardant, termite resistant and impervious to moisture. Every detail in the construction of this masterpiece was meant to make it strong, sleek, stylish and efficient. In the main house you will find two bedrooms, two offices, three and a half baths rooms, and ample storage space on the ground level. The elevated infinity pool allows for incredible views of the water and seamless access to the main house. The new house has all impact windows, a 21kw generator, 500 gallon buried propane tank, and exquisite finishes throughout the interior which must be seen in person to be fully appreciated. Just a few are all solid core doors, imported Italian tile floors, custom made cabinets clad in walnut veneer, level 5 drywall throughout, full low voltage system, and much more. The original house on the property has been lovingly upgraded to and designed to comfortably house guests or caretakers. Finished with the same high-end feel the flexibility this additional structure brings to the property is amazing. There are 3 bedrooms and two full bathrooms in the guest house. The seawall was replaced with vinyl panels and a 24 inch concrete cap, there is a long dock with access to a boat lift that has water and power, and the structure is in place if you wish to add a canvas cover over your boat. The location on the Manatee River gives way to Tampa Bay and then to the Gulf of America, so this is an excellent boating location with access to all the fun and beauty the waters have to offer. This unique offering is truly an unrivaled opportunity, schedule your private showing today.

907 35th Avenue Drive W, Palmetto

Listing courtesy of MICHAEL SAUNDERS & COMPANY. 941-951-6660

7320 Us Rt 52, Huntington Twp
$330,000
3 Beds ⋅ 2 Baths ⋅ 1888863 MLS
OHIO RIVERFRONT HOME WITH PRIVATE BOAT RAMP & 5-CAR GARAGE! Enjoy peaceful Ohio River views from this beautifully renovated 3-bedroom, 2-bath waterfront home on approximately 1.3 acres. The semi open-concept floor plan features spacious living areas, stainless steel appliances, and scenic river views from nearly every room. Tiered decks provide exceptional outdoor living and entertaining space overlooking the water. A private boat ramp offers direct Ohio River access for boating and fishing. The impressive 30x60 oversized garage provides room for up to 5 vehicles, boats, recreational equipment, storage, or a workshop. Full walkout basement adds additional flexibility. Ideal as a full-time residence, vacation home, weekend river retreat, fishing getaway, investment property, or short-term rental. Two HVAC systems installed in 2023. Rare opportunity for Ohio River waterfront living with acreage, boat access, incredible views, and abundant garage space!

7320 Us Rt 52, Huntington Twp

Courtesy of Jill Lorentz, Brk. with RE/MAX Local Experts

The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of MLS Now and updated as of . Real estate listings held by brokerage firms other than eXp Realty are marked with the Internet Data Exchange logo and detailed information about them includes the name of the listing broker(s).
IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
All information provided is deemed reliable but is not guaranteed and should be independently verified. © 2026 MLS Now. All Rights Reserved.

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than our company are marked with the Broker Reciprocity™ logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. This data is up-to-date as of . Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved. Information deemed reliable but not guaranteed.

board logo

The data relating to real estate for sale on this website comes in part from the Broker Reciprocity program of the Dayton Area Board of Realtors® MLS IDX Database. Real estate listings from the Dayton Area Board of Realtors® MLS IDX Database held by brokerage firms other than eXp Realty are marked with the IDX logo and are provided by the Dayton Area Board of Realtors® MLS IDX Database. Information is provided for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in. Copyright© 2026 Dayton Area Board of Realtors®

How much is your home worth?

Get instant property value now!