- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
Hot
No HOA
Street View
$349,900
Monthly Est:$1,742
4 Beds
2 Baths2 full baths
1,728sqft
5158 Trenton Franklin Rd, Madison Twp, OH 45042
$349,900
$1,742/moEst:
Get Pre-Approved
Single Family Residence
Built in 1866
$-- HOA
1.65 acres lot
$202/sq.ft
Description
Historic Charm Meets Modern Updates! Perched beautifully atop a picturesque hill, this charming 4-bedroom home blends timeless character with thoughtful modern updates. Original woodwork throughout adds warmth, craftsmanship, and personality that you simply don't find in newer homes. Major updates include new windows, a new roof, a beautifully updated kitchen, and two remodeled bathrooms, offering the perfect combination of classic charm and modern comfort. The spacious layout provides plenty of room for family and guests, while the elevated setting offers beautiful views and a peaceful atmosphere. Adding incredible versatility is a detached mother-in-law house(24x21) featuring a studio-style apartment and full bathroomperfect for extended family, guests, a home office, or additional living space. A rare opportunity to own a home where historic character, modern convenience, and flexible living come together in a truly special setting!
- Houzeo last checked: 12 minutes ago
- Listing updated: October 22, 2026 at 8:03 pm
- Listing Provided by: Lance Phillips | Realty First
- Source: Cincinnati MLS-OH | MLS#: 1893760
Property Details
Status
Pending
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1866
HOA Fees
-
Finished Area
1,728 sqft
Lot Size
1.65 acres lot
Basement Area
- sqft
MLS Name
Cincinnati MLS
MLS Number
1893760
MLS Status
Pending
Days on Market
49
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 2
Interior
Sewer
Septic Tank
Window Features
Vinyl
Heating
Heat Pump
Cooling
Central Air
Construction
Year Built
Year Built: 1866
Home type
Single Family Residence
Foundation Details
Block, Poured
Roof
Shingle
Construction Materials
Vinyl Siding
Architectural Style
Traditional
Utilities & Energy
Water Source
Public
Basement
Partial, 11, 3
Parking Features
Off Street, Driveway
Other Features
Lot Features
Sloped
Price History
| Date | Event | Price |
|---|---|---|
10/22/2026 Source: | Pending | $349,900 $202/sqft |
Nearby Homes
Find Homes by Property Features in Madison Twp, OH
Nearby New Homes For Sale
Based on information from the Multiple Listing Service of Greater Cincinnati (alternatively the REALTOR Alliance of Greater Cincinnati) through Oct 31, 2026, 03:45PM. IDX information is provided exclusively for consumers’ personal, non-commercial use, it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and the data is deemed reliable but is not guaranteed accurate by the MLS. The listings of some real estate brokerage firms have been excluded. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed. Copyright 2026, MLS of Greater Cincinnati, Inc. All rights reserved
Advertising Broker: Nicholas Huscroft | Chosen Realty
