Last Sold Price
5 beds3,285 sqft$267/sqft
23 Locust Hill Road, Cincinnati, OH 45245

Description

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!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!
LISTING CLOSED: 06/02/2020 12:00 AM

  1. Listed by Deborah A Martin • Brokerage DRE #2005017114 • Keller Williams Advisors
    P: (513)-313-9390 dmartin@dmartinsells.com

Property Details for 23 Locust Hill Road

Status
MLS #
1658016
Days on Market
3
Taxes
$7,503 / year
HOA Fees
$1,050 / year
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
1992
Lot Size
6.23 AC / 271,379 SF
Architectural Style
Transitional
Subdivision Name
Locust Hill Road
View
River, Woods
Zoning
Residential
Zoning Details
Residential

Location

Add your commute

Virtual Tour

Building Information for 23 Locust Hill Road

Stories-Year Built1992Building Size-Lot Size6.23 AC / 271,379 SF

Payment Calculator

$5,165 per month

30 year fixed, 6.55% Interest

Principal and Interest

$4,453

Property Taxes

$625

HOA Dues

$88

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 23 Locust Hill Road

Summary
Location and General Information
  • MLS Area Major: Clermont-C01
  • Area Short Name: C01
  • Cross Street: Locust Corner
  • 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.
  • FIPS Code: 25
  • Latitude: 39.016224
  • Longitude: -84.296379
  • Township: Pierce
  • Census Tract: 415.01
Taxes and HOA
  • Association Fee: $1,050.00
  • Association Fee Frequency: Annually
  • Association Fee Includes: Landscaping Community, Snow Removal, Other
  • Association Name: Locust Hill Road Ass
  • Has Association: Yes
  • Parcel Number: 272811D104
  • Semi Annual Taxes: $3751.53
  • Tax Abatement: No
School Information
  • High School District: New Richmond Ex Vill
  • School Name 1: Call SD 513-553-2616
  • School Type 1: District Phone
Parking
  • Garage Carport: Garage Attached, Oversized, Side
  • Garage Spaces: 5.0
  • Parking Features: Driveway
Virtual Tour
Property
Lot Information
  • Land Description: 5 to 9.9 Acres
  • Lot Area: 271379.0
  • Lot Size Acres: 6.23
  • Lot Size Dimensions: Of Record
  • Lot Size Square Feet: 271379.0
  • Lot Size Units: Acres
  • Miscellaneous: 220 Volt, Ceiling Fan, Home Warranty, Recessed Lights, Smoke Alarm, Tech Wiring
Property and Assessments
  • Living Area: 3285.0
  • 3rd Party Approval Required: No
  • Above Grade Sq Ft: 3285
  • Assessment Amount: Of Record
  • Has Board Loaded: No
  • Complete Renovation: No
  • New Construction: No
  • Single Family Description: Single Family
  • Validated: Yes
  • Year Built: 1992
Building Features
  • Foundation Details: Poured
  • Levels: Two
  • Entry: 16x8 Level: 1
  • Entry Area: 128
  • Entry Dimensions: 16 x 8
  • Entry Length: 16
  • Entry Width: 8
  • Has Additional Dwelling Unit: No
  • Construction Materials: Brick, Cedar
Green Features
  • Smart Technology: HVAC, Lighting, Thermostat
  • Energy Green Features: Yes
Utilities
  • Gas: Propane
  • Sewer: Septic Tank
  • Water Source: Public
  • Mechanical Systems: Garage Door Opener, Security System
Interior and Exterior Features
Exterior Features
  • Exterior Features: Deck, Enclosed Porch, Patio, Tiered Deck, Wooded Lot, Yard Lights
  • Fencing: Wood
  • Pool: Heated, In-Ground, Salt Water
  • Roof: Shingle
Interior Features
  • Appliances: Dishwasher, Double Oven, Dryer, Microwave, Oven/Range, Refrigerator, Warming Drawer, Washer, Wine Cooler
  • Basement: Full
  • Basement Features: Finished, Fireplace, Walkout, WW Carpet
  • Bathroom1: Full
  • Bathroom1 Level: 1
  • Bathroom2: Full
  • Bathroom2 Level: 1
  • Bathroom3: Full
  • Bathroom3 Level: 2
  • Bathroom4: Full
  • Bathroom4 Level: Lower
  • Bath Level1 Type: Full
  • Bathroom Level: Yes
  • Bathrooms: 7.0
  • Bathrooms Display: 7 (4 3)
  • Bathrooms Full: 4
  • Bathrooms Half: 3
  • Bedroom Level1: Yes
  • Bedrooms Total: 5
  • Basement Sq Ft: 1682
  • Cooling: Central Air
  • Entry Foyer: Marble/Slate, Open Foyer
  • Fireplace Features: Gas, Wood
  • Fireplaces Total: 2
  • Heating: Geothermal
  • Interior Features: Cathedral Ceiling, Skylight, Vaulted Ceiling
  • Lighting: LED
  • Primary Bathroom: Double Vanity, Shower, Tub
  • Rooms Total: 13
  • Study Features: Wall-to-Wall Carpet
  • Water Heating: Other
  • Window Features: Insulated, Wood
