Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2083 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2083 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2083 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

11546 Horseshoe Channel Drive
Lakeview, OH 43331
Eric Schnipke with Choice Properties Real Estate, original listing - (937) 842-2244

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $649,900
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1866 Square Feet
Agency: Choice Properties Real Estate
Agency Phone: (937) 842-2244

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1960
Notes: Looking for a waterfront home that's large enough to entertain family, friends, and host social gatherings? Then look no further! <br /> This GORGEOUS furnished waterfront home can sleep 14, and would be ideal as a full time residence, weekend/vacation home, or as a rental. Upon entering, you will first notice the large living room with a wall of windows,- what a view! The living room also features: vaulted ceilings, a gas fire place, and remote controlled window coverings. The open concept kitchen/dinning room is a host and bakers dream, that seats 12+ and features: Stainless Appliances, a lazy susan, granite countertops, large peninsula/island, pantry, beverage center, and table with 3 extensions. The home has 3 bedrooms (2 with walk in closets), 2 bathrooms, laundry room/mudroom, and part of the garage has been converted into a bunkhouse that can sleep up to 9 (1 queen bed, 2 bunk beds-each has a full size mattress on bottom and twin on top, and a jack knife sofa). When the bunkhouse is in use, you can close the primary bedroom off from the primary/second bathroom. This lets the guests in the bunkhouse have direct access to a bathroom separate from the main house as it has its own entrance offering privacy. Additionally after a long day on the water fishing/floating, or after a hard days work the mudroom/laundry room has direct access from outside and connects to the primary bathroom so you don't trek dirt/sand into the house. Outside you will find plenty of parking for guests or your water toys. The garage now offers a workshop, and storage for your lake gear. The covered carport has an inside/outside fridge, ceiling fan, and a 6 person poly bar height table for additional entertaining. The back yard oasis features a poured/stamped concrete patio, reinforced seawall, firepit, metal gazebo, nautical themed 6 person poly bar top, and 2 covered boat docks. Some updates include: furnace, central ac, water heater, well pump & tank, gazebo, water softener, and range.
MlsNumber: --
ListingId: 1036831


Listing Provided By: Choice Properties Real Estate, original listing
Phone: (419) 969-0966
Office Phone: (937) 842-2244
Agent Name: Eric Schnipke
Disclaimer: Copyright © 2025 Western Regional Information Systems and Technology, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2083 AND i.igate IN ('usahud','ohhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Judi Wilson
Judi Wilson
ASCIIHoward Hanna Real Estate Services
Call Today!: (937) 869-3213

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App