











Description
Unique property in Hot Madisonville! One parcel w/ Charming Duplex + sep Comm bldg behind it in the heart of growing Biz Dist. Amazing op for Savvy Investor, or Business owner to live/work/rent. Over 4,000 total sf, up to 4 streams of income! Situated across from Mazunte Mercado on highly sought after Madison Rd @33,000+ vehicles/PD. One Res unit updated + newer Furnace/HWH. Comm bldg in rear w/ office, bay & 2 car garage. Zoned T4N.MF-O. 1 unit Tenant occ (M-to-M). 24 hr notice req
Similar Listings
MLS# 1762465
ACTIVE
$11,000,000

Listing Agent: Ali Abdur-Rahman
Courtesy of: Plum Tree Realty
MLS# 1607133
ACTIVE
$9,900,000

Listing Agent: Jeffrey Bennett
Courtesy of: Coldwell Banker Heritage
MLS# 1745457
ACTIVE
$4,900,000

Listing Agent: Jeff Honnerlaw
Courtesy of: HONNERLAW REAL ESTATE SERVICE
MLS# 1758597
PENDING
$4,900,000
5 Beds
11 Baths

Listing Agent: Patrick Lach
Courtesy of: Sibcy Cline, Inc.
MLS# 1743016
ACTIVE
$4,800,000

Listing Agent: John Bissman
Courtesy of: Keller Williams Pinnacle Group
MLS# 1745461
ACTIVE
$4,500,000

Listing Agent: Jeff Honnerlaw
Courtesy of: HONNERLAW REAL ESTATE SERVICE
MLS# 1744832
ACTIVE
$4,500,000

Listing Agent: Leonard Koogler
Courtesy of: Koogler-Eyre Realtors
MLS# 1748714
ACTIVE
$4,275,000
5 Beds
8 Baths

Listing Agent: Judy Recker
Courtesy of: Sibcy Cline, Inc.
MLS# 1463241
ACTIVE
$4,034,500

Listing Agent: Robert Peach
Courtesy of: Peach Realty, Inc.
No similar listings found
Unfortunately, we don't have any similar listings at the moment. Please remove or change some of the selected filters.
Listing Agent: Meg Perez Courtesy of: Coldwell Banker Realty The data relating to real estate for sale on this website 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 Pivot Realty are marked with the Broker Reciprocity™ logo (the small black house) and detailed information about them includes the name of the listing brokers. Information Deemed Reliable But Not Guaranteed. Updated: 27th January, 2023 12:55 PM (UTC)