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

5200 Daylight Drive
Evansville, IN 47725
John Czoer with FIRST CLASS REALTY, original listing - (812) 475-2000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,249,888
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: FIRST CLASS REALTY
Agency Phone: (812) 475-2000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 46 acre(s)
Property Type: Land-Other
Year Built: --
Notes: You CAN buy dirt—and not just any dirt, but a rare 46-acre opportunity in the highly sought-after 47725 area. Owned by the same family for over 100 years, this land is filled with history, love, and endless possibilities. The location is unbeatable, with almost direct access to I-69, making it an ideal site for those looking to develop, invest, or build something truly extraordinary. The property is a developer’s dream, offering the potential for a stunning new neighborhood, or the future site of a thoughtfully designed development featuring single-family homes, luxury condos, and stylish town homes. Endless possibilities, a top-tier school, a thriving commercial hub, or for one with a vision of community and care, this could be the future home of a modern, next-gen senior living community or industrial space. One could preserve its legacy by remodeling the charming farmhouse and continuing to farm the land or create a private estate. With water, gas and sewers available on this side of the road, the groundwork is set for something remarkable. Close to top-rated schools, shopping, dining, and industry. Nestled in an area experiencing high demand. The property includes the original farmhouse, a livable home that could be beautifully restored to preserve its charm—though most developers may choose to remove it. Several additional structures add to the property's versatility, including a 30x40 pole barn built in 2011, a 20x40 barn, and a 20x18 smokehouse, offering ample storage. Plant new roots and watch them grow. This land holds limitless potential to become something truly special.
MlsNumber: --
ListingId: 202503876


Listing Provided By: FIRST CLASS REALTY, original listing
Phone: (812) 457-1432
Office Phone: (812) 475-2000
Agent Name: John Czoer
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