OFF MARKET

Off market may 2025 for $283K

$242,036

Est. refi paymentEst. refi $1,928/mo

•

1,721

sq ft

1074 Overlook Ave, Cincinnati, OH 45238

About this home

Public Remarks: Back on the market due to buyer getting cold feet. This beautifully updated 4-bedroom, 2 full bath home is move-in ready with stunning upgrades throughout! Step inside to find refinished hardwood floors, new carpet, and fresh paint on every wall, ceiling, and trim. The kitchen shines with wood cabinets, granite countertops, and brand-new appliances. Both bathrooms have been tastefully updated with new vanities, light fixtures, hardware, faucets, and fresh tile in the upstairs bath. The primary bedroom features a spacious walk-in closet, ready for your custom touch. Design it to match your needs! Enjoy peace of mind with a new water heater, a serviced and cleaned furnace (Jan. 2025), and a newer condenser. A one-car garage plus off-street parking adds convenience. Don't miss this incredible home and schedule your showing today!

Single-familyProperty Type

7,144 sq ftLot Size

$141Est. Price/Sq.Ft.

1 car garageParking

Listed by Alexandria Piercy • Howard Hanna Real Estate Svcs

•513-462-4722 (agent)

•alipiercy@gmail.com (agent)

•513-324-2267 (broker)

•anitaricketts@howardhanna.com (broker)

Listed by Charissa Napoles • Howard Hanna Real Estate Svcs

•513-324-2267 (broker)

•anitaricketts@howardhanna.com (broker)

Bought with Robert Smith • Coldwell Banker Realty

•513-891-8500 (broker)

•kathy.doherty@cbrealty.com (broker)

Redfin checked: 2 minutes ago

•Source:Cincy MLS #1831880

Redfin Estimate

$242,036

$42K since sold in May 2025$22K since October

Recently sold homes
Estimate history
Homes for sale

This home's estimate is 8.1% lower than the average sale price ($263K) of 6 comparable homes.

SOLD OCT 21, 2026
$259,900
A
4 beds2.5 baths1,871 sq ft
4970 Relleum Ave, Cincinnati, OH 45238
SOLD SEP 8, 2026
$228,000
B
3 beds2 baths1,442 sq ft
1151 Rulison Ave, Cincinnati, OH 45238
SOLD APR 17, 2026
$258,000
C
3 beds2 baths1,829 sq ft
1075 Coronado Ave, Cincinnati, OH 45238
SOLD JUL 24, 2026
$269,000
D
3 beds1.5 baths1,604 sq ft
1144 Carmania Ave, Cincinnati, OH 45238
SOLD FEB 4, 2026
$285,000
E
3 beds2 baths1,720 sq ft
1191 Rulison Ave, Cincinnati, OH 45238
SOLD APR 28, 2026
$280,000
F
3 beds2.5 baths1,702 sq ft
1127 Rulison Ave, Cincinnati, OH 45238

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

Earn from this home

Sell

$5,058

Est. take-home

List your home with Redfin and save $2,420

Refinance

Est. cash available

Get cash now or lower your monthly rate

Rent

$1,537/mo

Redfin rental estimate

List your home for rent

Market trends in 45238, OH

Last updated October 2026

Buyer's Market

Seller's Market

Seller's market

Sale-to-list price

98.9%

0.2% MoM

Median sale price

$230K

$7K MoM

Avg. days on market

49d

5 days MoM

Recently sold homes

138

11 MoM

New listings for sale

