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 = 743 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 = 743 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 = 743 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;

801 S Main Street
Bicknell, IN 47512
Trey Miller with RE/MAX Mainstream, original listing - (812) 291-0695

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $35,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 971 Square Feet
Agency: RE/MAX Mainstream
Agency Phone: (812) 291-0695

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1909
Notes: Discover the potential in this three-bedroom, one-bath home located on a desirable corner lot along South Main Street in Bicknell, Indiana. Offering over 900 square feet of interior space, this property provides a great opportunity for buyers or investors looking for a project with long-term value. Positioned on a corner, the lot adds convenience, visibility, and additional outdoor space that invites creativity for landscaping, parking, or exterior enhancements. The home itself offers a traditional layout, with three bedrooms and a central bathroom that can be refreshed and updated to meet today’s standards and personal taste. The kitchen is generously sized and offers room for improvement, whether through new cabinetry, updated surfaces, or reimagined layout changes. With some thoughtful renovations, the kitchen and adjoining spaces can be transformed into functional, inviting areas suited to everyday living. Throughout the home, updates and repairs are needed—but for those with a vision and a willingness to invest time and resources, the rewards could be significant. This property is ideal for someone seeking a fixer-upper project, whether to create a customized home or to prepare the property for future rental or resale purposes. Located within the city limits of Bicknell, the home is close to local schools, shops, parks, and essential services. The community is known for its small-town charm and accessible pace of life, making it a comfortable location for individuals or families. While the home does require significant care and attention, its layout and lot location offer promising potential. With some Tender, Loving, Care, this home could be brought back to life and serve as a worthwhile investment for years to come.
MlsNumber: --
ListingId: 202511920


Listing Provided By: RE/MAX Mainstream, original listing
Phone: (812) 291-0695
Office Phone: (812) 291-0695
Agent Name: Trey Miller
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