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 = 723 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 723 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 = 723 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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;

2337 Edwardsville Galena Road
Georgetown, IN 47122

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 3
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4773 Square Feet
Agency: Schuler Bauer Real Estate Services ERA Powered (N
Agency Phone: (812) 948-2888

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2001
Notes: Executive Mid-Century Modern Custom Built Home on 3 Ac, 1st time ever to hit the market. Such a unique property with a style all it's own. This home was constructed with Structural Insulation Panels in the exterior walls & roof making it extra energy efficient. There are 2 Lg Main Bedroom Suites with walk-in closets, dressing areas, & private bathrooms each with Barrier Free walk-in showers. 3rd bedroom is upstairs with it's own full bath, walk-in closet, sitting area, kitchenette, 2 walk-in attic spaces for extra storage, & could be divided to make multi bedrooms. Back on the main level there is the one of a kind GOURMET KITCHEN with 2 Kitchenaid Dishwashers, 2 elec. self-cleaning Ovens, a Viking Gas Stovetop, separate Sub-Zero Fridge & Freezer, all within Solid Cherry Cabinets finished with Quartz counters & 5 Applicance Garages. The kitchen opens up to the living area with double FIREPLACE that is shared with the separate Study. This home was built with space to add an Elevator to go to all 3 levels. There are 3 separate HVAC systems, 3 gas water heaters, & Central Vac. The WALKOUT Basement has a Holiday Tree Rm, Summer Kitchen, full bath, working fireplace, space for 2 extra vehicles, & storage galore. From the basement you can step outside & overlook the beautiful backyard with 24 Garden Boxes. Also enjoy the outdoors from the massive deck, multiple patios, & covered porches. Sq ft & rm sz approx.
MlsNumber: --
ListingId: 202408663


Listing Provided By: Schuler Bauer Real Estate Services ERA Powered (N, original listing
Phone: (502) 523-0672
Office Phone: (812) 948-2888
Agent Name: Julie L Blackman
Disclaimer: Copyright © 2024 Southern Indiana REALTORS Association. 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