NEW 17 HRS AGO
$179,000
2 beds1 bath852 sq ft
3322 Queen City Ave, Cincinnati, OH 45238
NEW 17 HRS AGO
$179,000
2 beds1 bath1,216 sq ft
3314 Queen City Ave, Cincinnati, OH 45238
NEW 17 HRS AGO
$149,000
2 beds1 bath1,024 sq ft
3318 Queen City Ave, Cincinnati, OH 45238
NEW 22 HRS AGO
$194,900
2 beds1 bath992 sq ft
4716 Shady Lawn Ter, Cincinnati, OH 45238
$219,900
4 beds2 baths1,814 sq ft
487 Pedretti Ave, Cincinnati, OH 45238
OPEN SUN, 1PM TO 2:30PM
$159,900
2 beds1.5 baths959 sq ft
4931 Heuwerth Ave, Cincinnati, OH 45238
OPEN SUN, 12PM TO 2PM
$249,000
4 beds2 baths1,768 sq ft
5345 Plumridge Dr, Cincinnati, OH 45238
$199,900
3 beds1 bath1,231 sq ft
3121 W Tower Ave, Cincinnati, OH 45238
$239,999
3 beds2 baths1,633 sq ft
551 S Delridge Dr, Cincinnati, OH 45238
$189,900
3 beds1.5 baths1,221 sq ft
2647 Foran Dr, Cincinnati, OH 45238
See all

Provided by Redfin

Sale history for 1074 Overlook Ave

Date

Event

Price

Cincy MLS #1831880

May 15, 2025

Sold

$283,895

$165/sq ft

Apr 19, 2025

Contingent

—

Mar 12, 2025

Relisted

—

Mar 10, 2025

Contingent

—

Mar 6, 2025

Listed

$279,900

$163/sq ft

Cincy MLS #1823868

Dec 13, 2024

Sold

$170,000

$99/sq ft

Nov 28, 2024

Contingent

—

Nov 7, 2024

Listed

$185,000

$107/sq ft

+41

Public Remarks

Sold AS-IS. Fireplace is inoperable. Welcome to 1074 Overlook Ave, a charming 4-bedroom, 1-bath Tudor bungalow on a tree-lined corner lot. Original hardwood floors and woodwork add warmth and timeless appeal. Natural light fills each room, creating a bright, airy atmosphere. The main level offers a primary bedroom, a second bedroom, and a bath, with two more bedrooms and a flexible space upstairs, ideal for an office or creative nook. The large basement with walk-out provides ample storage. Enjoy the cozy front and side porches, plus an oversized 1-car garage and wide driveway. Just minutes from downtown, shopping, and dining, this home offers convenience and potential. With a little TLC, 1074 Overlook Ave could be your dream home.

Year

Property tax

Land + Additions

Assessment*

2025

$2,376 (+2.8%)

$5,404 + $42,403

$47,807

2024

$2,312 (−4.2%)

$5,404 + $42,403

$47,807

2023

$2,413 (+121.7%)

$5,404 + $42,403

$47,807

2022

$1,088 (+6.7%)

$5,373 + $18,529

$23,902

2021

$1,020 (−4.0%)

$5,373 + $18,529

$23,902

2020

$1,062 (+6.8%)

$5,373 + $18,529

$23,902

2019

$994 (−0.2%)

$4,883 + $16,846

$21,729

2018

$996 (+6.2%)

$4,883 + $16,846

$21,729

2017

$938 (−26.4%)

$4,883 + $16,846

$21,729

2016

$1,274 (+9.1%)

$5,219 + $21,189

$26,408

2014

$1,168 (−17.9%)

$5,219 + $21,189

$26,408

2013

$1,422

$5,929 + $24,080

$30,009

Tax history for 1074 Overlook Ave

Year

Property tax

Land + Additions

Assessment*

2025

$2,376 (+2.8%)

$5,404 + $42,403

$47,807

2024

$2,312 (−4.2%)

$5,404 + $42,403

$47,807

2023

$2,413 (+121.7%)

$5,404 + $42,403

$47,807

2022

$1,088 (+6.7%)

$5,373 + $18,529

$23,902

2021

$1,020 (−4.0%)

$5,373 + $18,529

$23,902

2020

$1,062 (+6.8%)

$5,373 + $18,529

$23,902

2019

$994 (−0.2%)

$4,883 + $16,846

$21,729

2018

$996 (+6.2%)

$4,883 + $16,846

$21,729

2017

$938 (−26.4%)

