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

































































































1231 Anderson Ferry Rd, Cincinnati, OH 45238
About this home
Public Remarks: Stunning over 5,000 SQ FT contemporary estate situated on a 2.33 acre wooded lot! Train set runs through the back yard! 6 bedrooms & 6 baths! Four car attached garage and a 2 car detached garage! Concrete heated inground pool with an equipped bath pool house! Character galore! Four fireplaces w/gas starters! Finished lower level rec room w/fireplace! Huge eat in kitchen w/stainless steel appliances! Crown molding throughout! First floor family room w/wood ceiling, lots of windows and skylights! Boiler & 3 condenser units for all of your heating & cooling needs! One garage bay converted to handicapped accessible full bath w/roll in shower! Pool house remodeled 10 years ago! Primary suite has full bath w/shower & tub & a walk-in closet! Ceiling fans throughout! First floor study w/built in book shelves & fireplace! Beautiful random peg hardwood floors! Formal dining room w/antique chandelier! 2nd floor laundry w/washer & dryer(Converted full bath)! Immediate occupancy!

Redfin Estimate
Earn from this home
List your home with Redfin and save $7,869
Get cash now or lower your monthly rate
List your home for rent
Market trends in 45238, OH
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
See all
Provided by Redfin
Sale history for 1231 Anderson Ferry Rd
$193/sq ft
$199/sq ft
Tax history for 1231 Anderson Ferry Rd
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Property details
Parking
- Parking Information
- # of Garage Spaces: 5
- Garage/Carport: Rear, Garage Attached, Garage Detached, Heated
- Parking Features: Off Street, Driveway
Interior
- Accessibility Information
- Bedroom Level 1: No
- Bathroom Level 1: Yes
- Bathroom Level 1 Type: Full
- Bathroom Information
- # of Bathrooms (1/2): 1
- # of Bathrooms (Full): 5
- Bath 1: Full
- Bath 1 Level: 2
- Bath 2: Full
- Bath 2 Level: 1
- Bath 3: Full
- Bath 3 Level: 2
- Bath 4: Full
- Bath 4 Level: 2
- Primary Bathroom: Shower, Tub
- Bedroom Information
- # of Bedrooms Total: 6
- 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: 15x14 Level: 2
- Bedroom 2 Area: 210
- Bedroom 2 Dimensions: 15 x 14
- Bedroom 2 Length: 15
- Bedroom 2 Width: 14
- Bedroom 3: 16x10 Level: 2
- Bedroom 3 Area: 160
- Bedroom 3 Dimensions: 16 x 10
- Bedroom 3 Length: 16
- Bedroom 3 Width: 10
- Bedroom 4: 13x12 Level: 2
- Bedroom 4 Area: 156
- Bedroom 4 Dimensions: 13 x 12
- Bedroom 4 Length: 13
- Bedroom 4 Width: 12
- Bedroom 5: 14x12 Level: 2
- Bedroom 5 Area: 168
- Bedroom 5 Dimenstions: 14 x 12
- Bedroom 5 Length: 14
- Bedroom 5 Width: 12
- Den/Recreation Room Information
- Recreation Room: 26x16 Level: Lower
- Recreation Room Area: 416
- Recreation Room Dimensions: 26 x 16
- Recreation Room Length: 26
- Recreation Room Width: 16
- Study (Lib/Den): 14x12 Level: 1
- Study Features: Bookcases, Fireplace, Wood Floor
- Study/Library/Den Area: 168
- Study/Library/Den Dimensions: 14 x 12
- Study/Library/Den Length: 14
- Study Library/Den Width: 12
- Kitchen/Dining Room Information
- Kitchen Features: Eat-In, Tile Floor, Walkout, Window Treatment, Wood Cabinets
- Kitchen Area: 216
- Kitchen Dimensions: 18 x 12
- Kitchen Length: 18
- Kitchen Width: 12
- Dining Room: 14x13 Level: 1
- Dining Room Features: French Doors, Chair Rail, Chandelier, Window Treatment, Fireplace, Wood Floor, Formal
- Dining Room Area: 182
- Dining Room Dimensions: 14 x 13
- Dining Room Length: 14
- Dining Room Width: 13
- Living Room/Family Room Information
- Living/Great Room Area: 390
- Living/Great Room Dimensions: 26 x 15
- Living/Great Room Length: 26
- Living Great Room Width: 15
- Living Room: 26x15 Level: 1
- Living Room Features: Fireplace, Window Treatment, Wood Floor
- Family Room Features: Bookcases, Skylight, Walkout, Wall-to-Wall Carpet, French Doors
- Family Room Area: 320
- Family Room Dimensions: 20 x 16
- Family Room Length: 20
- Family Room Width: 16
- Other Room Information
- Entry (Foyer): Marble/Slate, Open Foyer, Tile Floor
- Entry: 10x10 Level: 1
- Entry Area: 100
- Laundry Room: 6x4 Level: 2
- Laundry Room Area: 24
- Laundry Room Dimensions: 6 x 4
- Laundry Room Length: 6
- Laundry Room Width: 4
- Basement: Full
- Basement Features: Part Finished, Concrete Floor, Vinyl Floor, Fireplace, Walkout, Glass Blk Wind
- Basement Sq. Ft. (Realist): 1,553
- Interior Features
- # of Rooms (Total): 12
- Interior Features: 9Ft + Ceiling, Crown Molding, French Doors, Heated Floors, Natural Woodwork, Skylight, Vaulted Ceiling
- Appliances: Dishwasher, Dryer, Garbage Disposal, Oven/Range, Refrigerator, Washer
Exterior
- Exterior Features
- Exterior Features: Covered Deck/Patio, Patio, Porch, Sprinklers, Wooded Lot, Yard Lights
- Fencing: Metal
- Roof: Shingle, Membrane
- Construction Materials: Brick
- Window Features: Bay/Bow, Storm, Wood
- Land Information
- Land Description: 1 to 4.9 Acres
- Topography Details: Level
- Zoning Details: Residential
- Lot Information
- Lot Area (Realist): 101,495
- Lot Size Dimensions: 260 x 3902
- Lot Size Units: Acres
- Lot Size Acres: 2.33
- Lot Size Sq. Ft.: 101,495
- Property Information
- # of Fireplaces (Total): 4
- Fireplace Features: Brick, Gas, Wood
- Architectural Style: Traditional
- Buildings: Shed
- MechanicalSystems: Garage Door Opener, Security System
- Pool: Gunite, Heated, In-Ground
- Single Family Desc: Single Family
- Foundation Details: Poured
- Levels: Two
- Census Tract Realist: 213.03
- 2nd Flor Area (Realist): 1,553
- Miscellaneous: 220 Volt, Attic Storage, Cable, Ceiling Fan, Laundry Chute, Recessed Lights, Smoke Alarm
Financial
- Tax Information
- Semi-Annual Taxes: $5,288
- Tax Abatement: No
- Parcel Number: 540-0060-0012-00
- Lease & Rent Information
- Lease Considered: No
Utilities
- Utility Information
- Water Source: Public
- Cooling: Central Air
- Gas: Natural
- Heating: Forced Air, Gas, Hot Water
- Sewer: Public Sewer
- Water Heating: Gas
Location
- Homeowners Association Information
- HOA: No
- School Information
- High School District: Oak Hills Local SD
- Location Details
- Access: County Road
- Cross Street: Cleves Warsaw
- Suburb: Delhi Twp.
- Directions: Anderson Ferry Road South to home on right not far from Cleves Warsaw
Public facts
- Beds: 4
- Baths: 3.5
- Sq. Ft.: 4,018
- Stories: 2.0
- Lot Size: 2.33 acres
- Style: Single Family Residential
- Year Built: 1938
- Year Renovated: —
- County: Hamilton County
- APN: 5400060001200
Other
- Listing Information
- Listing URL: Listing URL (External Link)
- Auction: No
- FIPS Code: 61
- Picture Provided By: Photo Supplied
Around this home
Schools
Public K-5 • Assigned • 1.5mi
Public 6-8 • Assigned • 2.4mi
Public 9-12 • Assigned • 2.7mi
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 103° expected this year, 19 days in 30 years
2% chance of strong winds in next 30 years
3 unhealthy days expected this year, 5 days in 30 years
Sun exposure
In this area, properties receive around 9.1 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 45238
Home values near 1231 Anderson Ferry Rd
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1578 Sq. Ft. | $243,229 |
3 Beds | 1.5 Baths | 1851 Sq. Ft. | $239,421 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2.5 Baths | 2132 Sq. Ft. | $256,541 |
4 Beds | 1.5 Baths | 1566 Sq. Ft. | $211,061 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1578 Sq. Ft. | $209,747 |
3 Beds | 1 Baths | 1102 Sq. Ft. | $189,540 |
More real estate resources
- Neighborhoods
- Zip Codes
- Cities
- Popular Searches
| Central Delhi homes for sale |
| 45204 homes for sale | |||
| 45238 homes for sale | |||
| 45205 homes for sale | |||
| 45233 homes for sale | |||
| 41048 homes for sale |
| West Chester homes for sale | |||
| Cincinnati homes for sale | |||
| Anderson Township 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