Discover perfection in this 3-bedroom, 2-bathroom historic farmhouse, masterfully renovated to blend timeless charm with modern luxury. Warm and inviting interiors showcase distinctive barn doors, creating an authentic farmhouse atmosphere while delivering contemporary comfort. Positioned on a generous three-parcel lot with abundant parking, this versatile property currently operates as a successful Airbnb, offering both turnkey investment potential or an idyllic personal residence. The thoughtful renovation preserves historic character while incorporating modern amenities throughout the three spacious bedrooms and two well-appointed bathrooms. Located just 10 minutes from downtown Cincinnati's vibrant entertainment district and professional sports venues, enjoy the perfect balance of peaceful living with urban accessibility. The expansive lot provides endless opportunities for outdoor living and future expansion.
Last Agent to Sell the Property
Bridgestream Realty License #2021006707 Listed on: 03/13/2025
Co-Listed By
Mike Mefferd
Bridgestream Realty License #2021001059
Home Type
Est. Annual Taxes
Year Built
Lot Details
Home Design
Interior Spaces
Kitchen
Bedrooms and Bathrooms
Parking
Utilities
Community Details
$239,900
This spacious 4-bedroom, 2.5-bath single-family home in Clifton is an ideal choice for student housing or a turnkey investment property. Spanning three levels, the home features bathrooms on each floor, generous bedroom sizes, and abundant closet spaceperfect for shared living. Currently leased until July 2025 at $2,600 per month (with tenants covering all utilities), this property offers stable
Jordan Fiore eXp Realty
$249,000
This spacious 2-bedroom, 3-bath landominium features numerous updates including a newer HVAC system (2021), water heater (2023), luxury vinyl plank flooring, fresh paint, and new cabinet doors. The lower level offers a versatile family room perfect for relaxing or entertaining. Upstairs, the huge primary suite includes an ensuite bath with double vanities and an expansive bonus area that can be
Jinhong Xia OwnerLand Realty, Inc.
$194,900
This beautifully renovated home offers both style and convenience in a prime location. Inside, refinished hardwood floors set a warm, inviting tone, while the updated kitchen and bathroom feature modern finishes designed for contemporary living. Recent upgrades include a new roof, A/C unit, appliances, fixtures, and countertops, ensuring both quality and comfort. Outside, enjoy a covered front
Dustin Walters Comey & Shepherd
$239,000
This attractive three bedroom brick ranch is situated on a wonderful .46 acre lot. The home offers single level living wt a laundry hookup on the main level. The equipped kitchen is open to the family room. There is a full basement that is partially finished and will make a nice workout or recreation space. There is also an extra storage room and a laundry room with a washer and dryer that stay!
Jeff Smith RE/MAX Victory + Affiliates
$197,000
Attention Investors: Home is currently producing around $19,800 a year of rental income with possibly room to increase it to produce up to 21,600 a year. Tenants are on a month to month lease. This 3br, 1.5 bath Northside home has new windows (2024), new hot water heater(2024), some new water lines (2024), new carpet, new kitchen appliances, and freshly painted basement. Close to I-74, I-75,
Jennifer Pope Keller Williams Seven Hills Re
$225,000
Back on Market with a NEW ROOF 2025! Great floorplan. So much space. 3 bedrooms upstairs with 2 full baths. Full basement with additional bonus room. Basement bath could be little retreat spa space! 2 car gargage. Hardwood under floors on first floor. Furnace new 2018, Hot H20 new 2018.
Megan Mull eXp Realty
$239,900
Discover timeless elegance in this stunning 4-bedroom stone Tudor-style home, nestled on over 0.86 acres of lush, private land, perfect for family fun and outdoor activities. Boasting modern updates throughout, this home offers a harmonious blend of classic character and contemporary comfort. Enjoy a refreshed kitchen with stainless steel appliances, recent HVAC system for year-round efficiency,
Jordan Fiore eXp Realty
$228,000
Back on the market due to buyer financing. Come tour this charming and fully updated 4BR,2BA home with a spacious front proch perfect for relaxing! Enjoy a first floor primary bedroom, beautiful kitchen and two full bathrooms. Additional upgrades include a new roof, gutters and HVAC, ensuring peace of mind. Modern finishes throughout. Fenced backyard and off street parking add extra value.
Jennifer Fehr Bastion, REALTORS
$250,000
Spacious 2200+ SQ ft home ready for someone to make it their own. You'll love the multiple living areas on the first floor, including a front TV gathering area, large living room with fireplace, spacious dining room with built in cabinetry, kitchen with walk-out, breakfast room and study off of bonus room that could be transformed into an amazing mudroom. Second floor has two nice sized
Amy Moeller Coldwell Banker Realty
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $225,000 | None Listed On Document | |
| Warranty Deed | $225,000 | None Listed On Document | |
| Deed | $150,000 | -- | |
| Quit Claim Deed | -- | Anderson Eric L | |
| Executors Deed | $28,000 | Chicago Title Company Llc |
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $180,000 | New Conventional | |
| Closed | $180,000 | New Conventional | |
| Previous Owner | -- | No Value Available | |
| Previous Owner | $120,000 | New Conventional | |
| Previous Owner | $65,000 | Credit Line Revolving |
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 04/19/2025 04/19/25 | Off Market | $225,000 | -- | -- |
| 04/17/2025 04/17/25 | Sold | $225,000 | 0.0% | $144 / Sq Ft |
| 03/17/2025 03/17/25 | Pending | -- | -- | -- |
| 03/13/2025 03/13/25 | For Sale | $225,000 | +703.6% | $144 / Sq Ft |
| 09/26/2017 09/26/17 | Off Market | $28,000 | -- | -- |
| 06/26/2017 06/26/17 | Sold | $28,000 | -17.6% | $18 / Sq Ft |
| 04/26/2017 04/26/17 | Pending | -- | -- | -- |
| 04/03/2017 04/03/17 | For Sale | $34,000 | -- | $22 / Sq Ft |
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $3,255 | $52,501 | $7,900 | $44,601 |
| 2023 | $3,326 | $52,501 | $7,900 | $44,601 |
| 2022 | $838 | $10,094 | $7,917 | $2,177 |
| 2021 | $786 | $10,094 | $7,917 | $2,177 |
| 2020 | $788 | $10,094 | $7,917 | $2,177 |
| 2019 | $835 | $9,800 | $7,686 | $2,114 |
| 2018 | $835 | $9,800 | $7,686 | $2,114 |
| 2017 | $799 | $9,800 | $7,686 | $2,114 |
| 2016 | $1,885 | $23,965 | $9,146 | $14,819 |
| 2015 | $1,693 | $23,965 | $9,146 | $14,819 |
| 2014 | $1,702 | $23,965 | $9,146 | $14,819 |
| 2013 | $1,462 | $20,139 | $7,686 | $12,453 |
Seller's Agent in 2025
Mellissa Andre
Bridgestream Realty
(513) 508-3795
1 in this area
29 Total Sales
M
Seller Co-Listing Agent in 2025
Mike Mefferd
Bridgestream Realty
(517) 270-9907
Buyer's Agent in 2025
Tawnda Cross
Huff Realty
(513) 250-6092
3 in this area
8 Total Sales
H
Seller's Agent in 2017
Hazen Master
eXp Realty
Buyer's Agent in 2017
Jennifer Allred
Coldwell Banker Realty
(513) 317-7869
174 Total Sales
Source: MLS of Greater Cincinnati (CincyMLS)
MLS Number: 1833573
APN: 008-0001-0075
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
The data relating to real estate for sale on this website comes in part from the Broker Reciprocity programs of the MLS of Greater Cincinnati, Inc.. Those listings held by brokerage firms other than Ten-X are marked with the Broker Reciprocity logo and house icon. The properties displayed may not be all of the properties available through Broker Reciprocity.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Ten-X does not display the entire Cincinnati MLS Broker Reciprocity™ database on this web site. The listings of some real estate brokerage firms have been excluded.
Copyright 2025, MLS of Greater Cincinnati, Inc. All rights reserved