Last Sold Price
3 beds2,690 sqft$268/sqft
817 Locust Corner Road, Cincinnati, OH 45245

Description

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...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 CLOSED: 06/16/2026 12:00 AM

  1. Listed by Ann V Hickman • Brokerage DRE #2018002622 • eXp Realty
    P: (513) 403-0372 annhickman100@gmail.com

Property Details for 817 Locust Corner Road

Status
MLS #
1870443
Days on Market
41
Taxes
$5,384 / year
HOA Fees
-
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
1952
Lot Size
6.13 AC / 267,153 SF
Architectural Style
Contemporary/Modern, Other
View
Woods
Zoning
Residential
Zoning Details
Residential

Location

Listing Courtesy of eXp Realty

Sold By Huff Realty

Add your commute

Building Information for 817 Locust Corner Road

Stories-Year Built1952Building Size-Lot Size6.13 AC / 267,153 SF

Payment Calculator

$4,108 per month

30 year fixed, 6.55% Interest

Principal and Interest

$3,660

Property Taxes

$449

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 817 Locust Corner Road

Summary
Location and General Information
  • MLS Area Major: Clermont-C01
  • Access: City Street, County Road, Paved Road
  • Access Disability Features: No
  • Area Short Name: C01
  • Cross Street: Merwin Ten Mile
  • Directions: Ohio Pike to Merwin Ten Mile to Locust Corner.
  • FIPS Code: 25
  • Topography: Cleared, Level, Pasture
  • Topography Details: Cleared, Level, Pasture
  • Trees: Cedar, Pine, Wooded-Partial
  • Census Tract: 415.06
Taxes and HOA
  • Has Association: No
  • Other Tax Parcel ID: 272814G017
  • Parcel Number: 272814G017
  • Semi Annual Taxes: $2692
  • Tax Abatement: No
  • Taxes Annual: $5,384.00
School Information
  • High School District: New Richmond Ex Vill
Parking
  • Garage Carport: Built in, Oversized, Front
  • Garage Spaces: 2.0
Property
Lot Information
  • Land Description: 5 to 9.9 Acres
  • Lot Area: 267153.0
  • Lot Size Acres: 6.133
  • Lot Size Dimensions: 6.133
  • Lot Size Square Feet: 267153.0
  • Lot Size Units: Acres
  • Miscellaneous: 220 Volt, Cable, Ceiling Fan, Recessed Lights, Smoke Alarm
Property and Assessments
  • Living Area: 2690.0
  • 3rd Party Approval Required: No
  • Above Grade Sq Ft: 2030
  • Has Board Loaded: No
  • Complete Renovation: No
  • New Construction: No
  • Single Family Description: Single Family
  • Validated: Yes
  • Year Built: 1952
Building Features
  • Foundation Details: Block
  • Levels: One and One Half
  • Entry: 7x5 Level: 1
  • Entry Area: 35
  • Entry Dimensions: 7 x 5
  • Entry Length: 7
  • Entry Width: 5
  • Has Additional Dwelling Unit: No
  • Buildings: Barn, Workshop
  • Construction Materials: Stone, Stucco
Green Features
  • Smart Technology: Appliances, Thermostat
  • Energy Green Features: No
  • Green Certification: No
Utilities
  • Gas: Propane
  • Sewer: Septic Tank
  • Water Source: Public
  • Mechanical Systems: Central Vacuum, Garage Door Opener, Sump Pump w/Backup, Water Softener
Interior and Exterior Features
Exterior Features
  • Exterior Features: Balcony, Deck, Fire Pit, Patio, Wooded Lot
  • Fencing: Wire
  • Pool: In-Ground, Salt Water
  • Roof: Shingle
Interior Features
  • Appliances: Dishwasher, Dryer, Garbage Disposal, Gas Cooktop, Microwave, Oven/Range, Refrigerator, Washer
  • Basement: Full
  • Basement Features: Concrete Floor, Unfinished
  • Bathroom1: Full
  • Bathroom1 Level: 2
  • Bathroom2: Full
  • Bathroom2 Level: 1
  • Bath Level1 Type: Full
  • Bathroom Level: Yes
  • Bathrooms: 2.0
  • Bathrooms Display: 2 (2 0)
  • Bathrooms Full: 2
  • Bedroom Level1: Yes
  • Bedrooms Total: 3
  • Basement Sq Ft: 660
  • Cooling: Ceiling Fans, Central Air
  • Entry Foyer: Closet, Open Foyer, Laminate Floor
  • Heating: Forced Air, Gas, Gas Furn EF Rtd 95%+
  • Interior Features: 9Ft + Ceiling, Beam Ceiling, Crown Molding, French Doors, Multi Panel Doors, Natural Woodwork, Vaulted Ceiling
  • Primary Bathroom: Built-In Shower Seat, Shower, Tile Floor, Double Vanity
  • Rooms Total: 6
  • Water Heating: Electric
  • Window Features: Double Hung, Vinyl, Insulated
