OFF MARKET

Off Market Dec 2024 for $700K

$832,610

Est. refi paymentEst. refi $4,568/mo

•

4,736

sq ft

25 Locust Hill Rd, Cincinnati, OH 45245

About this home

Public Remarks: Fully updated and exquisitely designed, this contemporary ranch boasts over 4,000 sq ft of refined living space with commanding river views. Nestled among 5.8 wooded acres within an exclusive, nature preserve-like neighborhood, this home offers 4 bedrooms, 3.5 baths, and modern finishes throughout. Perfect for entertaining, natural light floods the open-concept first floor, with gleaming hardwoods and dramatic stone fireplace. The primary bedroom captures stunning river views, while the adjoining primary bath is a spa-like indulgence. The new deck and in-ground pool with new liner create an idyllic outdoor oasis. Despite its tranquility and seclusion, this retreat is just 25 minutes from downtown Cincinnati, with effortless access to the amenities of Anderson and Eastgate. An exceptional offering for discerning buyers seeking luxury, privacy, and natural beauty. Trustee is agent.

Single-familyProperty Type

1987Year Built

5.81 acresLot Size

$176Est. Price/Sq.Ft.

3 car garageParking

Listed by Ben Freimuth • Comey & Shepherd

•513-635-9066 (agent)

•ben@thefreimuthgroup.com (agent)

•513-231-2800 (broker)

•chrishicks@comey.com (broker)

Bought with Ben Freimuth • Comey & Shepherd

•513-231-2800 (broker)

•chrishicks@comey.com (broker)

Redfin checked: a few seconds ago

•Source:Cincy MLS #1825231

Redfin Estimate

$832,610

$133K since sold in December 2024$9,000 since August

Recently sold homes
Estimate history
Homes for sale

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

SOLD APR 17, 2026
$510,000
A
4 beds3.5 baths3,660 sq ft
2908 Pond Run Rd, New Richmond, OH 45157
SOLD DEC 12, 2025
$980,000
B
4 beds3.5 baths4,544 sq ft
66 Locust Hill Rd, Cincinnati, OH 45245
SOLD JUN 15, 2026
$490,000
C
4 beds3 baths— sq ft
3487 Holly Ridge Dr, Cincinnati, OH 45245
SOLD JUL 18, 2026
$750,000
D
4 beds3.5 baths3,062 sq ft
942 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 MAY 28, 2026
$1,175,000
F
4 beds4 baths5,914 sq ft
8527 St Ives Pl, Cincinnati, OH 45255

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

Earn from this home

Sell

$240,733

Est. take-home

List your home with Redfin and save $8,326

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$1,466/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

NEW 1 HR AGO
$170,000
2 beds2 baths1,064 sq ft
997 Cedar Ridge Dr Unit 997-3, Cincinnati, OH 45245
$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
OPEN SAT, 11AM TO 12:30PM
$170,000
2 beds2 baths1,064 sq ft
977 Cedar Ridge Dr #10, Cincinnati, OH 45245
OPEN SAT, 2PM TO 3PM
$439,000
4 beds3 baths2,172 sq ft
4310 Minute Man Dr, Cincinnati, OH 45245
OPEN SAT, 12PM TO 3PM
$474,900
3 beds3 baths2,784 sq ft
3781 Fairmount Cir, Cincinnati, OH 45245
$475,000
4 beds2.5 baths3,120 sq ft
4122 Beamer Ct, Cincinnati, OH 45245
See all

Provided by Redfin

Sale history for 25 Locust Hill Rd

Date

Event

Price

Cincy MLS #1825231

Dec 6, 2024

Sold

$700,000

$148/sq ft

Nov 25, 2024

Contingent

—

Nov 22, 2024

Listed

$729,000

$154/sq ft

Public Records

Mar 26, 2018

Sold

$428,110

$90/sq ft

Cincy MLS #1552306

Mar 22, 2018

Sold

$430,000

$91/sq ft

Mar 1, 2018

Contingent

—

Feb 28, 2018

Relisted

—

Jan 29, 2018

Listing Removed

—

Jan 4, 2018

Relisted

—

Nov 28, 2017

Listing Removed

—

Nov 17, 2017

Relisted

—

Sep 17, 2017

Listing Removed

—

Sep 5, 2017

Listed

$439,900

$93/sq ft

Cincy MLS #1546500

Aug 22, 2017

Listing Removed

—

Jul 19, 2017

Listed

$469,900

$99/sq ft

Cincy MLS #1503186

Sep 9, 2016

Sold

$365,000

$77/sq ft

Aug 25, 2016

Contingent

—

Aug 9, 2016

Price Changed

$410,000

$87/sq ft

Jul 14, 2016

Listed

$430,000

$91/sq ft

Cincy MLS #629614

Jun 15, 1998

Sold

$355,000

$75/sq ft

May 4, 1998

Listed

$399,900

