$765,000
OPEN HOUSE 5/23 $34K PRICE DROP

817 Locust Corner Rd Cincinnati, OH 45245

Estimated payment $4,533/month

Total Views 4,408
3 Beds
2 Baths
2,690 Sq Ft
$284 Price per Sq Ft

Highlights

  • Eat-In Gourmet Kitchen
  • Cedar Trees
  • Contemporary Architecture
  • View of Trees or Woods
  • Deck
  • Vaulted Ceiling

About This Home

ESTATE - LUXURY MINI FARM. This one-of-a-kind property offers the perfect blend of luxury, charm and country living with no HOA. Nestled on 6.13 acres, this home features beautiful landscaping, privacy from tree lined yard, 20x36 salt water pool, 40x50 barn and foundation in place for outdoor kitchen. This 3 bedroom 2 full bath home provides first floor laundry, and additional laundry in spacious basement. Updated kitchen and baths including new cabinets and granite countertops. New windows on first level, doors, LVP flooring, tile and carpet provide a refreshing appearance. New roof, 6 inch gutters and gutter guards enhance the outdoor appearance. Walk in pantry, walk in coat closet, large closets throughout, All with Elfa shelving systems provide excellent storage. Central vacuum. Both upstairs bedrooms walk out onto a private balcony. Add your finishing touches to make this unique property yours. 20 minute drive to downtown. Survey recently updated. Much much more!

Listing Agent

Ann Hickman

eXp Realty License #0000439159 Listed on: 04/06/2026

eXp Realty

Open House Schedule

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,384

Year Built

  • Built in 1952

Lot Details

  • 6.13 Acre Lot
  • Wire Fence
  • Cedar Trees
  • Pine Trees
  • Partially Wooded Lot

Parking

  • 2 Car Garage
  • Oversized Parking
  • Front Facing Garage
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Block Foundation
  • Shingle Roof
  • Stucco
  • Stone

Interior Spaces

  • 2,690 Sq Ft Home
  • 1.5-Story Property
  • Wet Bar
  • Central Vacuum
  • Woodwork
  • Crown Molding
  • Beamed Ceilings
  • Vaulted Ceiling
  • Ceiling Fan
  • Recessed Lighting
  • Vinyl Clad Windows
  • Insulated Windows
  • Double Hung Windows
  • French Doors
  • Panel Doors
  • Entrance Foyer
  • Views of Woods

Kitchen

  • Eat-In Gourmet Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Oven or Range
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Smart Appliances
  • Kitchen Island
  • Solid Wood Cabinet
  • Disposal

Flooring

  • Laminate
  • Concrete
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • 2 Full Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Built-In Shower Bench

Laundry

  • Dryer
  • Washer

Unfinished Basement

  • Basement Fills Entire Space Under The House
  • Sump Pump with Backup

Home Security

  • Smart Thermostat
  • Fire and Smoke Detector

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Fire Pit

Utilities

  • 95% Forced Air Zoned Heating and Cooling System
  • Heating System Uses Gas
  • 220 Volts
  • Propane
  • Electric Water Heater
  • Water Softener
  • Septic Tank
  • Cable TV Available

Community Details

  • No Home Owners Association

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,384

Year Built

Built in 1952

Lot Details

6.13 Acres

Parking

2

