$817,658
$496K since sold in May 2015$9,000 since August
This home's estimate is 32% higher than the average sale price ($620K) of 6 comparable homes.
Claim this home to receive a free report every month with insights on the changing estimate.
Off Market May 2015 for $321K
$817,658
3
bd•
3 ba
•
3,108
sq ft
400 Gates Rd, Hamilton, OH 45013
About this home
Single-familyProperty Type
1996Year Built
16.6 acresLot Size
$263Est. Price/Sq.Ft.
2 car garageParking
Listed by Jan Gerding • Coldwell Banker Realty
•513-608-3770 (agent)
•jan.gerding@cbws.com (agent)
•513-686-7677 (broker)
•bill.heckman@cbws.com (broker)
Bought with Jan Gerding • Coldwell Banker Realty
•513-686-7677 (broker)
•bill.heckman@cbws.com (broker)
Redfin checked: 3 minutes ago
•Source:Cincy MLS #1435879
Redfin Estimate
Earn from this home
Sell
$575,640
Est. take-home
List your home with Redfin and save $8,177
Rent
$2,238/mo
Redfin rental estimate
List your home for rent
Market trends in 45013, OH
Last updated August 2026
Buyer's Market
Seller's Market
Seller's market
Sale-to-List Price
99.4%
+0.2% MoM
Median sale price
$260K
$112 MoM
Avg. days on market
43d
1 days MoM
Recently sold homes
184
12 MoM
New listings for sale
Provided by Redfin
Property details
Around this home
Lifestyle
Provided by Walk Score and Local Logic
Sun exposure
In this area, properties receive around 9.5 hours in June and 3.2 hours in December, placing it below the U.S. average for solar exposure.
JuneDecember
Provided by Shadowmap
Property information provided by Cincy MLS when last listed in 2015. This data may not match . Learn more.
More real estate resources
- Zip Codes
- Neighborhoods
- Cities
- Popular Searches
| 45011 homes for sale | |||
| 45067 homes for sale | |||
| 45013 homes for sale | |||
| 45014 homes for sale | |||
| 45015 homes for sale |
Find us
Subsidiaries
Affiliated Business
United States
CanadaCopyright: © 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.
GreatSchools Ratings provided by GreatSchools.org.