$4,883 + $16,846

$21,729

2016

$1,274 (+9.1%)

$5,219 + $21,189

$26,408

2014

$1,168 (−17.9%)

$5,219 + $21,189

$26,408

2013

$1,422

$5,929 + $24,080

$30,009

*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.

Public record

Beds

Baths

Stories

Lot width

197 ft.

Lot depth

—

Lot size

7,144 Sq. Ft.

Year renovated

—

Sq. Ft.

1,721

Year built

1924

Style

Single Family Residential

County

Hamilton County

APN

1800080024300

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 19, 2026.

Property details

Parking

Parking Information
# of Garage Spaces: 1
Garage/Carport: Garage Detached

Interior

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

Bathroom Information
# of Bathrooms (Full): 2
Bath 1: Full
Bath 1 Level: 1
Bath 2: Full
Bath 2 Level: 2

Bedroom Information
# of Bedrooms Total: 4
Primary Bedroom: 0x14 Level: 2
Primary Bedroom Dimensions: 0 x 14
Primary Bedroom Width: 14
Bedroom 2: 13x19 Level: 2
Bedroom 2 Area: 247
Bedroom 2 Dimensions: 13 x 19
Bedroom 2 Length: 13
Bedroom 2 Width: 19
Bedroom 3: 14x11 Level: 1
Bedroom 3 Area: 154
Bedroom 3 Dimensions: 14 x 11
Bedroom 3 Length: 14
Bedroom 3 Width: 11
Bedroom 4: 11x12 Level: 1
Bedroom 4 Area: 132
Bedroom 4 Dimensions: 11 x 12
Bedroom 4 Length: 11
Bedroom 4 Width: 12

Kitchen/Dining Room Information
Kitchen Features: Eat-In, Wood Cabinets, Wood Floor, Marble/Granite/Slate
Kitchen Area: 154
Kitchen Dimensions: 14 x 11
Kitchen Length: 14
Kitchen Width: 11
Dining Room: 13x14 Level: 1
Dining Room Features: Wood Floor
Dining Room Area: 182
Dining Room Dimensions: 13 x 14
Dining Room Length: 13
Dining Room Width: 14

Living Room/Family Room Information
Living/Great Room Area: 221
Living/Great Room Dimensions: 13 x 17
Living/Great Room Length: 13
Living Great Room Width: 17
Living Room: 13x17 Level: 1
Living Room Features: Walkout, Fireplace, Wood Floor

Other Room Information
Basement: Full
Basement Features: Unfinished
Basement Sq. Ft. (Realist): 1,163

Interior Features
# of Rooms (Total): 6

Exterior

Exterior Features
Roof: Shingle
Construction Materials: Brick
Window Features: Storm, Double Hung

Land Information
Zoning Details: Residential

Lot Information
Lot Area (Realist): 7,144
Lot Size Dimensions: 47 x 150
Lot Size Units: Acres
Lot Size Acres: 0.164
Lot Size Sq. Ft.: 7,144

Property Information
# of Fireplaces (Total): 1
Fireplace Features: Brick
Architectural Style: Tudor
Single Family Desc: Single Family
Foundation Details: Poured
Levels: One and One Half
Census Tract Realist: 99.01

Financial

Tax Information
Semi-Annual Taxes: $1,156
Tax Abatement: No
Parcel Number: 180-0080-0243-00

Lease & Rent Information
Lease Considered: No

Utilities

Utility Information
Water Source: Public
Cooling: Central Air
Gas: Natural
Heating: Forced Air, Gas
Sewer: Public Sewer
Water Heating: Electric, Gas

Location

Homeowners Association Information
HOA: No

School Information
High School District: Cincinnati City SD

Location Details
Suburb: Covedale
Directions: Glenway to Overlook

Public facts

Beds: 4
Baths: 1.0
Sq. Ft.: 1,721
Stories: 1.0
Lot Size: 7,144 square feet
Style: Single Family Residential
Year Built: 1924
Year Renovated: —
County: Hamilton County
APN: 1800080024300

