Search- Overview
- Sale & tax history
- Property details
- Neighborhood
- Climate









































































8 Andover Rd, Cincinnati, OH 45218
About this home
Public Remarks: Move-In Ready Duplex in Greenhills - Perfect for Investors or Owner-Occupants! Don't miss this fantastic opportunity to own a well-maintained duplex in Greenhills! Ideal for owner-occupants looking to generate rental income, this property features two spacious units with excellent amenities. Unit #8 - Tenant-occupied (month-to-month), offering 2 bedrooms, 1 full bath, 2 half baths, and a partially finished basement. Unit #10 - Owner-occupied, featuring 2 bedrooms, 2 full bathrooms, an updated interior with updated windows, an office/study with a cozy fireplace, a partially finished basement, a covered patio, and an oversized 1-car garage. Enjoy a large, level, fenced-in backyard perfect for entertaining, with direct access to a park. Conveniently located near Winton Woods Park, this duplex offers the best of suburban living with easy access to nature and outdoor activities. Schedule your showing today!

Redfin Estimate
Market trends in 45218, OH
Last updated September 2026
Buyer's Market
Seller's Market
Seller's market
0 days MoM
Provided by Redfin
Sale history for 8 Andover Rd
$146/sq ft
$144/sq ft
$53/sq ft
$66/sq ft
Tax history for 8 Andover 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: 1
- # of Open Parking Spaces: 2
- Garage: Attached, Side
- Parking Features: Off Street, Driveway
Interior
- Other Room Information
- Basement: Partial
- Basement Sq. Ft. (Realist): 1,007
- Interior Features
- Interior Features: Storage Area
- Multi-Unit Information
- # of Units (Total): 2
- 2-Bedroom Units: 2
Exterior
- Exterior Features
- Exterior Features: Patio, Porch, Metal Fence
- Roof: Shingle
- Construction Materials: Brick
- Window Features: Aluminum, Double Hung, Insulated
- Lot Information
- Lot Area (Realist): 9,540
- Lot Size Units: Acres
- Lot Size Acres: 0.219
- Lot Size Sq. Ft.: 9,540
- Other Features: Busline Near
- Property Information
- # of Fireplaces: 1
- Fireplace Features: Brick, Wood
- Structure Type: Duplex
- Foundation Details: Poured
- Levels: Two
- Census Tract Realist: 220
- 2nd Flor Area (Realist): 1,007
Financial
- Tax Information
- Semi-Annual Taxes: $0
- Parcel Number: 5970070013500
Utilities
- Utility Information
- Water Source: Public
- Cooling: Window Unit
- Gas: Natural
- Heating: Gas, Steam
- Heat Paid: Tenant
- Separate Furnace: Yes
- Separate Gas/Electricity: Yes
- Sewer: Public Sewer
- Water Paid: Tenant
Location
- School Information
- High School District: Winton Woods City SD
- Location Details
- Cross Street: Winton Rd
- Suburb: Greenhills
- Directions: Winton Rd to Andover Rd.
Public facts
- Beds: 4
- Baths: 3.5
- Sq. Ft.: 2,254
- Stories: 2.0
- Lot Size: 9,540 square feet
- Style: Multi-Family (2-4 Unit)
- Year Built: 1938
- Year Renovated: —
- County: Hamilton County
- APN: 5970070013500
Other
- Listing Information
- Listing URL: Listing URL (External Link)
- Auction: No
- FIPS Code: 61
- Picture Provided By: Photo Supplied
- Total Buildings: 1
Around this home
Schools
Public 1-2 • Assigned • 0.4mi
Public 7-8 • Assigned • 1.5mi
Public 9-12 • Assigned • 1.5mi
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
1% chance of strong winds in next 30 years
4 unhealthy days expected this year, 7 days in 30 years
Sun exposure
In this area, properties receive around 9.3 hours in June and 3.2 hours in December, placing it below the U.S. average for solar exposure.
Nearby similar homes
New listings for sale in 45218
Home values near 8 Andover Rd
| Address | Redfin Estimate |
|---|---|
4 Beds | 1.5 Baths | 1408 Sq. Ft. | $189,002 |
3 Beds | 1 Baths | 1296 Sq. Ft. | $182,552 |
| Address | Redfin Estimate |
|---|---|
4 Beds | 2 Baths | 2302 Sq. Ft. | $219,196 |
4 Beds | 2 Baths | 1584 Sq. Ft. | $235,528 |
| Address | Redfin Estimate |
|---|---|
3 Beds | 1.5 Baths | 1294 Sq. Ft. | $180,345 |
2 Beds | 1 Baths | 1026 Sq. Ft. | $169,180 |
More real estate resources
- Neighborhoods
- Zip Codes
- Cities
- Popular Searches
| Winston Lake homes for sale |
| 45240 homes for sale | |||
| 45231 homes for sale | |||
| 45218 homes for sale |
| West Chester homes for sale | |||
| Cincinnati homes for sale | |||
| Mason 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