$84/sq ft

Year

Property tax

Land + Additions

Assessment*

2025

$10,464 (+6.7%)

$93,000 + $147,700

$240,700

2024

$9,809

$93,000 + $147,700

$240,700

2023

$9,807 (+28.2%)

$93,000 + $147,700

$240,700

2022

$7,649 (+1.7%)

$57,650 + $92,510

$150,160

2021

$7,523 (+0.3%)

$57,650 + $92,510

$150,160

2020

$7,501 (+19.2%)

$57,650 + $92,510

$150,160

2019

$6,294 (+0.8%)

$57,510 + $83,930

$141,440

2018

$6,246

$57,540 + $80,120

$137,660

2017

$6,252 (+4.2%)

$57,540 + $80,120

$137,660

2016

$5,998 (+8.7%)

$55,340 + $77,040

$132,380

2014

$5,518

$55,340 + $77,040

$132,380

Tax history for 25 Locust Hill Rd

Year

Property tax

Land + Additions

Assessment*

2025

$10,464 (+6.7%)

$93,000 + $147,700

$240,700

2024

$9,809

$93,000 + $147,700

$240,700

2023

$9,807 (+28.2%)

$93,000 + $147,700

$240,700

2022

$7,649 (+1.7%)

$57,650 + $92,510

$150,160

2021

$7,523 (+0.3%)

$57,650 + $92,510

$150,160

2020

$7,501 (+19.2%)

$57,650 + $92,510

$150,160

2019

$6,294 (+0.8%)

$57,510 + $83,930

$141,440

2018

$6,246

$57,540 + $80,120

$137,660

2017

$6,252 (+4.2%)

$57,540 + $80,120

$137,660

2016

$5,998 (+8.7%)

$55,340 + $77,040

$132,380

2014

$5,518

$55,340 + $77,040

$132,380

*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

4.5

Stories

Lot width

—

Lot depth

—

Lot size

5.81 Acres

Year renovated

—

Sq. Ft.

4,736

Year built

1987

Style

Single Family Residential

County

Clermont County

APN

272811D109.

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: 3
Garage/Carport: Built in, Oversized, Front
Parking Features: Driveway

Interior

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

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

Bedroom Information
# of Bedrooms Total: 4
Primary Bedroom: 18x14 Level: 1
Primary Bedroom Area: 252
Primary Bedroom Dimensions: 18 x 14
Primary Bedroom Length: 18
Primary Bedroom Width: 14
Bedroom 2: 14x12 Level: 1
Bedroom 2 Area: 168
Bedroom 2 Dimensions: 14 x 12
Bedroom 2 Length: 14
Bedroom 2 Width: 12
Bedroom 3: 13x13 Level: 1
Bedroom 3 Area: 169
Bedroom 3 Dimensions: 13 x 13
Bedroom 3 Length: 13
Bedroom 3 Width: 13
Bedroom 4: 12x9 Level: Lower
Bedroom 4 Area: 108
Bedroom 4 Dimensions: 12 x 9
Bedroom 4 Length: 12
Bedroom 4 Width: 9

Den/Recreation Room Information
Recreation Room: 9x9 Level: Lower
Recreation Room Area: 81
Recreation Room Dimensions: 9 x 9
Recreation Room Length: 9
Recreation Room Width: 9

Kitchen/Dining Room Information
Kitchen Features: Quartz Counters, Counter Bar, Gourmet, Wood Cabinets, Wood Floor
Kitchen Area: 120
Kitchen Dimensions: 12 x 10
Kitchen Length: 12
Kitchen Width: 10
Breakfast Room: 12x10 Level: 1
Breakfast Room Area: 120
Breakfast Room Dimension: 12 x 10
Breakfast Room Length: 12
Breakfast Room Width: 10
Dining Room: 14x13 Level: 1
Dining Room Features: Open, Walkout, Wood Floor
Dining Room Area: 182
Dining Room Dimensions: 14 x 13
Dining Room Length: 14
Dining Room Width: 13

Living Room/Family Room Information
Family Room Features: Tile Floor, Walkout, Fireplace, Wet Bar
Family Room Area: 910
Family Room Dimensions: 35 x 26
Family Room Length: 35
Family Room Width: 26
Great Room: 25x16 Level: 1
Great Room Features: Walkout, Fireplace, Wood Floor

Other Room Information
Entry (Foyer): Open Foyer, Transom/Sidelit, Wood Floor
Entry: 16x4 Level: 1
Entry Area: 64
Laundry Room: 9x7 Level: 1
Laundry Room Area: 63
Laundry Room Dimensions: 9 x 7
Laundry Room Length: 9
Laundry Room Width: 7
Basement: Full
Basement Features: Finished, Fireplace, Walkout
Basement Sq. Ft. (Realist): 2,368