Room Information
Bedroom
  • Bedroom Width: 14
  • Primary Bed Feature: Bath Adjoins, Vaulted Ceiling, Walk-in Closet, Walkout, Wall-to-Wall Carpet
  • Primary Bedroom: 17x16 Level: 2
  • Primary Bedroom Area: 272
  • Primary Bedroom Dimensions: 17 x 16
  • Primary Bedroom Length: 17
  • Primary Bedroom Width: 16
  • Bedroom 2: 16x14 Level: 2
  • Bedroom 2 Area: 224
  • Bedroom 2 Dimensions: 16 x 14
  • Bedroom 2 Length: 16
  • Bedroom 3: 22x13 Level: 1
  • Bedroom 3 Area: 286
  • Bedroom 3 Dimensions: 22 x 13
  • Bedroom 3 Length: 22
  • Bedroom 3 Width: 13
  • Bedroom 4 Dimensions: 0 x 0
  • Bedroom 5 Dimensions: 0 x 0
Breakfast Room
  • Breakfast Room Dimensions: 0 x 0
Dining Room
  • Dining Room Dimensions: 0 x 0
Family Room
  • Family Room: 28x22 Level: Lower
  • Family Room Area: 616
  • Family Room Dimensions: 28 x 22
  • Family Room Feat: Walkout, Wall-to-Wall Carpet, Wet Bar, French Doors, Other
  • Family Room Length: 28
  • Family Room Width: 22
Kitchen
  • Kitchen Area: 372
  • Kitchen Dimensions: 31 x 12
  • Kitchen Features: Pantry, Counter Bar, Eat-In, Walkout, Gourmet, Island, Wood Cabinets, Laminate Floor, Marble/Granite/Slate
  • Kitchen Length: 31
  • Kitchen Width: 12
Laundry Room
  • Laundry Room: 7x5 Level: 1
  • Laundry Room Area: 35
  • Laundry Room Dimensions: 7 x 5
  • Laundry Room Length: 7
  • Laundry Room Width: 5
Living Room
  • Living Great Room Area: 342
  • Living Great Room Dimensions: 19 x 18
  • Living Great Room Length: 19
  • Living Great Room Width: 18
  • Living Room: 19x18 Level: 1
  • Living Room Feat: Walkout, Laminate Floor
Additional Room Information
  • Recreation Room Dimensions: 0 x 0
  • Study/Library Den Dimensions: 0 x 0
Rental
Rent Information
  • Occupancy: Negotiable
  • Has Lease Considered: No
  • Sub Lease: No

Property History for 817 Locust Corner Road

DateEvent & SourcePriceAppreciation
Jun 16, 2026

Sold (Public Record)

Public Record #1942918435

$720,000
Jun 16, 2026

Sold

MLS of Greater Cincinnati #1870443

$720,000
May 17, 2026

Contract Out

MLS of Greater Cincinnati #1870443

DateEvent & SourcePrice
06/16/2026

Sold (Public Record)

Public Record #1942918435

$720,000
06/16/2026

Sold

MLS of Greater Cincinnati #1870443

$720,000
05/17/2026

Contract Out

MLS of Greater Cincinnati #1870443

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 817 Locust Corner Road

Taxable ValueLand$47,500Additions$74,480Total$121,980
Tax Record2025$5,384 ($449 / month)
Home Facts
Beds2Baths1.5Total Finished SqFt2,690 SqFtAbove Grade Finished SqFt2,030 SqFtFinished Basement SqFt660 SqFtStories1Lot Size267,153 SqFtStyleSingle Family ResidenceYear Built1952Year Renovated1952CountyCLERMONTAPN27-28-14G-017

Schools near 817 Locust Corner Road

This home is within New Richmond Exempted Village School District.
Rating
School
Type
Grades
Distance
Public - PK to 5
Public - 6 to 8
Public - 9 to 12
Rating
School
Distance
Locust Corner Elementary School
PublicPK to 5

New Richmond Middle School
Public6 to 8

New Richmond High School
Public9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 45245

$539,900 | 970 Crestpoint Court, Cincinnati, OH 45245
1/48
Virtual TourNew Construction

$539,900

4
Bedrooms
1,358
Square Feet
0.26
Acres
$649,900 | 3282 Alpine Terrace, Cincinnati, OH 45245
1/74

$649,900

4
Bedrooms
4,266
Square Feet
1.34
Acres
$339,000 | 4165 Heritage Glen Drive, Cincinnati, OH 45245
1/65
Virtual Tour

$339,000

3
Bedrooms
1,406
Square Feet
0.34
Acres
$335,000 | 4150 Brookfield Drive, Cincinnati, OH 45245
1/39

$335,000

3
Bedrooms
1,657
Square Feet
0.46
Acres
$300,000 | 4572 Vermona Drive, Cincinnati, OH 45245
1/34

$300,000

3
Bedrooms
1,746
Square Feet
0.5
Acres
$270,000 | 655 Wilfert Drive, Cincinnati, OH 45245
1/23

$270,000

3
Bedrooms
1,066
Square Feet
0.46
Acres
$167,000 | 979 Cedar Ridge Drive, Unit 11, Cincinnati, OH 45245
1/30

$167,000

2
Bedrooms
1,064
Square Feet
$499,500 | 3781 Fairmount Circle, Cincinnati, OH 45245
1/53
New Construction

$499,500

3
Bedrooms
2,784
Square Feet
0.18
Acres
$1,500,000 | 41 Locust Hill Road, Cincinnati, OH 45245
1/84
Virtual Tour

$1,500,000

4
Bedrooms
5,639
Square Feet
6.99
Acres

Nearby home values

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of eXp Realty

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 Compass and its related brokerages, 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. Compass and its related brokerages, 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