Off Market Jun 2020 for $876K

$1,317,963

Est. refi paymentEst. refi $5,832/mo

•

3,285

sq ft

23 Locust Hill Rd, Cincinnati, OH 45245

About this home

Public Remarks: Custom transitional with gorgeous Ohio River views & 1st floor master suite! Privately set on a 6+ acre lot with heated saltwater pool & a relaxed, stylish vibe. Enhanced by walls of windows offering an abundance of natural light with sweeping river views plus premium new updates throughout including geothermal heat, 50 yr shingle roof, lighting, home automation & much more! A 5 car garage + 5 bedrooms- including a guest suite with kitchen - 4 full & 3 half baths + gorgeous outdoor living! Wow!

Single-familyProperty Type

1992Year Built

6.23 acresLot Size

$401Est. Price/Sq.Ft.

5 car garageParking

Listed by Debi Martin • Keller Williams Advisors

•513-313-9390 (agent)

•dmartin@dmartinsells.com (agent)

•513-766-9200 (broker)

•BROKER@WEAREADVISORS.COM (broker)

Bought with Maggie Womacks • Coldwell Banker Realty

•513-321-9944 (broker)

•bill.heckman@cbws.com (broker)

Redfin checked: 2 minutes ago

•Source:Cincy MLS #1658016

Redfin Estimate

$1,317,963

$442K since sold in June 2020$16K since August

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 90.8% higher than the average sale price ($691K) of 6 comparable homes.

SOLD SEP 14, 2026
$1,100,000
A
4 beds4.5 baths4,571 sq ft
1029 Eagles Lndg, Cincinnati, OH 45245
SOLD APR 17, 2026
$510,000
B
4 beds3.5 baths3,660 sq ft
2908 Pond Run Rd, New Richmond, OH 45157
SOLD JUL 18, 2026
$750,000
C
4 beds3.5 baths3,062 sq ft
942 Country Club Dr, Cincinnati, OH 45245
SOLD APR 20, 2026
$535,000
D
4 beds2.5 baths2,992 sq ft
854 Country Club Dr, Cincinnati, OH 45245
SOLD DEC 11, 2025
$760,000
E
4 beds3.5 baths3,626 sq ft
3636 Oakland Farm Dr, Cincinnati, OH 45245
SOLD JUN 15, 2026
$490,000
F
4 beds3 baths— sq ft
3487 Holly Ridge Dr, Cincinnati, OH 45245

Claim this home to receive a free report every month with insights on the changing estimate.

Earn from this home

Sell

$627,227

Est. take-home

List your home with Redfin and save $13,180

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$1,469/mo

Redfin rental estimate

List your home for rent

Market trends in 45245, OH

Last updated August 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-List Price

99.3%

0.1% MoM

Median sale price

$311K

$15K MoM

Avg. days on market

44d

1 days MoM

Recently sold homes

6 MoM

New listings for sale

$429,000
3 beds2.5 baths1,705 sq ft
954 London Ct, Cincinnati, OH 45245
NEW 16 HRS AGO
$465,000
4 beds3.5 baths3,281 sq ft
809 Deer Valley Dr, Cincinnati, OH 45245
OPEN SAT, 12PM TO 1:30PM
$400,000
3 beds3.5 baths1,982 sq ft
4166 Roland Creek Dr, Cincinnati, OH 45245
$299,000
3 beds1 bath1,053 sq ft
848 Hawthorne Dr, Cincinnati, OH 45245
$170,000
2 beds2 baths1,064 sq ft
997 Cedar Ridge Dr #3, Cincinnati, OH 45245
OPEN SAT, 3PM TO 5PM
$699,000
4 beds4.5 baths3,863 sq ft
3920 Nicklaus Ct, Cincinnati, OH 45245
$625,000
4 beds4.5 baths3,576 sq ft
3282 Alpine Ter, New Richmond, OH 45157
$575,000
4 beds3 baths3,015 sq ft
6451 Braewing Ct, Cincinnati, OH 45245
See all

Provided by Redfin

Sale history for 23 Locust Hill Rd

Date

Event

Price

Cincy MLS #1658016

Jun 2, 2020

Sold

$876,000

$267/sq ft

Apr 20, 2020

Contingent

—

Apr 17, 2020

Listed

$879,000

$268/sq ft

Cincy MLS #1159405

Mar 16, 2009

Sold

$599,000

$182/sq ft

Jan 30, 2009

Listed

$599,000

$182/sq ft

Cincy MLS #1016601

Jul 14, 2006

Sold

$860,000

$262/sq ft

Jul 14, 2006

Listed

$860,000

$262/sq ft

Cincy MLS #973073

May 11, 2006

Listing Removed

—

