This home's estimate is 0.4% lower than the average sale price ($590K) of 6 comparable homes.
Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate





























































751 Old Locust Hill Rd, Cincinnati, OH 45244
About this home
Public Remarks: Mary's House by David Niland (aka The Niland House), nestled on 5 wooded acres in a private enclave 2 mi from the Ohio River (5 min from the boat launch). International style by one of modern architecture's fiercest critics & proponents. Niland spent 40 yrs as a U of Cincinnati DAAP architecture professor, influencing generations of architects. One of very few local architects to have his work published internationally, his is own house is a case study in light, simplicity, space & form. His pioneering work in accessibility led him to design the home for easy wheelchair access, never compromising his design ideals. Mary's House is prominently featured in the book Great Houses of the Queen City, & is on the market for the first time EVER! NOTE: home has had important infrastructure updates (geothermal HVAC, Roof 2021), but still requires significant additional TLC & is priced accordingly. Sold as-is. Limitless potential to invest in this remarkable piece of art, architecture & history

Redfin Estimate
Earn from this home
List your home with Redfin and save $5,875
Get cash now or lower your monthly rate
List your home for rent
Market trends in 45245, OH
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 751 Old Locust Hill Rd
$235/sq ft
$237/sq ft
$108/sq ft
Tax history for 751 Old Locust Hill Rd
*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
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.Include but are not limited to:
- Housing-Single unit
- Housing-Senior
- Infrastructure
- Public service
- Recreation
- Park & open space
Property details
Parking
- Parking Information
- Parking Features: Gravel, Driveway
Interior
- Accessibility Information
- Access Disability Features: Yes
- Bedroom Level 1: Yes
- Bathroom Level 1: Yes
- Bathroom Level 1 Type: Full
- Bathroom Information
- # of Bathrooms (Full): 3
- Bath 1: Full
- Bath 1 Level: 1
- Bath 2: Full
- Bath 2 Level: 1
- Bath 3: Full
- Bath 3 Level: 1
- Bedroom Information
- # of Bedrooms Total: 3
- Primary Bedroom Features: Skylight, Other
- Primary Bedroom: 14x12 Level: 1
- Primary Bedroom Area: 168
- Primary Bedroom Dimensions: 14 x 12
- Primary Bedroom Length: 14
- Primary Bedroom Width: 12
- Bedroom 2: 13x11 Level: 1
- Bedroom 2 Area: 143
- Bedroom 2 Dimensions: 13 x 11
- Bedroom 2 Length: 13
- Bedroom 2 Width: 11
- Bedroom 3: 13x11 Level: 1
- Bedroom 3 Area: 143
- Bedroom 3 Dimensions: 13 x 11
- Bedroom 3 Length: 13
- Bedroom 3 Width: 11
- Kitchen/Dining Room Information
- Kitchen Features: Galley, Wood Floor
- Kitchen Area: 147
- Kitchen Dimensions: 21 x 7
- Kitchen Length: 21
- Kitchen Width: 7
- Dining Room: 17x13 Level: 1
- Dining Room Features: Built-ins, Chandelier, Wood Floor
- Dining Room Area: 221
- Dining Room Dimensions: 17 x 13
- Dining Room Length: 17
- Dining Room Width: 13
- Living Room/Family Room Information
- Great Room: 40x18 Level: 1
- Great Room Features: Bookcases, Walkout, Wet Bar, Fireplace, Wood Floor
- Other Room Information
- Entry (Foyer): Closet, Open Foyer, Transom/Sidelit, Wood Floor, Other
- Entry: 40x9 Level: 1
- Entry Area: 360
- Laundry Room: 17x7 Level: Basement
- Laundry Room Area: 119
- Laundry Room Dimensions: 17 x 7
- Laundry Room Length: 17
- Laundry Room Width: 7
- Basement: Partial
- Basement Features: Concrete Floor, Unfinished, Walkout
- Interior Features
- # of Rooms (Total): 8
- Interior Features: 9Ft + Ceiling
- Interior Doors: 31 5/8 Min Width
- Appliances: Dishwasher, Double Oven, Dryer, Electric Cooktop, Garbage Disposal, Washer
Exterior
- Exterior Features
- Outside Features: WheelchrRamp-No Step
- Exterior Features: Tiered Deck
- Roof: Membrane
- Construction Materials: Wood Siding
- Window Features: Picture, Other, Insulated
- Land Information
- Land Description: 5 to 9.9 Acres
- Zoning Details: Residential
- Lot Information
- Lot Area (Realist): 224,813
- Lot Size Units: Acres
- Lot Size Acres: 5.161
- Lot Size Sq. Ft.: 224,813
- Property Information
- # of Fireplaces (Total): 1
- Fireplace Features: Wood
- Architectural Style: Ranch, Contemporary/Modern
- MechanicalSystems: Security System
- Single Family Desc: Single Family
- Foundation Details: Poured
- Levels: One
- Other Features: Deck NoStep frm Door, Deck Ramp
- Census Tract Realist: 415.06
- Miscellaneous: 220 Volt, Recessed Lights, Smoke Alarm
Financial
- Tax Information
- Semi-Annual Taxes: $3,326
- Tax Abatement: No
- Parcel Number: 272814G097
- Lease & Rent Information
- Lease Considered: No
Utilities
- Utility Information
- Water Source: Public
- Cooling: Central Air, Geothermal
- Heating: Electric, Forced Air, Geothermal
- Sewer: Aerobic Septic
- Water Heating: Electric
Location
- Homeowners Association Information
- HOA: No
- School Information
- High School District: New Richmond Ex Vill
- Location Details
- Access: Private Drive
- Suburb: Pierce Twp.
Public facts
- Beds: 3
- Baths: 3.0
- Sq. Ft.: 2,640
- Stories: 1.0
- Lot Size: 5.16 acres
- Style: Single Family Residential
- Year Built: 1979
- Year Renovated: —
- County: Clermont County
- APN: 272814G097.
Other
- Listing Information
- Listing URL: Listing URL (External Link)
- Auction: No
- FIPS Code: 25
Around this home
Schools
- K - 12
- Preschool & daycare
Public PreK-5 • Assigned • 0.8mi
Public 6-8 • Assigned • 4.9mi
Public 9-12 • Assigned • 4.9mi
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
Minimal risk of a flood reaching the building in the next 30 years
Unlikely to be in a wildfire in next 30 years
7 days above 102° expected this year, 19 days in 30 years
1% chance of strong winds in next 30 years
2 unhealthy days expected this year, 3 days in 30 years
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.
Nearby similar homes





