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 / 35
For Sale
New · 3 days ago
$750,000

3195 Harborside Drive, Green Twp, OH, 45248

Open house: Sun, Nov 22, 1–2:30 PM

4
Beds
4
Baths
Type
Single Family Residence
Year built
Built in 2005
Lot
0.58 acres
HOA
None
Garage
2-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

OPEN HOUSE Sunday 11/22 from 1pm - 2:30pm. Spectacular Dennis Ott-built home approximately 4,200 square feet showcasing exceptional craftsmanship and custom details throughout! A stunning two-story foyer welcomes you into an open floor plan featuring beautiful hardwood floors, elegant crown molding, a gourmet kitchen, and a desirable first-floor primary suite. First-floor study and Jack-and-Jill bath add to the home's thoughtful design. The recently finished lower level is an entertainer's dream, complete with a walk-up bar, spacious entertainment area, and versatile multipurpose room. Enjoy picturesque lake views and outdoor entertaining from the covered porch. Impressive brick and stone exterior, Pella windows, high-efficiency mechanicals, heated driveway, and sprinkler system. Offering 3 full and 2 half baths, this exceptional home is a true pride of ownership!

Facts & features

Bedrooms & bathrooms
Bedrooms
4
Bathrooms
3 full · 2 half
Primary bedroom
Bath Adjoins, Walk-in Closet, Wood Floor
Primary bathroom
Shower, Double Vanity, Tile Floor
Rooms
Primary bedroom
17 x 14 · Level 1
Bedroom 2
14 x 12 · Level 2
Bedroom 3
13 x 12 · Level 2
Bedroom 4
12 x 11 · Level 2
Kitchen
25 x 13
Family room
38 x 32 · Level Lower
Study / den
12 x 12 · Level 1
Laundry room
8 x 7 · Level 1
Entry
20 x 13 · Level 1
Interior
Kitchen
Marble/Granite/Slate, Eat-In, Wood Floor
Basement
Full, Finished - Full
Levels
Two
Fireplaces
1
Fireplace features
Ceramic, Gas
Heating, cooling & utilities
Heating
Forced Air, Gas
Cooling
Central Air
Water heater
Gas
Gas
Natural
Water
Public
Sewer
Public Sewer
Parking
Garage
2-car garage
Garage details
Built in, Oversized, Side
Parking
Driveway
Exterior & lot
Style
Ranch, Traditional
Construction
Brick, Stone
Roof
Shingle
Foundation
Poured
Windows
Aluminum, Casement
Lot size
0.58 acres
Lot dimensions
IRR
HOA & taxes
HOA
None
Annual taxes (per listing)
$1,004
Property
Type
Single Family Residence
Year built
Built in 2005
Days on market
3
County
Hamilton
High school district
Oak Hills Local SD (verify with the district)
MLS #
1900439

Sale history

  1. Nov 18, 2026Listed
    Source: CincyMLS
    $750,000
  2. Jan 12, 2016Sold
    Warranty deed · Source: Hamilton County Auditor
    $370,000

Sold history: Hamilton County Auditor public records, retrieved 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.

Location

Green Twp, OH 45248

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 Hamilton 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 Rakesh Ram · 513-608-1199. Listing courtesy of Coldwell Banker Realty · 513-922-9400. 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.

$750,000
For Sale

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)