Refine Search
Map
Sort by
$500,000
6 Beds ⋅ 6 Baths ⋅ 1892333 MLS
Spacious 6-Bedroom Home with In-Law Suite & Walkout Basement! Welcome to 578 Rachel Dr in Hamilton, OH! This impressive 3,712 sq. ft. home offers 6 bedrooms. It has 4 full bathrooms and 1 half bathroom, giving you plenty of space and flexibility for everyday living, entertaining, and multigenerational needs. Refreshed with new paint, the home also includes a tankless water heater for peace of mind. One of the home's standout features is the main-level in-law suite, complete with a sitting area and a full bathroom, offering a private and comfortable space for extended family or guests. The primary bedroom features its own suite, creating a relaxing retreat at the end of the day. The full walkout basement adds even more living space with two separate living areas, a full bathroom, and a storage room. Whether you need a recreation room, home theatre, office, gym, or additional family space, the possibilities are endless.

578 Rachel Drive, Hamilton
$535,000
6 Beds ⋅ 7 Baths ⋅ 1856336 MLS
Amazing one of a kind historic duplex built in 1874 with over $250,000 of upgrades in the last few years! Currently used as a short-term rental with very strong financials for 2023 & 2024. Can be kept as a short-term rental, used as a single family, used as a duplex for maximum profit, or live in one unit and rent the other to pay all the housing expenses! Highlights include: On Hamiltons historic property list located in the Rossville Historic District built with 4,628 s/ft. 3 beds/3.5 baths (right unit - basement can be used as 4th bedroom) and 3 bed/2 bath (left unit), two single car garages, 12-foot ceilings on 1st and second floors, original doors, windows, & trim, dual furnaces w/ 2 AC units, 2 separate water heaters, library, game room, workshop area with full bathroom, inground pool, hot tub and large private back yard with nice, wooded views. Separate lot (228 South D) included in sale as well as all furniture in house. Agent/Owner.

232 S D Street, Hamilton

The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity™ program of the Multiple Listing Service of Greater Cincinnati. Real estate listings held by brokerage firms other than our company are marked with the Broker Reciprocity™ logo (the small house as shown to the left) and detailed information about them includes the name of the listing brokers. This data is up-to-date as of . Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved. Information deemed reliable but not guaranteed.