Title Page Background
DEBUG FN args: Array ( [0] => 2083 [1] => [2] => [3] => agent ) BEFORE: Site: 2083 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2083 Igate: njhud LocID: 2083 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2083 [1] => [2] => [3] => lender ) BEFORE: Site: 2083 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2083 Igate: njhud LocID: 2083 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2083 [1] => [2] => [3] => other ) BEFORE: Site: 2083 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2083 Igate: njhud LocID: 2083 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('cihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

10125 Seminole Shore Drive
Huntsville, OH 43324
Paige Duff with Choice Properties Real Estate, original listing - (937) 842-2244

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 1976 Square Feet
Agency: Choice Properties Real Estate
Agency Phone: (937) 842-2244

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1930
Notes: Impressive 3 bed/3 bath waterfront home located in the heart of Indian Isles. Just steps away from the wooded walking path at Pew Island and a quick golf cart ride to Cranberry Resort! Enjoy stress-free docking in the waters of the calm channel while also admiring stunning open water views. Included with this property are two parcels across the street that feature basketball/pickleball/shuffleboard courts, shed, and yard space. A great area to build a detached garage! Also, the newly paved parking area has room to park boat trailers or up to four cars! The main floor of the home features 2 bedrooms; 2 full updated baths; laundry room with new washer/dryer; a large living room with cathedral ceiling; and a full wall of windows showcasing those beautiful Indian Lake sunsets. You'll love the updated gas fireplace and newly remodeled kitchen featuring an island with storage and seating; quartz counters; stainless steel appliances; and LVP flooring. Upstairs you'll find a spacious bedroom complete with a large closet, beautiful wooden vaulted ceiling, new mini split unit, and a full en suite bath. Andersen windows throughout the home. The house has a great efficient dual zone heating system and a metal roof that will last a lifetime. The 6' deep crawl space with a cellar opening is a convenient space for extra storage and lake toys. Outside you'll enjoy a nice yard, concrete waterside patio, and single dock with electric lift. This place has it all. All this home needs is YOU!!
MlsNumber: --
ListingId: 1038452


Listing Provided By: Choice Properties Real Estate, original listing
Phone: (937) 869-4957
Office Phone: (937) 842-2244
Agent Name: Paige Duff
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App