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

521 S Middle Street
Grayville, IL 62844
Andrea Downing with DHI Realty Inc, original listing - (618) 240-1346

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $165,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 2723 Square Feet
Agency: DHI Realty Inc
Agency Phone: (618) 240-1346

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1964
Notes: STUNNING, mid-century style home in a secluded location! This is truly one-of-a-kind home for the area! Situated on just over 1/2 an acre, this home features a beautiful, wooded backdrop on the edge of town. An oversized carport is conveniently located just off the side of the home. The main feature of the backyard is an amazing in-ground pool and entertainers' patio, just waiting for those warmer months to hit! (The pool is currently winterized) Heading inside the front door, buyers immediately notice the large foyer and unique mid-century feel. The home features a MASSIVE living room with floor to ceiling windows that overlook the pool. It is an entertainer's dream!!! A sliding patio door allows for convenient access to the exterior and pool area! The kitchen is beautifully updated with butcherblock countertops and a farmhouse sink - all of which is open to the dining room and living room. Additional information on the home: Potential to be hooked up to a wood-burner stove for supplemental heat, newer plumbing, new electrical from the pole to the breaker box, roof installed in 2016, pool equipment is approx. 5 years old, new contemporary front door, several new wall heating units being installed (2025)
MlsNumber: --
ListingId: 202500324


Listing Provided By: DHI Realty Inc, original listing
Phone: (618) 240-1310
Office Phone: (618) 240-1346
Agent Name: Andrea Downing
Disclaimer: Copyright © 2025 Southwest Indiana Association of Realtors. 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