Interior Features
# of Rooms (Total): 10
Interior Features: 9Ft + Ceiling, Natural Woodwork, Vaulted Ceiling
Appliances: Dishwasher, Oven/Range, Refrigerator

Exterior

Exterior Features
Exterior Features: Covered Deck/Patio, Deck, Enclosed Porch, Patio, Wooded Lot
Roof: Shingle
Construction Materials: Cedar
Window Features: Casement, Wood, Insulated

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

Lot Information
Lot Area (Realist): 252,909
Lot Size Units: Acres
Lot Size Acres: 5.806
Lot Size Sq. Ft.: 252,909

Property Information
# of Fireplaces (Total): 2
Fireplace Features: Electric, Gas
Architectural Style: Ranch, Contemporary/Modern
Pool: Heated, In-Ground
Single Family Desc: Single Family
Foundation Details: Poured
Levels: One
Census Tract Realist: 415.06
Miscellaneous: Ceiling Fan, Recessed Lights, Smoke Alarm

Financial

Tax Information
Semi-Annual Taxes: $4,903
Tax Abatement: No
Parcel Number: 27-28-11D-109

Lease & Rent Information
Lease Considered: No

Utilities

Utility Information
Water Source: Public
Cooling: Central Air
Gas: Propane
Heating: Electric, Heat Pump
Sewer: Septic Tank
Water Heating: Electric

Location

Homeowners Association Information
HOA: Yes
Association Name: Locust Hill HOA
Association Fee: $1,200
Association Fee Frequency: Annually
Association Fee Includes: Snow Removal, Association Dues, LandscapingCommunity

School Information
High School District: New Richmond Ex Vill

Location Details
Access: County Road, Private Drive
Cross Street: Locust Corner Road
Suburb: Pierce Twp.
Directions: Nine Mile to Locust Corner Road to Locust Hill Road

Public facts

Beds: 4
Baths: 4.5
Sq. Ft.: 4,736
Stories: 1.0
Lot Size: 5.81 acres
Style: Single Family Residential
Year Built: 1987
Year Renovated: —
County: Clermont County
APN: 272811D109.

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.5mi

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

$791,000 – $958,000

Reach more buyers when you sell with Redfin. Save up to $8,326 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

$739,000

3 beds3 baths3,403 sq ft

488 Green Rd, Cincinnati, OH 45255

$625,000

4 beds4.5 baths3,576 sq ft

3282 Alpine Ter, New Richmond, OH 45157

OPEN SAT, 1PM TO 2:30PMVIDEO TOUR

$549,900

4 beds3 baths2,712 sq ft

3453 Mackenzie Xing, Cincinnati, OH 45245

NEW CONSTRUCTION

$759,900

4 beds3.5 baths— sq ft

1354 Young Rd, Amelia, OH 45102

VIDEO TOUR

$1,500,000

4 beds3.5 baths5,639 sq ft

41 Locust Hill Rd, Cincinnati, OH 45245

New listings for sale in 45245

NEW 1 HR AGO

$170,000

2 beds2 baths1,064 sq ft

997 Cedar Ridge Dr Unit 997-3, Cincinnati, OH 45245

$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

OPEN SAT, 11AM TO 12:30PM

$170,000

2 beds2 baths1,064 sq ft

977 Cedar Ridge Dr #10, Cincinnati, OH 45245

OPEN SAT, 2PM TO 3PMVIDEO TOUR

$439,000

4 beds3 baths2,172 sq ft

4310 Minute Man Dr, Cincinnati, OH 45245

OPEN SAT, 12PM TO 3PM

$474,900

3 beds3 baths2,784 sq ft

3781 Fairmount Cir, Cincinnati, OH 45245

$475,000

4 beds2.5 baths3,120 sq ft

4122 Beamer Ct, Cincinnati, OH 45245

Home values near 25 Locust Hill Rd

Data from public records.

Address	Redfin Estimate
23 Locust Hill Road, Cincinnati, OH 5 Beds \| 5.5 Baths \| 3285 Sq. Ft.	$1,301,039
33 Locust Hill Road, Cincinnati, OH 3 Beds \| 3.5 Baths \| 3050 Sq. Ft.	$774,820

Address	Redfin Estimate
21 Locust Hill Road, Cincinnati, OH 3 Beds \| 2 Baths \| 2044 Sq. Ft.	$668,942
29 Locust Hill Road, Cincinnati, OH 4 Beds \| 5 Baths \| 3666 Sq. Ft.	$1,070,117

Address	Redfin Estimate
27 Locust Hill Road, Cincinnati, OH 4 Beds \| 4.5 Baths \| 3878 Sq. Ft.	$883,886
31 Locust Hill Road, Cincinnati, OH 5 Beds \| 5 Baths \| 5184 Sq. Ft.	$796,209

Property information provided by Cincy MLS when last listed in 2024. 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 25 Locust Hill Rd

Tax history for 25 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 25 Locust Hill Rd

More real estate resources