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

5187 W State Road 64
Taswell, IN 47175
Ashley Bullington with Debby Broughton Realty, original listing - (812) 946-3393

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $145,000
Beds: 3
Baths: Full: 2
Status: Active Under Contract
SqFt: 1000 Square Feet
Agency: Debby Broughton Realty
Agency Phone: (812) 946-3393

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1977
Notes: Move-In Ready Home w/ Ample Untapped Potential Near Patoka Lake! Looking for a comfortable home with incredible potential? Look no further than this 3-bedroom, 2-bath home! Located in close proximity to Patoka Lake, this property offers the perfect blend of residential and commercial possibilities. The home itself is designed with both comfort and privacy in mind. The split bedroom layout ensures everyone has their own space, creating a peaceful and relaxing atmosphere. But the real treasure lies beyond the home in the extra-large garage, boasting over 3200 square feet! This isn't just a garage; it's a blank canvas for your dreams. Whether you need ample personal storage for hobbies, equipment, or you're considering a commercial venture, this expansive space provides the foundation you need. Imagine a workshop, storage facility, or even a small business operation – the possibilities are truly endless. Adding to the allure is the property's impressive highway frontage with plenty of parking. With over 600 feet of frontage on Highway 64, this property enjoys exceptional visibility and accessibility. This is a game-changer for anyone considering a commercial enterprise, offering prominent exposure to potential customers and clients. With its move-in ready home, massive garage, and exceptional highway frontage, it's a rare opportunity to own a unique property near Patoka Lake. Contact us today to schedule a viewing and explore the endless possibilities this property has to offer!
MlsNumber: --
ListingId: 202505752


Listing Provided By: Debby Broughton Realty, original listing
Phone: (812) 499-8384
Office Phone: (812) 946-3393
Agent Name: Ashley Bullington
Disclaimer: Copyright © 2025 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