Listing Details

  • Suburb: Pierce Twp.
  • Cross Street: Merwin Ten Mile
  • Topography: Cleared,Level,Pasture
  • Trees: Cedar, Pine, Wooded-Partial
  • Buildings: Barn,Workshop
  • Land Description: 5 to 9.9 Acres
  • Access: City Street, County Road, Paved Road
  • Broker Approved: Yes
  • Miscellaneous: 220 Volt, Cable, Ceiling Fan, Recessed Lights, Smoke Alarm
  • Census Tract Realist: 415.06
  • Cooling: Ceiling Fans, Central Air
  • Heating: Forced Air, Gas, Gas Furn EF Rtd 95%+
  • Lot Area Realist: 267153.00
  • Suburb S I C: Pierce Twp.
  • Zoning: Residential
  • Accessibility Features: No
  • Basement Features: Concrete Floor, Unfinished
  • Level 1 Bathroom Type: Full
  • Level 1 Bathroom: Yes
  • Level 1 Bedroom: Yes
  • Entry Foyer: Closet, Open Foyer, Laminate Floor
  • Family Room Feat: Walkout, Wall-to-Wall Carpet, Wet Bar, French Doors, Other
  • Living Great Rm Dim: 19 x 18
  • Living Room Feat: Walkout, Laminate Floor
  • Mechanical Systems: Central Vacuum, Garage Door Opener, Sump Pump w/Backup, Water Softener
  • Single Family Desc: Single Family
  • Smart Technology: Appliances, Thermostat
  • Study Lib Den Dim: 0 x 0
  • Water Heating: Electric
  • Year Built: 1952
  • Architecture: Contemporary/Modern, Other
  • Full Bathrooms: 2
  • Bedrooms: 3
  • Directions: Ohio Pike to Merwin Ten Mile to Locust Corner.
  • Lot Measurement: Acres
  • Status: Active
  • Property Subtype 1: Single Family Residence
  • Occupancy: Negotiable
  • ADU Y/N: No
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: 9Ft + Ceiling, Beam Ceiling, Crown Molding, French Doors, Multi Panel Doors, Natural Woodwork, Vaulted Ceiling
  • Bedroom 2: 16x14 Level: 2
  • Bedroom 3: 22x13 Level: 1
  • Family Room: 28x22 Level: Lower
  • Living Room: 19x18 Level: 1
  • Property Type: Residential
  • Other Tax Parcel I D: 272814G017
  • Reciprocal Listing: No
  • Semi Annual Taxes: $2692
  • Appliances: Dishwasher, Dryer, Garbage Disposal, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Washer
  • Kitchen Features: Pantry, Counter Bar, Eat-In, Walkout, Gourmet, Island, Wood Cabinets, Laminate Floor, Marble/Granite/Slate
  • Basement: Full
  • Entry: 7x5 Level: 1
  • Bathrooms: 2.00
  • Kitchen Dim: 31 x 12
  • Levels: One and One Half
  • Zero Selling Price: No
  • Bathroom 1: Full
  • Bathroom 2: Full
  • Bathroom 2 Level: 1
  • Laundry Room: 7x5 Level: 1
  • Laundryroom Dim: 7 x 5
  • Recreation Room Dim: 0 x 0
  • Available for Lease: No
  • Bldg Sq Ft (Realist): 2690.00
  • Windows: Double Hung, Vinyl, Insulated
  • PrimaryBedroomDim: 17 x 16
  • Primary Bathrooms: Built-In Shower Seat, Shower, Tile Floor, Double Vanity
  • PrimaryBedFeat: Bath Adjoins, Vaulted Ceiling, Walk-in Closet, Walkout, Wall-to-Wall Carpet
  • P R I M A R Y B E D R O O M: 17x16 Level: 2

Exterior Features

  • View: Woods
  • Fencing: Wire
  • Roof: Shingle
  • Pool: In-Ground,Salt Water
  • Construction: Stone, Stucco
  • Outside Features: Balcony, Deck, Fire Pit, Patio, Wooded Lot
  • Foundation: Block
  • Listing Price: 765000.00
  • Acres: 6.1330
  • New Construction: No

Garage/Parking

  • Garage Spaces: 2.00
  • Garage Carport: Built in, Oversized, Front

Utilities

  • Gas: Propane
  • Sewer: Septic Tank
  • Water Source: Public

Condo/Co-op/Association

  • HOA Yes/No: No
  • Association: Cincinnati Area Multiple Listing Service

Schools

  • District: New Richmond Ex Vill

Green Features

  • Energy Green Features: No

Lot Info

  • Lot Dimensions: 6.133
  • Lot Size Sq Ft: 267153.00
  • Total Assessed Value: 0

Rental Info

  • Sub Lease: No

Tax Info

  • Tax Abatement: No

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,384 $121,980 $47,500 $74,480
2024 $5,052 $121,980 $47,500 $74,480
2023 $4,079 $98,490 $24,010 $74,480
2022 $3,641 $70,360 $16,770 $53,590
2021 $3,582 $70,360 $16,770 $53,590
2020 $3,572 $70,360 $16,770 $53,590
2019 $2,860 $72,980 $18,450 $54,530
2018 $2,861 $72,980 $18,450 $54,530
2017 $2,809 $72,980 $18,450 $54,530
2016 $2,809 $66,640 $17,080 $49,560
2015 $2,584 $66,640 $17,080 $49,560
2014 $2,584 $66,640 $17,080 $49,560
2013 $2,704 $69,200 $17,080 $52,120
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
04/25/2026 04/25/26 Price Changed $765,000 -1.3% $284 / Sq Ft
04/17/2026 04/17/26 Price Changed $775,000 -3.0% $288 / Sq Ft
04/06/2026 04/06/26 For Sale $799,000 -- $297 / Sq Ft
Source: MLS of Greater Cincinnati (CincyMLS)

Purchase History

Date Type Sale Price Title Company
Certificate Of Transfer -- None Available
Source: Public Records

Source: MLS of Greater Cincinnati (CincyMLS)

MLS Number: 1870443

MLS of Greater Cincinnati (CincyMLS)

APN: 27-28-14G-017

Ohio Clermont County Cincinnati 45245

817 Locust Corner Rd, Cincinnati, OH

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLS of Greater Cincinnati (CincyMLS) The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved

Nearby Homes
Ann Hickman
Listing Agent
Ann Hickman
Section Image
eXp Realty
(513) 450-8252
Your Personal Tour Guide

Ask me questions while you tour the home.