Home facts updated by county records on Oct 19, 2026

Other

Listing Information
Listing URL: Listing URL (External Link)
Auction: No
FIPS Code: 61

Around this home

Schools

K - 12
Preschool & daycare

Carson Elementary School

Public PreK-6 • Assigned • 0.7mi

5/10

Gilbert A. Dater High School

Public 5-12 • Assigned • 0.8mi

3/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 103° expected this year, 18 days in 30 years

2/10 Wind Factor

1% chance of strong winds in next 30 years

3/10 Air Factor

3 unhealthy days expected this year, 5 days in 30 years

Provided by First Street

Historical weather

Cincinnati, OH • 45238

Average low and high temperatures (°F)

34°

19°

44°

27°

62°

40°

70°

49°

72°

54°

84°

66°

87°

70°

83°

65°

82°

60°

69°

49°

54°

40°

44°

30°

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

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.

9.1 hrs

3.1 hrs

JuneDecember

Provided by Shadowmap

Estimated sale price

$230,000 – $279,000

Reach more buyers when you sell with Redfin. Save up to $2,420 in fees. 3 minutes to get started.

Need the cash from your home fast? Sell to .

Nearby similar homes

$22,000

Land— sq ft

3235 Brater Ave, Cincinnati, OH 45211

Utilities available

$25,000

Land— sq ft

4660 Glenway Ave, Cincinnati, OH 45238

Vacant lot • Outdoor space

$189,900

3 beds2 baths1,843 sq ft

4049 St Williams Ave, Cincinnati, OH 45205

Brick exterior • Convenient location • Garage

$199,000

5 beds2 baths3,584 sq ft

3904 St Lawrence Ave, Cincinnati, OH 45205

Full basement • Detached garage • 7500 sq ft lot

$235,000

3 beds2 baths1,314 sq ft

4956 Shirley Pl, Cincinnati, OH 45238

Wood floors • Cozy wood stove • Spacious deck

$129,900

2 beds2 baths1,272 sq ft

4767 Highridge Ave, Cincinnati, OH 45238

Cozy fireplace • Bay window • Full basement

New listings for sale in 45238

NEW 17 HRS AGO

$179,000

2 beds1 bath852 sq ft

3322 Queen City Ave, Cincinnati, OH 45238

Hardwood floors • Wood cabinetry • Ample counter space

NEW 17 HRS AGO

$179,000

2 beds1 bath1,216 sq ft

3314 Queen City Ave, Cincinnati, OH 45238

Brick cape cod • Hardwood floors • Accent wall

NEW 17 HRS AGO

$149,000

2 beds1 bath1,024 sq ft

3318 Queen City Ave, Cincinnati, OH 45238

Newer roof • 5,576 sq ft lot • Garage

NEW 22 HRS AGO

$194,900

2 beds1 bath992 sq ft

4716 Shady Lawn Ter, Cincinnati, OH 45238

Hardwood floors • Open-concept layout • Modern countertops

$219,900

4 beds2 baths1,814 sq ft

487 Pedretti Ave, Cincinnati, OH 45238

7,100 sq ft lot • 2 garage spots • Built 1948

OPEN SUN, 1PM TO 2:30PM

$159,900

2 beds1.5 baths959 sq ft

4931 Heuwerth Ave, Cincinnati, OH 45238

Enclosed front porch • Hardwood floors • Arched doorways

OPEN SUN, 12PM TO 2PM

$249,000

4 beds2 baths1,768 sq ft

5345 Plumridge Dr, Cincinnati, OH 45238

Updated cape cod • Hardwood floors • Granite countertops

$199,900

3 beds1 bath1,231 sq ft

3121 W Tower Ave, Cincinnati, OH 45238

Updated kitchen • Renovated bathroom • Roof replaced

$239,999

3 beds2 baths1,633 sq ft

551 S Delridge Dr, Cincinnati, OH 45238

9,757 sq ft lot • Garage • Built 1952

