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

1314 Highway 335 Ne
Corydon, IN 47112

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $898,000
Beds: 4
Baths: 4
Status: Active
SqFt: 4934
Agency: Berkshire Hathaway HomeSerivces Parks & Weisberg,

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2004
Notes: Welcome to your dream retreat nestled on 50 acres of picturesque land in Corydon. This custom built home offers unparalleled craftsmanship & attention to detail at every turn. As you step inside you'll be greeted by stunning hardwood floors that flow throughout the house creating an inviting & warm atmosphere. The eat-in kitchen is a chef's delight featuring a spacious layout & adorned with an abundance of custom cabinetry throughout providing ample storage. The living spaces are thoughtfully designed, offering both comfort & style. Each room boasts unique touches from elegant fixtures to carefully selected aterials. One of the true highlights of this property is the panoramic views that can be enjoyed from nearly every window. Imagine waking up to breathtaking sunrises & winding down with spectacular sunsets over your expansive estate. Outside the property offers endless possibilities. Explore the vast acreage, perfect for hiking, horseback riding or simply enjoying nature's beauty. With plenty of space for outdoor activities, gardening or even building additional amenities like a pool or barn. This is not just a home; it's a lifestyle. Whether you're seeking tranquility in nature or a place to entertain family & friends, this meticulously designed property promises a once in a lifetime opportunity to own a truly exceptional piece of Corydon. Schedule your private tour today & prepare to be captivated by all that this extraordinary home has to offer.
MlsNumber: 202407616


Listing Provided By: Berkshire Hathaway HomeSerivces Parks & Weisberg,, original listing
Name: Berkshire Hathaway HomeSerivces Parks & Weisberg,
Phone: (502) 552-0411
Office Name: Berkshire Hathaway HomeServices Parks & Weisb
Office Phone: (812) 282-0426
Agent Name: Luke Castleman
Disclaimer: Copyright © 2024 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