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

4895 Sunset Lane
Evansville, IL 62242

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,450,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2600 Square Feet
Agency: eXp Realty

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Range, Garbage Disposer, Dryer, Cooktop - Electric, Water - Softener, Vacuum System
Architectural Style: Colonial
Construction Materials: Brick
Cooling: Other
Heating: Geothermal, Fireplace
Interior Features: Walk-in Closets, Open Floor Plan, Built-in Bookcases, Some Carpeting, Some Wood Floors, Private Inground Pool
Rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Family Room, Living Room

Window Features

Exterior Features: Clubhouse/Facilities
Parking Features: Garage, Garage - Attached, Oversized

Neighborhood/Schools

Elementary School/District: RED BUD DIST 132/RED BUD DIST 132
Middle/Junior High School/District: /RED BUD DIST 132
High School/District: Red Bud/RED BUD DIST 132
Subvidision Name: None

Description/Comments


Lot Size: 28 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Stunning custom-built brick ranch home nestled on 28.4 acres of scenic beauty! Property details include:4 bedrooms and 3 bathrooms, including a convenient Jack and Jill bathroom setup. Custom-built cabinets, adding a touch of elegance and functionality. Spacious living areas with a seamless flow, perfect for gatherings and relaxation. Modern kitchen with high-end appliances and ample cabinet space. Cozy fireplace for warmth and ambiance during colder seasons. Well-appointed bedrooms with plenty of natural light and serene views. In-ground pool with a bar area by the pool! Expansive 28.4 acres of land, including woods suitable for hunting enthusiasts. Stocked pond, providing fishing opportunities and scenic tranquility. Charming party saloon shed, perfect for hosting events or enjoying evenings with friends. 3 other outbuildings for storage, accommodating all your equipment and outdoor needs. Additional farmhouse on the property, offering rental income potential with a little TLC!
MlsNumber: --


Listing Provided By: eXp Realty, original listing
Phone: (618) 317-2319
Office Phone: (888) 574-9405
Agent Name: Jena Gibbs
Disclaimer: Copyright © 2024 MARIS. 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