Skip to content

Request a tour

Tell us when, and we'll take it from there.

Optional - usually gets you a faster reply.

· Terms of Use

← Back to search
1 / 41
For Sale
81 days on market
$264,900

790 Lakeshore Drive, Hamilton Twp, OH, 45039

2
Beds
2.5
Baths
1,288
Sq ft
Type
Condominium
Year built
Built in 1988
Lot
0.02 acres
Price per sq ft
$206/sq ft
HOA
$350/mo
Garage
1-car garage

Buyer BriefThe facts on this home and a current CMA, talked through with you by one of our agents. The brief is at no cost to you.

Get the Buyer Brief

About this home

Enjoy Living in this Wonderful 13 Acre Natural lake community featuring Fishing and Boating. Meticulous Townhome nestled in the Woods! Private and Serene living Near the Lake and Pools! Large Great Room/Gas Fireplace! Formal Dining Room! Nice Primary Suite with Adjoining Bath & Walk-In Closet! Second Bedroom with Ensuite Bath & Walk-In Closet! Full Basement w/Half Bath Rough-In! Lots and Closets and Storage! Mint Condition! Freshly Painted and New Carpet Throughout! Well Maintained! Attached One Car Garage! Relax on your Deck! Tranquil Wooded View! Great Location! Wonderful resort-style amenities:2 pools, clubhouse, tennis & pickleball courts, yoga on the lawn, and live music, all within this vibrant waterfront community. Carefree living is easy with HOA-included landscaping, trash & exterior maintenance. Located just minutes from Mason, Kings Island, and the Little Miami Bike Trail!

Facts & features

Bedrooms & bathrooms
Bedrooms
2
Bathrooms
2 full · 1 half
Primary bedroom
Bath Adjoins, Walk-in Closet, Wall-to-Wall Carpet
Primary bathroom
Shower, Double Vanity
Rooms
Primary bedroom
15 x 15 · Level 2
Bedroom 2
13 x 12 · Level 2
Kitchen
12 x 10
Dining room
12 x 10 · Level 1
Family room
18 x 12 · Level 1
Laundry room
8 x 7 · Level Lower
Entry
10 x 4 · Level 1
Interior
Kitchen
Wood Cabinets, Wood Floor
Appliances
Dishwasher, Microwave, Oven/Range
Interior features
Multi Panel Doors
Basement
Full, Bath Full Rough-In, Unfinished
Levels
Two
Fireplaces
1
Fireplace features
Gas
Heating, cooling & utilities
Heating
Forced Air, Gas
Cooling
Central Air
Water heater
Electric
Gas
Natural
Water
Public
Sewer
Public Sewer
Parking
Garage
1-car garage
Garage details
Built in, Front, Garage Attached
Exterior & lot
Style
Traditional
Construction
Stone, Vinyl Siding
Roof
Shingle
Foundation
Poured
Windows
Vinyl
Lot size
0.02 acres
Lot dimensions
Condo
HOA & taxes
HOA
$350/mo
HOA fee includes
Association Dues, Maintenance Exterior, Snow Removal
Annual taxes (per listing)
$2,974
Property
Type
Condominium
Year built
Built in 1988
Price per sq ft
$206/sq ft
Days on market
81
County
Warren
High school district
Little Miami Local S (verify with the district)
MLS #
1892506

Sale history

  1. Sep 1, 2026Listed
    Source: CincyMLS
    $264,900
  2. Apr 6, 1989Transfer
    Warranty deed · Source: Warren County Auditor
    —
  3. Sep 7, 1988Transfer
    Warranty deed · Source: Warren County Auditor
    —
  4. Sep 7, 1988Transfer
    Warranty deed · Source: Warren County Auditor
    —

Sold history: Warren County Auditor public records, updated Nov 14, 2026.

Listing dates and prices from CincyMLS.

Public-record transfers include non-sale deeds; a Transfer shows no price. Sold or Transfer follows each county's own sale-validity flag where it publishes one. Sale and deed dates are as recorded by each source; a price change is dated when our listing feed first showed it.

Similar homes that sold nearby

Recent sales of homes like this one in ZIP 45039. They show what other homes sold for, not what this one will sell for.

  • 8480 Island Pines Place #8

    $212,500

    Sold Oct 2026

    8480 Island Pines Place #8

    Deerfield Twp., OH 45039

    2 bd · 2 ba · 1,025 sq ft · Built 1992

    Listing courtesy of Plum Tree Realty 513-443-5060 · Javaria Usmani 513-465-5412

    Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.

    See this home's public record
  • 6762 Sandharbor Court

    $275,000

    Sold Mar 2026

    6762 Sandharbor Court

    Hamilton Twp, OH 45039

    2 bd · 2.5 ba · 1,352 sq ft · Built 1989

    Listing courtesy of Comey & Shepherd 513-489-2100 · Jennifer E Waddell 513-257-4277

    Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.

    See this home's public record

How these were chosen: sales of the same home type (Condominium) in ZIP 45039 that closed in the last 12 months, within 25% of this home's square footage and 20 years of its age, with at most 1 bedroom and 1 full bath of difference. New construction is left out, at most 2 are shown, and not every sale in the ZIP is shown. Source: CincyMLS.

One of our agents would be happy to provide you with a current CMA.

Location

Hamilton Twp, OH 45039

Drive time

See the drive from this home to a place you go often.

Or try:

Estimated drive without traffic. Check the drive at the time you'd travel. Kept on this device; we don't save the address. Routes: © OpenStreetMap contributors

Check it yourself

This home is in Warren County.

Opens FEMA's flood map and USDA's eligibility map. FEMA's map is a starting point — your lender's flood check is final. USDA's map covers the location only; income limits and the lender's review also apply.

Map shows the approximate property location.

Listed by Lawrence E Beebe · 513-290-6663. Listing courtesy of Comey & Shepherd · 513-489-2100. Data via Cincinnati Multiple Listing Service.

Broker Reciprocity — MLS of Greater Cincinnati

The data relating to real estate appearing on this site comes in part from the Broker Reciprocity program of the Multiple Listing Service of Greater Cincinnati. Properties marked with the Broker Reciprocity icon are provided courtesy of the MLS of Greater Cincinnati. Information is deemed reliable but not guaranteed — independently verify all details. 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. Equal Housing Opportunity. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.

CincyMLS data last updated November 21, 2026 at 4:15 AM ET.

$264,900
For Sale

Current CMA

Ask an agent for a current CMA.

A CMA, or comparative market analysis, is an agent's look at recent sales of similar homes nearby. We'll put one together and walk you through it.

If this is your home and it's listed with another brokerage, your listing agent is the right person to talk with about pricing.

Optional - usually gets you a faster reply.

Buyer Brief

Get a Buyer Brief on a home you're considering.

One of our agents will call to hear what you'd like to know. Then we put together the facts on the home and a current CMA: recent sales of similar homes nearby. The brief is at no cost to you.

If this is your home and it's listed with another brokerage, your listing agent is the right person to talk with about pricing.

So we can call you back — in 10 minutes or less, 8am–8pm ET, 7 days.
Add a question about the home (optional)