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

4957 Hill Grove Road Sw
Corydon, IN 47112
Brian D Beckort with Beckort Auctions, LLC, original listing - (812) 738-9476

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $579,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 3200 Square Feet
Agency: Beckort Auctions, LLC
Agency Phone: (812) 738-9476

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: ESTATE-STYLE COUNTRY SETTING FEATURES CUSTOM-BUILT 2-STORY HOME WITH UPDATES & MULTIPLE OUTBUILDINGS! Eye-catching & fashionable, the property design & layout flow seamlessly for both daily family living or formal entertainment! The updates add to the already quality condition of the home. Property is situated in a private country setting approx. midway b/w Corydon & Brandenburg, KY. It’s your own private sanctuary only minutes from town! Home boasts 3200 SF total living area between 2-stories & features two (2) full kitchens & living rooms! Jan 2025 updates include replacement deck boards & new railing on entire deck, new window trim, new LED lights in upper living room, minor electrical repairs & updates, septic pumped, & more! Gutters are set to be repaired as soon as weather permits. The amazing sunroom on the 2nd story walkout deck was added in 2012. Other awesome features include Mohawk flooring (ins. 2023), Schmidt custom cabinets, & metal roof w/2” Styrofoam & heat shield (2015). There is a 50-amp RV plug at the end of home. Outbuildings include a 2009-built detached 30x36 metal-sided garage w/covered front porch, concrete floors, electric, & EV plug; a 2010-built 30x48 metal-sided insulated garage w/three (3) OH doors, concrete floors & electric; & a 2013-built 24x48 metal sided garage w/16’ tall doors, concrete floors, electric, & 50-amp RV service. Space, privacy, scenery, entertainment, multiple uses, & so much more! Truly a forever home opportunity!
MlsNumber: --
ListingId: 202505548


Listing Provided By: Beckort Auctions, LLC, original listing
Phone: (812) 738-9476
Office Phone: (812) 738-9476
Agent Name: Brian D Beckort
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.


Local Real Estate Expert

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','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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;
Gid Miller
ASCIIJPAR Aspire Real Estate
Call Today!: (502) 296-1974

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App