Nov 10, 2005

Listed

$980,000

$298/sq ft

Cincy MLS #834967

Jun 5, 2003

Listing Removed

—

May 4, 2003

Listed

$1,200,000

$365/sq ft

Cincy MLS #813101

May 5, 2003

Listing Removed

—

Nov 4, 2002

Listed

$1,200,000

$365/sq ft

Public Records

Jun 7, 1989

Sold

$90,000

$27/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$16,263 (+6.7%)

$97,830 + $276,710

$374,540

2024

$15,244 (+14.2%)

$97,830 + $276,710

$374,540

2023

$13,351 (+27.4%)

$97,830 + $230,090

$327,920

2022

$10,476 (+1.7%)

$60,620 + $145,180

$205,800

2021

$10,303 (+0.3%)

$60,620 + $145,180

$205,800

2020

$10,274 (+36.9%)

$60,620 + $145,180

$205,800

2019

$7,503

$60,480 + $108,190

$168,670

2018

$7,505

$60,480 + $108,190

$168,670

2017

$7,513 (−4.4%)

$60,480 + $108,190

$168,670

2016

$7,861 (+8.7%)

$58,170 + $104,020

$162,190

2014

$7,231

$58,170 + $104,020

$162,190

Tax history for 23 Locust Hill Rd

Year

Property tax

Land + Additions

Assessment*

2025

$16,263 (+6.7%)

$97,830 + $276,710

$374,540

2024

$15,244 (+14.2%)

$97,830 + $276,710

$374,540

2023

$13,351 (+27.4%)

$97,830 + $230,090

$327,920

2022

$10,476 (+1.7%)

$60,620 + $145,180

$205,800

2021

$10,303 (+0.3%)

$60,620 + $145,180

$205,800

2020

$10,274 (+36.9%)

$60,620 + $145,180

$205,800

2019

$7,503

$60,480 + $108,190

$168,670

2018

$7,505

$60,480 + $108,190

$168,670

2017

$7,513 (−4.4%)

$60,480 + $108,190

$168,670

2016

$7,861 (+8.7%)

$58,170 + $104,020

$162,190

2014

$7,231

$58,170 + $104,020

$162,190

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Public record
Zoning

Beds

Baths

5.5

Stories

1.5

Lot width

—

Lot depth

—

Lot size

6.23 Acres

Year renovated

—

Sq. Ft.

4,978

Year built

1992

Style

Single Family Residential

County

Clermont County

APN

272811D104.

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Jul 13, 2026.

SFR

Single-Family Residential District

The Single-Family Residential District is intended to serve as the primary single-family residential housing district in Pierce Township. This district provides for suburban density developments when developments have access to sewer while also providing for reasonable, low-density development in the rural areas of the Township.

Permitted uses

Include but are not limited to:

Housing-Single unit
Housing-Senior
Infrastructure
Public service
Recreation
Park & open space

Property details

Parking

Parking Information
# of Garage Spaces: 5
Garage/Carport: Garage Attached, Oversized, Side
Parking Features: Driveway

Interior

Virtual Tour

Accessibility Information
Bedroom Level 1: Yes
Bathroom Level 1: Yes
Bathroom Level 1 Type: Full

Bathroom Information
# of Bathrooms (1/2): 3
# of Bathrooms (Full): 4
Bath 1: Full
Bath 1 Level: 1
Bath 2: Full
Bath 2 Level: 1
Bath 3: Full
Bath 3 Level: 2
Bath 4: Full
Bath 4 Level: Lower
Primary Bathroom: Shower, Tub

Bedroom Information
# of Bedrooms Total: 5
Primary Bedroom Features: Other
Primary Bedroom: 18x13 Level: 1
Primary Bedroom Area: 234
Primary Bedroom Dimensions: 18 x 13
Primary Bedroom Length: 18
Primary Bedroom Width: 13
Bedroom 2: 14x14 Level: 2
Bedroom 2 Area: 196
Bedroom 2 Dimensions: 14 x 14
Bedroom 2 Length: 14
Bedroom 2 Width: 14
Bedroom 3: 14x12 Level: 2
Bedroom 3 Area: 168
Bedroom 3 Dimensions: 14 x 12
Bedroom 3 Length: 14
Bedroom 3 Width: 12
Bedroom 4: 18x13 Level: 1
Bedroom 4 Area: 234
Bedroom 4 Dimensions: 18 x 13
Bedroom 4 Length: 18
Bedroom 4 Width: 13
Bedroom 5: 20x12 Level: Lower
Bedroom 5 Area: 240
Bedroom 5 Dimenstions: 20 x 12
Bedroom 5 Length: 20
Bedroom 5 Width: 12