New listings for sale in 45245








Home values near 751 Old Locust Hill Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 2702 Sq. Ft. | $710,566 |
3 Beds | 3.5 Baths | 4124 Sq. Ft. | $592,633 |
- Beds | 0.5 Baths | - Sq. Ft. | $1,257,737 |
4 Beds | 3 Baths | 3646 Sq. Ft. | $841,558 |
4 Beds | 2.5 Baths | 2061 Sq. Ft. | $632,761 |
3 Beds | 1.5 Baths | 1578 Sq. Ft. | $324,268 |
2 Beds | 1 Baths | 1334 Sq. Ft. | $209,588 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 2.5 Baths | 3592 Sq. Ft. | $627,036 |
4 Beds | 2.5 Baths | 3667 Sq. Ft. | $747,561 |
4 Beds | 4 Baths | 4556 Sq. Ft. | $994,945 |
4 Beds | 2 Baths | 2160 Sq. Ft. | $791,176 |
4 Beds | 3 Baths | 2352 Sq. Ft. | $725,221 |
3 Beds | 1.5 Baths | 1288 Sq. Ft. | $263,109 |
5 Beds | 3.5 Baths | 2892 Sq. Ft. | $1,555,912 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 4439 Sq. Ft. | $1,147,734 |
3 Beds | 2.5 Baths | 4310 Sq. Ft. | $1,163,026 |
5 Beds | 4.5 Baths | 4776 Sq. Ft. | $1,119,957 |
4 Beds | 3.5 Baths | 4666 Sq. Ft. | $949,020 |
2 Beds | 1 Baths | 860 Sq. Ft. | $207,109 |
3 Beds | 1 Baths | 2620 Sq. Ft. | $292,863 |
More real estate resources
- Cities
- Zip Codes
- Popular Searches
| 45255 homes for sale | |||
| 45245 homes for sale | |||
| 45102 homes for sale | |||
| 45103 homes for sale | |||
| 45157 homes for sale |
Find us
Subsidiaries
Affiliated Business
Copyright: © 2026 Redfin. All rights reserved.
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.












































United States
Canada