Home values near 1074 Overlook Ave

Data from public records.

Address	Redfin Estimate
1069 Overlook Ave, Cincinnati, OH 3 Beds \| 2 Baths \| 2164 Sq. Ft.	$236,280
1117 Overlook Ave, Cincinnati, OH 3 Beds \| 2 Baths \| 1925 Sq. Ft.	$234,907
1058 Overlook Ave, Cincinnati, OH 3 Beds \| 2 Baths \| 1331 Sq. Ft.	$235,715
1062 Overlook Ave, Cincinnati, OH 3 Beds \| 2.5 Baths \| 1991 Sq. Ft.	$243,745
1075 Overlook Ave, Cincinnati, OH 4 Beds \| 1.5 Baths \| 1978 Sq. Ft.	$242,103
1059 Overlook Ave, Cincinnati, OH 5 Beds \| 2.5 Baths \| 2445 Sq. Ft.	$293,921
4776 Highridge Ave, Cincinnati, OH 3 Beds \| 2.5 Baths \| 1598 Sq. Ft.	$236,489

Address	Redfin Estimate
1103 Overlook Ave, Cincinnati, OH 4 Beds \| 2.5 Baths \| 3185 Sq. Ft.	$278,933
1055 Overlook Ave, Cincinnati, OH 6 Beds \| 2.5 Baths \| 2307 Sq. Ft.	$314,312
1104 Overlook Ave, Cincinnati, OH 3 Beds \| 2 Baths \| 3098 Sq. Ft.	$280,839
1070 Overlook Ave, Cincinnati, OH 2 Beds \| 1.5 Baths \| 2398 Sq. Ft.	$188,844
1063 Overlook Ave, Cincinnati, OH 4 Beds \| 2.5 Baths \| 2507 Sq. Ft.	$314,454
4773 Loretta Ave, Cincinnati, OH 4 Beds \| 1.5 Baths \| 1626 Sq. Ft.	$206,047
4769 Loretta Ave, Cincinnati, OH 3 Beds \| 1.5 Baths \| 1370 Sq. Ft.	$213,783

Address	Redfin Estimate
1120 Overlook Ave, Cincinnati, OH 3 Beds \| 2 Baths \| 2605 Sq. Ft.	$245,132
1066 Overlook Ave, Cincinnati, OH 3 Beds \| 2 Baths \| 1500 Sq. Ft.	$246,739
1064 Overlook Ave, Cincinnati, OH 4 Beds \| 2 Baths \| 1598 Sq. Ft.	$212,558
1121 Overlook Ave, Cincinnati, OH 3 Beds \| 1.5 Baths \| 2768 Sq. Ft.	$322,426
1067 Overlook Ave, Cincinnati, OH 4 Beds \| 2 Baths \| 2402 Sq. Ft.	$287,764
4777 Loretta Ave, Cincinnati, OH 3 Beds \| 1 Baths \| 1350 Sq. Ft.	$155,317
4782 Loretta Ave, Cincinnati, OH 4 Beds \| 1.5 Baths \| 1850 Sq. Ft.	$197,862

Property information provided by Cincy MLS when last listed in 2025. 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.

Redfin Brokerage Licenses

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.

45236 homes for sale
45238 homes for sale
45227 homes for sale
45230 homes for sale
45231 homes for sale

Houses for rent in Cincinnati	Agents near me	Dayton, OH homes for sale	Cincinnati Housing Market
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	Cincinnati Property Records
Condos for sale near me	Dublin, OH homes for sale	OH New Listings

West Chester homes for sale
Mason homes for sale
Lebanon homes for sale

About this home

Redfin Estimate

Earn from this home

Market trends in 45238, OH

Sale history for 1074 Overlook Ave

Tax history for 1074 Overlook Ave

Public record

Property details

Around this home

Schools

Lifestyle

Climate risks

Historical weather

Sun exposure

Nearby similar homes

New listings for sale in 45238

Home values near 1074 Overlook Ave

More real estate resources