Title Page Background
DEBUG FN args: Array ( [0] => 2049 [1] => [2] => [3] => agent ) BEFORE: Site: 2049 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2049 Igate: njhud LocID: 2049 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 = 2049 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2049 [1] => [2] => [3] => lender ) BEFORE: Site: 2049 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2049 Igate: njhud LocID: 2049 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 = 2049 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2049 [1] => [2] => [3] => other ) BEFORE: Site: 2049 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2049 Igate: njhud LocID: 2049 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 = 2049 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1092 George Allen Drive
South Vienna, OH 45369
Alison North with Glasshouse Realty Group, original listing - (937) 949-0006

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Pending
SqFt: 2370 Square Feet
Agency: Glasshouse Realty Group
Agency Phone: (937) 949-0006

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: Welcome to life at the lake! Nestled in Vienna Woods at Sylvan Shores, this 4-bedroom, 3.5-bathroom retreat offers 117 feet of water frontage and a peaceful, wooded 1.1-acre lot. Built in 2004 by Bige Brock, this purposely designed and well-maintained home features 2,370 sq ft above grade with an additional 1,400 sq ft of finished walkout lower-level—plenty of room to spread out, entertain, or simply relax.<br /> Inside, the main floor features hardwood floors, a spacious kitchen with Corian countertops, center island, and dry bar, plus a generous dining area and living room with sliders that open to a large deck with views of the lake. The main floor also includes the laundry room, mudroom with half bath, and a convenient primary suite complete with walk-in closet, double vanity, walk-in shower, and a whirlpool tub.<br /> Two additional bedrooms share an adjoining full bath upstairs, while the lower level hosts a fourth bedroom (currently used as an office), a full bath, and a large finished living space with a bar, pool table, workout/flex space, and even a cedar-lined ''cold room'' ideal for wine storage. There's also a kitchenette with a refrigerator, wet bar, and microwave, making this level perfect for hosting or guests.<br /> Outside, enjoy not one but two lake-facing decks—one off the main floor and one covered, off the walkout level. Mature trees surround the property for added privacy, and there's also a shed for all your lake toys or lawn gear. Additional features include Anderson windows with built-in screens, a water softener (owned) with iron-out system, electric to the lake, and brand-new smoke detectors with 20-year lithium batteries. <br /> The 2.5-car garage includes built-in cabinetry and workspace, and select furnishings—including the pool table and bar—are negotiable. This home offers space, comfort, and lake living at its finest—come see what makes this one so special!
MlsNumber: --
ListingId: 1038683


Listing Provided By: Glasshouse Realty Group, original listing
Phone: (937) 206-2273
Office Phone: (937) 949-0006
Agent Name: Alison North
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => clark [3] => OH [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: clark State: OH Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: clark State: OH 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 = 2049 AND i.igate IN ('gahud','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 = 'gahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Taylor Laughlin
Taylor Laughlin
ASCIIColdwell Banker Heritage - Team Horne-Bowen
Call Today!: (937) 536-4258

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App