Room Information
Bedroom
  • Bedroom Width: 14
  • Primary Bed Feature: Bath Adjoins, Walk-in Closet, 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 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 Dimensions: 20 x 12
  • Bedroom 5 Length: 20
  • Bedroom 5 Width: 12
Breakfast Room
  • Breakfast Room: 21x11 Level: 1
  • Breakfast Room Area: 231
  • Breakfast Room Dimensions: 21 x 11
  • Breakfast Room Length: 21
  • Breakfast Room Width: 11
Dining Room
  • Dining Room: 16x13 Level: 1
  • Dining Room Area: 208
  • Dining Room Dimensions: 16 x 13
  • Dining Room Feat: Chandelier, WW Carpet
  • Dining Room Length: 16
  • Dining Room Width: 13
  • Formal Dining Room: Yes
Family Room
  • Family Room: 41x17 Level: Lower
  • Family Room Area: 697
  • Family Room Dimensions: 41 x 17
  • Family Room Feat: Fireplace, Walkout, Wet Bar, Wall-to-Wall Carpet
  • Family Room Length: 41
  • Family Room Width: 17
Kitchen
  • Kitchen Area: 260
  • Kitchen Dimensions: 20 x 13
  • Kitchen Features: Gourmet, Island, Marble/Granite/Slate, Pantry, Skylight, Walkout, Wood Cabinets, Wood Floor, Other
  • Kitchen Length: 20
  • Kitchen Width: 13
Laundry Room
  • Laundry Room: 13x11 Level: 1
  • Laundry Room Area: 143
  • Laundry Room Dimensions: 13 x 11
  • Laundry Room Length: 13
  • Laundry Room Width: 11
Living Room
  • Living Great Room Dimensions: 0 x 0
Additional Room Information
  • Flex Rooms: 3 Season Room, Exercise Room, Guest Suite w/ Ktchn
  • Great Room: 22x21 Level: 1
  • Great Room Feat: Fireplace, Wall-to-Wall Carpet, Other
  • Recreation Room: 20x18 Level: Lower
  • Recreation Room Area: 360
  • Recreation Room Dimensions: 20 x 18
  • Recreation Room Length: 20
  • Recreation Room Width: 18
  • Study/Library Den: 14x13 Level: 1
  • Study/Library Den Area: 182
  • Study/Library Den Dimensions: 14 x 13
  • Study/Library Den Length: 14
  • Study/Library Den Width: 13
Rental
Rent Information
  • Occupancy: At Closing
  • Has Lease Considered: No
  • Sub Lease: No

Property History for 23 Locust Hill Road

DateEvent & SourcePriceAppreciation
Jun 2, 2020

Sold

MLS of Greater Cincinnati #1658016

$876,000
May 26, 2020

Sold (Public Record)

Public Record #669551695

$876,000

+3.4% / yr

Apr 17, 2020

Listed (Active)

MLS of Greater Cincinnati #1658016

$879,000
DateEvent & SourcePrice
06/02/2020

Sold

MLS of Greater Cincinnati #1658016

$876,000
05/26/2020

Sold (Public Record)

Public Record #669551695

$876,000

+3.4% / yr

04/17/2020

Listed (Active)

MLS of Greater Cincinnati #1658016

$879,000

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

Public Records for 23 Locust Hill Road

Taxable ValueLand$97,830Additions$276,710Total$374,540
Tax Record2025$16,263 ($1,355 / month)
Home Facts
Beds5Baths3.5Total Finished SqFt4,978 SqFtAbove Grade Finished SqFt3,296 SqFtFinished Basement SqFt1,682 SqFtUnfinished Basement SqFt1,519 SqFtStories2Lot Size271,379 SqFtStyleSingle Family ResidenceYear Built1992CountyCLERMONTAPN27-28-11D-104Fireplace TypeHas Fireplace

Schools near 23 Locust Hill 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
NewNew 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
$259,000 | 1056 Terrydel Lane, Cincinnati, OH 45245
1/52

$259,000

3
Bedrooms
1,008
Square Feet
0.48
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
$750,000 | 3782 Fulton Grove Road, Cincinnati, OH 45245
1/64
New Construction

$750,000

4
Bedrooms
2,784
Square Feet
2.81
Acres

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 23 Locust Hill Road, Cincinnati, OH 45245
$876,000
5
3,285
271,379
$700,000
4
4,736
252,909
$540,000
3
2,044
274,428
4
2,178
236,095
$328,780
3
2,082
35,284
2
1,224
36,155

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 Keller Williams Advisors

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