About this home
Extraordinary 2,900+ SQ FT Custom Ranch w/ 768 SQ FT Garage w/ a Floored Loft on 3.65 Private Acres in the Award-Winning Lebanon School District. A Gated Entry & Long New Concrete Driveway Lead to This Remarkable Property Offering a Spectacular Setting w/ Manicured Landscaping & the Privacy Today's Buyers Crave. Acreage of This Caliber Is Increasingly Difficult to Find. This Home Showcases Soaring Ceilings in the Sun-Drenched Conservatory, Great Room, & Primary Suite, While Rich Beamed Ceilings Add Warmth & Character to the Living & Dining Rooms. The Stunning White Kitchen Features Custom Glass Cabinetry, Granite Counters, Double Ovens, Gas Cooktop, Coffee Bar, & Stone Accents. A Striking Floor-to-Ceiling Stone Fireplace Commands Attention in the Great RM. The Spacious Primary Suite Offers a 7x7 Custom Closet w/ Built-Ins & an Adjoining Updated Bath. 3 Fireplaces, 2 Patios, Covered Front Porch, Public Water, & New Septic Complete This Rare Opportunity to Own a One-of-a-Kind Property.
Similar homes that sold nearby
Recent sales of homes like this one in ZIP 45036. They show what other homes sold for, not what this one will sell for.
-
$643,000
Sold Oct 2026
580 Stubbs Mill Road
Turtle Creek Twp, OH 45036
3 bd · 3 ba · 2,887 sq ft · Built 1970
Listing courtesy of Coldwell Banker Realty 513-891-8500 · Melissa L Brooks 513-850-0259
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved.
See this home's public record -
$347,900
Sold Mar 2026
3732 Mary Ann Drive
Clearcreek Twp., OH 45036
3 bd · 2 ba · 2,291 sq ft · Built 1974
Listing courtesy of Coldwell Banker Heritage 513-424-2421 · Christy L Stamper 318-547-2563
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 (Single Family Residence) in ZIP 45036 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.
Location
Turtle Creek Twp, OH 45036
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.
5596 Greentree Road, Turtle Creek Twp, OH, 45036
Map shows the approximate property location.
Listed by Jane Ashcraft-West · 859-630-2222. Listing courtesy of RE/MAX Victory + Affiliates · 513-813-4098. Data via Cincinnati Multiple Listing Service.
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.