Skip to main content
Available Now
Want me to call you?
Drop your number — I'll call in minutes.

Cincinnati Full MLS

Search Every Active Listing

Direct MLS access — updated in real time, hours before Zillow. Filter by area, price, beds, and more.

Save
Ask
Tour
Hide
Share
$799,000
1 Day On Site

817 Locust Corner Road
Pierce Twp, OH 45245

For Sale|Single Family Residence|Active
3
Beds
2
Total Baths
2
Full Baths
2,690
SqFt
$297
/SqFt
1952
Built
County:
Clermont
Listing courtesy of Ann Hickman of eXp Realty
Call Now: 513-657-8256
Is this the listing for you? We can help make it yours.
513-657-8256
817 Locust Corner Road817 Locust Corner Road817 Locust Corner Road817 Locust Corner Road
Save
Ask
Tour
Hide
Share

Mortgage Calculator

Monthly Payment (Est.)

$3,645
Calculator powered by Showcase IDX, a Constellation1 Company. Copyright ©2026 Information is deemed reliable but not guaranteed.

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!

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$799,000
Days On Site 
1 Day
Bedrooms 
3
Inside Area (SqFt) 
2,690 sqft
Total Baths 
2
Full Baths 
2
Partial Baths 
N/A
Lot Size 
N/A
Year Built 
1952
MLS® Number 
1870443
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
yesterdayListing updated with changes from the MLS®
yesterdayListing first seen on site
General Features
Cross Street 
Merwin Ten Mile
Foundation 
Block
Garage 
Yes
Garage Spaces 
2
Levels 
One and One Half
Parking 
OversizedGarage Door Opener
Property Sub Type 
Single Family Residence
Security 
Smoke Detector(s)
Sewer 
Septic Tank
Style 
Contemporary/ModernOther
Utilities 
PropaneCable Available
Water Source 
Public
Zoning 
Residential
Interior Features
Appliances 
DisposalRangeOvenWater SoftenerElectric Water HeaterDishwasherDryerGas CooktopMicrowaveRefrigeratorWasher
Basement 
UnfinishedSump PumpFull
Cooling 
Ceiling Fan(s)Central Air
Heating 
Natural GasForced Air
Interior 
Vaulted Ceiling(s)Eat-in KitchenKitchen IslandPantryCentral VacuumWalk-In Closet(s)Crown MoldingNatural Woodwork
Window Features 
Insulated Windows
Bathroom 1 
Level - Second
Bathroom 2 
Level - First
Bedroom 2 
Dimensions - 16 x 14Level - SecondArea - 224
Bedroom 3 
Dimensions - 22 x 13Level - FirstArea - 286
Entry Room 
Level - FirstArea - 35
Family Room 
Dimensions - 28 x 22Level - LowerArea - 616
Kitchen 
Dimensions - 31 x 12Area - 372
LaundryRoom 
Dimensions - 7 x 5Level - FirstArea - 35
Living Room 
Dimensions - 19 x 18Area - 342
Master Bedroom 
Dimensions - 17 x 16Level - SecondArea - 272
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
StoneStucco
Exterior 
BalconyFire Pit
Fencing 
Wire
Lot Features 
WoodedClearedLevel
Other Structures 
Barn(s)Workshop
Patio And Porch 
DeckPatio
Pool Features 
In Ground
Private Pool 
Yes
Roof 
Shingle
View 
Trees/Woods
Waterview 
Trees/Woods
Windows/Doors 
Insulated Windows
Community Features
MLS Area 
Clermont-C01
School District 
New Richmond Ex Vill
Schools
School District
New Richmond Ex Vill
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Ann Hickman of eXp Realty



Listing information is provided by Participants of the Cincy MLS. 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. Copyright 2026, Cincy MLS.
Last checked: 2026-04-07 10:15 PM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share