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

8975 W Co Road 490s Road
French Lick, IN 47432
Rosemary Trinkle with Trinkle Group Real Estate and Appraisals, original listing - (812) 723-4213

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3640 Square Feet
Agency: Trinkle Group Real Estate and Appraisals
Agency Phone: (812) 723-4213

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 133 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: This once-in-a-lifetime opportunity features 133 AC of prime cropland, pasture, and woods, along with a charming Two-Story Southern Home. The well-appointed interior boasts three bedrooms, 2.5 baths, and a Full Walkout Basement with Family Room, Office, Bath, and Built-In Garage. The Main Level is flooded with natural light, complimented by cathedral ceilings and an open stairway. The Designer Kitchen is equipped and a brick fireplace serves as the focal point, creating a warm and welcoming atmosphere for family and friends. On the upper level, there are two spacious bedrooms, bath, a balcony, and a comfortable sitting area. The sitting room offers a picturesque view of the living room and the surrounding landscape. One can retreat to this peaceful space to read a book or simply enjoy the panoramic view of the farm. The tranquil lake attracts various wildlife; an ideal location for nature lovers. Strategically located within 6 miles of French Lick Casino, West Baden Hotel, and Patoka Lake Boat Ramps. This expansive estate offers the perfect setting for a B&B to thrive. With a steady influx of visitors year-round, the demand for accommodations is high. Discover the perfect combination of work and play at the Highly Productive Walters Farm, featuring a 32 x 80 pole barn for storing equipment and toys like campers, ATVs, boats, and farming tools. Become the new owner of this fantastic property today!
MlsNumber: --
ListingId: 202442145


Listing Provided By: Trinkle Group Real Estate and Appraisals, original listing
Phone: (812) 723-4213
Office Phone: (812) 723-4213
Agent Name: Rosemary Trinkle
Disclaimer: Copyright © 2024 Bedford Board 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