Den/Recreation Room Information
Recreation Room: 20x18 Level: Lower
Recreation Room Area: 360
Recreation Room Dimensions: 20 x 18
Recreation Room Length: 20
Recreation Room Width: 18
Study (Lib/Den): 14x13 Level: 1
Study Features: Wall-to-Wall Carpet
Study/Library/Den Area: 182
Study/Library/Den Dimensions: 14 x 13
Study/Library/Den Length: 14
Study Library/Den Width: 13

Kitchen/Dining Room Information
Kitchen Features: Gourmet, Island, Marble/Granite/Slate, Pantry, Skylight, Walkout, Wood Cabinets, Wood Floor, Other
Kitchen Area: 260
Kitchen Dimensions: 20 x 13
Kitchen Length: 20
Kitchen Width: 13
Breakfast Room: 21x11 Level: 1
Breakfast Room Area: 231
Breakfast Room Dimension: 21 x 11
Breakfast Room Length: 21
Breakfast Room Width: 11
Dining Room: 16x13 Level: 1
Dining Room Features: Chandelier, WW Carpet
Dining Room Area: 208
Dining Room Dimensions: 16 x 13
Dining Room Length: 16
Dining Room Width: 13
Has Formal Dining Room

Living Room/Family Room Information
Family Room Features: Fireplace, Walkout, Wet Bar, Wall-to-Wall Carpet
Family Room Area: 697
Family Room Dimensions: 41 x 17
Family Room Length: 41
Family Room Width: 17
Great Room: 22x21 Level: 1
Great Room Features: Fireplace, Other

Other Room Information
Entry (Foyer): Marble/Slate, Open Foyer
Entry: 16x8 Level: 1
Entry Area: 128
Flex Rooms: 3 Season Room, Exercise Room, GuestSuite w/ Ktchn
Laundry Room: 13x11 Level: 1
Laundry Room Area: 143
Laundry Room Dimensions: 13 x 11
Laundry Room Length: 13
Laundry Room Width: 11
Basement: Full
Basement Features: Finished, Fireplace, Walkout, WW Carpet
Basement Sq. Ft. (Realist): 1,682

Interior Features
# of Rooms (Total): 13
Interior Features: Cathedral Ceiling, Skylight, Vaulted Ceiling
Appliances: Dishwasher, Double Oven, Dryer, Microwave, Oven/Range, Refrigerator, Warming Drawer, Washer, Wine Cooler

Exterior

Exterior Features
Exterior Features: Deck, Enclosed Porch, Patio, Tiered Deck, Wooded Lot, Yard Lights
Fencing: Wood
Roof: Shingle
Construction Materials: Brick, Cedar
Window Features: Insulated, Wood

Land Information
Land Description: 5 to 9.9 Acres
Zoning Details: Residential

Lot Information
Lot Area (Realist): 271,379
Lot Size Dimensions: Of Record
Lot Size Units: Acres
Lot Size Acres: 6.23
Lot Size Sq. Ft.: 271,379

Property Information
# of Fireplaces (Total): 2
Fireplace Features: Gas, Wood
Architectural Style: Transitional
Energy/GreenFeatures: Yes
MechanicalSystems: Garage Door Opener, Security System
Pool: Heated, In-Ground, Salt Water
Single Family Desc: Single Family
Smart Technology: HVAC, Lighting, Thermostat
Foundation Details: Poured
Levels: Two
Census Tract Realist: 415.01
Miscellaneous: 220 Volt, Ceiling Fan, Home Warranty, Recessed Lights, Smoke Alarm, Tech Wiring

Financial

Tax Information
Semi-Annual Taxes: $3,751.53
Tax Abatement: No
Parcel Number: 272811D104

Lease & Rent Information
Lease Considered: No

Utilities

Utility Information
Water Source: Public
Cooling: Central Air
Gas: Propane
Heating: Geothermal
Sewer: Septic Tank
Water Heating: Other

Location

Homeowners Association Information
HOA: Yes
Association Name: Locust Hill Road Ass
Association Fee: $1,050
Association Fee Frequency: Annually
Association Fee Includes: Snow Removal, LandscapingCommunity, Other

School Information
School Name 1: Call SD 513-553-2616
School Type 1: District Phone
High School District: New Richmond Ex Vill

Location Details
Cross Street: Locust Corner
Suburb: Pierce Twp.
Directions: US-52 to to Nine Mile Road. R on Locust Corner, R on Locust Hill Road. Home on private lane on the left. House numbers are on the markers.

Public facts

Beds: 5
Baths: 5.5
Sq. Ft.: 4,978
Stories: 1.5
Lot Size: 6.23 acres
Style: Single Family Residential
Year Built: 1992
Year Renovated: —
County: Clermont County
APN: 272811D104.

Home facts updated by county records on Jul 13, 2026

Other

Listing Information
Listing URL: Listing URL (External Link)
Auction: No
FIPS Code: 25
Picture Provided By: Photo Supplied

Around this home

Schools

Locust Corner Elementary School

Public PreK-5 • Assigned • 1.3mi

5/10

New Richmond Middle School

Public 6-8 • Assigned • 4.6mi

4/10

New Richmond High School

Public 9-12 • Assigned • 4.6mi

5/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

4/10 Heat Factor

7 days above 102° expected this year, 19 days in 30 years

2/10 Wind Factor

1% chance of strong winds in next 30 years

3/10 Air Factor

2 unhealthy days expected this year, 3 days in 30 years

Provided by First Street

Historical weather

Cincinnati, OH • 45245

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

In this area, properties receive around 9 hours in June and 3.1 hours in December, placing it below the U.S. average for solar exposure.

9 hrs

3.1 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$1.25M – $1.52M

Reach more buyers when you sell with Redfin. Save up to $13,180 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$975,000

3 beds2 baths1,400 sq ft

5646 New Dr

OPEN SAT, 1PM TO 3PM

$424,900

4 beds3 baths2,159 sq ft

1167 Greens Farm Rd, Amelia, OH 45102

$213,000

2 beds1 bath1,090 sq ft

820 Lilly Ln, Cincinnati, OH 45245

$575,000

4 beds3 baths3,015 sq ft

6451 Braewing Ct, Cincinnati, OH 45245

NEW CONSTRUCTION

$759,900

4 beds3.5 baths— sq ft

1354 Young Rd, Amelia, OH 45102

NEW CONSTRUCTION

$539,900

3 beds2.5 baths1,981 sq ft

8016 Hignite Ct, Cincinnati, OH 45255

New listings for sale in 45245

$429,000

3 beds2.5 baths1,705 sq ft

954 London Ct, Cincinnati, OH 45245

NEW 16 HRS AGO

$465,000

4 beds3.5 baths3,281 sq ft

809 Deer Valley Dr, Cincinnati, OH 45245

OPEN SAT, 12PM TO 1:30PM

$400,000

3 beds3.5 baths1,982 sq ft

4166 Roland Creek Dr, Cincinnati, OH 45245

$299,000

3 beds1 bath1,053 sq ft

848 Hawthorne Dr, Cincinnati, OH 45245

$170,000

2 beds2 baths1,064 sq ft

997 Cedar Ridge Dr #3, Cincinnati, OH 45245

OPEN SAT, 3PM TO 5PM

$699,000

4 beds4.5 baths3,863 sq ft

3920 Nicklaus Ct, Cincinnati, OH 45245

$625,000

4 beds4.5 baths3,576 sq ft

3282 Alpine Ter, New Richmond, OH 45157

$575,000

4 beds3 baths3,015 sq ft

6451 Braewing Ct, Cincinnati, OH 45245

Home values near 23 Locust Hill Rd

Data from public records.

Address	Redfin Estimate
25 Locust Hill Rd, Cincinnati, OH 4 Beds \| 3.5 Baths \| 4736 Sq. Ft.	$848,578
33 Locust Hill Rd, Cincinnati, OH 3 Beds \| 3.5 Baths \| 3050 Sq. Ft.	$778,442

Address	Redfin Estimate
21 Locust Hill Rd, Cincinnati, OH 3 Beds \| 2 Baths \| 2044 Sq. Ft.	$654,862
29 Locust Hill Rd, Cincinnati, OH 4 Beds \| 5 Baths \| 3666 Sq. Ft.	$1,103,624

Address	Redfin Estimate
27 Locust Hill Rd, Cincinnati, OH 4 Beds \| 4.5 Baths \| 3878 Sq. Ft.	$859,062
31 Locust Hill Rd, Cincinnati, OH 5 Beds \| 5 Baths \| 5184 Sq. Ft.	$795,685

Property information provided by Cincy MLS when last listed in 2020. This data may not match . Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for sale near me	Columbus, OH homes for sale	Westerville, OH homes for sale
Land for sale near me	Cincinnati, OH homes for sale	Toledo, OH homes for sale
Open Houses near me	Cleveland, OH homes for sale	New Richmond Property Records
Condos for sale near me	Dublin, OH homes for sale	OH New Listings
Agents near me	Dayton, OH homes for sale	New Richmond Housing Market

Cincinnati homes for sale
Anderson Township homes for sale
Covington homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 45245, OH

Sale history for 23 Locust Hill Rd

Tax history for 23 Locust Hill Rd

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 45245

Home values near 23 Locust Hill Rd

More real estate resources